Age (Years) Price ($)
36 250
20 140
29 212
33 255
41 331 350
27 173
30 209 300
45 297
34 237 250
22 182
200
Price ($)
150
100
50
0
15
Scatter Plot of Wine Age vs Price
350
300
250
200
Price ($)
150
100
50
0
15 20 25 30 35 40 45 50
Age (Years)
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9399703047
R Square 0.8835441738
Adjusted R Square 0.8689871955
Standard Error 20.954078399
Observations 10
ANOVA
df SS MS
Regression 1 26649.8127875 26649.812788
Residual 8 3512.58721246 439.07340156
Total 9 30162.4
Coefficients Standard Error t Stat
Intercept 8.3593551893 29.0357539931 0.287898678
Age (Years) 6.9476544104 0.89178403028 7.7907365175
F Significance F
60.695575485 5.2821305E-05
P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
0.7807418813 -58.597213588 75.315923966 -58.597213588 75.315923966
5.28213E-05 4.8911967489 9.004112072 4.8911967489 9.004112072
Income Age The rent ofLocal or Not Degree
5000 25 1000 1 1
7000 30 2000 0 2
6000 28 1500 1 2
5500 25 1000 1 1
7500 32 2000 0 2
6500 28 1500 1 2
9200 42 1000 1 3
7500 32 2000 0 2
5800 22 1500 1 2
7500 32 2000 0 2
6500 28 1500 1 2
8000 36 1000 1 3
7500 32 2000 0 2
5800 25 1500 1 2
5500 25 1200 1 1
7500 32 2000 0 2
6500 28 1300 1 2
9200 42 1000 1 3
7500 32 2000 0 2
6200 30 1560 0 2
Y=1, N=0
Bechelor =1 Master=2 Ph.D.=3
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9823790742
R Square 0.9650686453
Adjusted R Square 0.9557536174
Standard Error 244.57164047
Observations 20
ANOVA
df SS MS F Significance F
Regression 4 24788271 6197068 103.6034 9.7709835E-11
Residual 15 897229.3 59815.29
Total 19 25685500
Coefficients Standard Error t Stat P-value Lower 95%
Intercept -1582.6856585 1050.661 -1.506372 0.152739 -3822.1162306
Age 202.96489134 24.49716 8.285242 5.579E-07 150.75043438
The rent of the house 1.0151275649 0.358209 2.833894 0.012569 0.2516222636
Local or Not 461.44344027 304.1353 1.517231 0.149999 -186.80571215
Degree 244.93423376 202.6127 1.208879 0.245421 -186.92459472
Upper 95%
Lower 95.0%
Upper 95.0%
656.7449 -3822.116 656.7449
255.1793 150.7504 255.1793
1.778633 0.251622 1.778633
1109.693 -186.8057 1109.693
676.7931 -186.9246 676.7931
Week Value Forecast Error Abs Error
1 18
2 13 18 -5 5
3 16 13 3 3
4 11 16 -5 5
5 17 11 6 6
6 14 17 -3 3
MAE 4.4
MSE
MAPE %
Forecast Week 7
Squared Error Abs % Error
25 0.38461538461538
9 0.1875
25 0.45454545454545
36 0.35294117647059
9 0.21428571428571
20.8
31.877754598
14
3-Month MA
Month Percentage MA Error MA Sq Error
Forecast
1 80
2 82
3 84
4 83 82 1 1
5 83 83 0 0
6 84 83.3333333333333 0.6666666666667 0.444444444444
7 85 83.3333333333333 1.6666666666667 2.777777777778
8 84 84 0 0
9 82 84.3333333333333 -2.333333333333 5.444444444444
10 83 83.6666666666667 -0.666666666667 0.444444444444
11 84 83 1 1
12 83 83 0 0
MA MSE 1.234567901235
ES MSE
Forecast Month 13 MA 83.3333333333333
Forecast Month 13 ES
Exp Smoothing Forecast ES Error ES Sq Error
80
80 2 4 On-time Sh
80.4 3.6 12.96
86
81.12 1.88 3.5344
81.496 1.504 2.262016 85
81.7968 2.2032 4.85409024 84
82.23744 2.76256 7.6317377536
83
82.789952 1.210048 1.464216162304
Percentage
83.0319616 -1.0319616 1.064944743875 82
82.82556928 0.17443072 0.03042607608 81
82.860455424 1.139544576 1.298561840691
80
83.0883643392 -0.0883643392 0.007808256442
79
78
77
1 2 3
3.555291006636
83.07069147136
On-time Shipments Percentage Over 12 Months
86
85
84
83
Percentage
82
81
80
79
78
77
1 2 3 4 5 6 7 8 9 10 11 12
Month
