2. Draw a trendline associated with the data points. Be sure to select the inclusion of the Equation and R-squared values on the chart.
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.