.9 8 8 5 7 4 1 4 1 4 3 4 38 5 9 6 9 1 2 6 2 24 7 81 3 7 5 7 2 6 6 3 2 3 2 8 3 5
ID: 3319007 • Letter: #
Question
.9 8 8 5 7 4 1 4 1 4 3 4 38 5 9 6 9 1 2 6 2 24 7 81 3 7 5 7 2 6 6 3 2 3 2 8 3 5 5 9 21 83 10 5 9268 344344133344222233131223242411413223411323343432 46922 47 .3 6 1 9 4 7 3 18 869-81996 .4 4-6428 .8 978-2 8 9 5 11993, 4 5 0 0.3 2 52 an 35 21 18 0.1 2.2 201 6 4 1 2 7 2 8 6 9 3 4 1 1.7 4 1 3 7 41 61 20 1.7 as 64 75 57 4 9 64 1 1.6 3.5 12 68931569 .6 4 4 2 9 9 5 5 7 4 861472 16295323648222794992354 in 234567 8 9 10 12 14 15 6 7 8 9 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 4 4 4 43 4 4 4 4 4 4 50 553 54 55
Explanation / Answer
Run the below written formulas in excel to calculate the required fields:
(1) For total Spending (in G column) =B7+C7
Spending per capita (in H column) =[(B7+C7)*1000]/D7
(2) Mean =AVERAGE(H) Mean value of the observation
Median =MEDIAN(H) Middle value of the observation
Mode =MODE.SNGL(H) Highest frequency value of the observation
Standard Deviation =STDEV.S(H) standard deviation of the observation
(3) Q1 =QUARTILE.EXC(H,1)
IQR = Q3-Q1
(4) Lower fence = Q1-1.5*IQR
Upper fence = Q1+1.5*IQR
Q3 =QUARTILE.EXC(H,3)Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.