# MN 207 PGU Slope of the Regression Line and the Correlation Coefficient Worksheet

User Generated

neobynlynznqevq

Health Medical

MN 207

Purdue Global University

MN

## Description

For the Unit 6 discussion, you will work with a team to conduct a regression analysis for one of the chosen data sets. To find the names of your team members, go to the More Tools dropdown on the Course Home page. Choose Groups, then click on the number under the heading Members and you will see a listing of your team members. You can also email your team members directly from this page.

Through your reading this week, you have hopefully come to realize there is a certain order to the procedures one follows when conducting regression analysis. The Unit 6 discussion will be a team discussion effort and will allow you to simulate the flow of tasks involved in this type of analysis. The success of your team's final prediction output will require team collaboration and interdependence in getting each of the tasks completed in a timely, appropriate order.

The individual tasks are outlined below and depending on when each team member logs into the discussion to complete their part. The tasks are labeled Task 1, Task 2, etc. depending on their placement in the sequential process. ***It is very important that you change the subject line to "Your Name – Task #" when you post your team contribution, so the next member who logs in will know where they need to continue in the project.***

Post 1: Initial Response

2. Using your first team member's dataset choice and specification of independent and dependent variables, create a scatter plot using Excel to provide a visual representation of the relationship between the two variables. Make sure to label the graph appropriately, and include a title on the graph. In your response, change the subject line to "Your Name – Task 2." Attach your Excel spreadsheet for use in subsequent tasks.
3. Using your second team member's scatterplot, comment on the relationship, or lack of one, that you see from the scatterplot (include comments on strength, form (linear or nonlinear), and direction). Calculate the correlation coefficient, and comment on any additional information this statistic provides regarding the relationship between the two variables. Based on these first three tasks of the project, would you recommend that your team continue with the creation of a linear model for prediction? In your response, change the subject line to "Your Name – Task 3."
4. Use your third team member's correlation value to calculate the coefficient of determination. Explain what this value tells you about your model in terms of "explained variance." Explain what this value tells you about your model in terms of "unexplained variance." Should you use the word "cause" in your explanation – why or why not? In your response, change the subject line to "Your Name – Task 4."
5. Regardless of whether the linear model is appropriate or not, use the attached scatterplot from Task 2 and Excel to derive the equation of the linear model. Show the equation on the scatterplot. What is the slope of the linear model? What is the y-intercept of the linear model? Are the sign of the slope of the regression line and the sign of the correlation coefficient the same? Will this always be the case? In your response, change the subject line to "Your Name – Task 5."

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Here is the answer. I included two tabs in the excel sheet where one is height dependent and the other one is height as independent. Depending on which you prefer to be your D.V, pick a tab and delete the other. Thanks.

Stories
64
68
50
48
32
46
58
45
49
40

Height in ft.
995
844
732
679
648
635
610
600
583
573

Height as a Function of the No. of S...

### Review

Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4