Statistics for Decision Making: Luxury Car Buyers/online homework help

Statistics for Decision Making: Luxury Car Buyers/online homework help

ECON 940 – Statistics for Decision Making

PRESENTATION OF ASSIGNMENT

The answer to your assignment should be in the form of a business report.
Marks awarded will be based on presentation (5%) as well as the rest (90%).
The report will provide you with an opportunity to demonstrate proficiency in integrating statistical software SPSS, Mintab, KaddStat, Excel/PhStat with a word processor, Word. Note that you can easily import Minitab, KaddStat, SPSS, Excel/PhStat output to Word.
Your report must include:


An Executive Summary (100 to 150 words). In this section you summarize the main conclusions of the report in business language. It should also describe the primary purpose of the study, the general methodology used, the significant findings of each section, as well as key general conclusions and recommendations.


A Table of Contents with page numbers
Business Problem as given in the question in business language.
Statistical problem using the language of statistics (i.e. methods you have used to do your analysis).
Analysis: This section should present statistical output and discuss the results from all the analyses conducted. Outline required steps and show necessary computer output. Clearly label tables and graphs.


General Conclusion: This section should briefly review the study, summarize the inference(s) stemming from it, and highlight the evidence supporting each inference. Where appropriate, indicate the limitations of the results. The conclusions should be written in business language and in terms of the variables under discussion.
Implications: bearing in mind why the study was undertaken, briefly describe the implications and consequences of the conclusions drawn. You should include your recommendations for action (based on what you have found in your study).
Write clearly and precisely. A precise report is a clear report, one that is composed of unambiguous statements. The word limit is 3000 words.

Executive Summary:

The scope of the study is to analyze the data of luxury car buyers. The data set consists of type of car and details of people buying the car namely age, annual income and year of experience in education. The different tasks are executed by analyzing the data in excel. From the statistical analysis it is found that the age, annual income and education of people can affect the selection of luxury cars. The report also shows the results of test that older people with higher annual income and higher education mostly prefer Mercedes. From the results, it is recommended that marketing and sales strategies can be made in such a way to attract the target customers. Each car type buyers have some unique similarities which are explained in the report. It can also used to increase the sales by making strategies for different types of cars.

Task 1

cars purchased by different age groups

A car manufacturer creates various plans to market it. The above data points represent the cars purchased by different age groups. The visual is shown as Line chart. 

BMW car buyer’s age is in the range from 36 to 57. LEXUS car buyer’s age is in the range from 36 to 68. The buyers of the Mercedes have ages in the range from 35 to 70.

It is important to keep in mind that vehicles advertisements must reach the respective age groups.

Ages of People Buying Cars
BMW Lexus Mercedes
55 56 52
41 46 54
43 48 53
57 44 64
42 56 49
41 49 43
47 55 50
46 49 48
BMW   Lexus   Mercedes  
Mean 45.21538 Mean 50.45714 Mean 51.98667
Standard Error 0.381908 Standard Error 0.515472 Standard Error 0.55037
Median 45 Median 50 Median 53
Mode 46 Mode 55 Mode 53
Standard Deviation 4.354423 Standard Deviation 6.099147 Standard Deviation 6.740628
Sample Variance 18.961 Sample Variance 37.19959 Sample Variance 45.43606
Kurtosis 0.04742 Kurtosis 0.611214 Kurtosis -0.0195
Skewness 0.508655 Skewness 0.360262 Skewness -0.02894
Range 21 Range 32 Range 35
Minimum 36 Minimum 36 Minimum 35
Maximum 57 Maximum 68 Maximum 70
Sum 5878 Sum 7064 Sum 7798
Count 130 Count 140 Count 150

DESCRIPTIVE STATISTICS OF BMW CARS

Minimum of 36 and maximum of 57 year old people has interest to buy BMW. The total number of BMW purchases is 130

DESCRIPTIVE STATISTICS OF LEXUS CARS

 Minimum 36 and maximum 68 years of age groups are attracted by Lexus. The total number of LEXUS purchases is 140.

DESCRIPTIVE STATISTICS OF MERCEDES CAR

Minimum 35 and maximum 70 years of age groups are attracted by Mercedes. The total number of Mercedes purchases is 150.

From the detailed statistics based on the people’s age that has higher age mostly prefer only Mercedes.

Task 2

Three different luxury cars are required to display data with annual income of buyers. Next, we need to calculate statistics with three different luxury cars with their income in dollar.

A car manufacturer produces various plans to market it. In this regard, we are investigating to find out which types of cars are purchased with buyers on annual income basis. 

Row Labels Average of Annual Income ($)
BMW 139271.3385
Lexus 154186.8571
Mercedes 184423.9467
Grand Total 160369.1095
Type of cars is taken on the horizontal axis has been analyzed with annual income on the vertical axis

Type of cars is taken on the horizontal axis has been analyzed with annual income on the vertical axis. The analysis shows that People earning average annual profits of 139271.3385 (dollar) buy BMW. People with an average annual income of 154186.8571 dollar buy Lexus. People with average earnings per annum of 184423.9467 dollar buy Mercedes.

 It seems to have Mercedes as a desire for higher annual income. It is important to keep in mind those vehicles advertisements should reach out to those with suitable annual income during marketing.

  annual income

BMWLexusMercedes148,066118,571161,590191,835129,564129,017172,689120,807194,379159,380159,132226,016138,269120,165153,589166,091160,062275,299105,033200,609135,562176,274170,884211,308
bmw   lexus   mercedes  
           
Mean 139271.3 Mean 154186.9 Mean 184423.9
Standard Error 2907.846 Standard Error 2556.425 Standard Error 3845.333
Median 138512 Median 154492 Median 186070
Mode 109568 Mode 179617 Mode 161590
Standard Deviation 33154.54 Standard Deviation 30248.02 Standard Deviation 47095.52
Sample Variance 1.1E+09 Sample Variance 9.15E+08 Sample Variance 2.22E+09
Kurtosis -0.22439 Kurtosis 0.963641 Kurtosis 0.987178
Skewness -0.03855 Skewness 0.693685 Skewness 0.273966
Range 170652 Range 152065 Range 284882
Minimum 46068 Minimum 96069 Minimum 49941
Maximum 216720 Maximum 248134 Maximum 334823
Sum 18105274 Sum 21586160 Sum 27663592
Count 130 Count 140 Count 150

DESCRIPTIVE STATISTICS FOR BMW CAR

People prefer BMW who got minimum 46068 dollars and a maximum of 216720 dollar annually. The total number of BMW purchases is 130

Mean:

The middle trend is the mean or average commonly used method. To calculate the mean value you have to do addition of all the values and divide by the number of values.

By using average annual income of buyers and BMW the mean value for buyer’s average annual income is 139271.3 dollar.

Median: 

By using average annual income of buyers and BMW, median value for buyer’s average annual income is 138512 dollar.

Mode:

The most frequently occurring value in a set of scores. The most frequently occurring value is known as mode.

The most frequently occurring value in the given data set for BMW is 109568 dollar.

Note:

In the same set of ages, we have the mean, median and mode three different values for 139271.3, 138512, and 109568 (dollars) respectively. If the distribution is really normal (ie in the form of a bell), the mean, median and mode are all equal to each other.

Statistics for Decision Making: Luxury Car Buyers/online homework help

DESCRIPTIVE STATISTICS FOR LEXUS CAR

People who got minimum 96069 dollar and maximum 248134 dollar yearly income attracted by Lexus. Total number of Lexus buyers is 140.

Mean:

By using average annual income of buyers and Lexus the mean value for buyer’s average annual income is 154186.9 dollar 

Median: 

By using average annual income of buyers and Lexus the median value for buyer’s average annual income is 154492 dollar

Mode:

The most frequently occurring value in a set of scores. To determine the system, sort scores as shown above, then count each. The most frequently occurring value is known as mode.

The most frequently occurring value in the given data set is 179617 dollar.

Note:

In the same set of ages, we have the mean, median and mode three different values for 154186.9, 154492, 179617 (dollar) respectively. If the distribution is really normal (ie in the form of a bell), the mean, median and mode are all equal to each other.

DESCRIPTIVE STATISTICS FOR MERCEDES CAR

People who got minimum 49941 dollar and maximum 334823 dollar yearly prefer only Mercedes. The total number of Mercedes purchases is 150.

Mean:

By using average annual income of buyers and Mercedes the mean value for buyer’s average annual income is 184423.9 dollar.

Median: 

The exact middle value of the set is known as median. List all scores in a way of numerical order to calculate the average, then find the centre score in the sample.

By using average annual income of buyers and Mercedes the median value for buyer’s average annual income is 186070dollar. 

Mode:

The most frequently occurring value in a set of scores. To determine the system, sort scores as shown above, then count each. The most frequently occurring value is known as mode.

The most frequently occurring value in the given data set is 161590 dollar.

Note:

In the same set of ages, we have the mean, median and mode three different values for 184423.9, 186070, and 161590 (dollars) respectively. If the distribution is really normal (ie in the form of a bell), the mean, median and mode are all equal to each other.

TASK 3

Three different luxury cars have to display data with the years of education of buyers. Next, we need to calculate statistics with the years of education of buyers of three different luxury cars.

Row Labels Average of Education (Years)
BMW 15.83076923
Lexus 15.8
Mercedes 17.29333333
Grand Total 16.34285714
Type of cars on The horizontal axis which is analyzed with an average year of education on a vertical axis

A car manufacturer produces various plans to market it. Studies have been made to find out which types of cars they have with year of education. Let’s see in detail the data analysis on the top. Type of cars on The horizontal axis which is analyzed with an average year of education on a vertical axis. 

The year of education of 15.83076923 people buy BMW. 

An average year of education 15.8 people buys Lexus. 

The year of education of education17.29333333 people are getting Mercedes.

It seems that Mercedes as a desire for higher year’s education

It is important to keep in mind that vehicles must be reached to those who have a suitable year of education in marketing.

Education (Years)    
BMW Lexus Mercedes
18 15 20
16 12 14
17 18 18
17 16 17
11 19 18
17 17 17
15 14 17
15 19 15
bmw   lexus   mercedes  
Mean 15.83076923 Mean 15.8 Mean 17.29333
Standard Error 0.160922527 Standard Error 0.204069593 Standard Error 0.142067
Median 16 Median 16 Median 17
Mode 16 Mode 16 Mode 17
Standard Deviation 1.83479911 Standard Deviation 2.414583986 Standard Deviation 1.739963
Sample Variance 3.366487776 Sample Variance 5.830215827 Sample Variance 3.027472
Kurtosis -0.172883895 Kurtosis -0.977282698 Kurtosis 0.039633
Skewness -0.434503723 Skewness 0.169719918 Skewness 0.081676
Range 8 Range 9 Range 9
Minimum 11 Minimum 12 Minimum 13
Maximum 19 Maximum 21 Maximum 22
Sum 2058 Sum 2212 Sum 2594
Count 130 Count 140 Count 150

DESCRIPTIVE STATISTICS OF BMW CAR

People whose preference for BMW has minimum 11 and maximum of 19 years of education. The total number of BMW purchases is 130

Mean:

The middle trend is the mean or average commonly used method. To calculate the mean value you have to do addition of all the values and divide by the number of values.

By using average annual income of buyers and type of three different cars mean value for buyers average education is 15.83076923,

Median: 

The exact middle value of the set is known as median. List all scores in a way of numerical order to calculate the average, then find the centre score in the sample.

By using average annual income of buyers and type of three different cars median value for buyer’s average education are 16.

Mode:

The most frequently occurring value in a set of scores. To determine the system, sort scores as shown above, then count each. The most frequently occurring value is known as mode.

The most frequently occurring value in the given data set is 16.

Note:

In the same set of ages, we have the mean, median and mode three different values for 15.83076923,, 16, 16 (average age) respectively. If the distribution is really normal (ie in the form of a bell), the mean, median and mode are all equal to each other.

DESCRIPTIVE STATISTICS OF LEXUS CAR

People who has minimum 12 and maximum 21year of educators are attracted by Lexus. Total number of Lexus buyers is 140

Mean:

The middle trend is the mean or average commonly used method. To calculate the mean value you have to do addition of all the values and divide by the number of values.

By using average annual income of buyers and type of three different cars mean value for buyers average education is 15.8

Median: 

The exact middle value of the set is known as median. List all scores in a way of numerical order to calculate the average, then find the centre score in the sample.

By using average annual income of buyers and type of three different cars median value for buyer’s average education are 16.

Mode:

The most frequently occurring value in a set of scores. To determine the system, sort scores as shown above, then count each. The most frequently occurring value is known as mode.

The most frequently occurring value in the given data set is 16.

Note:

In the same set of ages, we have the mean, median and mode three different values for 15.8,, 16, 16(average age)  respectively. If the distribution is really normal (ie in the form of a bell), the mean, median and mode are all equal to each other.

DESCRIPTIVE STATISTICS OF MERCEDES CAR

Minimum 13 and maximum 22 years of education prefer Mercedes. The total number of Mercedes purchases is 150

This quality analysis can make sense of Mercedes as a desire for people with higher years of education

Mean:

The middle trend is the mean or average commonly used method. To calculate the mean value you have to do addition of all the values and divide by the number of values.

By using average annual income of buyers and type of three different cars mean value for buyers education is 17.29333(average age)

Median: 

The exact middle value of the set is known as median. List all scores in a way of numerical order to calculate the average, then find the centre score in the sample.

By using average annual income of buyers and type of three different cars median value for buyer’s education is 17(average age)

Mode:

The most frequently occurring value in a set of scores. To determine the system, sort scores as shown above, then count each. The most frequently occurring value is known as mode.

The most frequently occurring value in the given data set is 17.

Note:

In the same set of ages, we have the mean, median and mode three different values for 17.29333,,17, 17(average age)  respectively. If the distribution is really normal (ie in the form of a bell), the mean, median and mode are all equal to each other.

TASK 4

The scope of the task is to test the belief that there is no significant difference of the average ages of the buyers of three different luxury cars

Row Labels Average of Age (Years)
BMW 45.21538462
Lexus 50.45714286
Mercedes 51.98666667
Grand Total 49.38095238
Type of cars is taken on the horizontal axis which is analysed with average age of buyers on vertical axis

Type of cars is taken on the horizontal axis which is analysed with average age of buyers on vertical axis.

Bar chart will created by using excel with help of the given data. 

The people of average age 45.21538462 have bought BMW.

The people of average age 50.45714286 have bought LEXUS. 

The People of average age 51.98666667 have bought Mercedes.

This means that Mercedes is attracted by more aged people. This decision is made clear that there is considerable difference in age for buying cars.

TASK 5

In this task we will discuss about the belief that that there is no significant difference in mean household incomes of the three different luxury cars.

Row Labels Average of Annual Income ($)
BMW 139271.3385
Lexus 154186.8571
Mercedes 184423.9467
Grand Total 160369.1095

Type of cars is taken on the horizontal axis which is analysed with average annual income of buyers on vertical axis.

Bar chart is created by using excel with help of the given data. 

People of An average annual income 139271.3385 dollar have bought BMW. 

People of An average of annual income 154186.8571 dollar have bought LEXUS. 

People of An Average of annual income 184423.9467 dollar have bought Mercedes.

This makes us feel Mercedes as the choice of most annual income. This decision is made clear that there is a substantial amount of annual income on buying cars

TASK 6

In this task we will discuss about the belief that that there is no significant difference in mean household incomes of the three different luxury cars.

Row Labels Average of Education (Years)
BMW 15.83076923
Lexus 15.8
Mercedes 17.29333333
Grand Total 16.34285714
Type of cars are taken on the horizontal axis which is analysed with Average of Education (Years) of buyers on vertical axis

Type of cars are taken on the horizontal axis which is analysed with Average of Education (Years) of buyers on vertical axis.

Bar chart will created by using excel with help of the given data. 

People of An Average of Education (Years) 15.83076923 have bought BMW. 

People of An Average of Education (Years) 15.8 have bought LEXUS. 

People of An Average of Education (Years) 17.29333333 have bought Mercedes.

This makes us feel Mercedes as the choice of higher education (year) people. This decision is made clear by considering a substantial amount of years of education in buying luxury cars.

Task 7

In this task we will discuss about the belief “Some other car dealers claim that older people with higher household income and more years of education prefer Mercedes to BMW or Lexus”.

  Values  
Row Labels Average of Annual Income ($) Average of Education (Years)
70 184735 17
Mercedes 184735 17
68 153138 12
Lexus 153138 12
66 134556 14
Lexus 134556 14
64 186936 17
Mercedes 186936 17
63 195663 15.5
Lexus 171605 13
Mercedes 219721 18
62 178344.5 16
Lexus 170619 15
Mercedes 186070 17
61 137412 19.5
Lexus 114276 17
Mercedes 160548 22
60 138797 17
Mercedes 138797 17

Above table contains type of cars with respect to age, average annual income, and average education details of the buyers

It will clearly show when the ages of buyers’ increases BMW car lose their place. It means that people with higher age and higher annual income people do not prefer BMW.

Our problem is some other car dealer’s claim that older people with higher household income and more years of education prefer Mercedes to BMW or Lexus. It may be false because highest education of people with low level income also selecting Lexus.

For example ,in this table take that 70 aged customer their annual income is 184735 dollar  but their years of education is low when compared with others they choose Mercedes as favourite car.

May be annual income of the customer and age will affect the choosing of their favourite car but year of education doesn’t matter when choose a favourite car.