When you determine if there is an association between two variables, it is also important for you to determine how strong or weak that association is This is why, when you have data for two quantitative variables, you calculate what is called the coefficient for correlation In this assignment, you will answer questions and solve problems involving the coefficient for correlation Instructions Suppose you are determining the association between the weight of a car and the miles per gallon that the car gets Answer the following questions in a Word document In your own words, define correlation and talk about how you can use correlation to determine the relationship between these two variables Before you look at some data, what kind of association do you think will exist between the weight of a car and the miles per gallon that the car gets Will it be positive or negative Given the data below, use Excel or other technology to calculate the correlation coefficient for this data Model City MPG Weight Mazda MX 5 Miata 25 2365 Mercedes Benz SLK 22 3020 Mitsubishi Eclipse 23 3235 Pontiac Firebird 18 3545 Porsche Boxster 19 2905 Saturn SC 27 2420 Now that you have calculated the correlation, what does this value represent What does it tell you about the relationship between these two variables

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

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 23, 2024

When you determine if there is an association between two variables, it is also important for you to determine how strong or weak that association

When you determine if there is an association between two variables, it is also important for you to determine how strong or weak that association is. This is why, when you have data for two quantitative variables, you calculate what is called the coefficient for correlation. In this assignment, you will answer questions and solve problems involving the coefficient for correlation.

Instructions

Suppose you are determining the association between the weight of a car and the miles per gallon that the car gets. Answer the following questions in a Word document:

In your own words, define correlation and talk about how you can use correlation to determine the relationship between these two variables.
Before you look at some data, what kind of association do you think will exist between the weight of a car and the miles per gallon that the car gets? Will it be positive or negative?
Given the data below, use Excel or other technology to calculate the correlation coefficient for this data:

Model

City MPG

Weight

Mazda MX-5 Miata

2365

Mercedes/Benz SLK

3020

Mitsubishi Eclipse

3235

Pontiac Firebird

3545

Porsche Boxster

2905

Saturn SC

2420

Now that you have calculated the correlation, what does this value represent? What does it tell you about the relationship between these two variables?