valuation Title:Simple Linear Regression

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

Steps

1. Open the Heart Rate Dataset in Excel 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 atrendlineto the scatter plot (Find and view aYouTubevideo on how to do this if you need help)
4. Use the Data Analysis tools in Excel to perform a regression analysis on the X and Y variables.
5. In a Word document,describe the relationship between the X-variable (rest heart rate)and the Y-variable (after exercise).Make sure you include the following:

• Scatter plot with a trend line
• Estimates for the intercept