Question

Instructions: In this assignment, you use linear regression to calculate the expected after exercising heart rate.

Steps:

1. Open the Heart Rate database and identify the X-variable (resting) and the Y-variable (after exercise).

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 a trendline to the scatter plot (Find and View a YouTube video on how to do this if you need help)

4. Use the Data Analysis tools in Excel to perform regression analysis on the X and Y variables

In a Word document, describe the relationship between the X-variable (rest heart rate) and the Y-Variable (after exercise). Make certain you include the estimates for the intercept and the slope coefficients.

Heart Database:

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	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	89.6	106.7
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	82.5	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	85.5	92.0
1	76.6	88.2
1	79.2	90.4
1	80.6	101.3
1	75.5	93.1
1	83.9	90.5
1	73.9	89.1
1	76.8	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	80.8	86.7
1	78.5	89.9
1	86.3	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	94.9	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	79.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	100.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	92.0
1	85.2	99.2
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	93.5
1	80.6	95.9
1	85.8	90.5
1	84.6	93.0
1	80.5	91.8
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	101.6
1	89.7	94.3
1	78.4	88.0
1	79.9	88.5

Answer 1

1.Bring data in to excel sheet and selet restind and after exercise data.

2. Go to insert tab and choose scatter plot diagram.

3. right click on the chart and choose add trendline option.

4.select the trendline , right click and choose format trendline.

5. select linear as trendline option and check last three option ( set intercept, display equation chart on chart)

6. Go to dta--> data analysis and choose regression .

7. select X and Y variables and populate the regression analysis summary report.

8.

describe the relationship between the X-variable (rest heart rate) and the Y-Variable (after exercise).

If the points cluster in a band running from lower left to upper right, there is a positive correlation (if x increases, y increases)

so the releationship between X and Y variable is positive correlation

Make certain you include the estimates for the intercept and the slope coefficients.

The slope indicates the steepness of a line and the intercept indicates the location where it intersects an axis. The slope and the intercept define the linear relationship between two variables, and can be used to estimate an average rate of change. The greater the magnitude of the slope, the steeper the line and the greater the rate of change.

By examining the equation of a line, you quickly can discern its slope and y-intercept (where the line crosses the y-axis).

The slope is positive. y increases by 0.83 . The y-intercept is 23.