Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Microeconomics Expert

Economics


Home >> Microeconomics

Assignment

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 (10%), and
(2) a log-linear (exponential) regression equation (10%).

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

Microeconomics, Economics

  • Category:- Microeconomics
  • Reference No.:- M92726190

Have any Question?


Related Questions in Microeconomics

Question why is there asymmetric information in the labor

Question: Why is there asymmetric information in the labor market? What signals can an employer look for that might indicate the traits they are seeking in a new employee? The response must be typed, single spaced, must ...

Question try to reflect on the ethical implications of

Question: Try to reflect on the ethical implications of price discrimination. Write Reflecting upon the ethical implications of price discrimination. What criteria of fairness would you apply to pricing? Is price discrim ...

Question many retirement funds charge an administrative fee

Question: Many retirement funds charge an administrative fee each year equal to 0.25% on managed assets. Suppose that Alexx and Spenser each invest $5,000 in the same stock this year. Alexx invests directly and earns 5% ...

Question economic homework please help1 compare and

Question: Economic homework, please help 1. Compare and contrast classical economics theory and Marxist economic theory in relation to women and their economic capacity or contribution (or lack thereof). Can you write 3 ...

Question the present worth of an amount of money y that

Question: The present worth of an amount of money "Y" that will be received 10 years from now is $10,000. At an interest rate of 8% per year, the value of "Y" 10 years from now is equal to? The response must be typed, si ...

Question oil prices have risen temporarily due to political

Question: Oil prices have risen temporarily, due to political uncertainty in the Middle East. An advisor to the Fed suggests, "Higher oil prices reduce aggregate demand. To offset this we must increase the money supply. ...

Question why does longo use salespeople instead of price

Question: Why does Longo use salespeople instead of price tags? Why not just offer cars at a fixed discount under the sticker price? Or why not be like the General Motors Saturn and advertise a no bargaining policy? The ...

Question assume that your probability of surviving an

Question: Assume that your probability of surviving an accident is greater in a car equipped with certain safety features. If so, what will be the likely effect on the number of accidents? Give a numerical example showin ...

Question what information could be lost if a firm were to

Question: What information could be lost if a firm were to buy a supplier of its intermediate goods and incorporate that firm into its existing operating structure? The response must be typed, single spaced, must be in t ...

Question 1 how do managerial economists distinguish between

Question: 1. How do managerial economists distinguish between short and long run for business? 2. In most production processes the short run average cost of production typically drops as more is produced, but eventually, ...

  • 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

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved