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

 

• Running head
• A title page with
  • Assignment name
  • Your name
  • Professor’s name
  • Course

 

Estimated time to complete: 3 hours