Explore BrainMass

Draw scatter diagram and find correlation coefficient

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

Car Weight MPG
1 3775 19
2 3964 17
3 3530 21
4 3175 22
5 2580 27
6 3730 18
7 2605 26
8 3772 17
9 3310 20
10 2991 25
11 2752 26

If car we add a car 12 that weighs 3305 lbs and gets 19 mpg complete parts A through E
A) Draw a scatter diagram
B)Compute the linear correlation coefficient with car 12 included
C) compare the linear correlation coefficient of part b with the linear correlation coefficient for the original data (for the original data linear correlation coefficient r= -.972) Why are results reasonable?
Because car 12 is a hybrid car
because car 12 does not follow the overall pattern of data
because car 12 follows the overall pattern of data
D) Suppose car 13 replaces car 12 on the original set of data. Car 13 weighs 2890 pounds and gets 60 miles per gallon. Construct a scatter diagram to show info

E) compute the linear correlation coefficient with car 13 included round to three decimal places

© BrainMass Inc. brainmass.com October 25, 2018, 6:46 am ad1c9bdddf

Solution Summary

The solution provides detailed explanation how to draw the scatter diagram and find correlation coefficient.

See Also This Related BrainMass Solution

Coefficients of correlation and determination, regression equations, and weighted moving averages

This posting has 5 examples of how to calculate a coefficient of correlation (r), coefficient of determination (r^2), regression equation, and weighted moving average.

1. The following sample observations were randomly selected.

[table of data] - SEE ATTACHMENT

Determine the coefficient of correlation and the coefficient of determination. Interpret.

2. Bi-lo Appliance Stores has outlets in several large metropolitan areas. The general sales manager
plans to air a commercial for a digital camera on selected local TV stations prior to a sale starting
on Saturday and ending Sunday. She plans to get the information for Saturday-Sunday digital
camera sales at the various outlets and pair them with the number of times the advertisement was
shown on the local TV stations. The purpose is to find whether there is any relationship between
the number of times the advertisement was aired and digital camera sales. The pairings are:

[table of data]

a. What is the dependent variable?
b. Draw a scatter diagram.
c. Determine the coefficient of correlation.
d. Determine the coefficient of determination.
e. Interpret these statistical measures.

3. Mr. James McWhinney, president of Daniel-James Financial Services, believes there is a
relationship between the number of client contacts and the dollar amount of sales. To document
this assertion, Mr. McWhinney gathered the following sample information. The X column indicates
the number of client contacts last month, and the Y column shows the value of sales ($ thousands)
last month for each client sampled.

[table of data]

a. Determine the regression equation.
b. Determine the estimated sales if 40 contacts are made.

4. We are studying mutual bond funds for the purpose of investing in several funds. For this particular
study, we want to focus on the assets of a fund and its five-year performance. The question
is: Can the five-year rate of return be estimated based on the assets of the fund? Nine mutual
funds were selected at random, and their assets and rates of return are shown below.

[table of data]

a. Draw a scatter diagram.
b. Compute the coefficient of correlation.
c. Compute the coefficient of determination.
d. Write a brief report of your findings for parts b and c.
e. Determine the regression equation. Use assets as the independent variable.
f. For a fund with $400.0 million in sales, determine the five-year rate of return (in percent).

5. The yield on a 30-year treasury note at the end of each year since 1990 is recorded below. Compute
a five-year weighted moving average using weights of .1, .1, .2, .3 and .3, respectively.
Describe the trend in yield.

[table of data]

View Full Posting Details