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?

Heart rate before and after exercise
M=0 F=1	Resting	After Exercise
0	55.0	65.0
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	67.0	79.9
0	85.0	100.0
0	86.2	95.9
0	83.9	93.9
0	78.1	87.2
0	64.0	70.7
0	72.8	86.7
0	65.0	75.0
0	80.2	83.3
0	78.2	86.0
0	62.0	88.0
0	75.5	84.4
0	82.7	89.1
0	87.7	95.1
0	76.0	88.7
0	73.4	82.7
0	80.1	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	72.0	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	87.5	105.9
0	75.6	84.3
0	84.0	90.4
0	78.2	94.0
0	86.6	90.6
0	84.9	95.1
0	78.8	90.4
0	69.4	82.6
0	78.3	91.1
0	76.9	92.3
0	84.2	87.9
0	76.3	85.9
0	86.3	99.7
0	72.3	80.9
0	81.8	93.8
0	92.8	99.8
0	74.8	90.2
0	91.7	99.2
0	71.0	87.0
0	96.1	100.2
0	82.5	95.1
0	81.9	97.5
0	89.7	94.8
0	81.4	100.9
0	74.8	94.0
0	88.1	102.1
0	69.2	81.4
0	78.8	90.9
0	85.3	94.2
0	74.8	81.3
0	77.7	89.9
0	78.0	89.8
0	80.5	95.3
0	75.4	84.8
0	81.5	84.2
0	73.9	85.2
0	69.4	74.1
0	89.4	96.7
0	70.9	82.0
0	82.9	90.2
0	60.1	79.0
0	74.5	75.6
0	92.3	102.2
0	87.7	98.0
0	78.9	89.7
0	79.8	81.5
0	85.5	97.4
0	87.3	94.1
0	77.8	97.8
0	71.0	80.1
0	70.0	90.7
0	74.8	83.7
0	69.2	79.4
0	80.5	87.4
0	89.4	99.2
0	74.5	88.0
0	70.0	100.0
1	60.0	78.1
1	79.2	90.4
1	80.5	101.3
1	75.4	93.1
1	83.7	90.5
1	73.9	89.1
1	76.0	90.8
1	85.2	93.5
1	82.1	93.5
1	76.3	87.0
1	97.0	104.5
1	81.5	86.5
1	65.3	86.3
1	60.8	86.7
1	78.5	89.9
1	60.4	97.6
1	89.8	92.9
1	87.8	98.5
1	76.2	89.9
1	74.2	88.8
1	67.4	78.8
1	75.5	80.2
1	80.0	90.2
1	76.4	88.0
1	60.0	95.7
1	89.2	96.9
1	83.3	87.7
1	85.8	90.4
1	75.3	84.1
1	77.9	99.0
1	70.0	83.0
1	88.0	94.2
1	86.9	95.0
1	87.1	95.9
1	60.3	82.7
1	81.2	90.7
1	82.9	91.9
1	87.4	103.6
1	83.0	90.0
1	76.8	83.3
1	76.9	87.7
1	79.8	88.2
1	83.2	93.0
1	79.5	88.6
1	82.4	89.3
1	80.8	84.2
1	83.2	94.5
1	71.6	81.5
1	82.8	93.1
1	76.8	92.8
1	93.2	89.4
1	91.4	100.9
1	97.3	103.3
1	88.3	90.1
1	80.6	85.2
1	87.4	91.7
1	96.5	99.3
1	77.9	91.6
1	76.1	84.1
1	85.2	89.7
1	68.6	72.8
1	79.4	91.0
1	85.2	99.1
1	74.3	85.6
1	74.3	89.2
1	78.5	98.5
1	80.4	90.8
1	82.9	85.9
1	78.9	90.7
1	78.6	87.0
1	87.5	93.9
1	78.9	91.4
1	80.0	89.1
1	80.4	89.2
1	88.3	90.5
1	80.6	95.9
1	85.8	90.5
1	84.6	93.0
1	90.5	101.2
1	92.4	101.2
1	84.4	96.7
1	82.3	86.9
1	77.2	85.8
1	83.3	82.1
1	86.2	98.9
1	81.3	97.7
1	90.2	96.4
1	78.4	85.5
1	84.7	90.9
1	89.7	94.3
1	78.4	88.0
1	70.0	80.0

Answer rating: 100% (QA)

To perform the analysis as requested follow these steps 1 Identify Variables Xvariable Resting heart rates for all 200 participants Yvariable After ex... View the full answer