This is excel spreadsheet assignment. It would be great if you can provide excel

Question

This is excel spreadsheet assignment. It would be great if you can provide excel formulas

Compare State Spending on Education.

This is excel spreadsheet assignment. It would be great if you can provide excel formulas

Compare State Spending on Education.

Key for REGION is as follows: 1 = Northeast, 2 = Midwest, 3 = South, 4 = North Fiscal Year 2015 Amounts in $ billion State State Spending Local Spending Population (million) REGION 2012 election Alabama 6.6 8.3 4.9 3 r Alaska 1.8 2 0.7 4 r Arizona 4.9 9.9 6.8 4 r Arkansas 3.3 5.2 3 3 r California 31 79.7 39.2 4 d Colorado 5.5 8.9 5.4 4 d Connecticut 3.6 9.5 3.6 1 d Delaware 1.9 2.1 0.9 3 d Florida 10.6 29.5 20.2 3 d Georgia 8.4 18 10.2 3 r Hawaii 3.4 -0.1 1.4 4 d Idaho 1.2 2.2 1.7 4 r Illinois 8.9 29.1 12.9 2 d Indiana 6.9 10.6 6.6 2 r Iowa 3.5 7.4 3.1 2 d Kansas 2.5 6.1 2.9 2 r Kentucky 5.7 7.2 4.4 3 r Louisiana 4.4 8.7 4.7 3 r Maine 1 3.2 1.3 1 d Maryland 4.8 13.8 6 3 d Massachusetts 6.6 14.6 6.8 1 d Michigan 10.1 13.9 9.9 2 d Minnesota 6.4 11.3 5.5 2 d Mississippi 2.7 5.4 3 3 r Missouri 5.2 11.1 6.1 2 r Montana 1 1.7 1 4 r Nebraska 2.1 4.4 1.9 2 r Nevada 1.6 4.1 2.9 4 d New Hampshire 1.2 3 1.3 1 d New Jersey 9.9 26.7 9 1 d New Mexico 2.5 4.1 2.1 4 d New York 13.3 61 19.8 1 d North Carolina 10.2 20 10 3 r North Dakota 1.3 1.7 0.8 2 r Ohio 8.6 23.5 11.6 2 d Oklahoma 4.4 6.4 3.9 3 r Oregon 3.8 7.5 4 4 d Pennsylvania 11.2 26.3 12.8 1 d Rhode Island 1.2 2.3 1.1 1 d South Carolina 5.2 5.7 4.9 3 r South Dakota 0.7 1.4 0.9 2 r Tennessee 5.9 9.9 6.6 3 r Texas 24.4 64.9 27.4 3 r Utah 4.9 5.1 3 4 r Vermont 0.9 1.6 0.6 1 d Virginia 9.2 15.7 8.4 3 d Washington 8.3 12.9 7.2 4 d West Virginia 2.5 3.5 1.8 3 r Wisconsin 6.4 12.4 5.8 2 d Wyoming 0.7 2 0.6 4 r

Explanation / Answer

50

Comparing the mean to median,the data set is right skewed .

4.1181

Lower fence can be calculated as Q1-1.5*IQR

Upper fence can be calculated as Q3+1.5*IQR

There are high outliers in the data.That is the items above the upper fence are 4.17,4.44,4.50 and 5.43

Please note that I couldnt attach the excel data with spending per capita.Eventhough the spendings are in billion,if we change it to million ,the values remain the same in terms of million for total spending.

spending per capita Mean 3.0492 Standard Error 0.0949 Median 2.9550 Mode 3.2308 Standard Deviation 0.6710 Sample Variance 0.4502 Kurtosis 2.4415 Skewness 1.1458 Range 3.4631 Minimum 1.9655 Maximum 5.4286 Sum 152.4613 Count

50

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.