Use a computer regression package, to work these two computer exercises. 2. Ozar
ID: 1234569 • Letter: U
Question
Use a computer regression package, to work these two computer exercises.2. Ozark Bottled Water Products, Inc. hired a marketing consulting firm to perform a
test marketing of its new brand of spring water called Liquid Ozarka. The
marketing experts selected 15 small and medium-sized towns in Arkansas and
Missouri for a one-month-long sales test. For one month, Liquid Ozarka was sold
at a variety of prices ranging from $3 per gallon to $4 per gallon. Specifically, in
three of the markets, price was set by the marketing experts at $3 per gallon. In
three more markets, price was set at $3.25 per gallon, and so on. The prices
charged in each market (P) are shown in the table below. For each of the 15 market
areas, the marketing consultants collected data on average household income (M),
the population of the marketing area (N), and the price of a rival brand of bottled
Chapter 7: Demand Estimation and Forecasting
159
water (PR). At the end of the month, total sales of Liquid Ozarka (Q) were
tabulated to provide the following data from which the consultants estimated an
empirical demand function for the new product.
Market P M PR N Q
1 $3.00 $45,586 $2.75 274,000 7,952
2 3.00 37,521 3.50 13,450 8,222
3 3.00 41,333 2.64 54,150 7,166
4 3.25 47,352 2.35 6,800 6,686
5 3.25 51,450 2.75 11,245 7,715
6 3.25 27,655 3.15 54,500 6,643
7 3.50 30,265 2.55 26,600 5,155
8 3.50 39,542 3.00 158,000 7,127
9 3.50 41,596 2.75 22,500 5,834
10 3.75 42,657 2.45 46,150 5,093
11 3.75 36,421 2.89 8,200 5,828
12 3.75 47,624 2.49 38,500 6,590
13 4.00 50,110 3.15 105,000 6,228
14 4.00 57,421 2.80 92,000 7,218
15 4.00 38,450 2.90 38,720 5,846
Using the marketing data from the 15 test markets shown above, estimate the
parameters of the linear empirical demand function:
Q = a + bP + cM + dPR + eN
If any of the parameter estimates are not significant at the 2 percent level of
significance, drop the associated explanatory variable from the model and estimate
the demand function again.
a. Your estimated linear demand function for Liquid Ozarka is
Explanation / Answer
One question each please. Thanks!
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.