Statistics assessment unit 7 simple linear regression due saturday


Unit 7

Attached Files:

Assessment Unit 7 Simple Linear Regression due Saturday

Evaluation Title: Assignment 7 Rubric

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


  1. Open the Heart Rate database 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 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 certain you include the estimates for the intercept and the slope coefficients.

Additional Instructions: Your assignment should be typed into a Word or other word processing document, formatted in APA style.

Estimated time to complete: 3 hours


Correlation: Against all odds: Inside statistics [Video file]. (2013). Retrieved August 2, 2017, from

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.

Click Here to Make an Order Click Here to Hire a Writer