Instructions 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 atrendlineto 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

The Answer is in the image, click to view ...

Question: Instructions In this lesson, you will run a correlation between the resting and after exercising heart rates to determine if a linear relationship exists between

Instructions

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 atrendlineto 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?

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!

Instructions 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...

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...

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...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

PSYC 355 SPSS HOMEWORK 4 INSTRUCTIONS: TWO-WAY ANOVA Part 1: Note: For a two-way ANOVA, you will be expected to create a line graph as covered in the SPSS tutorial in the Course Content (and not a...

PSY-380 Introduction to Probability and Statistics Project 3 Answer each question completely. Copy and Paste the SPSS output into the word document for the calculations portion of the problems,...

OPRE 3360: Managerial Methods in Decision Making Under Uncertainty Graded Group Assignment 2: Hypothesis Testing and Statistical Inference This group assignment is open book and notes. However, once...

A researcher is interested to learn if there is a linear relationship between the hours in a week spent exercising and a person's life satisfaction. The researchers collected the following data from...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

The following data reflects the number of cars sold at a local dealership over a ten-month period. Calculate the MAPE for months 4 through 10 using a three month moving average forecast. Time Period...

Using the data for Leotard Travel Service shown in Practice Exercise 1-4B, prepare a statement of owners equity for the current year ended February 28, 2008. Harry Thompson invested an additional...

There are five end - of - year journal entries when consolidating financial statements indexed with the letters CEADI Describe each journal entry and its purpose.

5 pong In the next year, the economy can enter either a boom, a bust or remain in a normal state with the probabilitles stated in the table. An investment has the following retums given the specific...

developing thick cultural analysis grounded in interaction situations such as international joint ventures;

advancing understanding of the interaction processes of cultures, within power relations, that give rise to successful and unsuccessful hybrid forms of managing through cross-vergence of cultures;

breaking out of previously conceived and investigated cultural dimensions, to develop new concepts that are more helpful in overcoming pejorative assumptions about cultures outside Western traditions;