Georgia State University Statistics Worksheet

Description

Instructions

In this lesson, you will run a correlation between the resting and after-exercising heart rates to determine if a linear relationship exists between the two variables and how strong the relationship is.

Steps

Open the Heart Rate Data excel Sheets in Excel and identify the X-variable (resting heart rates for all 200 participants) and the Y-variable (after-exercise heart rates for all 200 participants).
Use the Scatter Plot function in the Insert Charts section of Excel to create a scatter plot of the X and Y variables.
Add a trendline to the scatter plot.
Use the Data Analysis tools in Excel to find the regression equation.
In a Word document, describe the relationship between the X-variable (resting heart rate)and the Y-variable (after exercise heart rate).
- Graph the scatter plot with a trend line. Does it appear there is a linear relationship? What does this mean?
- Calculate the correlation coefficient r using excel. Is this r (value) high compared to +1? Based on the correlation coefficient is the relationship strong?
- Use excel to find the regression equation. Identify the slope. What does it tell us in terms of our heart rate data?

1 attachments

Slide 1 of 1

attachment_1

attachment_1

Unformatted Attachment Preview

Heart rate before and after exercise
M=0 F=1 Resting
After Exercise
0
85.9
87.5
0
67.7
79.4
0
80.3
93.4
0
85.2
97.7
0
86.3
99.7
0
76.6
83.7
0
94.4
101.9
0
86.4
100.6
0
83.4
97.4
0
89.8
97.4
0
88.7
97.1
0
78.4
87.2
0
71.3
79.9
0
92.6
104.7
0
86.2
95.9
0
83.9
93.9
0
78.1
90.1
0
64.0
70.7
0
72.8
86.7
0
72.7
81.2
0
80.2
83.3
0
78.2
86.0
0
70.6
90.2
0
75.5
84.4
0
82.7
94.2
0
87.7
95.1
0
80.0
88.7
0
73.4
82.7
0
89.5
94.6
0
77.6
84.6
0
76.6
86.4
0
85.6
96.2
0
74.2
82.1
0
79.0
91.6
0
74.6
86.7
0
88.8
98.8
0
82.1
85.6
0
77.6
80.6
0
77.9
83.8
0
88.1
93.9
0
81.6
90.3
0
91.2
100.6
0
80.3
88.0
0
76.7
91.8
0
88.4
103.0
0
75.2
86.5
0
75.2
84.9
0
73.1
71.9
0
77.0
84.7
0
59.0
68.2
0
84.9
96.0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
87.5
75.6
84.0
78.2
86.6
84.9
78.8
69.4
78.3
76.9
84.2
76.3
86.3
72.3
81.8
92.8
74.8
91.7
71.0
96.1
82.5
81.9
89.7
81.4
74.8
88.1
69.2
78.8
85.3
74.8
77.7
78.0
80.5
75.4
81.5
73.9
69.4
89.4
70.9
82.9
89.6
74.5
92.3
87.7
78.9
79.8
85.5
87.3
77.8
71.0
82.5
74.8
69.2
80.5
89.4
105.9
84.3
90.4
94.0
90.6
95.1
90.4
82.6
91.1
92.3
87.9
85.9
99.7
80.9
93.8
99.8
90.2
99.2
87.0
100.2
95.1
97.5
94.8
100.9
94.0
102.1
81.4
90.9
94.2
81.3
89.9
89.8
95.3
84.8
84.2
85.2
74.1
96.7
82.0
90.2
106.7
75.6
102.2
98.0
89.7
81.5
97.4
94.1
97.8
80.1
90.7
83.7
79.4
87.4
99.2
0
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
74.5
85.5
76.6
79.2
80.6
75.5
83.9
73.9
76.8
85.2
82.1
76.3
97.0
81.5
65.3
80.8
78.5
86.3
89.8
87.8
76.2
74.2
67.4
75.5
80.0
76.4
94.9
89.2
83.3
85.8
75.3
77.9
70.0
88.0
86.9
87.1
79.3
81.2
82.9
87.4
83.0
76.8
76.9
79.8
83.2
79.5
82.4
80.8
83.2
71.6
82.8
76.8
93.2
91.4
97.3
88.0
92.0
88.2
90.4
101.3
93.1
90.5
89.1
90.8
93.5
93.5
87.0
104.5
86.5
86.3
86.7
89.9
97.6
92.9
98.5
89.9
88.8
78.8
80.2
90.2
88.0
95.7
96.9
87.7
90.4
84.1
99.0
83.0
94.2
95.0
95.9
82.7
90.7
91.9
103.6
90.0
83.3
87.7
88.2
93.0
88.6
89.3
84.2
94.5
81.5
93.1
92.8
100.4
100.9
103.3
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
88.3
80.6
87.4
96.5
77.9
76.1
85.2
68.6
79.4
85.2
74.3
74.3
78.5
80.4
82.9
78.9
78.6
87.5
78.9
80.0
80.4
88.3
80.6
85.8
84.6
80.5
92.4
84.4
82.3
77.2
83.3
86.2
81.3
90.2
78.4
84.7
89.7
78.4
79.9
90.1
85.2
91.7
99.3
91.6
84.1
89.7
72.8
92.0
99.2
85.6
89.2
98.5
90.8
85.9
90.7
87.0
93.9
91.4
89.1
89.2
93.5
95.9
90.5
93.0
91.8
101.2
96.7
86.9
85.8
82.1
98.9
97.7
96.4
85.5
101.6
94.3
88.0
88.5

Purchase answer to see full
attachment

Explanation & Answer:

4 pages

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



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}