Login

Create Account
+14156709189
info@expertsmind.com
Submit Homework/Assignment
Get quote & make Payment
Get Solution
Regression Analysis, Managerial Economics
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 mediumsized towns in Arkansas and
Missouri for a onemonthlong 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
ˆQ
= _______________________________________.
b. What percentage of the variation in sales of Liquid Ozarka is explained by
your estimated demand function?
The marketing consultants describe a “typical” market as one in which the price of
Liquid Ozarka is $3.50 per gallon, average household income is $45,000, the price
of rival bottled water is $3 per gallon, and the population is 75,000. Answer the
following questions for this “typical” market scenario.
c. What is the estimated elasticity of demand for Liquid Ozarka? Is demand
elastic or inelastic? What would be the percentage change in price required
to increase sales of Liquid Ozarka by 10 percent?
Chapter 7: Demand Estimation and Forecasting
160
d. What is the estimated income elasticity of demand? Is Liquid Ozarka a
normal or inferior good? A 6 percent increase in average household income
would be predicted to cause what percentage change in sales of Liquid
Ozarka?
e. What is the estimated crossprice elasticity of demand for Liquid Ozarka
with respect to changes in price of its rival brand of bottled water? Does the
estimated crossprice elasticity have the expected algebraic sign? Why or
why not? If the price of the rival brand of water rises by 8 percent, what is
the estimated percentage change in sales of Liquid Ozarka?
Using the marketing data from the preceding 15 test markets, estimate the
parameters for the loglinear empirical demand function:
Q = aPbMcPR
dNe
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.
f. Your estimated loglinear demand function for Liquid Ozarka is
ˆQ
= _______________________________________.
g. Does a loglinear specification work better than a linear specification of
demand for Liquid Ozarka? Explain by comparing Fratios, R2s, and tratios
(or pvalues).
h. Using the estimated loglinear demand function, compute the price, income,
and crossprice elasticities of demand. How do they compare to the estimated
elasticities for the linear demand specification?
Chapter 7: Demand Estimation and Forecasting
161
3. For 2007–2009, Gallaway, Inc. has collected the following data on monthly sales
of its Titan II driving club, where Q = the number of units sold per month.
Year Month Q Year Month Q Year Month Q
2007 January 6,942 2008 January 8,007 2009 January 7,925
February 7,348 February 7,698 February 7,326
March 7,328 March 7,417 March 8,037
April 8,350 April 8,897 April 9,087
May 8,619 May 8,607 May 9,303
June 9,282 June 9,314 June 9,139
July 8,183 July 8,686 July 8,105
August 8,317 August 8,539 August 8,321
September 8,552 September 8,967 September 8,960
October 7,993 October 8,507 October 7,580
November 8,198 November 8,359 November 8,562
December 8,082 December 8,157 December 8,072
a. Management at Gallaway is concerned about sales. They would like to know
if there is an upward trend is sales of the Titan II. Use the data above to
estimate the monthly trend in sales using a linear trend model of the
form: Qt = a + bt . Does your statistical analysis indicate a trend? If so, is it
an upward or downward trend and how great is it? Is it a statistically
significant trend (use the 5 percent level of significance)?
b. Now adjust your statistical model to account for seasonal variation in club
sales. Estimate the following model of sales:
Qt = a + bt + c1D1t + c2D2t + c3D3t
where D1t = 1 for the months of January–March or 0 otherwise, D2t = 1 for
the months of April–June or 0 otherwise, and D3t = 1 for the months of
July–September or 0 otherwise. Do the data indicate a statistically significant
seasonal pattern (use the 5 percent level of significance)? If so, what is the
seasonal pattern of sales of Titan II clubs?
Posted Date: 11/17/2012 3:35:43 PM  Location : United States
Ask an Expert
Related Discussions:
Regression Analysis, Assignment Help, Ask Question on Regression Analysis, Get Answer, Expert's Help, Regression Analysis Discussions
Write discussion on Regression Analysis
Your posts are moderated
Write your message here..
Related Questions
Contracting and insideroutsider models of unemployment, CONTRACTING AND IN...
CONTRACTING AND INSIDEROUTSIDER MODELS OF UNEMPLOYMENT From the Walrasian assumption of a marketclearing wage on efficiency considerations  it was postulated th
Economic cost, The economic cost Unemployment represents a terrible wa...
The economic cost Unemployment represents a terrible waste of resources and means that the economy is producing a lower rate of output than it could do if there were full empl
What do you mean by theory of firm, Q. What do you mean by Theory of Firm? ...
Q. What do you mean by Theory of Firm? Microeconomics especially the theory of firm, assumed importance and attracted considerable attention in the early 20 th century. This sh
Calculate the percentage of the disk space that must be free, Free disk spa...
Free disk space can be kept track of using a free list or a bit map. Disk addresses require D bits. For a disk with B blocks, F of which are free, state the condition under which t
Illustrate about sales maximisation, Q. Illustrate about Sales maximisation...
Q. Illustrate about Sales maximisation? The concept that business firms (specifically those operating in the real world) are principally goaded by the aspiration to achieve the
Derive the intertemporal budget constraint, Problem: (a) (i) Assuming...
Problem: (a) (i) Assuming that a household uses a subjective discount rate of 10%, calculate the amount that she must spend on consumption per annum during her years of existe
State the theory of capital and investment, Theory of Capital and Investmen...
Theory of Capital and Investment: Theory of Capital and Investment evinces the below significant issues: Selection of a viable investment project Efficient allocatio
How we can measure elasticity of demand, How we can measure Elasticity of d...
How we can measure Elasticity of demand Though a manager requires an exact measure of this relationship for appropriate business decisions. Elasticity of demand is a measure t
Problem, Calculate point elasticity of demand for demand function Q=102p f...
Calculate point elasticity of demand for demand function Q=102p for decrease in price from Rs 3 to Rs 2 . Thanks a lot!
Supplementary reserve, Supplementary Reserve, Requirements/Special Deposit ...
Supplementary Reserve, Requirements/Special Deposit If the Central Bank feels that there is too much money in circulation, it can in addition require commercial banks to mainta
Assignment Help
Accounting Assignment Help
Economics Assignment Help
Finance Assignment Help
Statistics Assignment Help
Physics Assignment Help
Chemistry Assignment Help
Math Assignment Help
Biology Assignment Help
English Assignment Help
Management Assignment Help
Engineering Assignment Help
Programming Assignment Help
Computer Science Assignment Help
IT Courses and Help
ExpertsMind Services
Online Tutoring
Projects Assistance
Exam Preparation
Coursework Help
Programming Courses
Engineering Courses
Why Us ?
~Experienced Tutors
~24x7 hrs Support
~Plagiarism Free
~Quality of Work
~Time on Delivery
~Privacy of Work