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