Relationships Between Variables

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

Don't use plagiarized sources. Get Your Custom Essay on

Just from $13/Page

Order Essay

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

(Vertex42, 2017)
Estimated time to complete: 6 minutes

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.

(Matt Macarty, 2016)
Estimated time to complete: 6 minutes

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

Plagiarism Free Papers

We ensure that all our papers are written from scratch. We deliver original plagiarism-free work. To guarantee this, we submit all work alongside a plagiarism report.

Free Revisions

All our papers are completed and submitted before the deadline. We ensure this to provide you with enough time to go through the work and point out any sections or topics that may need revision or polishing. We provide unlimited revision services for free.

Title-page

All papers have a title page providing your personal and institutional information. We do not charge you for this title page.

Bibliography

All papers have a bibliography or references page. This page is a requirement for academic and professional documents. We provide this page at no cost for all our papers.

Originality & Security

At Thehomeworklabs, we guarantee the confidentiality and security of your information. We value our clients and take confidentiality seriously. All personal information is treated with confidentiality and stored safely to ensure that no third parties gain access to it. We also provide original work and attach an originality/plagiarism report alongside all papers.

24/7 Customer Support

Our customer support team is available 24/7 to provide you with any necessary assistance when you need it. You can contact us at any time, day or night, via email or through the live chat button.

Try it now!

Calculate the price of your order

Type of paper needed:

Pages:

Academic level:

Total price:

$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

We provide our customers with the best experience in the academic and business writing field.

Pricing

Flexible Pricing

We provide the best quality of service at affordable prices. We also allow our clients to make partial payments for their orders. You can also contact our customer support team in case you need to discuss a different payment plan.

Communication

Admission help & Client-Writer Contact

We realize that sometimes clarification is necessary to ensure that quality work is done. Therefore, we provide a button for clients and writers to communicate in case some clarification is needed.

Deadlines

Paper Submission

We ensure that we submit all papers ahead of their respective deadlines. This allows you to go through the documents and request any revision, corrections, or polishing before the paper is due.

Reviews

Customer Feedback

We encourage customer feedback, positive or negative. We can identify the various areas that we need to improve to provide even better services through your feedback. Please feel free to give us feedback.