Assignment - Relationships Between Variables

Assignment Help Applied Statistics

Reference no: EM132491214

Assignment - Relationships Between Variables, Herzing University, USA

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?

Additional Instructions: Your assignment should be typed into a Word or other word processing document, formatted in APA style.

Attachment:- Relationships Between Variables Assignment & Data Files.rar

Reference no: EM132491214

Questions Cloud

Market rate of return for type of security : It is February 2016. Whole Foods Market, Inc. just made an annual earnings announcement of $1.62 per share and is expected to increase that amount

Describe the structure of lcrs trees : Write a function and accompanying test harness to empirically measure the performance of one of the three array search algorithms

What is the yield to maturity : A josh bond has a par value of $1,000, a yield of 5.71 percent, and a coupon of 4.71 percent, paid semiannually and sells for $825.50. What is the unusual featu

Develop two sampling structure probability and nonprobabilty : Develop two sampling structure i.e. probability and nonprobabilty. Explain who would be included in each sample and how each sample would be selected.

Assignment - Relationships Between Variables : Assignment - Relationships Between Variables, Herzing University, USA. Calculate the correlation coefficient r using excel. Graph scatter plot with a trend line

What is the corresponding direct exchange rate : 1.The indirect quotation for the exchange rate between the Japanese yen and the US dollar is currently ¥107.8000/$1.

Discuss about the coevolution : Discuss about the coevolution. describes your favorite example of coevolution between one or more species. In your summary, please describe the relationships

How much would billy gain or lose if he purchased : How much would Billy gain or lose if he purchased a 30-year zero-coupon bond with a $1,000 par value and 9% yield to maturity

What is the economic impact of coronavirus in the US : What is the economic impact of coronavirus in the US? What are the main economic measures implemented by the government and policymakers?

User Account

All Pages