BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 49

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.