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

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

Open the Heart Rate Dataset in Excel and identify the X-variable (resting) and the Y-variable (after exercise).

Use the Scatter Plot function in the Insert Charts section of Excel to create a scatter plot of the X and Y variables

Add a trendline to the scatter plot (Find and view a YouTube video on how to do this if you need help)

Use the Data Analysis tools in Excel to perform a 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 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

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