Scribd
Upload
4 views2 pages

Quarterly Car Sales Data Analysis

The document provides detailed sales data for various Audi and BMW car models from 2016 to 2017, including total cars sold, averages, counts, and statistical measures. Key insights include a total of 877,904 cars sold, with an average of 27,434.5 cars sold quarterly. Additionally, it highlights the maximum, minimum, median, and standard deviation of quarterly car sales.

Uploaded by

20.0091 Adit Trinoviantoro
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
4 views2 pages

Quarterly Car Sales Data Analysis

The document provides detailed sales data for various Audi and BMW car models from 2016 to 2017, including total cars sold, averages, counts, and statistical measures. Key insights include a total of 877,904 cars sold, with an average of 27,434.5 cars sold quarterly. Additionally, it highlights the maximum, minimum, median, and standard deviation of quarterly car sales.

Uploaded by

20.0091 Adit Trinoviantoro
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Car Make Car Model Year Quarter Cars sold

Audi A5 2016 Q1 42,101 SUM


Audi A5 2016 Q2 22,664 SUMIF
Audi A5 2016 Q3 27,233 SUMIFS
Audi A5 2016 Q4 24,002
Audi A5 2017 Q1 32,723 AVERAGE
Audi A5 2017 Q2 43,243 AVERAGEIF
Audi A5 2017 Q3 14,840 AVERAGEIFS
Audi A5 2017 Q4 37,215
Audi A6 2016 Q1 9,740 COUNT
Audi A6 2016 Q2 49,718 COUNTIF
Audi A6 2016 Q3 8,220 COUNTIFS
Audi A6 2016 Q4 46,491
Audi A6 2017 Q1 12,600 MEDIAN
Audi A6 2017 Q2 48,081
Audi A6 2017 Q3 37,836 MAX
Audi A6 2017 Q4 30,305 MIN
BMW 4 Series Gran Coupe 2016 Q1 5,233
BMW 4 Series Gran Coupe 2016 Q2 42,530 LARGE
BMW 4 Series Gran Coupe 2016 Q3 14,251 SMALL
BMW 4 Series Gran Coupe 2016 Q4 13,483
BMW 4 Series Gran Coupe 2017 Q1 47,422 STDDEV.P
BMW 4 Series Gran Coupe 2017 Q2 17,065
BMW 4 Series Gran Coupe 2017 Q3 9,380 [Link]
BMW 4 Series Gran Coupe 2017 Q4 35,858
BMW 5 Series 2016 Q1 35,300 [Link]
BMW 5 Series 2016 Q2 25,888
BMW 5 Series 2016 Q3 2,870 [Link]
BMW 5 Series 2016 Q4 31,168
BMW 5 Series 2017 Q1 18,809
BMW 5 Series 2017 Q2 17,387
BMW 5 Series 2017 Q3 34,061
BMW 5 Series 2017 Q4 40,187

# Classification: Protected A
Sum of all cars sold 877,904.0
Sum of all cars sold in Q1 203,928.0
Sum of all cars sold in Q1 of 2016 92,374.0

Average of all cars sold quarterly 27,434.5


Average Audi cars sold quarterly 30,438.3
Average Audi cars sold quarterly in 2016 28,771.1

Count all cells with data on all cars sold 32.0


Count all cells with data on Audi cars sold 16.0
Count all cells with data on Audi A5 cars sold 8.0

Median quarterly car sales 28,769.0

Maximun quarterly car sales 49,718.0


Minimum quarterly car sales 2,870.0

Second largest quarterly car sales 47,422.0


Second largest quarterly car sales 5,233.0

Standard deviation of quarterly car sales 13,855.6

Rank of 9,740 in quarterly car sales 5.0

Value of first quartile. 25% of the data is greater than or equal to this value 14,692.8

25th percentile of quarterly car sales 49,718.0

# Classification: Protected A

You might also like