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.

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.

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 a trendline to 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?

Review these videos as needed to complete this assignment.
Creating an XY Scatter Plot in Excel


Using Excel to Calculate a Correlation Coefficient

Directions: This video does a very good job explaining correlations as well as how to produce the correlation coefficient in Excel.

Additional Instructions:

Your assignment should be typed into a Word or other word processing document, formatted in APA style. The assignments must include

Running head
A title page with
Assignment name
Your name
Professor’s name
Course

Answer preview to 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.

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.

APA

510 words

Get instant access to the full solution from yourhomeworksolutions by clicking the purchase button below

The post 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. appeared first on .



Logo
.
CLICK HERE TO ORDER 100% ORIGINAL PAPERS AT PrimeWritersBay.com

Comments

Post a Comment

Popular posts from this blog

Analyze Beefsteak’s company profile and business model.

Image
Analyze Beefsteak’s company profile and business model. Review Chapters 1, 11, 12 and 13 in your Applied Psychology in Talent Management text. Watch the Week 4 Assignment video above with Brenda Forde, Program Chair of MBA. Review the articles listed for the Contemporary Human Capital Topics discussion: The Big Disconnect in Your Talent Strategy and How to Fix It Reimagining Time Off HR Then and Now: 6 Trends That Have Shaped the Workplace—and HR—Over the Past Decade Diversity & Innovation: Meet Five Leaders Who Have Invented New Approaches to D & I Review the articles listed for the Current Human Capital Management: Predictive Analysis discussion: Data Science and Predictive Analytics Enabling Better Hiring Mechanisms for Enterprises An Algorithm for Success: People Analytics Are Becoming as Important as People Skills in Making Insightful workforce Decisions. Visit the Beefsteak Case Study page to explore the Company Background Information Packet and review the Company Backg
Read more

Outline the four “Key Messages” that structure the IOM Report recommendations.

Image
Outline the four “Key Messages” that structure the IOM Report recommendations. Review the IOM report, “The Future of Nursing: Leading Change, Advancing Health,” and explore the “Campaign for Action: State Action Coalition” website. In a 1,000-1,250 word paper, discuss the influence the IOM report and state-based action coalitions have had on nursing practice , nursing education, and nursing workforce development, and how they continue to advance the goals for the nursing profession. Include the following: Describe the work of the Robert Wood Foundation Committee Initiative that led to the IOM report, “Future of Nursing: Leading Change, Advancing Health.” Outline the four “Key Messages” that structure the IOM Report recommendations. Explain how these have transformed or influenced nursing practice, nursing education and training, nursing leadership, and nursing workforce development. Provide examples. Discuss the role of state-based action coalitions. Explain how these coalitions h
Read more

Poetry Analysis Essay (3G) that defends a thesis you developed through a close critical reading

Image
Poetry Analysis Essay (3G) that defends a thesis you developed through a close critical reading Poetry Analysis Essay Poetry Analysis Essay (3G) that defends a thesis you developed through a close critical reading/analysis of three (or more) works of poetry listed on the syllabus. Your analysis relies mainly on textual support from the primary text, but can also include at secondary sources that support/sustain your argument. Do not confuse “critical analysis” with “plot summary;” the goal is to develop, sustain, and advance a thesis based on a critique of the primary text that clearly demonstrates the presence of a major themes in the chosen collection of works. a_3f Answer preview to Poetry Analysis Essay (3G) that defends a thesis you developed through a close critical reading APA 2180 words Get instant access to the full solution from yourhomeworksolutions by clicking the purchase button below  The post Poetry Analysis Essay (3G) that defends a thesis you developed th
Read more