Demand Analysis Of Luxury Cars Based On Age, Income, And Education In An Essay.

Output based on different Classes.

Output based on different types of Students.

Analysis based on different types of students.

Output based on marks of class for different types of students.

Analysis based on marks of class for different types of students.

The Automobile association has been facing problems in targeting the population group to whom which brand of car should be more advertised. The taste and preferences of the people differ with different age group, income and education. Thus, the company wanted to analyse the demand for the luxury cars in the households considering the factors such as age, income and years of education. The main aim of this research will be to identify how each of the considered attributes such as age, income and education of the buyers of luxury cars define their preferences towards any particular brands. The customer profile information will be useful for the association to analyse their demands so that they can come up with some strategies to sell the cars to the potential buyers and attract new customers as well.

The business problem that has been discussed already needs to be evaluated with the help of the application of appropriate statistical techniques and interpretation of the results as well. Measures of shape and location will be used to determine the shape of the distribution of the profiles of the customers. The Association is also interested to know the differences in the age, annual income and years of education of the buyers of the different brands of cars. Appropriate testing strategies will be used in order to test these differences. The preference of the brands of the luxury cars with respect to the influence of age, education and annual income of the customers will be evaluated with the help of logistic regression technique.

It can be seen from table that in the lower age group of 35 – 44 years, preference of people is more towards BMW rather than Lexus and Mercedes, in the age group of 45 – 54 years, people can be seen to be preferring Lexus and between 55 – 64 years, people mostly prefer Mercedes. Thus, it can be said that the older people are more likely to prefer Mercedes than BMW or Lexus and the Younger People are more likely to prefer BMW over Mercedes and Lexus. Lexus is preferred by the middle aged people mostly.

Table 1: Preference of Luxury Cars with respect to Age Groups

It can be seen that the average age of the people preferring BMW cars is 45.22 years, preferring Lexus cars is 50.46 years and preferring Mercedes cars is 51.99 years. It can also be seen that the standard deviation of the ages of the people preferring the three types of cars namely BMW, Lexus and Mercedes are 4.4 years, 6.1 years and 6.7 years respectively, which can be said as very low deviations. Thus, it can be said that the ages of the people preferring these types of cars are close to the average ages. Moreover, the mean, median and the mode of the ages are quite close to each other. Thus, the distribution of the ages of the three types of car users can be said to be symmetrically distributed. These has also been illustrated with the help of histograms provided in figures 2, 3 and 4.  

Methodology

It can be seen from table 3 that the people preferring Mercedes belong to higher income group. The people of the lower income group can be seen to be preferring BMW cars over Lexus and Mercedes. Lexus cars are preferred mostly by people who belong to an average income group.

Table 3: Preference of Luxury Cars with respect to Income Groups

It can be seen that the average income of the people preferring BMW cars is $139,271.3, preferring Lexus cars is $154,186.9 and preferring Mercedes cars is $184,423.9. It can also be seen that the standard deviation of the income of the people preferring the three types of cars namely BMW, Lexus and Mercedes are $2,907.85, $2,556.43 and $3,845.33 respectively, which can be said as very low deviations compared to the average income. Thus, it can be said that the income of the people preferring these types of cars are close to the average income. Moreover, the mean, median and the mode of the incomes of the individuals preferring different type of cars are quite close to each other. Thus, the distribution of the income of the three types of car users can be said to be symmetrically distributed. These has also been illustrated with the help of histograms provided in figures 6, 7 and 8.

It can be seen from table 5 that in the lower education group of 11 – 13 years, preference of people is more towards Lexus rather than BMW and Mercedes, in the education group of 14 – 16 years, people can be seen to be preferring BMW and between 17 – 22 years, people mostly prefer Mercedes. Thus, it can be said that the people with higher education are more likely to prefer Mercedes than BMW or Lexus and the people with lower income groups are more likely to prefer Lexus over Mercedes and BMW. BMW is preferred by the mostly by the people with 14 – 16 years of education.

Table 5: Preference of Luxury Cars with respect to Years of Education

It can be seen that the average years of education the people preferring BMW cars is 15.8 years, preferring Lexus cars is 15.8 years and preferring Mercedes cars is 17.3 years. It can also be seen that the standard deviation of the years of education of the people preferring the three types of cars namely BMW, Lexus and Mercedes are 1.8 years, 2.4 years and 1.7 years respectively, which can be said as very low deviations. Thus, it can be said that the years of education of the people preferring these types of cars are close to the average years of education. Moreover, the mean, median and the mode of the years of education are quite close to each other for each of the car types. Thus, the distribution of the years of education of the three types of car users can be said to be symmetrically distributed. These has also been illustrated with the help of histograms provided in figures 10, 11 and 12.

Analysis of Age Group Preferences

In order to check independency of average ages of buyers of belonging to groups of three different luxury cars, hypothesis testing needs to be done. The most significant statistical tool for analyzing mean ages of three different group the test of Analysis of Variance or ANOVA.

The null and alternative hypothesis for the specific ANOVA test is given as follows.

Null hypothesis: Average ages of buyers of three different groups are equal.

Alternative Hypothesis: Average ages of buyers are significantly different.

Result of the ANOVA test is produced below.

Table 7: ANOVA test result for independency of average ages

Decision rule of the ANOVA test indicates that the null hypothesis is rejected at 5% level of significance if the estimated value F exceeds the tabulated value. The estimated F value of the given test is obtained as 49.8. The critical F value or tabulated F value is given as 3.017. As the estimated F value exceeds the critical F value, null hypothesis is rejected.  It can thus be said that average ages of buyers of three groups are not equal. The mean ages differ significantly among the three groups.

In order to check independency of average income of buyers of belonging to groups of three different luxury cars, hypothesis testing needs to be done. The most significant statistical tool for analyzing mean incomes of three different group the test of Analysis of Variance or ANOVA.

The null and alternative hypothesis for the specific ANOVA test is given as follows.

Null hypothesis: Average income of buyers of three different groups are equal.

Alternative Hypothesis: Average income of buyers are significantly different.

Result of the ANOVA test is produced below.

Table 8: ANOVA test result for independency of average income

Decision rule of the ANOVA test indicates that the null hypothesis is rejected at 5% level of significance if the estimated value F exceeds the tabulated value. The estimated F value of the given test is obtained as 52.18. The critical F value or tabulated F value is given as 3.017. As the estimated F value exceeds the critical F value, null hypothesis is rejected.  It can thus be said that average income of buyers of three groups are not equal. The mean incomes differ significantly among the three groups.

In order to check independency of average years of education of buyers of belonging to groups of three different luxury cars, hypothesis testing needs to be done. The most significant statistical tool for analyzing mean education years of three different group the test of Analysis of Variance or ANOVA.

The null and alternative hypothesis for the specific ANOVA test is given as follows.

Null hypothesis: Average education years of buyers of three different groups are equal.

Alternative Hypothesis: Average education years of buyers are significantly different.

Result of the ANOVA test is produced below.

Table 9: ANOVA test result for independency of average education years

Decision rule of the ANOVA test indicates that the null hypothesis is rejected at 5% level of significance if the estimated value F exceeds the tabulated value. The estimated F value of the given test is obtained as 25.93. The critical F value or tabulated F value is given as 3.017. As the estimated F value exceeds the critical F value, null hypothesis is rejected.  It can thus be said that average education years of buyers of three groups are not equal. The mean education years differ significantly among the three groups.

Some dealers claim that there is a higher chance of buying Mercedes cars in case of buyers with higher age, higher income and higher years of education. To verify this claim regression analysis needs to be done. The simple linear regression however cannot be done here because of categorical nature of the dependent variable. For this, logistic regression has been done. The dependent variable takes two values 0 and 1. 1 represents probability of buying Mercedes and 0 represents probability of buying Lexus or Mercedes.

The table below represents proportion of samples choosing Mercedes and other two types of cars.

Table 10: Proportion of choosing Mercedes and two other types of cars

In the selected sample group, among the 420 household 150 are buying Mercedes and 270 are buying BMW or Mercedes. That is in chosen sample, 35.7% are preferring Mercedes over BMW or Lexus.

The result of logistic regression is given in the following table:

Table 11: Logistic Regression Coefficients

From the regression result the estimated regression equation is obtained as:

From regression table coefficient of all the independent variables are found to be positive. This implies that with increase in each of the independent variable the probability of buying Mercedes cars increases. P values corresponding to all the independent variables are 0.000. The p value lower than the significance level indicates rejection of null hypothesis stating no significant relation between the dependent and independent variables. The regression result thus supports the claim that older people who has higher income and more years of education tend to buy Mercedes cars.

Conclusion

The analysis conducted so far in this research paper indicates that the people with lower age groups prefer BMW and higher age groups prefer Mercedes cars. People having higher income prefer Mercedes whereas with lower income prefer BMW. The people with lower years of education prefer Lexus cars whereas with higher years of education prefer BMW vars. Thus, it can be concluded that older people with higher income group and higher years of education prefer Mercedes over other car types. Significant differences have also been observed in the average ages, average income and average years of education for the three different car types. Further, it has also been observed that the preference of Mercedes cars is positively influenced by the attributes such as age, income and years of education.

The information obtained so far can be used to determine the marketing strategy for the Automobile association. The advertisement for the different types of cars can be targeted to different people belonging to different customer profile. Mercedes cars can be shown to older people with higher income and higher education years. They will be more likely to buy the car. The middle aged people must be given preference for selling of Lexus and BMW cars.