3. Perform a regression analysis on the data set. Remember to identify which of the variables are dependent( Y axis) and independent( X axis) so as not to get confused on your input values. Place the regression results, starting at cell I1, instead of using the default, which is a separate sheet. Be sure to identify and highlight on the regression data, the R-squared value, the Intercepts point, and the slope of the line. STEP 8: Sorting Statistics The data listed here is the first and last five presidents to have died of natural causes. Many forget that simply sorting information in a specific format can provide meaningful information. However, before we begin the multiple sorting exercise, simply complete the descriptive statistics at the bottom of this group of presidents. There are multiple ways of calculating the average age for the first and last five presidents, but for this exercise, use the AVERAGEIF function. Because there is not a MEDIANIF function, you will have to do this one manually with your formula( not with a calculator).
Your next step is to copy the data for each president, excluding the ordinal column, to each of the other two categories. For example, the column of President should start at cell G3, and at cell L3. Once you have copied the data, reorder the data, with the second group by Age at Death, and the third set by Year of Death. You will most likely find this information very interesting. Some find it strange that the average age of death of the first five and the last five presidents was less than a year different, especially given all the advances in medicine. STEP 9: Regression Analysis Scenario: The owner of the Original Greek Diner has been advertising for the past year, and is now ready to renew his contract. He needs to know if the advertising has been effective, so your task is to take the prior year ' s data and perform a regression analysis to determine the correlation between advertising expenditures and restaurant sales( revenues). Using the GreekData sheet, prepare a scatter plot graph with a title of Revenues( Y), placed to the right of the data on the same sheet. The