1 given the data please construct a multiple linear, Ask an Expert

Economics

1. Given the data, please construct a multiple linear regression program by MS Excel.

2. Interpret each coefficient of independent variable in the soft drink demand estimated function in question 1.

3. Given your answer in question 1, please comment on whether the regression estimated function is a good fit or not. What is the interpretation of coefficient of determination (R-square)? May we use the estimated function to predict for the future demand? Explain why.

4. How many cans/capita/year on soft drink should be for a state in which 6-pack price=$1.95, Income/Capita=$23,500, and Mean Temp= 68°F?

5. Now omit the price and temperature from the regression equation. Should a marketing plan for soft drinks be designed that relocates most canned drink machines into low-income neighborhoods? Why or why not?

Attachment:- 1483559_2_Copy-of-ECON-3305-Case-1-Data.xls

View complete question

Microeconomics, Economics

Category:- Microeconomics
Reference No.:- M91704793

Have any Question?Write your Review or question?

Related Questions in Microeconomics

Essay questions 1 the tuitions and fees for any given

Essay Questions: 1) The tuitions and fees for any given institution of higher education are theoretically the same for all attending students. Colleges and universities, however, routinely charge different tuitions and f ...

Question why does marginal analysis work ie allows a firm

Question: Why does marginal analysis work (i.e., allows a firm to determine the correct level to produce where it maximizes profits or minimizes losses)? The response must be typed, single spaced, must be in times new ro ...

Question the american cancer society acs is a nationwide

Question: The American Cancer Society (ACS) is a nationwide, community-based, voluntary health organization dedicated to eliminating cancer as a major health problem. Together with its supporters, ACS is committed to hel ...

Question corporate directors are either insiders who hold

Question: Corporate directors are either insiders who hold (or have held) important positions within the company or outsiders who have achieved distinction elsewhere. a. Why do you as a shareholder probably prefer that t ...

Question youve invested 10000 in a portable bratwurst stand

Question: You've invested $10,000 in a portable bratwurst stand, giving up the 8% rate of return you could have earned had you invested that money elsewhere. Last year you sold 1600 brats at $3 each; the meat, buns, and ...

Question why does the assumption of independence of risks

Question: Why does the assumption of independence of risks matter in the examples of insurance? What would happen to premiums if the probabilities of houses burning were positively correlated? Can you think of a situatio ...

Assignment 1 discussion-cultural differences and ethical

Assignment 1: Discussion-Cultural Differences and Ethical Standards Your Module 3 readings explained that understanding cultural differences are critical to success in international business. A country's culture reflects ...

Question a which scenario is better for long-term economic

Question: (A) Which scenario is better for long-term economic growth: (a) the stock market grows at 6% per year indefinitely, or (b) it quickly doubles, then falls back to its previous level, and finally returns to its l ...

Question grade-school education is said to yield a

Question: Grade-school education is said to yield a beneficial externality because all of us benefit from interacting with people who know basic reading and writing. Assuming that this is true, make a case for providing ...

Question the interest rate is 10 percent and you purchase

Question: The interest rate is 10 percent and you purchase the newly issued bond in equation 16.3 for $10,000. After you hold it for 16 years the market interest rate rises to 15 percent. Calculate the change in its pric ...

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

Recent Questions

Ask Microeconomics Expert