I need help with the attachment below 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. Question 5 (5 points): Question 5 (5 points): Question 5 (5 points): Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Question 6 (10 points): Question 6 (10 points): Question 6 (10 points): Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Spending Spending Frequency Frequency Question 7 (10 point its): Question 7 (10 point its): Question 7 (10 point its): Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. 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) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Question 5 (5 points): Question 5 (5 points): Question 5 (5 points): Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Question 6 (10 points): Question 6 (10 points): Question 6 (10 points): Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Spending Spending Frequency Frequency Question 7 (10 point its): Question 7 (10 point its): Question 7 (10 point its): Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. 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) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) 5 (5 points): Question 5 (5 points): Question 5 (5 points): Question 5 (5 points): Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Question 6 (10 points): Question 6 (10 points): Question 6 (10 points): Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Spending Spending Frequency Frequency Question 7 (10 point its): Question 7 (10 point its): Question 7 (10 point its): Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. 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) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) 5 (5 points): Question 5 (5 points): Question 5 (5 points): Question 5 (5 points): Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Question 6 (10 points): Question 6 (10 points): Question 6 (10 points): Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Spending Spending Frequency Frequency Question 7 (10 point its): Question 7 (10 point its): Question 7 (10 point its): Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. 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) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) 5 (5 points): Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Question 6 (10 points): Question 6 (10 points): Question 6 (10 points): Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Spending Spending Frequency Frequency Question 7 (10 point its): Question 7 (10 point its): Question 7 (10 point its): Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. 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) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Question 5 (5 points): Question 5 (5 points): Question 5 (5 points): Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Question 6 (10 points): Question 6 (10 points): Question 6 (10 points): Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Spending Spending Frequency Frequency Question 7 (10 point its): Question 7 (10 point its): Question 7 (10 point its): Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. 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) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Question 5 (5 points): Question 5 (5 points): Question 5 (5 points): Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Question 6 (10 points): Question 6 (10 points): Question 6 (10 points): Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Spending Spending Frequency Frequency Question 7 (10 point its): Question 7 (10 point its): Question 7 (10 point its): Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. 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) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Question 5 (5 points): Question 5 (5 points): Question 5 (5 points): Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Produce a column to the right which eliminates any outliers. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Make sure your column is sorted as well. Question 6 (10 points): Question 6 (10 points): Question 6 (10 points): Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Complete the following table by creating 8 bins and classifying the data accordingly: Spending Spending Frequency Frequency Question 7 (10 point its): Question 7 (10 point its): Question 7 (10 point its): Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Create a relative frequency histogram from the above data . Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. Be sure to label your chart with meaningful axis titles and a chart title. 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) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem) Place your histogram below (not to the side to the problem)