Construct the demand estimation

Assignment Help Managerial Economics
Reference no: EM1336566

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. 


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. 

3. . Please interpret the coefficient of each independent variable in the multiple-linear soft drink demand estimated equation.

4. Given the multiple-linear equation, how many cans/capita/year on soft drink should be for a state in which 6-pack price=$2.99, Income/Capita=$48,500, and Mean Temp= 64°F? 

5. Given the log-linear equation, please provide the price elasticity of demand and income elasticity. Comment on whether the demand is elastic or inelastic and whether soft drink is a necessity, normal good or luxury good.

6. Now omit both price and temperature from the regression equation then run the simple linear regression again. Given the Excel output of only one independent variable, income, should a marketing plan for soft drinks be designed that relocates most canned drink vending machines into low-income neighborhoods? Please explain your answer in the language of economics.

Attachment:- econ 3305 case 1 data.xls

Reference no: EM1336566

Which instrument of the common agricultural policy

Which instrument (one) of the Common Agricultural Policy of the European Union do you consider as the most effective from the point of view of farmers' interests and why?

Economic analysis and organizational architecture

Discuss how organizational architecture and corporate culture are related. Use an example of a real-life firm and discuss how its corporate culture blends with its organizat

Manager compensation plan in car dealership

Two months before, the landlord of a car dealership significantly changed his sales manager's compensation plan. Under the old plan, the manager was paid a salary of $6000 eve

What are some earned value metrics

What are some earned value metrics? What do they stand for and how do they help you control a project? What do story points represents in an Agile project? How do they aid in

What are the three aspects of organizational architecture

What are the three aspects of organizational architecture? Your colleague recommends that your company adopt a piece-rate compensation sys- tem to boost productivity. What do

Calculating marginal revenue and optimum price

Suppose you are the manager of a company that produces output in two plants. The demand for your company's product is P = 78 - 15Q, where Q = Q1 + Q2.

Finding the product cost

Wakefield, Corporation, offers a CPA review course in cities throughout the eastern US. Wakefield emplayes local CPAs to do teaching. Every instructor is paid 120 dollar an ho

Evaluation of an investment opportunity

ANNA is considering to form a new company with initial investment of $8Million, there are two projects available for her to choose. the first project offers a 40 percent chanc


Write a Review

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