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

1. Open the Heart Rate Dataset 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).
2. Use the Scatter Plot function in the Insert Charts section of Excel to create a scatter plot of the X and Y variables
3. Add atrendlineto the scatter plot
4. Use the Data Analysis tools in Excel to find the regression equation.
5. 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?

OF7 7 837 101988 2 BB . 09 84 2 94 5 815 82 B 93.1 91 100.9 103 3 90.1 85 2 P9 3 101 3 179 91.6 76 1 84 1 85 2 89 7 128 T9 4 02 0 95 99 2 93 5 743 85.6 1045 29 85. 65 87 0 93.9 91 4 92 9 BO. 89 1 76.2 89.9 93.5 88 8 87 4 78 8 95 9 75. 80 2 93.0 91 8 76 4 BB.0 101.2 95.1 92 84 96 7 86 9 87. 85.8 99.0 86 2 81 3 97.7 70.0 83.0 94.2 964 78 85 5 95.0 87 95 0 04 3 82.7 BB.C 81 2 82 174 103.6 83 0 76 8 83 76 9 87 7