In this lesson, you will run a correlation between the resting and after exercising heart rates to determine if a linear relationship exists between the two variables and how strong the relationship is.
Steps

Open the Heart Rate Dataset in Excel and identify the X-variable (resting heart rates for all 200 participants) and the Y-variable (after exercise heart rates for all 200 participants).
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
Use the Data Analysis tools in Excel to find the regression equation.
In a Word document, describe the relationship between the X-variable (resting heart rate)and the Y-variable (after exercise heart rate).  

Graph the scatter plot with a trend line. Does it appear there is a linear relationship?  What does this mean?
Calculate the correlation coefficient r using excel. Is this r (value) high compared to +1?  Based on the correlation coefficient is the relationship strong?
Use excel to find the regression equation. Identify the slope.  What does it tell us in terms of our heart rate data?

Review these videos as needed to complete this assignment.
Creating an XY Scatter Plot in Excel
Running Head: HEART RATE DATASET
1
Heart Rate Dataset
Kearston Avery
Jorge Gavillan
Statistics
HEART RATE DATASET
2
Heart Rate Dataset
The heart rate data set has three variables. They include gender, heart rate at rest and heart rate
after an exercise. The gender variable is classified as qualitative discrete variable where 0=male
and 1=female. The variable is best represented by a pie chart. On the other hand, heart rates
before and after the exercise are classified as quantitative continuous variables and are best
represented by a histogram.
Appropriate Graphs:
a) The gender variable
Pie chart
male
108
Female
92
Gender Pie Chart
Female
46%
male
54%
male
Female
The pie chart implies that the population under study consist of 54 percent male and 46
percent female.
HEART RATE DATASET
3
b) Heart Rate Before the exercise:
Best displayed by a histogram
From the graph, it is clear that the data is skewed towards the left. The heart rate of the
majority lies between 71 and 91 with majority between 75 and 79.
c) Heart rate after exercise
Best displayed by a histogram
The distribution is approximately normal with the center between 89.2 and 93.4.
Comparing to the histogram before the exercise, the heart rate has significantly increased
after the exercise.

Purchase answer to see full
attachment