Compute the frequency distribution for Oil change wait times (see table below).
ID: 3246676 • Letter: C
Question
Compute the frequency distribution for Oil change wait times (see table below).
Compute
1. Min and max
2. Bin size for 10 bins
3. First bin = min + bin size
4. 9 remaining bin values
5. Use function = FREQUENCY()
The frequency distribution is
a) Wait times Frequency
10.0 1
16.0 7
22.0 8
28.0 20
34.0 34
40.0 45
46.0 41
52.0 27
58.0 13
64.0 4
b)
Wait times Frequency
16 8
22 8
28 19
34 34
40 44
46 41
52 27
58 13
64 3
70 3
Total 200
c) Wait times Frequency
15.0 7
21.0 8
27.0 18
33.0 30
39.0 45
45.0 39
51.0 31
57.0 16
63.0 4
69.0 2
Total 200
d) None of the above
Waiting Time (Minutes) 11.0 33.0 29.0 29.0 33.0 30.0 42.0 23.0 25.0 55.0 12.0 49.0 33.0 49.0 42.0 12.0 40.0 70.0 52.0 26.0 46.0 32.0 32.0 39.0 51.0 47.0 25.0 22.0 43.0 43.0 45.0 41.0 52.0 62.0 31.0 45.0 32.0 43.0 43.0 38.0 55.0 31.0 46.0 44.0 51.0 35.0 49.0 40.0 16.0 55.0 43.0 60.0 20.0 34.0 10.0 41.0 36.0 22.0 47.0 52.0 44.0 24.0 43.0 53.0 49.0 43.0 44.0 51.0 37.0 58.0 53.0 39.0 27.0 47.0 24.0 39.0 38.0 32.0 21.0 27.0 31.0 57.0 27.0 38.0 31.0 39.0 38.0 24.0 21.0 37.0 45.0 43.0 33.0 36.0 52.0 40.0 20.0 33.0 41.0 38.0 46.0 66.0 55.0 48.0 28.0 45.0 29.0 27.0 49.0 51.0 40.0 23.0 30.0 47.0 36.0 20.0 43.0 47.0 39.0 32.0 15.0 46.0 39.0 46.0 45.0 51.0 57.0 43.0 32.0 14.0 44.0 42.0 54.0 40.0 38.0 36.0 34.0 30.0 41.0 44.0 41.0 43.0 31.0 35.0 39.0 23.0 29.0 40.0 44.0 36.0 47.0 36.0 34.0 34.0 57.0 28.0 57.0 26.0 38.0 34.0 35.0 38.0 43.0 26.0 35.0 51.0 48.0 30.0 34.0 38.0 39.0 35.0 48.0 35.0 42.0 44.0 13.0 35.0 46.0 30.0 39.0 25.0 53.0 39.0 37.0 60.0 47.0 30.0 49.0 46.0 37.0 51.0 36.0 21.0 32.0 34.0 37.0 46.0 28.0 69.0Explanation / Answer
there are 200 values
enter the same in column A of excel
In cell A201, type the formula
=MAX(A1:A200)
We get max = 70
=MIN(A1:A200)
we get min = 10
We need to form 10 bins and the rnage of data is 70-10 = 60
Thus the bin size = 60/10 = 6
First Bin = 6 + 10 = 16
The 10 bin values are as follows
70
The cumulative frequency using the formula frequency is as flows
=FREQUENCY($A$1:$A$200,E1)
That id
Wait times Frequency
16 8
22 8
28 19
34 34
40 44
46 41
52 27
58 13
64 3
70 3
Total 200
Answer is option b
16 22 28 34 40 46 52 58 6470
The cumulative frequency using the formula frequency is as flows
=FREQUENCY($A$1:$A$200,E1)
8 16 35 69 113 154 181 194 197 200Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.