Regression Analysis
Not what you're looking for?
Given cellar capacity constraints, The Kalamazoo Brewing Company (KBC) currently sells its microbrews in a seven-state area. The company's marketing department has collected data from its distributors at each state. Data on the quantity and price (per case) of microbrews sold in the state of Ohio, as well as the average income (in thousands of dollars) of consumers living in the state of Ohio is given in the file attached to this assignment under the file name Ohio-KAZ.xls. Assuming that the underlying demand relation is a linear function of price and income, use Excel program to estimate of the state's demand for KBC microbrews in Ohio. Print (past) the computer regression output and provide an economic interpretation of the regression results. (Note: Reporting the results and providing correct and full economic interpretation of the results is as important, if not more important, as estimating the relationship)
Purchase this Solution
Solution Summary
Solution carries out regression analysis to establish a linear relationship between quantity, price and average income level. Regression results are also explained in detail.
Solution Preview
Please see the attached file for better understanding of regression results.
Solution:
Interpreting Signs and Regression coefficients
Negative sign of P variable indicates an inverse relationship between price and Quantity demanded. An increase in price will decrease the demand and a decrease in price will increase the demand. For a unit increase (1 dollar) in price will result decrease of 2.476738768 units of quantity demanded. Similarly a unit decrease in price will result increase of 2.476738768 quantity demanded.
A positive sign for I variable shows product is normal or ...
Education
- BEng (Hons) , Birla Institute of Technology and Science, India
- MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
- "Thank you"
- "Really great step by step solution"
- "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
- "Thanks Again! This is totally a great service!"
- "Thank you so much for your help!"
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.