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
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. 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 |
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.
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.
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.