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

Q1 in quantity theory of money model mv py assume that v

Q1. In quantity theory of money model, MV = PY, assume that V is constant, M is growing at 6% per year, Y is growing at 3%. a. If r = 2, what is i? b. If the Fed reduces the money growth rate by 2% points per year, what ...

Assignmentwrite a 5-6 page paper on one of the following

Assignment Write a 5-6 page paper on ONE of the following topics. Advice: Read the question you choose very carefully, and make sure you are answering it. What you write must be clearly relevant to answering the question ...

Assignmentyou are the director of safety and health at

Assignment You are the Director of Safety and Health at Rotorcraft America, a mid-sized company that designs, manufactures and sells helicopters. Your organization has manufacturing operations in San Francisco, Californi ...

Feeding america final milestonein this assignment you will

Feeding America Final milestone In this assignment, you will demonstrate your mastery of the following course outcomes: - Evaluate management strategies and organizational structures of not-for-profit organizations for t ...

Assignmentpart idirections read the prompts below and

Assignment PART I Directions: Read the prompts below and formulate a response of at least one half of one page in length for each question. Please show Your references on a reference page 1. Explain records checks. List ...

Description of assignmentreport paper basisstudents work

Description of Assignment: Report Paper basis. Students work together to research and profile a particular in Microeconomic policy: the property tax in the United States. Grading Criteria (What constitutes a good assignm ...

Meqa assignment 2its been three weeks since you started

MEQA Assignment 2 It's been three weeks since you started working for BioMed and there's still no trace of Selwyn. That means you're still BioMed's resident economic expert. Harry the CEO was pleased with your earlier wo ...

1 a explain in clear language the economic inefficiency

1. a) Explain in clear language the economic inefficiency associated with adverse selection. b) The ACA (aka Obamacare) included an insurance mandate, which forces everyone to purchase insurance or face a penalty. Under ...

Great depression economy paperwritten assignmentplease

Great depression , economy paper Written Assignment Please provide a comprehensive answer to the following two questions: 1) Which were the main causes of the Great Depression? 2) Why did the Great Depression last so lon ...

Short-run economic fluctuationsplease have by 800 pm west

Short-Run Economic Fluctuations Please have by 8:00 pm west coast time cailfornia time 12/13/2016. Plagrism free, orignal work, and refs. APA format double space. please ask questions right away please dont wait to the l ...

  • 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