Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Macroeconomics Expert

Assignment

CASE 1- DEMAND ESTIMATION and ELASTICITY: Soft Drinks in the U.S.

Demand can be estimated with experimental data, time-series data, or cross-section data. In this case, cross-section data appear in the Excel file. Soft drink consumption in cans per capita per year is related to six-pack price, income per capita, and mean temperature across the 48 contiguous states in the United States.

QUESTIONS

1. Given the data, please construct the demand estimation for soft drink consumption in the United States by (1) a multiple-linear regression equation, and? (2) a log-linear (exponential) regression equation

2. Given the MS Excel output in Question 1, please compare the two regression equations' coefficient of determination (R-square), F-test and t-test. Which equation is a good (better) fit?

Which equation shows the stronger overall significance to predict the future demand?

Which equation will you choose as a better estimation for quantity demanded? Which equation will you choose as a better estimation for elasticities? Explain your answer in the language of statistics.

Attachment:- Case-Data.rar

Macroeconomics, Economics

  • Category:- Macroeconomics
  • Reference No.:- M92722201

Have any Question?


Related Questions in Macroeconomics

Question - explain why it is important to evaluate the

Question - Explain why it is important to evaluate the overall performance of the firm's sales force and list the advantages and disadvantages of sales, cost, and profit analyses. Also, discuss the use of ROI in measurin ...

Question jones is one of 100000 corn farmers in a perfectly

Question: Jones is one of 100,000 corn farmers in a perfectly competitive market. What will happen to the price she can charge if: a. The rental price on all farmland increases as urbanization turns increasing amounts of ...

Question assume two countries a and b with sizes of

Question: Assume two countries, A and B, with sizes of domestic markets 300 million and 533 1 3 million units in annual sales, respectively. In this market, firms compete by differentiating their product, while the cost ...

Question when other firms reactsuppose you are the

Question: When other firms react Suppose you are the owner-operator of a gas station in a small town. Over the past 20 years, you and your rival have successfully kept prices at a very high level. You recently learned th ...

Question a firm invents and obtains a patent for a new

Question: A firm invents and obtains a patent for a new strong, biodegradable fabric that is used to makegrocery bags. The demand function for these bags is Q = 800 - p. The firm's cost function isC(Q) = 100 + 100Q + 0.5 ...

Question - suppose you are drawing cards out of a 30 card

Question - Suppose you are drawing cards out of a 30 card deck. The following table reports the value of each type of card and the frequency of each type. Value Frequency 1 6 2 7 3 6 4 3 5 8 Are the card values discrete ...

Question - a a firm producing two products x and y where x

Question - a. A firm producing two products X and Y where x and y are the quantity of product X and Y produced respectively. If the firm produces on the same isocost and has a fixed cost of $1000. Given the marginal cost ...

Question prehistory no names or dates here the key

Question: Prehistory. No names or dates here. The key questions are how early human groups supported themselves; what kind of social, economic, and political institutions they developed to manage the resources of their e ...

Question tara is considering leaving her current job which

Question: Tara is considering leaving her current job, which pays $56,000 per year, to start a new company that manufactures a line of special pens for personal digital assistants. Based on market research, she can sell ...

Economics assignment -part a microeconomicsconsider the

Economics Assignment - Part A: Microeconomics Consider the following three sources. Source 1. Macquarie Analysis: Woolworths Trails Coles on Grocery Prices (by Catie Low) Source 2: Supermarkets Price War Source 3: Suppor ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As