Global results
Dependant variable | prix 2011 € |
Independant variable(s) | note note2 note3 note4 |
Examples | 324 |
R2 | 0.704679194867 |
Adjusted R2 | 0.701910562319 |
Sigma error | 0.480956372967 |
F-Test(3,320) | 254.522470071(p < .0000*) |
Table 1. ANOVA source table
Source of variation |
SS |
df |
MS |
F Obs |
F Stat |
Regression |
SSR = 176.6277 |
dfR = 3 |
MSR = 58.8759 |
MSR/MSE = 254.52 |
p < .0000* |
Error |
SSE = 74.0221 |
dfE = 320 |
MSE = 0.2313 |
|
|
Total |
SSTO = 250.6498 |
dfTO = 323 |
|
|
|
* indicates significance
Table 2. Test of regression parameters
Parameter |
Estimate |
SE |
T Obs |
T Stat |
Intercept |
b0=-809.822075 |
s{b0}=390.124470 |
t0=-2.075804 |
p = 0.0387* |
note4 |
b1=0.000037 |
s{b1}=0.000017 |
t1=2.185627 |
p = 0.0296* |
note3 |
b2=-0.008931 |
s{b2}=0.004153 |
t2=-2.150294 |
p = 0.0323* |
note2 |
b3=0.601110 |
s{b3}=0.283295 |
t3=2.121856 |
p = 0.0346* |
* indicates significance
Stepwise selection process for prix 2011 €
Step | 1 | 2 | 3 | 4 |
R2 | 0.6924 | 0.7005 | 0.7047 | |
note | 701.52(0.0000) | 8.38(0.0041) | 4.47(0.0352) | 0.35(0.5559) |
note2 | 709.93(0.0000) | 8.5(0.0038) | 4.5(0.0346) | |
note3 | 717.76(0.0000) | 8.62(0.0036) | | |
note4 | 724.96(0.0000) | | | |
-------------- D'AGOSTINO ----------------
K2=19.3112841762 (1.36593825974)2 + (4.17678067975)2
(0.0001)
d'Agostino: FAIL
------------------ ANDERSON-DARLING -----------------
A2=2.37230793741
alpha=0
p-value=p < 0.01
A2=2.372308
(p < 0.01)
Anderson-Darling: FAIL
2011 OUT (1) : Le Pin;Pomerol;94;1116.67;1.91176254284
Global results
Dependant variable | prix € |
Independant variable(s) | note note2 note3 note4 |
Examples | 323 |
R2 | 0.706309423768 |
Adjusted R2 | 0.703547443428 |
Sigma error | 0.469477625797 |
F-Test(3,319) | 255.725724529(p < .0000*) |
Table 1. ANOVA source table
Source of variation |
SS |
df |
MS |
F Obs |
F Stat |
Regression |
SSR = 169.0929 |
dfR = 3 |
MSR = 56.3643 |
MSR/MSE = 255.73 |
p < .0000* |
Error |
SSE = 70.3105 |
dfE = 319 |
MSE = 0.2204 |
|
|
Total |
SSTO = 239.4035 |
dfTO = 322 |
|
|
|
* indicates significance
Table 2. Test of regression parameters
Parameter |
Estimate |
SE |
T Obs |
T Stat |
Intercept |
b0=-858.662014 |
s{b0}=380.998224 |
t0=-2.253717 |
p = 0.0249* |
note4 |
b1=0.000039 |
s{b1}=0.000017 |
t1=2.357546 |
p = 0.0190* |
note3 |
b2=-0.009425 |
s{b2}=0.004056 |
t2=-2.323700 |
p = 0.0208* |
note2 |
b3=0.635428 |
s{b3}=0.276659 |
t3=2.296792 |
p = 0.0223* |
* indicates significance
Stepwise selection process for prix €
Step | 1 | 2 | 3 | 4 |
R2 | 0.6943 | 0.7015 | 0.7063 | |
note | 706.34(0.0000) | 7.44(0.0067) | 5.23(0.0229) | 0.58(0.4486) |
note2 | 714.51(0.0000) | 7.57(0.0063) | 5.28(0.0223) | |
note3 | 722.07(0.0000) | 7.69(0.0059) | | |
note4 | 729(0.0000) | | | |
-------------- D'AGOSTINO ----------------
K2=13.1701727075 (0.589259093648)2 + (3.58091418887)2
(0.0014)
d'Agostino: FAIL
------------------ ANDERSON-DARLING -----------------
A2=1.92391217286
alpha=0
p-value=p < 0.01
A2=1.923912
(p < 0.01)
Anderson-Darling: FAIL
2011 OUT (2) : Vieux Château Certan;Pomerol;96;131.62;-1.6544432735
Global results
Dependant variable | prix € |
Independant variable(s) | note note2 note3 note4 |
Examples | 322 |
R2 | 0.660061474587 |
Adjusted R2 | 0.655772029471 |
Sigma error | 0.505098538343 |
F-Test(4,317) | 153.880387042(p < .0000*) |
Table 1. ANOVA source table
Source of variation |
SS |
df |
MS |
F Obs |
F Stat |
Regression |
SSR = 157.0346 |
dfR = 4 |
MSR = 39.2587 |
MSR/MSE = 153.88 |
p < .0000* |
Error |
SSE = 80.8745 |
dfE = 317 |
MSE = 0.2551 |
|
|
Total |
SSTO = 237.9091 |
dfTO = 321 |
|
|
|
* indicates significance
Table 2. Test of regression parameters
Parameter |
Estimate |
SE |
T Obs |
T Stat |
Intercept |
b0=154138.429688 |
s{b0}=57106.729339 |
t0=2.699129 |
p = 0.0073* |
note4 |
b1=0.002350 |
s{b1}=0.000840 |
t1=2.798511 |
p = 0.0054* |
note3 |
b2=-0.846283 |
s{b2}=0.305169 |
t2=-2.773164 |
p = 0.0059* |
note2 |
b3=114.254379 |
s{b3}=41.573808 |
t3=2.748230 |
p = 0.0063* |
note |
b4=-6853.883301 |
s{b4}=2516.503437 |
t4=-2.723574 |
p = 0.0068* |
* indicates significance
Stepwise selection process for prix €
Step | 1 | 2 | 3 | 4 |
R2 | 0.6965 | 0.7076 | 0.7189 | 0.6601 |
note | 707.47(0.0000) | 11.62(0.0007) | 12.65(0.0004) | 7.42(0.0068) |
note2 | 716.89(0.0000) | 11.85(0.0007) | 12.82(0.0004) | |
note3 | 725.83(0.0000) | 12.09(0.0006) | | |
note4 | 734.24(0.0000) | | | |
-------------- D'AGOSTINO ----------------
K2=12.2660949893 (1.67967844874)2 + (3.07323531447)2
(0.0022)
d'Agostino: FAIL
------------------ ANDERSON-DARLING -----------------
A2=1.28478216656
alpha=0
p-value=p < 0.01
A2=1.284782
(p < 0.01)
Anderson-Darling: FAIL
2011 OUT (3) : La Mission Haut-Brion blanc;Pessac-Léognan;94;796.78;1.68581574159
Global results
Dependant variable | prix € |
Independant variable(s) | note note2 note3 note4 |
Examples | 321 |
R2 | 0.310062020932 |
Adjusted R2 | 0.301328628792 |
Sigma error | 0.706680421615 |
F-Test(4,316) | 35.5030457762(p < .0000*) |
Table 1. ANOVA source table
Source of variation |
SS |
df |
MS |
F Obs |
F Stat |
Regression |
SSR = 70.9205 |
dfR = 4 |
MSR = 17.7301 |
MSR/MSE = 35.50 |
p < .0000* |
Error |
SSE = 157.8095 |
dfE = 316 |
MSE = 0.4994 |
|
|
Total |
SSTO = 228.7300 |
dfTO = 320 |
|
|
|
* indicates significance
Table 2. Test of regression parameters
Parameter |
Estimate |
SE |
T Obs |
T Stat |
Intercept |
b0=174106.351562 |
s{b0}=81153.982344 |
t0=2.145383 |
p = 0.0327* |
note4 |
b1=0.002645 |
s{b1}=0.001193 |
t1=2.216494 |
p = 0.0274* |
note3 |
b2=-0.953432 |
s{b2}=0.433691 |
t2=-2.198412 |
p = 0.0286* |
note2 |
b3=128.833618 |
s{b3}=59.082068 |
t3=2.180587 |
p = 0.0300* |
note |
b4=-7735.157227 |
s{b4}=3576.245179 |
t4=-2.162927 |
p = 0.0313* |
* indicates significance
Stepwise selection process for prix €
Step | 1 | 2 | 3 | 4 |
R2 | 0.6961 | 0.7062 | 0.7184 | 0.3101 |
note | 704.95(0.0000) | 10.47(0.0013) | 13.55(0.0003) | 4.68(0.0313) |
note2 | 714.01(0.0000) | 10.7(0.0012) | 13.75(0.0002) | |
note3 | 722.57(0.0000) | 10.93(0.0011) | | |
note4 | 730.61(0.0000) | | | |
-------------- D'AGOSTINO ----------------
K2=6.52838157819 (0.959939269727)2 + (2.3678889705)2
(0.0382)
d'Agostino: PASS
------------------ ANDERSON-DARLING -----------------
A2=0.93413632188
alpha=0.01
p-value=0.01 =< p < 0.025
A2=0.934136
(0.01 =< p < 0.025)
Anderson-Darling: FAIL
2011 OUT (4) : Carruades de Lafite;Pauillac;90;152.8;1.55120410302
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L184
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L184
E_warning:(Division by zero
D:\web\blg\math5\PDL\FDistribution.php @ L80
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L196
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L196
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L196
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L196
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L196
Global results
Dependant variable | prix € |
Independant variable(s) | note note2 note3 note4 |
Examples | 320 |
R2 | 0.726186864521 |
Adjusted R2 | 0.723587372729 |
Sigma error | 0.443318707074 |
F-Test(3,316) | 279.357244601(p < .0000*) |
Table 1. ANOVA source table
Source of variation |
SS |
df |
MS |
F Obs |
F Stat |
Regression |
SSR = 164.7075 |
dfR = 3 |
MSR = 54.9025 |
MSR/MSE = 279.36 |
p < .0000* |
Error |
SSE = 62.1039 |
dfE = 316 |
MSE = 0.1965 |
|
|
Total |
SSTO = 226.8114 |
dfTO = 319 |
|
|
|
* indicates significance
Table 2. Test of regression parameters
Parameter |
Estimate |
SE |
T Obs |
T Stat |
Intercept |
b0=-1386.769077 |
s{b0}=381.920437 |
t0=-3.631042 |
p = 0.0003* |
note4 |
b1=0.000063 |
s{b1}=0.000017 |
t1=3.761539 |
p = 0.0002* |
note3 |
b2=-0.015169 |
s{b2}=0.004076 |
t2=-3.721248 |
p = 0.0002* |
note2 |
b3=1.024445 |
s{b3}=0.277799 |
t3=3.687726 |
p = 0.0003* |
* indicates significance
Stepwise selection process for prix €
Step | 1 | 2 | 3 | 4 |
R2 | 0.7034 | 0.7144 | 0.7262 | |
note | 726.18(0.0000) | 11.75(0.0007) | 13.41(0.0003) | |
note2 | 736.03(0.0000) | 11.99(0.0006) | 13.6(0.0003) | |
note3 | 745.38(0.0000) | 12.24(0.0005) | | |
note4 | 754.19(0.0000) | | | |
-------------- D'AGOSTINO ----------------
K2=7.92155835035 (-0.194096644867)2 + (2.80782564323)2
(0.019)
d'Agostino: FAIL
------------------ ANDERSON-DARLING -----------------
A2=1.21259427734
alpha=0
p-value=p < 0.01
A2=1.212594
(p < 0.01)
Anderson-Darling: FAIL
2011 OUT (5) : Doisy-Daëne;Barsac;94;35.56;-1.52405273492
Global results
Dependant variable | prix € |
Independant variable(s) | note note2 note3 note4 |
Examples | 319 |
R2 | 0.420235701196 |
Adjusted R2 | 0.412850168727 |
Sigma error | 0.647125600944 |
F-Test(4,314) | 56.8998515637(p < .0000*) |
Table 1. ANOVA source table
Source of variation |
SS |
df |
MS |
F Obs |
F Stat |
Regression |
SSR = 95.3122 |
dfR = 4 |
MSR = 23.8280 |
MSR/MSE = 56.90 |
p < .0000* |
Error |
SSE = 131.4943 |
dfE = 314 |
MSE = 0.4188 |
|
|
Total |
SSTO = 226.8064 |
dfTO = 318 |
|
|
|
* indicates significance
Table 2. Test of regression parameters
Parameter |
Estimate |
SE |
T Obs |
T Stat |
Intercept |
b0=150961.617188 |
s{b0}=73693.609120 |
t0=2.048504 |
p = 0.0413* |
note4 |
b1=0.002302 |
s{b1}=0.001084 |
t1=2.123876 |
p = 0.0345* |
note3 |
b2=-0.828887 |
s{b2}=0.393842 |
t2=-2.104619 |
p = 0.0361* |
note2 |
b3=111.902939 |
s{b3}=53.652479 |
t3=2.085699 |
p = 0.0378* |
note |
b4=-6712.702148 |
s{b4}=3247.538580 |
t4=-2.067012 |
p = 0.0396* |
* indicates significance
Stepwise selection process for prix €
Step | 1 | 2 | 3 | 4 |
R2 | 0.7128 | 0.7253 | 0.7367 | 0.4202 |
note | 755.15(0.0000) | 13.81(0.0002) | 13.4(0.0003) | 4.27(0.0396) |
note2 | 766.26(0.0000) | 14.08(0.0002) | 13.58(0.0003) | |
note3 | 776.86(0.0000) | 14.35(0.0002) | | |
note4 | 786.89(0.0000) | | | |
-------------- D'AGOSTINO ----------------
K2=4.27848552034 (0.699251582174)2 + (1.94667222335)2
(0.1177)
d'Agostino: PASS
------------------ ANDERSON-DARLING -----------------
A2=0.787636015161
alpha=0.025
p-value=0.025 =< p < 0.05
A2=0.787636
(0.025 =< p < 0.05)
Anderson-Darling: FAIL
2011 OUT (6) : Quintus;Saint-Emilion;90;130.15;1.3879543374
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L184
E_warning:(Division by zero
D:\web\blg\math5\PDL\FDistribution.php @ L80
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L196
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L196
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L196
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L196
E_warning:(Division by zero
D:\web\blg\lib\MultipleRegression.inc.php @ L196
Global results
Dependant variable | prix € |
Independant variable(s) | note note2 note3 note4 |
Examples | 318 |
R2 | 0.743320201904 |
Adjusted R2 | 0.740867847145 |
Sigma error | 0.429149675292 |
F-Test(3,314) | 303.104678967(p < .0000*) |
Table 1. ANOVA source table
Source of variation |
SS |
df |
MS |
F Obs |
F Stat |
Regression |
SSR = 167.4679 |
dfR = 3 |
MSR = 55.8226 |
MSR/MSE = 303.10 |
p < .0000* |
Error |
SSE = 57.8292 |
dfE = 314 |
MSE = 0.1842 |
|
|
Total |
SSTO = 225.2971 |
dfTO = 317 |
|
|
|
* indicates significance
Table 2. Test of regression parameters
Parameter |
Estimate |
SE |
T Obs |
T Stat |
Intercept |
b0=-1330.459089 |
s{b0}=369.903867 |
t0=-3.596770 |
p = 0.0004* |
note4 |
b1=0.000061 |
s{b1}=0.000016 |
t1=3.745480 |
p = 0.0002* |
note3 |
b2=-0.014608 |
s{b2}=0.003948 |
t2=-3.700209 |
p = 0.0003* |
note2 |
b3=0.985262 |
s{b3}=0.269047 |
t3=3.662046 |
p = 0.0003* |
* indicates significance
Stepwise selection process for prix €
Step | 1 | 2 | 3 | 4 |
R2 | 0.7189 | 0.7323 | 0.7433 | |
note | 773.91(0.0000) | 15.2(0.0001) | 13.23(0.0003) | |
note2 | 785.83(0.0000) | 15.48(0.0001) | 13.41(0.0003) | |
note3 | 797.23(0.0000) | 15.76(0.0001) | | |
note4 | 808.05(0.0000) | | | |
-------------- D'AGOSTINO ----------------
K2=5.85191733513 (-0.24261423415)2 + (2.4068767456)2
(0.0536)
d'Agostino: PASS
------------------ ANDERSON-DARLING -----------------
A2=0.990387185843
alpha=0.01
p-value=0.01 =< p < 0.025
A2=0.990387
(0.01 =< p < 0.025)
Anderson-Darling: FAIL
2011 OUT (7) : Guiraud;Sauternes;94;40.23;-1.43278258051
Global results
Dependant variable | prix € |
Independant variable(s) | note note2 note3 note4 |
Examples | 317 |
R2 | 0.911556439532 |
Adjusted R2 | 0.910422547731 |
Sigma error | 0.252714698686 |
F-Test(4,312) | 803.918362252(p < .0000*) |
Table 1. ANOVA source table
Source of variation |
SS |
df |
MS |
F Obs |
F Stat |
Regression |
SSR = 205.3681 |
dfR = 4 |
MSR = 51.3420 |
MSR/MSE = 803.92 |
p < .0000* |
Error |
SSE = 19.9258 |
dfE = 312 |
MSE = 0.0639 |
|
|
Total |
SSTO = 225.2939 |
dfTO = 316 |
|
|
|
* indicates significance
Table 2. Test of regression parameters
Parameter |
Estimate |
SE |
T Obs |
T Stat |
Intercept |
b0=134160.984375 |
s{b0}=29020.788724 |
t0=4.622927 |
p < .0000* |
note4 |
b1=0.002052 |
s{b1}=0.000427 |
t1=4.807370 |
p < .0000* |
note3 |
b2=-0.738302 |
s{b2}=0.155105 |
t2=-4.760020 |
p < .0000* |
note2 |
b3=99.596397 |
s{b3}=21.129341 |
t3=4.713654 |
p < .0000* |
note |
b4=-5969.989258 |
s{b4}=1278.917397 |
t4=-4.668002 |
p < .0000* |
* indicates significance
Stepwise selection process for prix €
Step | 1 | 2 | 3 | 4 |
R2 | 0.7271 | 0.742 | 0.7525 | 0.9116 |
note | 800.91(0.0000) | 17.54(0.0000) | 13.2(0.0003) | 21.79(0.0000) |
note2 | 814.17(0.0000) | 17.84(0.0000) | 13.36(0.0003) | |
note3 | 826.91(0.0000) | 18.15(0.0000) | | |
note4 | 839.07(0.0000) | | | |
-------------- D'AGOSTINO ----------------
K2=2.8207867322 (0.577938938368)2 + (1.57695063833)2
(0.244)
d'Agostino: PASS
------------------ ANDERSON-DARLING -----------------
A2=0.674991362304
alpha=0.05
p-value=0.05 =< p < 0.10
A2=0.674991
(0.05 =< p < 0.10)
Anderson-Darling: PASS
-------------- D'AGOSTINO ----------------
K2=2.8207867322 (0.577938938368)2 + (1.57695063833)2
(0.244)
d'Agostino: PASS
------------------ ANDERSON-DARLING -----------------
A2=0.674991362304
alpha=0.05
p-value=0.05 =< p < 0.10
A2=0.674991
(0.05 =< p < 0.10)
Anderson-Darling: PASS
type: array
count: 11
value: Array
(
[90] => 35.21
[92] => 63.43
[91] => 47.33
[88] => 18.21
[86] => 12.76
[93] => 91.51
[89] => 25.42
[95] => 412.55
[87] => 13.9
[94] => 161.15
[96] => 1921.36
)
Price estimation (average) 2011 formula:
log(prix) = 134160.984375 - 5969.98925781 * note + 99.5963973999 * note2 - 0.738301992416 * note3 + 0.00205201865174 * note4