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 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
Get step-by-step solutions from verified subject matter experts
