User Account

All Pages

Calculate the correlation coefficient

Assignment Help Basic Statistics
Reference no: EM132414181

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

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

2. Use the Scatter Plot function in the Insert Charts section of Excel to create a scatter plot of the X and Y variables

3. Add a trendline to the scatter plot

4. Use the Data Analysis tools in Excel to find the regression equation.

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

Attachment:- linear relationship.rar

Reference no: EM132414181

Questions Cloud

What is booth additional funds needed : Booth's after-tax profit margin is forecasted to be 5% and its payout ratio to be 60%. What is Booth's additional funds needed (AFN) for the coming year?
Calculate tax credit on disposal : This asset qualifies as a five-year recovery asset under MACRS. The five-year expense percentages for years 1, 2, 3, and 4 are 20.00%
What is a indenture-what is a debenture : What is a indenture? What is a debenture? What happens if a company is to call outstanding bonds?
FINS3648 Banking, Finance and Technology - Python Assignment : FINS3648/FINS5548 Banking, Finance and Technology - Python Assignment Help and Solution, University of New South Wales, Australia
Calculate the correlation coefficient : Determine if a linear relationship exists between the two variables and how strong the relationship - Use the Data Analysis tools in Excel to find regression
Descriptive statistics analysis : Describe Sun Coast data using descriptive statistics tools discussed in unit lesson. Establish assumptions are met to use parametric statistical procedures.
Capital budgeting-managerial accounting : The purpose of this assignment is for students to research and learn about current topics in managerial accounting.
About the length reactionary forces : How did the incident serve as a wake up call to America at large about the length reactionary forces were willing to go to in order to prevent the desegregation
What is p-value for null hypothesis of no treatment effect : STAT 645 Assignment - Based on the model, what is the p-value for the null hypothesis of no treatment effect? Report coefficient estimates and standard erros

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd