Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Microeconomics Expert

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.

problemS

1. Given the data, please construct (a) a multiple linear regression equation and (b) a log-linear (exponential) regression equation for demand by MS Excel.

2. Given the MS Excel output in problem 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 for a better demand estimation? describe your answer in the language of statistics.

3. Given your choice of equation in problem 2, please interpret each coefficient of independent variable in the soft drink demand estimated equation.

4. Given your choice of equation in problem 2, how many cans/capita/year on soft drink should be for a state in which 6-pack price=$2.45, Income/Capita=$36,500, and Mean Temp= 68°F?

5. Given your choice of equation in problem 2 and the numbers in problem 4, please find out the price elasticity of demand and income elasticity. Comment on whether the demand is elastic or inelastic and whether soft drink is necessity, normal good or luxury good.

6. Now omit the price and temperature from the regression equation then run the 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 machines into low-income neighborhoods? Please describe your answer in the language of economics.

Microeconomics, Economics

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

Have any Question? 


Related Questions in Microeconomics

Short paperthus far in the course the primary focus has

Short Paper Thus far in the course, the primary focus has been on hospitals within the healthcare industry. For this short paper you will consider the economic issues related to long-term care facilities. In this assignm ...

Assignmentoverviewthe incidence of fraud in the news has

Assignment Overview The incidence of fraud in the news has become more common in recent years. As the accounting profession becomes more aware of fraud schemes, it seems that the criminals who perpetrate them have become ...

Assignmentlearning objectives covered1explain 3 ways the

Assignment Learning Objectives Covered: 1. Explain 3 ways the statement of goals, application of rewards, and institution of discipline affect and motivate ethical behavior in individuals 2. Demonstrate how roles and aut ...

Asignment 11 given the production function asy 68 135x1

Assignment 1 1. Given the production function as: y = 6.8 + 1.35x 1 + 7.7x 2 - 8.5x 3 + 0.4x 4 - 0.06x 1 2 - 1.25x 2 2 + 0.2x 1 x 2 and assuming x 3 = 0.32 and x 4 = 4.25 i. Form production function in iso-quant set. ii. ...

Application evaluation of research resultsno research

Application: Evaluation of Research Results No research project or study is perfect. Studies that contain errors can produce unreliable or misleading results. As a consumer of research, you must be able to determine the ...

Exam set 1 amp 2set-11 which of the following statements is

Exam SET 1 & 2 SET-1 1. Which of the following statements is true about a downward-sloping demand curve that is a straight line? The slope and the elasticity are the same at all points. The slope remains the same, but el ...

Assignmentthere is the widespread notion that economists

Assignment There is the widespread notion that economists rarely agree with each other. This seems perplexing when we note also that economics is often called the "Queen of the Social Sciences" (meaning that it is the mo ...

Assignmenta computerworld investigation reported that

Assignment A Computerworld investigation reported that delays in overhauling the federal tax system have cost the U.S. government approximately $50 billion a year in uncollected taxes. Although the IRS has spent hundreds ...

Create the demand and supply of the labor market and demand

Create the demand and supply of the labor market and demand and supply of the goods market using the production function and consumption utility function given. Solving the equations and graphing the models have to be th ...

Discussion questionsi need 3 different discussion to be

Discussion Questions I need 3 different Discussion to be answered, by replying to what the student wrote. I'll forward the Discussions as we agree to shake hands. Word counts asnwer question no more than 100 words if mor ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro