# Excel Spreadsheet Assignment with questions

## Get Help With a similar task to - Excel Spreadsheet Assignment with questions

##### Additional Instructions:

Data 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 Data Analysis Compare State Spending on Education. The data given in tab one can be used to compare education spending by state. We cannot use the data as given, however. For example, to compare Texas and Vermont purely on total amount spent would give a false impression of how much each state spends on education because of varied population size. To make a more valid comparison we can calculate spending per capita by dividing total spent by state population. (although this is total state population and not just students it will give a much better basis for comparison). Question1 (5 points): Create a column showing spending per capita. Please be sure and note that spending is in billions and population is in millions. Also note that there are two spending columns which need to be combined. Place this column in the right part of this spreadsheet. Question 2 (10 points): Provide descriptive statistics for the per capita spending. Calculations using EXCEL functions must be shown. Explain what each item represents, or give a definition in your own words. Mean: Median: Mode: Range: Standard Deviation: Comparing the mean to the median, is this data set likely skewed right, skewed left, or symmetric? Question 3 (5 points): Using the EXCEL functions provide: Lower Quartile (Q1): Upper Quartile (Q3): Interquartile Range: Question 4 (5 points): Your textbook gives a method for finding potential outliers in a set of data using the values found in Question 3. Determine whether there are any low outliers or high outliers in the duration data. First, provide the lower fence and upper fence (limits) for outliers. Lower fence (limit): Upper fence (limit): Are there low outliers (items below the lower fence)? Are there high outliers (items above the upper fence)? Note that there could be multiple outliers on either side, or there may be none on either side. Histograms Question 5 (5 points): Produce a column to the right which eliminates any outliers. Make sure your column is sorted as well. Question 6 (10 points): Complete the following table by creating 8 bins and classifying the data accordingly: Spending Frequency Question 7 (10 point its): Create a relative frequency histogram from the above data . Be sure to label your chart with meaningful axis titles and a chart title. Place your histogram below (not to the side to the problem) Bivariate Question 8 (10 points): Create a scatter plot (below) to explore the relationship between state and local spending on education. Make local spending the dependent variable. Make sure you give your scatter plot a clear title and axis labels. Question 9 (10 points): Using EXCEL calculate the slope and intercept and give the resulting regression equation. slope intercept regression line Question 10 (10 points): A regression line can be created for any two variables. Doing a correlation describes whether or not there is a meaningful relationship. Using an EXCEL function describe the correlation between the two. Is this a strong or weak correlation? Question 11 (10 points): Based on your regression line from question 10, what amount would you predict for local spending if a state spends $40 billion. What might be some reasons that using that prediction would give you hesitation?

## Related Questions

Tutlance Experts offer help in a wide range of topics. Here are some of our top services:

- Do my math homework
- Do my nursing homework
- Do my statistics homework
- Nursing coursework help
- Capstone project writing services
- Essay writers for hire
- Case study writing help
- Buy college papers online
- Buy college research papers
- College homework help
- Professional resume writing services
- Do my programming homework
- Do my engineering homework
- Coursework writing help
- Term paper writing help
- Biology assignment help
- Do my physics homework
- Dissertation data analysis help
- PhD Dissertation writing help
- Chemistry assignment help

Post your project now for free and watch professional experts outbid each other in just a few minutes.