Compute the frequency distribution for Oil Change Wait Times
Compute the frequency distribution for Oil Change Wait Times (please see 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()
Oil Change Wait Times
Waiting Time (Minutes)
11 33 29 29 33 30 42 23
25 55 12 49 33 49 42 12
40 70 52 26 46 32 32 39
51 47 25 22 43 43 45 41
52 62 31 45 32 43 43 38
55 31 46 44 51 35 49 40
16 55 43 60 20 34 10 41
36 22 47 52 44 24 43 53
49 43 44 51 37 58 53 39
27 47 24 39 38 32 21 27
31 57 27 38 31 39 38 24
21 37 45 43 33 36 52 40
20 33 41 38 46 66 55 48
28 45 29 27 49 51 40 23
30 47 36 20 43 47 39 32
15 46 39 46 45 51 57 43
32 14 44 42 54 40 38 36
34 30 41 44 41 43 31 35
39 23 29 40 44 36 47 36
34 34 57 28 57 26 38 34
35 38 43 26 35 51 48 30
34 38 39 35 48 35 42 44
13 35 46 30 39 25 53 39
37 60 47 30 49 46 37 51
36 21 32 34 37 46 28 69
The frequency distribution is