Regression
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Regression as PDF for free.
More details
- Words: 420
- Pages: 7
Sales
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
525.00 500.00 475.00 450.00 425.00 400.00 375.00 350.00 325.00 300.00 275.00 250.00 225.00 200.00 175.00
Column C
30
40
50
60
70
80
Advertising Expenditures
90
0
Column C
80
nditures
90
550.00 500.00 450.00 Sales
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 4 50 314.20 313.86 0.34 0.12 5 60 382.20 369.36 12.84 164.87 6 70 450.20 424.86 25.34 641.97 7 70 423.60 424.86 -1.26 1.59 8 70 410.20 424.86 -14.66 215.00 9 80 500.40 480.37 20.03 401.37 10 90 505.30 535.87 -30.57 934.44
400.00 350.00
Colum Colum
300.00 250.00
Intercept Slope
36.34 5.55
ESS
3336.24
200.00 150.00 30
40
50
60
70
Advertising Exp.
R^2 ?
Y=a+bX
80
90
0
Column C Column D
70
ng Exp.
80
90
SUMMARY OUTPUT Regression Statistics Multiple R 0.98 R Square 0.97 Adjusted R Square 0.97 Standard Error 20.42 Observations 10 ANOVA df Regression Residual Total
Intercept X Variable 1
SS MS 1 104739.6 104739.6 8 3336.24 417.03 9 108075.84
Coefficients Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% 36.34 21.98 1.65 0.14 -14.35 87.04 -14.35 87.04 5.55 0.35 15.85 0 4.74 6.36 4.74 6.36
RESIDUAL OUTPUT Observation
F Significance F 251.16 0
Predicted Y Residuals 1 202.85 -18.45 2 258.35 20.75 3 258.35 -14.35 4 313.86 0.34 5 369.36 12.84 6 424.86 25.34 7 424.86 -1.26 8 424.86 -14.66 9 480.37 20.03 10 535.87 -30.57
PROBABILITY OUTPUT Percentile 5 15 25 35 45 55 65 75 85 95
Y 184.4 244 279.1 314.2 382.2 410.2 423.6 450.2 500.4 505.3
Residuals
20 0 -20 -40 Row Row Row Row Row Row Row Row Row Row 25 26 27 28 29 30 31 32 33 34 X Variable 1
Y
Upper 95.0%
X Variable 1 Residual Plot
Normal Probability Plot
600 500 400 300 200 100 0
10
20
30
40
50
60
70
Sample Percentile
80
90 100
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
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
525.00 500.00 475.00 450.00 425.00 400.00 375.00 350.00 325.00 300.00 275.00 250.00 225.00 200.00 175.00
Column C
30
40
50
60
70
80
Advertising Expenditures
90
0
Column C
80
nditures
90
550.00 500.00 450.00 Sales
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 4 50 314.20 313.86 0.34 0.12 5 60 382.20 369.36 12.84 164.87 6 70 450.20 424.86 25.34 641.97 7 70 423.60 424.86 -1.26 1.59 8 70 410.20 424.86 -14.66 215.00 9 80 500.40 480.37 20.03 401.37 10 90 505.30 535.87 -30.57 934.44
400.00 350.00
Colum Colum
300.00 250.00
Intercept Slope
36.34 5.55
ESS
3336.24
200.00 150.00 30
40
50
60
70
Advertising Exp.
R^2 ?
Y=a+bX
80
90
0
Column C Column D
70
ng Exp.
80
90
SUMMARY OUTPUT Regression Statistics Multiple R 0.98 R Square 0.97 Adjusted R Square 0.97 Standard Error 20.42 Observations 10 ANOVA df Regression Residual Total
Intercept X Variable 1
SS MS 1 104739.6 104739.6 8 3336.24 417.03 9 108075.84
Coefficients Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0% Upper 95.0% 36.34 21.98 1.65 0.14 -14.35 87.04 -14.35 87.04 5.55 0.35 15.85 0 4.74 6.36 4.74 6.36
RESIDUAL OUTPUT Observation
F Significance F 251.16 0
Predicted Y Residuals 1 202.85 -18.45 2 258.35 20.75 3 258.35 -14.35 4 313.86 0.34 5 369.36 12.84 6 424.86 25.34 7 424.86 -1.26 8 424.86 -14.66 9 480.37 20.03 10 535.87 -30.57
PROBABILITY OUTPUT Percentile 5 15 25 35 45 55 65 75 85 95
Y 184.4 244 279.1 314.2 382.2 410.2 423.6 450.2 500.4 505.3
Residuals
20 0 -20 -40 Row Row Row Row Row Row Row Row Row Row 25 26 27 28 29 30 31 32 33 34 X Variable 1
Y
Upper 95.0%
X Variable 1 Residual Plot
Normal Probability Plot
600 500 400 300 200 100 0
10
20
30
40
50
60
70
Sample Percentile
80
90 100
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
Related Documents
Regression
November 2019 28
Regression
May 2020 27
Regression
November 2019 24
Regression
May 2020 9
Regression Model
October 2019 23