More Subjects
Project Proposal
Compact Cars
Student’s Name
Institution
Introduction
Compact cars are some of the expensive cars in the United States and Europe. The sales of these cars are different and each brand or model registers different sales pattern. Some of the compact cars are Chevy Cruze, Ford Focus, Hyundai Elanta, Honda Civic, Toyota Corolla and VW Jetta. The identification of the numbers of each model sold has been difficult and therefore, it is important to establish the best way to identify sales of each car brand. The goal of the study is to test whether the mean of the type of the car sold is different from the six models and whether or not the different of the mean of car sold per is different between the months. The purpose of report is to present the analysis if the sales of each car per month and the total sales of all the cars made every month in the six months period. The sales of the car are analyzed based on the model of the car and the sales per month.
Descriptive statistic
The statistical analysis of the sales of sic brands of compact cars established the mean of cars sold in the six months are different. The descriptive analysis indicates that the mean of the Chevy Cruze is 18441.17, Ford focus is 17830.83333, Hyundai Elantra mean is 16847.167, Honda Civic is 17125.33333, Toyota Corolla mean is 17119.16667, and VW Jetta mean is 17075. However, the analysis of the sales of the six brands of cars does not give a clear mode and therefore, it can concluded that there is not mode. The range of the sales for Chevy Cruze is 5467, Ford Focus is 5156, Hyundai Elantra is 6711, Honda Civic is 6372, Toyota Corolla is 6892, and VW Jetta is 5771. Moreover, the sales details including the mode, standard deviation and the range are provided in the descriptive statistic are illustrated in the table below:
Table 1: Descriptive Statistic
Chevy Cruze
Ford Focus
Hyundai Elantra
Honda Civic
Toyota Corolla
VW Jetta
Mean
18441.16667
Mean
17830.83333
Mean
16847.16667
Mean
17125.33333
Mean
17119.16667
Mean
17075
Range
5467
Range
5156
Range
6711
Range
6372
Range
6892
Range
5771
Standard deviation
1923.845047
SD
2090.287867
SD
2881.971229
SD
2524.778776
SD
2710.957057
SD
2105.071305
Mean
18104
Mean
16988.5
Mean
15383.5
Mean
16490.5
Mean
16308
Mean
16884
The descriptive analysis of the sales for each month for the compact cars is indicated in the table provided below. The investigation revealed that the mean of sales for compact cars for each January is 20670, standard deviation is 944.54 and the media is 20,996. The means for February is 19,569, standard deviation is 877,447, and the median is 19585. It is also obtained that the mean for March is 16713, median is 16,723 and the standard deviation is 808.087. The mean for April 15726, median is 14777, and the standard deviation is 2201.28. The mean for May is 16112, Standard deviation is 772.67 and the media is 15974. It is therefore, evident that the mean, media, range and standard deviation for each month is different. It could mean that the sales of registered by the company every month is different. However, it is important to point out that the mean of sales of compact cars are different and the sales of compact cars for each month are different as well.
Month
Chevy Cruze
Ford Focus
Hyundai Elantra
Honda Civic
Toyota Corolla
VW Jetta
Mean
Stdev
median
Mode
January
21,711
21,303
21,006
19,341
20,985
19,671
20,670
944.5349649
20,996
#N/A
February
18,274
19,385
19,992
20,872
19,785
19,105
19,569
877.4475293
19,585
#N/A
March
17,934
16,557
15,713
17,181
16,889
16,006
16,713
808.087289
16,723
#N/A
April
19,387
17,420
15,054
14,500
14,093
13,900
15,726
2201.280597
14,777
#N/A
May
17,097
16,147
15,023
15,800
15,727
16,875
16,112
772.6716638
15,974
#N/A
June
16,244
16,173
14,295
15,058
15,236
16,893
15,650
951.7666556
15,705
#N/A
Mean
18,441
17,831
16,847
17,125
17,119
17,075
Median
18,104
16,989
15,384
16,491
16,308
16,884
Mode
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Stdev
1923.845047
2090.287867
2881.971229
2524.778776
2710.957057
2105.071305
Analysis
The business question being answered is the number of each model sold and the highest car model or brand sold. The analysis of the sales record or data of compact cars indicates that Chevy Cruze is the highest sold car among the six brands of compact cars. The second highest sold model is Ford Focus and the lowest sold car among the six models of compact cars is Hyundai Elantra car. It is because the mean of Chevy Cruze is 18,441, the means for Ford Focus and the mean for Hyundai Elantra is 16,847. It is therefore, evident that there are substantial different of mean among the six models of compact cars, and the highest sold car in the market is Chevy Cruze and the least sold compact car is Hyundai Elantra car.
It is evident that there mean different of the sales of compact car registered during the six months. The analysis of the sales data gathered for the six months indicates that a lot of sales of cars were made in January and February compared to the rest of the months. The highest sales of car were registered in January and the lowest sales were made in June and April of 2018.
Conclusion Recommendation
It is recommended for the company to improve the marketing of Hyundai in the market to improve its sales and other cars such as Toyota corolla, which registered the lowest sales. It is also recommended for the company to bring in several Chevy Cruze and Ford Focus to meet the high demand of these models of cars by customers. However, it is evident that the sales of cars are not the same and each different sales volume is registered by the company.
Appendix: Descriptive statistic
Chevy Cruze
Ford Focus
Hyundai Elantra
Honda Civic
Toyota Corolla
VW Jetta
Mean
18441.16667
Mean
17830.83333
Mean
16847.16667
Mean
17125.33333
Mean
17119.16667
Mean
17075
Standard Error
785.4064517
Standard Error
853.3564483
Standard Error
1176.559828
Standard Error
1030.736619
Standard Error
1106.743584
Standard Error
859.3917617
Median
18104
Median
16988.5
Median
15383.5
Median
16490.5
Median
16308
Median
16884
Mode
#N/A
Mode
#N/A
Mode
#N/A
Mode
#N/A
Mode
#N/A
Mode
#N/A
Standard Deviation
1923.845047
Standard Deviation
2090.287867
Standard Deviation
2881.971229
Standard Deviation
2524.778776
Standard Deviation
2710.957057
Standard Deviation
2105.071305
Sample Variance
3701179.767
Sample Variance
4369303.367
Sample Variance
8305758.167
Sample Variance
6374507.867
Sample Variance
7349288.167
Sample Variance
4431325.2
Kurtosis
0.993457071
Kurtosis
-0.037381403
Kurtosis
-1.557474099
Kurtosis
-1.254091371
Kurtosis
-1.402329598
Kurtosis
-0.356502093
Skewness
0.95369437
Skewness
1.12165585
Skewness
0.916339289
Skewness
0.637736356
Skewness
0.59653976
Skewness
-0.237381771
Range
5467
Range
5156
Range
6711
Range
6372
Range
6892
Range
5771
Minimum
16244
Minimum
16147
Minimum
14295
Minimum
14500
Minimum
14093
Minimum
13900
Maximum
21711
Maximum
21303
Maximum
21006
Maximum
20872
Maximum
20985
Maximum
19671
Sum
110647
Sum
106985
Sum
101083
Sum
102752
Sum
102715
Sum
102450
Count
6
Count
6
Count
6
Count
6
Count
6
Count
6
More Subjects
Join our mailing list
© All Rights Reserved 2024