Ask Question, Ask an Expert


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.


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

Discussion questionthe value of teams in strategic

Discussion Question The Value of Teams in Strategic Management The value of teams is often described in the work product created by teams versus individuals. Using available research, how does team work differ from indiv ...

Clarkson v orkin exterminating co incwrite a brief in the

Clarkson v. Orkin Exterminating Co., Inc. Write a brief in the prescribed format. Fact,Issue,Holding,rationale Case Questions 1. Why did the trial court grant the plaintiff's summary judgment motion and order reformation ...

From the e-activity analyze the elasticity of demand for

From the e-Activity, analyze the elasticity of demand for products within the selected industry relevant to Katrina's Candies. Determine the factors involved in making decisions about pricing these products that you beli ...

Assignment swot analysiswrite a white paper in which you

Assignment SWOT Analysis Write a white paper, in which you describe how a SWOT analysis can help companies maximize their marketing strategies in a global context. Support your views with appropriate evidence. Your answe ...

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

Question -for production of dodecylbenzene sulfonates main

Question - For production of Dodecylbenzene sulfonates (main raw material for production of detergent), the detergent plant needs 2000 metric ton per day of hydrocarbons (mixture is acceptable) with boiling point between ...

Principles of economics1 which statement is truea today

Principles of Economics 1. Which statement is true? A) Today more workers in the U.S. are members of labor unions than any time in our history. B) Today labor unions are weaker than any time in the last 100 years. C) No ...

Q1 the demand and supply curves for beer aredemand qd 50 -

Q1. The demand and supply curves for beer are Demand: Q d = 50 - 2P d Supply: Q s   = 2P s where Q D is the quantity of beer demanded per year (in millions of cases), Q S is the quantity of beer supplied (in millions of ...

Highly competitive industry-econanalyze an article

Highly Competitive Industry-Econ Analyze an article published within 60 days prior to the term that deals with a highly competitive industry. • Analyze the factors driving change in the industry. Are there potential chan ...

Microeconomichow would a low-cost price leader enforce its

Microeconomic How would a low-cost price leader enforce its leadership through implied threats to a rival? How does a firm become a "low cost" price leader? Discuss the specific type of market structure that implied thre ...

  • 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