Computer regression package

Assignment Help Basic Computer Science
Reference no: EM131441663

Use a computer regression package, to work computer exercises 2 and 3.

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 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:

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.

1. Your estimated linear demand function for Liquid Ozarka is_______________________________________.

2. 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.

3. 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?

4. 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?

5. What is the estimated cross-price elasticity of demand for Liquid Ozarka with respect to changes in price of its rival brand of bottled water? Does the estimated cross-price 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 log-linear empirical demand function: 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.

6. Your estimated log-linear demand function for Liquid Ozarka is_______________________________________.

Reference no: EM131441663

Questions Cloud

Find expected mean return on apple stock : Apple's current stock price is $120. Annualized standard deviation of returns: 37% Expected mean return on Apple's stock: 15% annual Assuming Apple pays no dividends, calculate the 95% confidence level limits of Apple stock price in 12 months (1 y..
What strategies are used to notify regular education teacher : What strategies are used to notify the regular education teacher to ensure that modifications are implemented? What steps are undertaken if the teacher does not accommodate the student's special needs or learning style?
Budget deficit by making across-the-board cuts : Assume the economy is initially in a long-run equilibrium. Suppose Congress and the President decide to reduce the budget deficit by making 10% across-the-board cuts to every government program tomorrow (and for the record, 10% is a very big numbe..
How could the family genogram be applied to treatment : How could the family genogram be applied to the treatment of a family with addiction issues? Please apply this to a hypothetical family
Computer regression package : 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.
What is the expected earnings and expected retained earnings : Common Stock costs $5 per share to issue, floatation cost for bonds is 5% and the bonds have ten years to maturity. Assume the growth rate in earnings and dividends to be constant over time and the payout rate to be the same as in the previous yea..
Calculate and compare fixed asset turnover : Based on the data for each company, estimate the total useful life, age and remaining useful life of each company's property, plant, and equipment. Calculate and compare fixed asset turnover for each company
Revise the given paper self-regulation learning : Please read and revise the attached paper. Ensure it anwers the following questions and use APA for the format. Paper: Self-Regulation Learning.
Endowment of factor accounted for by each country : Here is the information about each country share of the world endowment of a factor. Percentage of the world endowment of factor accounted for by each country:

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd