statistic

Instructions

Develop: Regression Analysis

Evaluation 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 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 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
   • Slope coefficients

Additional Instructions:

Your assignment should be typed into a Word or other word processing document, formatted in APA style. The assignments must include