Using appropriate formulas, find the mean and standard deviation of the frequency distribution you constructed. Use the additional headings I have provided!!!!! Show how you use the appropriate formulas. Again, treat the data as sample data.
Please show me how to use it in Excel. Data set is
43 |
42 |
41 |
39 |
38 |
37 |
37 |
30 |
27 |
27 |
26 |
26 |
24 |
18 |
14 |
52 |
43 |
41 |
39 |
37 |
37 |
27 |
27 |
22 |
21 |
21 |
20 |
19 |
19 |
17 |
Boundaries | Midpoints (m) | Freq. (f) | Rel. Freq. | mf | (m - x̅)2 *f |
12.5-19.5 | 16 | ||||
19.5-26.5 | 23 | ||||
26.5-33.5 | 30 | ||||
33.5-40.5 | 37 | ||||
40.5-47.5 | 44 | ||||
47.5-54.5 | 51 | ||||
x̅ = | |||||
s = |
Following is the completed table:
Get Answers For Free
Most questions answered within 1 hours.