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

Microeconomics assignmentdiscussion forumnote the video has

Microeconomics Assignment DISCUSSION Forum Note: The video has Closed Captioning. To activate it, start the video, mouse over the bottom of the video and click on the CC icon, then select from the menu. This week's discu ...

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 ...

Intermediate microeconomics assignmentexercise 1 -

INTERMEDIATE MICROECONOMICS ASSIGNMENT Exercise 1 - Capturing surplus using a block pricing Consider a monopolist facing a linear demand p(q) = 20 - q, and marginal cost MC = 2. a) If the monopolist charges the same pric ...

Mcdonalds and the hindu culturein many ways mcdonalds

McDonald's and the Hindu Culture In many ways, McDonald's Corporation has written the book on global expansion. Every day, on average, somewhere around the world 4.2 new McDonald's restaurants are opened. By 2003, the co ...

Assignment-money and pricesjaydeethe organizations

Assignment-Money and Prices Jaydee The organization's strategic plan you wrote about in Week 2 calls for an aggressive growth plan, requiring investment in facilities and equipment, growth in productivity, and labor over ...

Here is a link to the pdf version of dan ariellys

Here is a link to the pdf version of Dan Arielly's Predictably Irrational. http://radio.shabanali.com/predictable.pdf The Table of Contents starts on page 11. Scan through it and choose a chapter that looks interesting. ...

Assignment1in your own words please define describe and use

Assignment 1. IN YOUR OWN WORDS, please define, describe and use an example for the following term (see below). The term (including example) should be no more than 50 words.The following rubric is used to assess each ter ...

Can you write a great paper on a research economic topic10

Can you write a great paper on a Research economic topic 10 page paper Including abstract, introduction, content and conclusion, reference. You can choose any economic topics and analyze the issue from your own perspecti ...

Discussion questionconsider a group of documents that has

Discussion Question Consider a group of documents that has been selected from a much larger set of diverse documents so that the selected documents are as dissimilar from one another as possible. If we consider documents ...

Microeconomics paper-project paperthe paper is to be a

Microeconomics Paper- Project Paper The paper is to be a properly formatted (APA) paper that I expect will take at least 5 pages to do properly. It is to take the material discussed in the course and apply it to some iss ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen