Docstoc

Regression

Document Sample
Regression Powered By Docstoc
					     Advertising Actual Sales
Obs. (in '000 Rs.) (in '000 Rs.)
   1            30         184.40
   2            40         279.10           600.00
   3            40         244.00
   4            50         314.20
   5            60         382.20           500.00
   6            70         450.20
   7            70         423.60           400.00
   8            70         410.20




                                    Sales
   9            80         500.40           300.00
  10            90         505.30
                                            200.00

                                            100.00

                                              0.00
                                                     0               50           100
                                                         Advertising Expenditures
      Series1




100
     Advertising Actual Sales Est. Sales              Squared
Obs. (in '000 Rs.) (in '000 Rs.) (in '000 Rs.) Error Error
   1            30         184.40       202.85 -18.45   340.44
   2            40         279.10       258.35 20.75    430.39
   3            40         244.00       258.35 -14.35   206.04               600.00
   4            50         314.20       313.86 0.34        0.12
   5            60         382.20       369.36 12.84    164.87               500.00
   6            70         450.20       424.86 25.34    641.97
                                                                             400.00
   7            70         423.60       424.86 -1.26       1.59




                                                                     Sales
   8            70         410.20       424.86 -14.66   215.00               300.00
   9            80         500.40       480.37 20.03    401.37
  10            90         505.30       535.87 -30.57   934.44               200.00

                                                                             100.00
     Intercept             36.34              ESS      3336.24
     Slope                  5.55                                               0.00
                                                                                      0         50
                                                                                          Advertising Exp.



                                                                  R^2 ?         Y=a+bX
                         Series1
                         Series2




      50           100
Advertising Exp.
SUMMARY OUTPUT

     Regression Statistics
Multiple R           0.984444
R Square             0.969131
Adjusted R Square 0.965272
Standard Error       20.42132
Observations               10

ANOVA
                          df       SS       MS        F   Significance F
Regression                     1 104739.6 104739.6 251.1558 2.51E-07
Residual                       8 3336.244 417.0305
Total                          9 108075.8

                                Standard Error t Stat
                      Coefficients                    P-value Lower 95%Upper 95%Lower 95.0%
Intercept              36.34235 21.98328 1.653181 0.136894 -14.3512 87.03593 -14.3512
X Variable 1           5.550294 0.350223 15.84789 2.51E-07 4.742678 6.35791 4.742678




RESIDUAL OUTPUT                                     PROBABILITY OUTPUT

   Observation        Predicted Y Residuals         Percentile   Y
                  1    202.8512 -18.4512                     5   184.4
                  2    258.3541 20.74588                   15      244
                  3    258.3541 -14.3541                   25    279.1
                  4    313.8571 0.342941                   35    314.2
                  5       369.36      12.84                45    382.2
                  6    424.8629 25.33706                   55    410.2
                  7    424.8629 -1.26294                   65    423.6
                  8    424.8629 -14.6629                   75    450.2
                  9    480.3659 20.03412                   85    500.4
                 10    535.8688 -30.5688                   95    505.3
                                      X Variable 1 Residual Plot

                           40
              Residuals    20
                            0
                          -20 0          20      40       60       80   100
                          -40
                                                 X Variable 1




                                        Normal Probability Plot
                           600
Upper 95.0%                400
              Y




  87.03593                 200
   6.35791                   0
                                  0       20      40       60      80   100
                                               Sample Percentile
     Advertising Actual Sales
Obs. (in '000 Rs.) (in '000 Rs.)
   1            30         184.40
   2            40         279.10
   3            40         244.00
   4            50         314.20
   5            60         382.20
   6            70         450.20
   7            70         423.60
   8            70         410.20
   9            80         500.40
  10            90         505.30

				
Kapil Angraje Kapil Angraje
About PLEASE CLICK ON THE ADS!!