Excel Spreadsheet Assignment with questions

The questions and tasks are in the excel spreadsheet tabs. The data is given, there are questions and histogram to complete. the tabs are below on the excel file

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

Login to view and/or buy answers.. or post an answer
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

Similar orders to Excel Spreadsheet Assignment with questions
5
Views
0
Answers
Unit 9 Statistics test Comparing Populations
Anything higher than 80% is fine. I don't have many requirements outside of that. Must be done Sunday before 11:59. There's an hour and fifteen-minute time limit....
5
Views
0
Answers
I need help Completing lumen ohm assignment homework
I need someone who can completely ruin only so assignment and at least an 85 percentile I will pay more the Homeworks required knowledge of statistics in calculator usage they are due at the end of the night...
13
Views
0
Answers
statistic exam 7:15pm est 5/13/2021
It will be an online exam 2 hour exam Content: likelihood, hypothesis testing, most powerful test Unsure of amount of questions Would like to get a 90+...
8
Views
0
Answers
I need help With Statistics homework
I need help with a few chapters of statistics homework, please message me and I will provide more information. Each chapter has questions that I need to have done as soon as possible....