Explore BrainMass

# Covariance and Correlation

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

See attached file.

There are several methods for calculating fuel economy. Go to the Resources section in this syllabus and open the file mileage.xls. The table in the file indicates the mileage, as calculated by owners and by current standards.

1. Compute the covariance.
2. Compute the correlation coefficient.
3. Which do you think is more valuable in expressing the relationship between the owner and current government standards mileage - the covariance or the correlation coefficient? Explain.
4. What conclusions do you reach about the relationship between owner and current government standards mileage?

https://brainmass.com/statistics/correlation/covariance-and-correlation-316974

#### Solution Preview

See attached file.

1. Covariance between mileage calculated by owner and by current standards.

Use =covar() function.

covariation =

2. Correlation between mileage calculated by owner and by current standards.

Use =pearson() function.

correlation (r) =

3. Which do you think is more valuable in expressing the relationship between the owner and current government standards mileage - the ...

\$2.49