wine-data - REGCOD Regional Code 0=CA, 1=Pacific NW, 2=NY...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: REGCOD Regional Code 0=CA, 1=Pacific NW, 2=NY WINEAGE of wine Age PRICE price per bottle RATING Overall rating of wine NY Dummy variable for NY region PACNW Dummy variable for Pacific NW region REGCOD 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 WINEAGE 8 4 13 6 5 4 4 13 4 5 4 4 3 3 5 4 6 5 4 5 12 4 12 5 6 5 4 4 5 6 5 4 5 5 6 5 7 6 4 6 4 5 6 5 PRICE ATING R $45 98 $85 97 $78 97 $100 93 $65 93 $85 92 $85 92 $78 92 $20 91 $13 87 $25 87 $17 86 $27 86 $19 84 $22 83 $25 89 $26 88 $28 87 $11 88 $10 84 $35 97 $50 93 $13 91 $48 90 $15 87 $10 87 $20 88 $36 94 $33 89 $30 89 $25 87 $20 84 $20 84 $25 83 $30 89 $22 88 $20 86 $20 82 $8 80 $7 82 $36 94 $32 88 $50 91 $50 90 NY PACNW 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Calif Pacific NW NY Avg Price $23.66 $19.76 $15.58 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 4 5 3 5 5 5 4 6 4 5 6 8 6 7 4 5 6 4 3 4 3 4 3 3 4 3 4 4 4 4 3 4 3 4 4 3 4 3 4 4 4 4 3 3 3 3 3 3 4 3 4 3 $18 $25 $25 $18 $16 $20 $20 $20 $18 $24 $22 $20 $38 $45 $39 $24 $22 $18 $20 $29 $25 $29 $11 $15 $20 $17 $15 $14 $22 $40 $30 $16 $16 $20 $20 $10 $10 $36 $18 $11 $10 $10 $15 $11 $10 $14 $19 $15 $18 $16 $30 $25 $30 88 88 88 85 85 92 90 89 88 91 90 88 95 92 92 91 91 89 95 94 94 93 90 89 91 90 90 89 88 93 92 89 85 91 90 89 85 93 89 87 85 83 82 81 80 75 88 88 89 87 97 95 93 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 8 4 4 3 4 5 3 5 4 3 4 4 4 8 3 3 4 3 4 2 3 4 5 4 3 4 8 4 4 3 4 4 4 5 4 5 3 4 5 5 8 6 3 4 4 3 5 4 4 4 6 5 $17 $30 $15 $28 $19 $18 $25 $17 $16 $40 $27 $27 $45 $16 $50 $17 $12 $16 $12 $8 $8 $30 $28 $28 $30 $17 $23 $30 $16 $19 $22 $38 $38 $36 $40 $50 $35 $31 $45 $35 $35 $60 $50 $22 $18 $24 $24 $58 $18 $11 $11 $29 $29 92 92 88 91 90 90 90 92 91 90 91 91 90 88 85 89 87 83 88 87 86 93 90 93 92 90 90 89 88 94 91 95 95 94 94 93 92 92 92 91 89 87 94 92 92 92 91 91 91 90 85 92 89 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 5 4 4 5 4 6 4 4 4 4 4 4 4 5 4 5 6 5 4 4 5 7 6 4 5 4 3 4 4 3 3 4 3 3 4 2 2 3 2 2 3 2 3 4 3 4 5 3 2 3 4 8 $27 $22 $17 $39 $10 $13 $45 $20 $20 $12 $20 $28 $16 $40 $32 $25 $18 $20 $20 $20 $22 $20 $32 $35 $18 $14 $9 $10 $9 $15 $15 $12 $11 $10 $10 $10 $11 $13 $13 $10 $9 $8 $6 $6 $6 $11 $15 $24 $18 $12 $12 $35 $30 88 87 86 89 88 82 89 85 87 84 91 94 84 93 88 85 81 91 89 86 89 89 92 91 90 90 88 87 87 88 88 88 88 86 86 86 84 83 76 88 89 83 85 84 83 80 85 76 88 87 83 92 92 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 3 5 5 4 3 3 8 6 8 12 12 3 3 5 8 4 4 12 3 3 4 4 5 4 4 5 4 5 4 3 4 3 3 3 4 3 3 4 4 3 5 4 4 4 4 4 4 3 4 5 4 7 $15 $18 $30 $13 $18 $19 $25 $48 $26 $30 $50 $32 $17 $17 $23 $20 $17 $24 $10 $16 $23 $21 $18 $10 $15 $20 $20 $15 $14 $16 $26 $23 $25 $13 $22 $10 $17 $28 $24 $18 $22 $16 $20 $20 $20 $20 $14 $15 $15 $15 $25 $25 $50 89 88 88 84 89 88 86 88 87 87 85 78 81 90 88 88 87 87 79 82 91 91 88 82 89 89 83 89 84 92 92 91 90 90 88 84 92 92 92 89 88 90 89 89 88 88 87 88 87 82 90 88 86 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 4 5 3 12 5 4 5 4 3 5 4 6 4 4 4 5 5 4 6 6 6 3 3 4 5 3 4 3 3 4 3 3 2 3 3 3 4 4 4 4 4 4 5 5 5 3 4 3 2 4 5 5 5 $16 $15 $18 $23 $27 $14 $10 $12 $12 $18 $14 $26 $27 $25 $16 $14 $26 $20 $27 $25 $17 $28 $31 $30 $30 $26 $25 $26 $14 $13 $18 $12 $12 $21 $13 $18 $12 $15 $21 $42 $29 $31 $28 $28 $15 $18 $18 $12 $30 $18 $12 $18 $25 92 90 88 74 87 84 88 88 84 88 90 92 90 90 89 89 87 88 85 84 82 92 92 91 91 90 90 90 89 87 89 87 86 89 88 88 87 87 86 92 91 90 90 88 87 86 84 89 90 87 86 86 86 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 4 4 2 3 4 5 3 2 2 4 2 3 4 2 4 5 4 7 5 5 5 7 5 3 3 5 4 3 3 3 4 4 4 4 2 3 3 4 5 5 5 5 7 6 3 5 3 4 $18 $12 $12 $13 $13 $50 $30 $14 $7 $13 $13 $8 $8 $8 $8 $7 $13 $14 $15 $17 $22 $22 $12 $17 $17 $10 $15 $15 $17 $15 $10 $15 $26 $17 $12 $13 $12 $19 $15 $23 $15 $19 $19 $13 $13 $9 $17 $14 $12 85 85 84 84 79 91 88 86 79 87 83 89 85 85 84 75 87 86 79 82 88 88 75 85 80 90 88 84 88 86 85 87 77 90 84 83 82 81 84 86 85 89 87 82 81 80 80 79 77 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Avg Rating 88.43 87.17 83.79 CA 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.195 0.038 0.033 12.95 358 ANOVA Regression Residual Total Intercept NY PACNW df 2 355 357 Coefficients 23.66 -8.09 -3.90 SS 2363 59536 61899 MS 1181.3 167.7 Standard Error t Stat 0.79 29.86 2.39 -3.38 1.88 -2.08 F 7.0 Significance F 0.0010 P-value 7.6E-99 7.9E-04 0.0381 Lower 95% 22.10 -12.79 -7.59 Upper 95% 25.22 -3.39 -0.21 Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.489 0.240 0.237 11.50 358 ANOVA Regression Residual Total Intercept RATING df 1 356 357 Coefficients -117.54 1.59 SS 14829 47070 61899 MS 14829 132 Standard Error t Stat 13.22 -8.89 0.15 10.59 F 112.2 Significance F 0 P-value 3.0E-17 5.8E-23 Lower 95% -143.54 1.30 Upper 95% -91.55 1.89 Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.492 0.243 0.236 11.51 358 ANOVA Regression Residual Total Intercept RATING NY df 3 354 357 SS 15011 46888 61899 MS 5004 132 F 37.8 Significance F 3.3E-21 Coefficients -114.42 1.56 -0.84 Standard Error 14.15 0.16 2.25 t Stat -8.09 9.77 -0.37 P-value 9.8E-15 4.0E-20 0.7080 Lower 95% -142.24 1.25 -5.27 PACNW -1.95 1.68 -1.16 0.2475 -5.25 Upper 95% -86.59 1.88 3.58 1.36 $120 $100 Price $80 $60 Column C Column C Column C $40 $20 $0 70 75 80 85 Rating 90 95 100 SUMMARY OUTPUT Regression Statistics Multiple R 0.195 R Square 0.038 Adjusted R Square 0.033 Standard Error 12.95 Observations 358 ANOVA df SS Regression MS 2 2363 1181 Residual 355 59536 357 Significance F 168 Total F 61899 Coefficients Intercept 15.58 Standard Error t Stat 2.25 6.91 7.04 P-value 0.00000 0.0010 Lower 95% Upper 95% 11.14 20.01 PACNW 4.18 2.82 1.48 0.13941 -1.37 9.74 CA 8.09 2.39 3.38 0.00079 3.39 12.79 ...
View Full Document

Ask a homework question - tutors are online