Q demand can be predicted with experimental data

Assignment Help Business Economics

Reference no: EM13353434

Q. Demand can be predicted with experimental data, cross-section data or time-series data. In this case, cross-section data appear in the Excel file. Soft drink utilization in cans per capita per year is related to six-pack cost, income per capita, as well as mean temperature across the 48 contiguous states in the United States.

1. Given data, please assemble (a) a multiple linear regression equation as well as (b) a log-linear (exponential) regression equation for demand by MS Excel.

2. Given the MS Excel output in question 1, compare the 2 regression equations' coefficient of determination (R-square), F-test as well as t-test. Which equation is a good (better) fit? Which among the equation shows stronger overall significance to calculate the future demand? Which among the equation will you choose for a better demand estimation? Illustrate answer in the language of statistics.

3. By your choice of question 2, interpret each coefficient of independent variable in the soft drink demand estimated equation.

4. By your choice of equation in question 2, Clarify how many cans/capita/year on soft drink should be for a state in which 6-pack cost=$2.45, Income/Capita=$36,500, as well as Mean Temp= 68°F?

5. By your choice of equation in question 2 also the numbers in question 4, Calculate the cost elasticity of demand as well as income elasticity. Observe whether the demand is elastic or inelastic as well as whether soft drink is necessity, normal good or luxury good.

6. Now neglect cost as well as temperature from regression equation then runs the regression again. Illustrate the Excel output of only one independent variable, profits, should a marketing plan for soft drinks be designed that relocates most canned drink machines into low-income neighborhoods? Please clarify your answer in the language of economics.

Reference no: EM13353434

Questions Cloud

Q1 assume the supply of money graph if reserve prerequisite : q1. assume the supply of money graph. if reserve prerequisite before the shift was 10 as well as the fed adjusted the

Q implement the letter bigram model which learns letter : q. implement the letter bigram model which learns letter bigram probabilities from the training data. a separate bigram

Qdominos pizza is considering incoming to the marketplace : q.dominos pizza is considering incoming to the marketplace in your community. conduct research regarding demand

Q1 data mining has found that young men be likely to buy : q1. data mining has found that young men be likely to buy beer and diapers at the same time while they shop at

Q demand can be predicted with experimental data : q. demand can be predicted with experimental data cross-section data or time-series data. in this case cross-section

Q david needs help financing his lodi new jersey-based : q. david needs help financing his lodi new jersey-based access direct inc. a six-year-old 3.5 million company. were

Qconsider republic of netflexs balance of payments in : q.consider republic of netflexs balance of payments in 2009foreign investment into netflex 22imports of goods as well

Q1 define imminent dangers and consider osha inspections : q1. define imminent dangers and consider osha inspections related to these potential events and how they might differ

Q1 you want to buy a car that costs 24999 you have 3000 to : q1. you want to buy a car that costs 24999. you have 3000 to pay upfront as a down-payment as well as you are

User Account

All Pages