The following table gives the sales experience (in Months) and the number of computers sold during the previous month by 7 sales persons
Experience 4,12,9,6,10,30,7
Sales 19,42,28,31,39,30,21
using minitab output write the straight line (least squares) equation and the coefficient
The regression equation is Sales = 27.2 + 0.252 exp
Predictor Coef SE Coef T P
Constant 27.195 5.781 4.70 0.005
Exp 0.2517 0.4201 0.60 0.575
s=8.97833 R-Sq=6.7%
so this is where I am
4,6,7,9,19,12,30 I know the yis 27.195 and slope is 0.252
19,21,28,30,31,39,42
X Y Product
4-9=-5 19-30=-11 55
6-9=-3 21-30=-9 27
7-9=-2 28-30=-2 4
9-9=0 30-30=0 0
10-9=1 31-30 =1 1
12-9=3 39-30=9 27
30-9=21 42-30=12 252
55+27+4+0+1+27+252=366
(n-1)*sx*sy =correlation coeficient
correlation = 0.82385 So now how do I get the straight line equation? y=mx+b so 27.195=(.25175) (????)+27.19512
c)The I need to calculate 2 points to draw line on graph and give calculations.
d)Interpet what the slope means in term of the problem.
e)Identify a possible outlier, remove it and recalculate the new least squares line.
f)using my equation from (e)predict the number of sales for a person with 15 months experience.
g)can this model determine sales targets.
Experience 4,12,9,6,10,30,7
Sales 19,42,28,31,39,30,21
using minitab output write the straight line (least squares) equation and the coefficient
The regression equation is Sales = 27.2 + 0.252 exp
Predictor Coef SE Coef T P
Constant 27.195 5.781 4.70 0.005
Exp 0.2517 0.4201 0.60 0.575
s=8.97833 R-Sq=6.7%
so this is where I am
4,6,7,9,19,12,30 I know the yis 27.195 and slope is 0.252
19,21,28,30,31,39,42
X Y Product
4-9=-5 19-30=-11 55
6-9=-3 21-30=-9 27
7-9=-2 28-30=-2 4
9-9=0 30-30=0 0
10-9=1 31-30 =1 1
12-9=3 39-30=9 27
30-9=21 42-30=12 252
55+27+4+0+1+27+252=366
(n-1)*sx*sy =correlation coeficient
correlation = 0.82385 So now how do I get the straight line equation? y=mx+b so 27.195=(.25175) (????)+27.19512
c)The I need to calculate 2 points to draw line on graph and give calculations.
d)Interpet what the slope means in term of the problem.
e)Identify a possible outlier, remove it and recalculate the new least squares line.
f)using my equation from (e)predict the number of sales for a person with 15 months experience.
g)can this model determine sales targets.