Forum: Week 6 Discussion: Excel and Linear Regression

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
• Group#2 Your last name starts with letter F L
• Group#3 Your last name starts with letter M S
• Group#4 Your last name starts with letter T Z

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.

Struggling with your essay and deadlines?

Get this or a similar paper done in as fast as 4 hours, 24/7.

NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions

✔Secure Service ✔ Plagiarism Free ✔On-time Delivery

WRITE MY PAPER