Midterm1 Data

SUMMARY OUTPUT Regression Statistics Multiple R 0.96 R Square 0.93 Adjusted R Square 0.92 Standard Error 1441.73 Observations 48 ANOVA df Regression Residual Total

Intercept Price Adv Psub Income Pop Time

Sales Price Adv Psub Income Pop Time

6 41 47

SS 1085090831.6 85221668.4 1170312500

Coefficients Standard Error -4516.29 4988.24 -3598.5 701.87 0.2 0.08 3795.98 706.52 0.78 0.07 0 0 356.05 92.29

29028.77 5.5 3750 4.75 40000 1000000 9

MS 180848471.93 2078577.28

t Stat -0.91 -5.13 2.64 5.37 11.7 2.04 3.86

Price Change

F 87.01

Significance F 0

P-value 0.37 0 0.01 0 0 0.05 0

Lower 95% -14590.25 -5015.95 0.05 2369.14 0.64 0 169.67

New Sales Change in Q 28830.85 -0.01 1% 5.56

Income Change 1%

29339.59 40400

0.01

Upper 95%Lower 95.0% Upper 95.0% 5557.67 -14590.25 5557.67 -2181.05 -5015.95 -2181.05 0.36 0.05 0.36 5222.82 2369.14 5222.82 0.91 0.64 0.91 0 0 0 542.43 169.67 542.43 Elasticity Price -0.68

Elasticity Income 1.07

Yr./Qtr. 1995-1 1995-2 1995-3 1995-4 1996-1 1996-2 1996-3 1996-4 Baltimore 1995-1 1995-2 1995-3 1995-4 1996-1 1996-2 1996-3 1996-4 Chicago 1995-1 1995-2 1995-3 1995-4 1996-1 1996-2 1996-3 1996-4 Denver 1995-1 1995-2 1995-3 1995-4 1996-1 1996-2 1996-3 1996-4 Erie 1995-1 1995-2 1995-3 1995-4 1996-1 1996-2 1996-3 1996-4 Ft. Lauderdale 1995-1 1995-2 1995-3 1995-4 1996-1 1996-2 1996-3 1996-4 Atlanta

Sales 22,500 25,000 22,500 27,500 25,000 25,000 25,000 27,500 22,500 22,500 22,500 22,500 25,000 27,500 25,000 27,500 27,500 25,000 30,000 30,000 22,500 27,500 32,500 32,500 30,000 27,500 25,000 27,500 30,000 32,500 32,500 35,000 17,500 15,000 17,500 15,000 17,500 15,000 17,500 17,500 25,000 27,500 30,000 30,000 25,000 27,500 27,500 27,500

Price $6.00 $5.25 $5.00 $5.25 $5.75 $5.75 $6.00 $5.50 $6.00 $6.25 $5.50 $6.00 $5.50 $5.25 $6.00 $6.00 $5.75 $6.00 $5.75 $5.50 $6.00 $6.00 $5.50 $6.00 $5.50 $5.75 $6.00 $5.50 $6.00 $5.50 $5.75 $5.00 $5.75 $5.75 $5.75 $6.25 $5.75 $6.00 $6.25 $6.00 $5.75 $6.00 $5.75 $5.50 $6.25 $6.25 $6.25 $6.25

Adv $5,000.00 $7,500.00 $7,500.00 $10,000.00 $5,000.00 $10,000.00 $7,500.00 $10,000.00 $7,500.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $10,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $15,000.00 $5,000.00 $10,000.00 $5,000.00 $15,000.00 $5,000.00 $10,000.00 $10,000.00 $5,000.00 $5,000.00 $12,500.00 $7,500.00 $10,000.00 $15,000.00 $2,500.00 $5,000.00 $2,500.00 $2,500.00 $2,500.00 $5,000.00 $2,500.00 $2,500.00 $10,000.00 $12,500.00 $12,500.00 $7,500.00 $5,000.00 $5,000.00 $12,500.00 $5,000.00

Psub $4.25 $3.75 $3.25 $4.00 $4.00 $3.75 $3.75 $3.75 $4.00 $4.00 $3.75 $4.00 $4.00 $4.25 $4.00 $4.25 $3.75 $4.50 $3.50 $3.75 $3.50 $3.75 $3.75 $4.00 $4.25 $3.50 $3.25 $3.50 $4.00 $4.25 $4.00 $4.00 $4.00 $3.50 $3.75 $3.25 $3.50 $3.75 $3.75 $3.75 $4.00 $4.00 $4.25 $4.25 $3.75 $4.50 $3.50 $4.00

Income $39,500.00 $39,500.00 $39,000.00 $39,500.00 $39,500.00 $40,000.00 $40,500.00 $41,500.00 $38,500.00 $39,000.00 $39,000.00 $39,000.00 $39,000.00 $39,500.00 $39,500.00 $40,000.00 $44,000.00 $44,500.00 $44,500.00 $45,000.00 $44,500.00 $45,000.00 $45,500.00 $46,000.00 $46,500.00 $47,000.00 $46,500.00 $46,000.00 $46,500.00 $47,000.00 $47,000.00 $47,500.00 $34,000.00 $34,000.00 $34,000.00 $34,000.00 $34,500.00 $34,500.00 $35,000.00 $35,500.00 $43,500.00 $43,500.00 $44,000.00 $44,500.00 $44,500.00 $45,000.00 $46,000.00 $46,000.00

Pop Time 2,150,000 1 2,150,000 2 2,250,000 3 2,300,000 4 2,350,000 5 2,450,000 6 2,500,000 7 2,650,000 8 2,150,000 1 2,200,000 2 2,200,000 3 2,250,000 4 2,200,000 5 2,250,000 6 2,300,000 7 2,300,000 8 6,050,000 1 6,100,000 2 6,250,000 3 6,200,000 4 6,150,000 5 6,100,000 6 6,150,000 7 6,200,000 8 1,450,000 1 1,450,000 2 1,500,000 3 1,550,000 4 1,550,000 5 1,600,000 6 1,650,000 7 1,600,000 8 280,000 1 275,000 2 270,000 3 265,000 4 270,000 5 285,000 6 290,000 7 300,000 8 1,025,000 1 1,050,000 2 1,100,000 3 1,350,000 4 1,450,000 5 1,300,000 6 1,450,000 7 1,500,000 8

Data from: Case Study for Chapter 5, Hirschey and Pappas Fundamentals of Managerial Economics