Overview
In this lesson, you will run a correlation between 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 Set 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).
Review these videos as needed to complete this assignment.
Creating an XY Scatter Plot in Excel
(Vertex42, 2017)
Estimated time to complete: 6 minute
https://www.youtube.com/watch?v=gBbGBrHTMrm
Using Excel to Calculate a Correlation Coefficient
Directions: This video does a very good job explaining correlations as well as how to produce the correlation coefficient in Excel.