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

Assignmentyou have been asked to assist your organizations

Assignment You have been asked to assist your organization's marketing department to better understand how consumers make economic decisions. Write a 1,050-word analysis that includes the following: • The impact the theo ...

Assignmentioverview provide an overview consisting of a

Assignment I. Overview: Provide an overview consisting of a brief description of the chosen company, your chosen product or service, and annual sales. II. Macroeconomic Variables For this section, you will utilize macroe ...

Assignmentfirms use inputs workers machinery natural

Assignment Firms use inputs (workers, machinery, natural resources) to produce outputs (goods and services). For example: General Motors uses steel, rubber and other materials to create automobiles. A pizza restaurant tu ...

Assignmentteamworkhow does effective teamwork look how is

Assignment Teamwork How does effective teamwork look? How is teamwork displayed in your life as it relates to your current role? Why is teamwork a necessity for organizations? Does this help or hurt an organization if te ...

Assignmentwe often have difficulty understanding how our

Assignment We often have difficulty understanding how our own customs and traditions could be viewed any way other than as right. In that regard, cultural relativism (viewing a custom from the other culture's perspective ...

Assignmentin the article at the beginning of the readings

Assignment In the article at the beginning of the readings book, Aronson talks about Social Psychology as a leap of faith, and about the imperfect nature of social psychological experiments (which is true of science in a ...

Assignmentselect and review an inspection report posted on

Assignment Select and review an inspection report posted on the OSHA website. The inspection reports can be searched by industry group or establishment name by accessing the reports through the OSHA's Statistics & Data P ...

Question 1which of the following levels of supply chain

Question 1 Which of the following levels of supply chain information systems is most likely to provide the firm with a competitive advantage? A.Strategic planning B.Decision analysis C.Management control D.Transaction sy ...

Samsung smartphone manufacturer vs google inc search engine

Samsung (smartphone manufacturer) Vs. Google Inc. (search engine) - economic and financial analysis Objectives: • Assess and compare the market types of Google Inc.(as a search engine) and Samsung • Determine the various ...

Assignmentfor this assignment write a paper describing how

Assignment For this assignment, write a paper describing how an analysis of intrusion signatures could be conducted for your project organization. Include the following in your paper: • A description of signature analysi ...

  • 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