Annual Data for Per Capita Consumption of Beer

Do you need this or any other assignment done for you from scratch?
We have qualified writers to help you.
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!

Multiple regression model of the demand for beer in Australia

The descriptive statistics of the regression model provide that the average per capita consumption of beer is 115 liters and the per capita income is $5691.61.

The average prices of beer, wine and spirits is $1.52, $3.34 and $17.41 respectively (Table 1). The standard deviations of the per capita consumption of beer, income, price of beer, price of wine and price of spirits are 13.33, 5399.03, 1.27, 2.31 and 15.06 respectively while the total number of variables applied in the research is 42 (Table, 1).

The regression analysis for this study was done at 5 degrees of freedom. And this provides the basis for conducting the test of the level of significance for the data.

The regression models for data set are: Income Y = -4.063 X -.010, price of beer Y = -6.490 X -68.239, price of wine Y = 7.272 X + 41.922, and price of spirits Y = 2.995 X + 2.652.

The regression line for the income, Y = -4.063 X -.010, indicates that the consumption of beer is negatively related to the income of the consumers.

This also indicates that when the income of a consumer is $1 the level of consumption will be less by 4.063+.010 liters (because when x = 1 y= -4.063*1-.010). The regression line for price of beer is y = -6.490X -6.490 and this indicates that when the price of beer is $1 the consumption of beer is less by 6.490.

Additionally, consumers take less of the beer by -68.239 liters when the price is zero. The regression line for wine is price of wine Y = 7.272 X + 41.922 and this indicates that when the price of wine is $1 the level of beer is 49.194 liters while the consumers take 41.922 liters of beer when price zero.

The regression line of spirits Y = 2.995 X + 2.652 and this indicates that the consumption level of beer is 5.647 liters when price is $1. In addition, when price is zero the consumption of beer is 2.652 liters.

All the observations were significant at 5 degrees of freedom, i.e. the level of significance is less that 05 for all variables under investigation (Table, 2).

From the above regression analysis results it can be observed that when the income of consumers is low there is a decline on the level of consumption of beer as observed in the regression between consumption beer and income levels.

This indicates that consumption pattern follows that of a giffen commodity because consumers reduce the consumption of the products when their incomes are low.

Since the product is not a basic commodity consumers can reduce its consumption when their incomes are low The three range of products; beer, wine and spirits have different demand patterns.

Wine has a higher demand than any of the other products while beer has the least demand of the three products. There is a positive relationship between the consumption of beer and the price of wine and spirits whereas the consumption of beer is negatively related to the price of beer. In addition, there is a negative relationship between the consumption of beer and the income of consumers.

Conditions are required for the validity of regression analysis

  1. For regression analysis to be valid the independent variables are required to have independent values. This means that there should be no relationship between all the independent values.
  2. It should be possible to identify the independent as well as the dependent variables in the experiment.
  3. It is important that enough data should be collected when conducting the regression analysis.
  4. The relationship between variables should be easily identifiable both in visual and numbers. This means that the goodness of fit and the numbers should be easy to describe the relationship between all the variables (Wainer, Braun and Educational Testing Service, 1988).

Analysis to determine satisfaction of the conditions

All the independent variables have no relationship at all and therefore the first condition has been fulfilled. The independent variables are the per capita income, price of wine, price of beer and price of spirits. These variables have no relationship at all and this means that the regression valid on basis of the first condition.

The second conditions for validity in regression analysis require that there should be a possibility of differentiating the independent and dependent variables.

In the experiment the independent variables are per capita income, price of wine, price of beer and price of spirits. The dependent variable is the quantity of beers consumed.

In addition, sufficient data has been collected from the population to explain the relationships and this is an indication that the condition of validity has been attained. Lastly, the data is clearly visible both in figures and in the diagram.

This indicates that the regression analysis is valid. Therefore, the conditions for validity of regression analysis have been fulfilled and this shows that the regression is valid.

Reference List

Wainer, H., Braun, H., and Educational Testing Service (1988). Test Validity. New Jersey: NJ, Routledge. Appendices

Table 1

Mean Std. Deviation N
ConsBeer 114.9964 13.33145 42
Income 5691.6133 5399.03051 42
Pbeer 1.5157 1.26794 42
Pwine 3.3417 2.31252 42
Pspirits 17.4064 15.05587 42

Table 3

Model Unstandardized Coefficients Standardized Coefficients t Sig.
B Std. Error Beta
1 (Constant) 89.281 3.420 26.105 .000
Income -.010 .004 -4.063 -2.605 .013
Pbeer -68.239 13.087 -6.490 -5.214 .000
Pwine 41.922 2.685 7.272 15.613 .000
Pspirits 2.652 .976 2.995 2.717 .010
a. Dependent Variable: ConsBeer
Do you need this or any other assignment done for you from scratch?
We have qualified writers to help you.
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!