Heart Rate Dataset 

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.StepsOpen 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 variablesAdd a trendline to the scatter plotUse 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).

Calculate Price

Price (USD)