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

1 a consumers preference ordering over baskets of goods x1

1. A consumer's preference ordering over baskets of goods (x1, x2) includes the following: i) she is indifferent between (5, 90) and (35, 10); ii) she strictly prefers (20, 50) to (5, 90). Check whether convexity of pref ...

Problem assignmentmicrosoft word - sio 20 problem

Problem Assignment Microsoft Word - SIO 20 Problem Assignment 4_2016.docx 1. Describe the life-cycle of a frontal cyclone (also called "wave cyclone" or "midlatitude cyclone"). Draw a diagram if that helps. 2. Describe t ...

These questions are about the usa industrialization and

These questions are about the USA Industrialization and Economic Development. At least 200 words for each question! 1. What is meant by the term "development" inneo-classic economics? How might your answer to this questi ...

From the scenario for katrinas candiessuggest one1method in

From the scenario for Katrina's Candies,suggest one(1)method in which Herb could use a cost-benefit analysis to argue for or against an expansion. Create three optimal decision rules for Katrina's Candies(e.g.,whether to ...

Economic essayi want you to keep up with current events by

Economic essay I want you to keep up with current events by reading The Wall Street Journal or The New York Times (you have free access to these resources). When you find an article that deals in some way with a topic be ...

Discussion questions1 discuss the differences between

Discussion Questions 1. Discuss the differences between conducting a risk assessment for a carcinogen versus a non-carcinogen. 2. Discuss how OSHA's Field Operations Manual could be used by an organization's management t ...

Long-term investment and cost-benefit analysis please

Long-Term Investment and Cost-Benefit Analysis" Please respond to the following: From the scenario for Katrina's Candies, suggest one method in which Herb could use a cost-benefit analysis to argue for or against an expa ...

Assignment current economics analysisthere are two internet

Assignment: Current Economics Analysis There are two Internet Questions included with this assignment. Problem 1 Could we ever achieve an unemployment rate below "full" employment? What problems might we encounter if it ...

Part awe have discussed several examples of constrained

Part A: We have discussed several examples of constrained utility maximisation in lectures and in classes. For example, we have learned how to find the optimal bundle of goods consumed by an individual trying to maximise ...

Assignmentslegal and ethical norms in business must be

ASSIGNMENTS Legal and ethical norms in business must be considered to support the aims of research, such as verification of knowledge, truth, and avoidance of error. Business ethics have become of paramount concern and a ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate