Global results
Dependant variableprix 2011 €
Independant variable(s)note note2 note3 note4
Examples324
R20.704679194867
Adjusted R20.701910562319
Sigma error0.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 €
Step1234
R20.69240.70050.7047 
note701.52(0.0000)8.38(0.0041)4.47(0.0352)0.35(0.5559)
note2709.93(0.0000)8.5(0.0038)4.5(0.0346) 
note3717.76(0.0000)8.62(0.0036)  
note4724.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 variableprix €
Independant variable(s)note note2 note3 note4
Examples323
R20.706309423768
Adjusted R20.703547443428
Sigma error0.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 €
Step1234
R20.69430.70150.7063 
note706.34(0.0000)7.44(0.0067)5.23(0.0229)0.58(0.4486)
note2714.51(0.0000)7.57(0.0063)5.28(0.0223) 
note3722.07(0.0000)7.69(0.0059)  
note4729(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 variableprix €
Independant variable(s)note note2 note3 note4
Examples322
R20.660061474587
Adjusted R20.655772029471
Sigma error0.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 €
Step1234
R20.69650.70760.71890.6601
note707.47(0.0000)11.62(0.0007)12.65(0.0004)7.42(0.0068)
note2716.89(0.0000)11.85(0.0007)12.82(0.0004) 
note3725.83(0.0000)12.09(0.0006)  
note4734.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 variableprix €
Independant variable(s)note note2 note3 note4
Examples321
R20.310062020932
Adjusted R20.301328628792
Sigma error0.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 €
Step1234
R20.69610.70620.71840.3101
note704.95(0.0000)10.47(0.0013)13.55(0.0003)4.68(0.0313)
note2714.01(0.0000)10.7(0.0012)13.75(0.0002) 
note3722.57(0.0000)10.93(0.0011)  
note4730.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 variableprix €
Independant variable(s)note note2 note3 note4
Examples320
R20.726186864521
Adjusted R20.723587372729
Sigma error0.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 €
Step1234
R20.70340.71440.7262 
note726.18(0.0000)11.75(0.0007)13.41(0.0003) 
note2736.03(0.0000)11.99(0.0006)13.6(0.0003) 
note3745.38(0.0000)12.24(0.0005)  
note4754.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 variableprix €
Independant variable(s)note note2 note3 note4
Examples319
R20.420235701196
Adjusted R20.412850168727
Sigma error0.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 €
Step1234
R20.71280.72530.73670.4202
note755.15(0.0000)13.81(0.0002)13.4(0.0003)4.27(0.0396)
note2766.26(0.0000)14.08(0.0002)13.58(0.0003) 
note3776.86(0.0000)14.35(0.0002)  
note4786.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 variableprix €
Independant variable(s)note note2 note3 note4
Examples318
R20.743320201904
Adjusted R20.740867847145
Sigma error0.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 €
Step1234
R20.71890.73230.7433 
note773.91(0.0000)15.2(0.0001)13.23(0.0003) 
note2785.83(0.0000)15.48(0.0001)13.41(0.0003) 
note3797.23(0.0000)15.76(0.0001)  
note4808.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 variableprix €
Independant variable(s)note note2 note3 note4
Examples317
R20.911556439532
Adjusted R20.910422547731
Sigma error0.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 €
Step1234
R20.72710.7420.75250.9116
note800.91(0.0000)17.54(0.0000)13.2(0.0003)21.79(0.0000)
note2814.17(0.0000)17.84(0.0000)13.36(0.0003) 
note3826.91(0.0000)18.15(0.0000)  
note4839.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

residuals-poly2011
quantiles-poly2011

-------------- 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