Question: 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

 in this lesson, you will run a correlation between the resting

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 1. Open the Heart Piste Dataset in Excel and identity the X-uartabie {resting heart rates for all 200 participants) and the Yuariabie latter exercise heart rates tor all 200 participants}. 2. Use the Scatter Plot function in the Insert Charts section o! Excel to create a scatter plot oi the X and Y variables 3. Add a trendltne to the scatter plot 4. Use the Data Analysis tools in Excel to find the regression equation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!