USE EXCEL TO CALCULATE THE FREQUENCIES AS SHOWN BELOW. PLEASE PROVIDE EXCEL FORMULA USED.
Frequency Distribution | |||
Low | High | Bins | Frequency |
-67.0 | -56.6 | (-67, -56.6] | |
-56.6 | -46.2 | (-56.6, -46.2] | |
-46.2 | -35.8 | (-46.2, -35.8] | |
-35.8 | -25.4 | (-35.8, -25.4] | |
-25.4 | -15.0 | (-25.4, -15] | |
-15.0 | -4.6 | (-15, -4.6] | |
-4.6 | 5.8 | (-4.6, 5.8] | |
5.8 | 16.2 | (5.8, 16.2] | |
16.2 | 26.6 | (16.2, 26.6] | |
26.6 | 37.0 | (26.6, 37] | |
37.0 | 47.4 | (37, 47.4] | |
47.4 | 57.8 | (47.4, 57.8] | |
57.8 | 68.2 | (57.8, 68.2] | |
68.2 | 78.6 | (68.2, 78.6] | |
78.6 | 89.0 | (78.6, 89] | |
89.0 | 99.4 | (89, 99.4] |
2.0 |
-61.0 |
-9.0 |
14.0 |
43.0 |
-16.0 |
-11.0 |
8.0 |
20.0 |
-15.0 |
0.0 |
-37.0 |
9.0 |
14.0 |
40.0 |
-29.0 |
38.0 |
-49.0 |
65.0 |
27.0 |
89.0 |
-16.0 |
83.0 |
72.0 |
-3.0 |
-21.0 |
51.0 |
36.0 |
26.0 |
-45.0 |
-6.0 |
14.0 |
-3.0 |
55.0 |
39.0 |
-6.0 |
-35.0 |
25.0 |
27.0 |
6.0 |
12.0 |
37.0 |
-12.0 |
35.0 |
24.0 |
15.0 |
35.0 |
-67.0 |
2.0 |
-32.0 |
-34.0 |
-32.0 |
22.0 |
51.0 |
33.0 |
10.0 |
-28.0 |
2.0 |
12.0 |
17.0 |
44.0 |
-29.0 |
22.0 |
-28.0 |
-18.0 |
-12.0 |
-19.0 |
11.0 |
62.0 |
50.0 |
-27.0 |
46.0 |
62.0 |
-26.0 |
-54.0 |
-61.0 |
45.0 |
-51.0 |
-41.0 |
14.0 |
9.0 |
-56.0 |
0.0 |
-34.0 |
-52.0 |
-28.0 |
14.0 |
63.0 |
23.0 |
-46.0 |
29.0 |
1.0 |
1.0 |
20.0 |
1.0 |
25.0 |
-4.0 |
29.0 |
-15.0 |
78.0 |
The answer is:
Frequency Distribution | |||
Low | High | Bins | Frequency |
-67.0 | -56.6 | (-67, -56.6] | 3 |
-56.6 | -46.2 | (-56.6, -46.2] | 5 |
-46.2 | -35.8 | (-46.2, -35.8] | 4 |
-35.8 | -25.4 | (-35.8, -25.4] | 12 |
-25.4 | -15.0 | (-25.4, -15] | 5 |
-15.0 | -4.6 | (-15, -4.6] | 8 |
-4.6 | 5.8 | (-4.6, 5.8] | 11 |
5.8 | 16.2 | (5.8, 16.2] | 14 |
16.2 | 26.6 | (16.2, 26.6] | 10 |
26.6 | 37.0 | (26.6, 37] | 8 |
37.0 | 47.4 | (37, 47.4] | 8 |
47.4 | 57.8 | (47.4, 57.8] | 4 |
57.8 | 68.2 | (57.8, 68.2] | 4 |
68.2 | 78.6 | (68.2, 78.6] | 2 |
78.6 | 89.0 | (78.6, 89] | 1 |
89.0 | 99.4 | (89, 99.4] | 1 |
Total | 100 |
The formulas are:
Frequency Distribution | |||
Low | High | Bins | Frequency |
-67.0 | -56.6 | (-67, -56.6] | =COUNTIFS(A1:A100,">-68",A1:A100,"<-56.6") |
-56.6 | -46.2 | (-56.6, -46.2] | =COUNTIFS(A1:A100,">-56.7",A1:A100,"<-46.2") |
-46.2 | -35.8 | (-46.2, -35.8] | =COUNTIFS(A1:A100,">-46.3",A1:A100,"<-35.8") |
-35.8 | -25.4 | (-35.8, -25.4] | =COUNTIFS(A1:A100,">-35.9",A1:A100,"<-25.4") |
-25.4 | -15.0 | (-25.4, -15] | =COUNTIFS(A1:A100,">-25.5",A1:A100,"<-15") |
-15.0 | -4.6 | (-15, -4.6] | =COUNTIFS(A1:A100,">-15.1",A1:A100,"<-4.6") |
-4.6 | 5.8 | (-4.6, 5.8] | =COUNTIFS(A1:A100,">-4.7",A1:A100,"<5.8") |
5.8 | 16.2 | (5.8, 16.2] | =COUNTIFS(A1:A100,">5.7",A1:A100,"<16.2") |
16.2 | 26.6 | (16.2, 26.6] | =COUNTIFS(A1:A100,">16.1",A1:A100,"<26.6") |
26.6 | 37.0 | (26.6, 37] | =COUNTIFS(A1:A100,">26.5",A1:A100,"<37") |
37.0 | 47.4 | (37, 47.4] | =COUNTIFS(A1:A100,">36.9",A1:A100,"<47.4") |
47.4 | 57.8 | (47.4, 57.8] | =COUNTIFS(A1:A100,">47.3",A1:A100,"<57.8") |
57.8 | 68.2 | (57.8, 68.2] | =COUNTIFS(A1:A100,">57.7",A1:A100,"<68.2") |
68.2 | 78.6 | (68.2, 78.6] | =COUNTIFS(A1:A100,">68.1",A1:A100,"<78.6") |
78.6 | 89.0 | (78.6, 89] | =COUNTIFS(A1:A100,">78.5",A1:A100,"<89") |
89.0 | 99.4 | (89, 99.4] | =COUNTIFS(A1:A100,">88.9",A1:A100,"<99.4") |
Total | =SUM(G3:G18) |
The Excel output is:
The Excel formulas are:
Please give me a thumbs-up if this helps you out. Thank you!
USE EXCEL TO CALCULATE THE FREQUENCIES AS SHOWN BELOW. PLEASE PROVIDE EXCEL FORMULA USED. Frequency Distribution...