Spreadsheet: 144e6a30-abd5-4894-85c5-f5d13b57c16e
Sheet: Regressions Vince

Region | Year | Price | Rate | Up to Down | Right to Left | Font Change | Yellow/Orange; 25% or Less | Abstract/Realistic/Else | Symmetry | Use of Gold | Golden Mean
Napa | 2002 | 30 | 88 | 1 | 0 | 0 | 1 | 0 | 0 | 0
Napa | 2002 | 125 | 94 | 1 | 0 | 0 | 1 | 0 | 0 | 0 |  | Price Regression
Napa | 2003 | 65 | 87 | 0 | 1 | 1 | 0 | 0 | 0 | 1
Sonoma | 2001 | 22 | 84 | 1 | 0 | 0 | 1 | 2 | 0 | 1 |  | Regression Statistics
Napa | 2003 | 40 | 88 | 1 | 0 | 0 | 1 | 1 | 1 | 1 |  | Multiple R | 0.4585376394400216
Napa | 2002 | 60 | 92 | 0 | 0 | 1 | 1 | 1 | 1 | 1 |  | R Square | 0.2102567667832272 | VIF=
Other California | 2002 | 16 | 84 | 0 | 0 | 1 | 1 | 0 | 1 | 0 |  | Adjusted R Square | 0.07863289458043177
Sonoma | 2002 | 35 | 83 | 0 | 0 | 0 | 1 | 0 | 1 | 0 |  | Standard Error | 27.2136932731095
Napa | 2003 | 55 | 88 | 1 | 0 | 0 | 1 | 0 | 1 | 1 |  | Observations | 50
Other California | 2003 | 22 | 84 | 0 | 0 | 1 | 1 | 0 | 0 | 1
South Coast | 2002 | 23 | 91 | 0 | 1 | 1 | 1 | 0 | 0 | 0 |  | ANOVA
Napa | 2002 | 40 | 91 | 1 | 0 | 1 | 1 | 2 | 1 | 0 |  |  | df | SS | MS | F | [NAME]
Sonoma | 2003 | 45 | 87 | 1 | 0 | 0 | 1 | 2 | 1 | 1 |  | Regression | 7 | 8281.105734358818 | 1183.015104908403 | 1.597406027223395 | 0.1628361935327253
Sonoma | 2002 | 17 | 83 | 0 | 0 | 0 | 1 | 2 | 1 | 1 |  | Residual | 42 | 31104.57426564118 | 740.5851015628853
Sonoma | 2003 | 30 | 85 | 1 | 0 | 1 | 0 | 2 | 1 | 1 |  | Total | 49 | 39385.68
Sonoma | 2002 | 35 | 92 | 1 | 1 | 1 | 0 | 0 | 0 | 0
Sonoma | 2001 | 15 | 86 | 0 | 0 | 0 | 0 | 1 | 1 | 1 |  |  | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0%
Other California | 2001 | 35 | 88 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  | Intercept | 38.83400209539024 | 12.7428885098785 | 3.047503873653564 | 0.003980150447630424 | 13.11781225782109 | 64.5501919329594 | 13.11781225782109 | 64.5501919329594
Napa | 2002 | 109 | 95 | 0 | 0 | 1 | 1 | 2 | 0 | 0 |  | Up to Down | 18.86212259125035 | 8.584608462360347 | 2.197202431998184 | 0.03357456067855201 | 1.53768153315573 | 36.18656364934496 | 1.53768153315573 | 36.18656364934496
Sonoma | 2002 | 21 | 86 | 0 | 0 | 1 | 1 | 0 | 0 | 1 |  | Right to Left | -10.70476315855316 | 13.22593901589591 | -0.8093764189965934 | 0.4228604096890896 | -37.39578837228116 | 15.98626205517483 | -37.39578837228116 | 15.98626205517483
Other California | 2001 | 15 | 87 | 0 | 0 | 0 | 0 | 1 | 0 | 1 |  | Font Change | -9.865052609827574 | 8.277651938120774 | -1.191769439398195 | 0.240042496855626 | -26.5700303301471 | 6.839925110491949 | -26.5700303301471 | 6.839925110491949
Other California | 2002 | 10 | 83 | 0 | 0 | 1 | 1 | 0 | 1 | 1 |  | Yellow/Orange; 25% or Less | 8.47076398418155 | 9.255352521892279 | 0.9152286705606414 | 0.3652965856768926 | -10.2072933716601 | 27.1488213400232 | -10.2072933716601 | 27.1488213400232
Other California | 2002 | 13 | 81 | 0 | 0 | 1 | 1 | 2 | 0 | 0 |  | Abstract/Realistic/Else | 2.309482368922399 | 4.754328716676329 | 0.4857641333931406 | 0.6296591078868063 | -7.285141309490426 | 11.90410604733522 | -7.285141309490426 | 11.90410604733522
Napa | 2001 | 50 | 89 | 0 | 0 | 1 | 0 | 0 | 0 | 1 |  | Symmetry | -14.68715307125604 | 8.791660615633907 | -1.670577802461845 | 0.1022419215115876 | -32.429442286441 | 3.055136143928914 | -32.429442286441 | 3.055136143928914
Napa | 2003 | 45 | 87 | 1 | 0 | 1 | 1 | 1 | 1 | 1 |  | Use of Gold | 1.230982204206999 | 8.644875281031148 | 0.1423944434349514 | 0.8874493586390219 | -16.21508221649047 | 18.67704662490447 | -16.21508221649047 | 18.67704662490447
Napa | 2002 | 27 | 89 | 0 | 0 | 0 | 0 | 1 | 1 | 1
Other California | 2001 | 17 | 86 | 0 | 0 | 0 | 0 | 1 | 1 | 1
Napa | 2002 | 62 | 94 | 1 | 0 | 0 | 1 | 0 | 1 | 1 |  | Rate Regression
Napa | 2002 | 60 | 89 | 0 | 0 | 0 | 1 | 0 | 1 | 1
Sonoma | 2002 | 20 | 89 | 0 | 1 | 1 | 1 | 0 | 0 | 0 |  | Regression Statistics
Napa | 2002 | 32 | 87 | 0 | 0 | 1 | 1 | 0 | 0 | 0 |  | Multiple R | 0.3292679249503141
Napa | 2002 | 62 | 89 | 1 | 0 | 1 | 0 | 2 | 1 | 1 |  | R Square | 0.1084173664010857 | VIF=
Other California | 2003 | 120 | 92 | 0 | 0 | 0 | 1 | 2 | 0 | 1 |  | Adjusted R Square | -0.04017973919873338
Sonoma | 2002 | 24 | 86 | 0 | 0 | 1 | 1 | 0 | 0 | 1 |  | Standard Error | 3.834067658799439
Napa | 2002 | 29 | 84 | 0 | 0 | 1 | 1 | 2 | 1 | 0 |  | Observations | 50
Other California | 2002 | 18 | 88 | 0 | 1 | 1 | 1 | 0 | 0 | 0
Napa | 2002 | 48 | 91 | 0 | 0 | 0 | 1 | 0 | 1 | 0 |  | ANOVA
Sonoma | 2002 | 26 | 86 | 0 | 0 | 1 | 1 | 0 | 0 | 1 |  |  | df | SS | MS | F | [NAME]
Carneros | 2002 | 22 | 83 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  | Regression | 7 | 75.0768578854238 | 10.7252654122034 | 0.7296061788246413 | 0.6478696038942409
Napa | 2003 | 100 | 93 | 1 | 0 | 1 | 1 | 2 | 0 | 1 |  | Residual | 42 | 617.4031421145761 | 14.70007481225181
Other California | 2002 | 10 | 82 | 1 | 0 | 1 | 1 | 0 | 1 | 1 |  | Total | 49 | 692.4799999999999
Other California | 2001 | 13 | 82 | 0 | 1 | 1 | 1 | 1 | 0 | 0
Napa | 2003 | 55 | 87 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |  |  | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0%
Napa | 2002 | 48 | 94 | 0 | 0 | 0 | 1 | 2 | 0 | 0 |  | Intercept | 87.72893776566171 | 1.7953129781061 | 48.86553978917268 | 1.209048041378385e-38 | 84.1058495367223 | 91.35202599460112 | 84.1058495367223 | 91.35202599460112
Other California | 2002 | 11 | 86 | 0 | 0 | 1 | 0 | 1 | 0 | 0 |  | Up to Down | 2.307584602493285 | 1.209463535091537 | 1.907940616265573 | 0.06325090600196553 | -0.1332115989268261 | 4.748380803913397 | -0.1332115989268261 | 4.748380803913397
Napa | 2003 | 50 | 83 | 1 | 0 | 1 | 1 | 2 | 0 | 0 |  | Right to Left | 0.1503305402694038 | 1.863368728720373 | 0.08067675385571164 | 0.9360822415638568 | -3.610099752125886 | 3.910760832664693 | -3.610099752125886 | 3.910760832664693
Sonoma | 2001 | 20 | 83 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  | Font Change | -1.202836138599474 | 1.166217215290933 | -1.031399745114727 | 0.308256372245265 | -3.556357734351772 | 1.150685457152824 | -3.556357734351772 | 1.150685457152824
Napa | 2002 | 85 | 94 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |  | Yellow/Orange; 25% or Less | 0.5313903464929015 | 1.303962950520914 | 0.4075195129436913 | 0.6856962494593174 | -2.100113393868422 | 3.162894086854225 | -2.100113393868422 | 3.162894086854225
Other California | 2002 | 12 | 84 | 0 | 0 | 1 | 1 | 2 | 0 | 1 |  | Abstract/Realistic/Else | -0.1582562951995853 | 0.669825215893136 | -0.2362650605629537 | 0.8143754514429484 | -1.510018291433425 | 1.193505701034255 | -1.510018291433425 | 1.193505701034255
Napa | 2002 | 60 | 92 | 1 | 0 | 1 | 1 | 0 | 1 | 0 |  | Symmetry | -1.015169621036696 | 1.238634583526016 | -0.8195876609119189 | 0.4170780558685241 | -3.514835380855631 | 1.484496138782239 | -3.514835380855631 | 1.484496138782239
 |  |  |  |  |  |  |  |  |  |  |  | Use of Gold | -0.2127510031864248 | 1.217954373069518 | -0.1746789599763451 | 0.8621712428578718 | -2.670682409168087 | 2.245180402795238 | -2.670682409168087 | 2.245180402795238