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

  Compute the variance and standard deviation of each cluster

Compute the representation of the cluster as in the BFR Algorithm. That is, compute N, SUM, and SUMSQ.

  What are some applications that use a java gui

After reading this chapter, you should now be familiar with the "Fun" part of Java utilizing the GUI. The GUI offers all kinds of functionality in the graphical sence. Why do you think Java and Javas GUI are so popular? What are some applications ..

  Majority of high performance embedded systems

A vast majority of High Performance Embedded systems today use RISC architecture why?

  Financial budget would be created in what type of data file

A financial budget would be created in what type of data file?

  Write a report -background on an it security evaluation

Write a report containing the following sections:- Introduction - purpose of the proposal, Background on an IT Security Evaluation - what it is? Proposed work effort

  Identifying mixed methods research

Identifying Mixed Methods Research.

  Find the angle ? for which the 1250-n homogeneous cylinder

Determine the angle θ for which the 1250-N homogeneous cylinder will be in equilibrium in the position shown. Also, find the tension in the rope AB.

  Extracting company''s data using web data extractor

Extracting Company's Data Using Web Data Extractor

  Value of the franc decrease

What you can do to hedge your bet. Analyze steps you will take to avoid losing all your money should the value of the franc decrease.

  Implement a solution that offers redundancy

Implement a solution that offers redundancy and site resilience or fault tolerance. Implement a backup solution for server data protection. Suggest a backup rotation for protecting your domain controllers.

  Find a shortest path from 1 to all nodes

Find a shortest path from 1 to all nodes using the binary heap method, Dial's algorithm, the D'Esopo-Pape algorithm, the SLF method, and the SLF/LLL method.

  Calculating the weighted average of the cost of equity

We find the cost of capital by calculating the weighted average of the cost of equity, debt, and preferred stock.  Different sources of funds have different costs. Debt is almost always cheaper than equity, but using debt increases risk in terms of d..

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