CHAP4.Coke_data - 835 363 37 32 2002 53 2.01 5.12 27.2 1.80...

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

View Full Document Right Arrow Icon
year Qcoke Pcoke Pjuice INCOME CPI ADVcoke ADVjuice AGE2044 TREND 1970 24 0.61 1.29 3.6 0.39 222 85 32 1 1971 26 0.64 1.34 3.9 0.41 409 179 32 2 1972 26 0.66 1.43 4.1 0.42 562 255 33 3 1973 28 0.67 1.44 4.6 0.44 680 315 33 4 1974 28 0.83 1.50 5.0 0.49 613 198 34 5 1975 28 1.03 1.62 5.5 0.54 609 278 34 6 1976 31 0.99 1.65 6.0 0.57 671 386 35 7 1977 33 1.04 1.99 6.5 0.61 561 348 35 8 1978 34 1.13 2.11 7.2 0.65 746 458 36 9 1979 35 1.23 2.31 8.0 0.73 926 475 37 10 1980 35 1.38 2.47 8.8 0.82 885 422 37 11 1981 35 1.52 2.83 9.8 0.91 806 471 38 12 1982 35 1.56 2.96 10.4 0.97 833 375 39 13 1983 37 1.60 2.97 11.1 1.00 958 443 39 14 1984 39 1.63 3.25 12.3 1.04 975 519 40 15 1985 41 1.64 3.41 13.0 1.08 926 453 40 16 1986 43 1.65 3.24 13.6 1.10 794 389 40 17 1987 44 1.69 3.38 14.2 1.14 790 443 40 18 1988 46 1.69 3.79 15.3 1.18 939 533 40 19 1989 46 1.73 3.91 16.3 1.24 905 545 40 20 1990 47 1.79 4.31 17.1 1.31 1036 558 40 21 1991 47 1.80 4.08 17.6 1.36 981 514 40 22 1992 47 1.83 4.27 18.5 1.40 924 485 40 23 1993 48 1.85 4.04 18.9 1.45 617 379 40 24 1994 49 1.85 4.06 19.6 1.48 738 471 39 25 1995 51 1.91 4.20 20.3 1.52 1155 648 39 26 1996 52 1.91 4.45 21.1 1.57 1165 702 38 27 1997 53 1.89 4.55 21.9 1.61 846 458 38 28 1998 54 1.88 4.62 23.2 1.63 764 422 38 29 1999 54 1.90 4.83 24.0 1.67 1005 547 37 30 2000 53 1.97 4.95 25.5 1.72 821 405 37 31 2001 53 2.00 5.09 26.2 1.77
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 835 363 37 32 2002 53 2.01 5.12 27.2 1.80 706 399 36 33 2003 52 2.01 5.26 28.1 1.84 700 445 36 34 2004 52 2.04 5.15 29.6 1.89 766 613 36 35 2005 52 2.11 5.11 30.6 1.95 799 723 35 36 Unit Gal/person $ $ $1000/person real mil$ real mil$ % Mean value 42.0 1.5 3.4 15.2 1.2 796 436 37.2 18.5 Data for AEM4150 Chapter 4: Carbonated Soft-Drink Demand in the United States, 1970-2005 Source: Zheng and Kaiser 2008 Using this data, we will learn: 1. How to specify a demand model 2. Why we need to deflate price/monetary variable 3. How to run a regression using MS Excel Click Data sheet tab, select Tools|Data Analysis, select Regression in the Analysis Tools list box, and Click the OK button. 4. How to interpret econometric results...
View Full Document

Ask a homework question - tutors are online