Regression Analysis

/in /by

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:

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"
[promo2]