Forum: Week 6 Discussion: Excel and Linear Regression

Overview

In this discussion we will practice using Excel to analyze data.

For your last name group listed below, download data in the associated spreadsheet.

• Group#1 Your last name starts with letter A – E
  MTH 315_Week 6 Discussion Data_A-E.xlsx
• Group#2 Your last name starts with letter F – L
  MTH 315_Week 6 Discussion Data_F-L.xlsx
• Group#3 Your last name starts with letter M – S
  MTH 315_Week 6 Discussion Data_M-S.xlsx
• Group#4 Your last name starts with letter T – Z
  MTH 315_Week 6 Discussion Data_T-Z.xlsx
  

1. For your initial Post:
   1. Create a scatterplot with the linear regression equation displayed within Excel. State what the regression equation is within your written post.
   2. Define your input and output variables. What do each of the variables in your equation represent in the context of this scenario?
   3. State the value of the correlation coefficient (round to four decimal places). Interpret the meaning of this value within the context of this scenario.
   4. State the value of the coefficient of determination (round to four decimal places). Interpret the meaning of this value within the context of this scenario.
   5. State the interval of ages for which this linear regression equation is appropriate.
   6. Attach your Excel file to your post. Be sure that all required work is written in the text box for the discussion post.