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 assignmentquestion 1 - read attachment

MICROECONOMICS ASSIGNMENT Question 1 - Read Attachment 1 Answer the following questions. Use diagrams where appropriate. [Assume that the Australian grape and wine industries are perfectly competitive markets]: Use deman ...

Econ discussionwith everything discussed with this course

Econ discussion With everything discussed with this course, first watch How we can make the world a better place by 2030. Then, offer your considerations as to whether this could work or not. Within your response, provid ...

Assignmentin this assignment you will discuss the role of

Assignment In this assignment, you will discuss the role of entrepreneurship in improving the economic condition of countries and individuals and understand the manner in which this perception has spread around the world ...

1 the crr model european claimconsider the crr model of

1. The CRR model: European claim. Consider the CRR model of stock price S with T periods and parameters d (a) Consider the European claim X with expiry date T and the payoff X = g(S r ) = 1/S T 1[k,∞)(S T ). Show that th ...

Project-listen to this video asafter you work on your graph

Project- Listen to this video as/after you work on your graph. The lecture is on the 'Aftermath of the Financial Crisis' given by Ben Bernanke in March 29 th 2012. https://www.c-span.org/video/?305198-1/ben-bernanke-lect ...

Question 1 - read the following passage carefully and

Question 1 - Read the following passage carefully and answer questions The beverages industries in which Pepsi operate are highly competitive. They compete with major international beverage companies in multiple geograph ...

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

Question 1which of the following has not been identified as

Question 1 Which of the following has NOT been identified as a basic consumer right? Consumers have a right to safe products. Consumers have a right to collude. Consumers have a right to be informed about a product. Cons ...

Assignmentxyz company enters into a contract with mary to

Assignment XYZ Company enters into a contract with Mary to landscape Ben's yard, using None Nursery to supply trees and buses. Kate owns the lot next to Ben's property. The landscaping is a gift from Mary to Ben, who is ...

Assignmentvirtually all general managers face

Assignment Virtually all general managers face capital-budgeting decisions in the course of their careers. The most common of these is the simple "yes" versus "no" choice about a capital investment. Regardless of the typ ...

  • 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