Suppose you are determining the association between the weight of a car and the
ID: 3159519 • Letter: S
Question
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?
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
Explanation / Answer
Correlation is a statistical technique that can show whether and how strongly pairs of variables are related.Correlation is measure of relationship between two variables.As per my knowledge there is negative relationship between the weight of a car and the miles per gallon.
correlation is - 0.812 therefor by correlation we conclude that there is negative relationship between the weight of a car and the miles per gallon.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.