Question

Ten salespeople were surveyed and the average number of client contacts per month, x, and the...

Ten salespeople were surveyed and the average number of client contacts per month, x, and the sales volume, y (in thousands), were recorded for each: X   40   42   44   40   41   46   50   48   50   55 Y   50   55   42   45   30   80   90   95   110   130

a)   Find the correlation coefficient r.

b)   Find the regression equation

c)   Construct the scatter plot and graph the regression equation.

Homework Answers

Answer #1

SOLUTION:-

(A)

X Values
∑ = 456
Mean = 45.6
∑(X - Mx)2 = SSx = 232.4

Y Values
∑ = 727
Mean = 72.7
∑(Y - My)2 = SSy = 9886.1

X and Y Combined
N = 10
∑(X - Mx)(Y - My) = 1426.8

R Calculation
r = ∑((X - My)(Y - Mx)) / √((SSx)(SSy))

r = 1426.8 / √((232.4)(9886.1)) = 0.9413

r = 0.9413

This is a strong positive correlation, which means that high X variable scores go with high Y variable scores

(B)

Sum of X = 456
Sum of Y = 727
Mean X = 45.6
Mean Y = 72.7
Sum of squares (SSX) = 232.4
Sum of products (SP) = 1426.8

Regression Equation = ŷ = bX + a

b = SP/SSX = 1426.8/232.4 = 6.13941

a = MY - bMX = 72.7 - (6.14*45.6) = -207.25731

ŷ = 6.13941X - 207.2573

(C)

ANSWERED

THIS IS A 100% VALID ANSWER

SO PLEASE RATE ME POSITIVE

THANKS

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Mr. James McWhinney, president of Daniel-James Financial Services, believes there is a relationship between the number...
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 ycolumn shows the value of sales ($ thousands) last month for each client sampled. (Round your answers to 3 decimal places.) Number of Contacts, x Sales ($ thousands), y Number of...
Barclay's manager of Financial Service wants to find out the relationship between the number of client...
Barclay's manager of Financial Service wants to find out the relationship between the number of client contacts and the dollar amount of sales ($ thousands). She recorded the amount of sales ($ thousands) last month from ten randomly selected clients. The results from the Regression are presented below: y^=1.4606x-6.5321;R2=0.735 What are the Independent and Dependent Variables? Independent variable:   Dependent variable:   What is the value of the correlation coefficient? Interpret it. What % of the variation in the amount of sales...
Mr. James McWhinney, president of Daniel-James Financial Services, believes there is a relationship between the number...
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. Number of Contacts, X Sales ($ thousands), Y Number of Contacts, X Sales ($ thousands), Y...
Use the following dataset for the next four questions: X:     5     3     6     3     4     4    ...
Use the following dataset for the next four questions: X:     5     3     6     3     4     4     6     8 Y:    13    15    7    12    13    11    9    5 1. (3 points) What is the correlation value “r”? a. -0.98 b. -0.89 c. 0.89 d. None of the above 2. (3 points) Is the “r” signifcant at alpha = 0.05? (circle one)     Yes     No 3. (4 points) Identify the regression equation below (note: Y is the dependent variable): a. Y = 19.12...
Mr. James McWhinney, president of Daniel-James Financial Services, believes there is a relationship between the number...
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. (Round the final answers to 2 decimal places.) Number of Contacts, X   Sales ($ thousands), Y  ...
Provide answers for each prompt. Scatter plot (copy and paste) Find correlation coefficient using Excel Find...
Provide answers for each prompt. Scatter plot (copy and paste) Find correlation coefficient using Excel Find means and standard deviations of Reading score and Math score. Interpret the result (regarding the correlation). Reading score Math score 45 102 40 100 48 106 45 101 38 98 43 100 36 92 41 102 42 102 50 110 43 104 50 108 42 96 40 99 41 96 48 102 47 104 37 94 42 98 45 100 Reading Score Mean= Math...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (The pair of variables have a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The table below shows the heights​ (in feet) and the number of stories of six notable buildings in a city. Height x= 772 628 518 508 496 483 Stories,...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (The pair of variables have a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The table below shows the heights​ (in feet) and the number of stories of six notable buildings in a city. Height comma x 764 625 520 510 492 484...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (The pair of variables have a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The table below shows the heights​ (in feet) and the number of stories of six notable buildings in a city. Height, x: 758, 621, 518, 510, 492, 483 Stories,...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (The pair of variables have a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The table below shows the heights​ (in feet) and the number of stories of six notable buildings in a city. Height comma xHeight, x 772 628 518 508 496...