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

  Suppose fred sees your rsa signature on m1 and m2

Suppose Fred sees your RSA signature on m1 and m2

  Write a brief paragraph describing the application

4. Research an application of Fuzzy Sets/Fuzzy Logic. Write a brief paragraph describing the application (what is the problem it addresses; why was a Fuzzy System chosen as a solution; pros and cons of the Fuzzy solution; etc.). (and you must ..

  Why and where is flow control needed? explain its parameters

Explain stop-and-wait flow control with special reference to the handling of (i) a damaged frame (ii) a lost frame.

  Write an application that converts miles to kilometers

Write an application that converts miles to kilometers

  What is bios

What is BIOS?Just need 2 pages description of BIOS and put reference where you got stuff from.

  Develop a program that will allow the district sales manager

You have been asked to develop a program that will allow the district sales manager to input each of the dealership's ID along with their four quarterly sales volumes for the year, calculate and display each quarter's rebate and the sales bonus fo..

  Help in troubleshooting the issue

Jason from the designer group submitted a ticket with your companies IT Help Desk stating that he could no longer access the Internet. Whenever he types a website name into his web browser, he gets an error stating that the name can't be resolved...

  Relevance of data-driven decision making

Establish the relevance of data-driven decision making, preferably with examples from your work experience. However, you may also quote examples from other organisation. THe objective is to underline the importance of such style of decision making..

  Most important element to ensuring high availability

Give your opinion on what you believe to be the most important element to ensuring high availability on an enterprise network. Explain your rationale.

  University information technology services

You are working as a Support Specialist in the University Information Technology Services (UITS) department at Indiana University, Bloomington (IUB). Your manager, the instructor, has tasked you to review the latest survey on computer user satisfa..

  Document the current state of the foundation for execution

Document the current state of the foundation for execution for Adopt-A-Farm using a standard Enterprise Architecture Framework (e.g., Zachman, POLDAT, or TOGAF).Explain your choice of framework.

  Create a chart or column design

Write a program that uses a loop to display the number of calories burned after 10, 15, 20, 25,and 30 minutes. Running on a particular treadmill you burn 4.2 calories per minute. Create a chart or column design using the TAB character escape seque..

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