Explore BrainMass
Share

Regression and Correlation

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

11. A study is conducted concerning automobile speeds and fuel consumption rates. The following data is collected:

Speed MPG

44 22
51 26
48 21
60 28
66 33
61 32

a. Plot these data in a scatter diagram.
b. Compute the coefficient of correlation.
c. Determine the regression equation.

© BrainMass Inc. brainmass.com October 25, 2018, 12:41 am ad1c9bdddf
https://brainmass.com/statistics/regression-analysis/statistics-regression-correlation-237098

Solution Preview

** Please see the attached Excel file. **

Speed MPG
44 22
51 26
48 21
60 28
66 33
61 32

a. Plot these data in a scatter diagram.

Go to insert --> chart.
Choose XY ...

Solution Summary

This solution shows how to create a scatter diagram, compute the coefficient of correlation, and determine the regression equation in Excel for the given problem.

$2.19
See Also This Related BrainMass Solution

Statistics: Regression, Correlation, ANOVA

1. Find the equation of the regression line for the given data. What is the predicted value of Y when X = -2? What is the predicted value of Y when X = 4?

X -5 -3 4 1 -1 -2 0 2 3 -4
Y -10 -8 9 1 -2 -6 -1 3 6 -8

2. The data below are the final exam scores of 10 randomly selected statistics students and the number of hours they studied for the exam. Find the equation of the regression line for the given data. Predict the final exam score for students who studied 4 hours. Predict th final exam score for students who studied 6 hours.

Hours (X) 3 5 2 8 2 4 4 5 6 3
Score (Y) 65 80 60 88 66 78 85 90 90 71

3. Find the correlation coefficient between X and Y. Is there a weak or strong, positive or negative correlation between X and Y?

X -5 -3 4 1 -1 -2 0 2 3 -4
Y -10 -8 9 1 -2 -6 -1 3 6 -8

4. An investigator hypothesizes that light affects the growth rate of bacteria. She exposed cultures to red light, blue light, and no light at all. The test data are the number of hours required for the bacteria colonies to double in size. Perform a one-way ANOVA analysis, testing at the 0.05 level. Describe your results.

Group Test data

Red light 7 4 6 8 6 6 2 9
Blue light 5 5 3 4 4 7 2 2
No light 2 4 7 1 2 1 5 5

View Full Posting Details