Scribd
Upload
16 views1 page

Ibm Class

Data Analysis guide

Uploaded by

akinrinladeoluwatobi7
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
16 views1 page

Ibm Class

Data Analysis guide

Uploaded by

akinrinladeoluwatobi7
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

MONTH CAR SALES PART SERVICING ACCESSORIES MONTH TOTAL

jan £ 193,670.00 £ 11,240.00 £ 5,980.00 £ 1,710.00 £ 212,600.00


feb £ 221,445.00 £ 13,657.00 £ 6,124.00 £ 1,844.00 £ 243,070.00
mar £ 233,378.00 £ 13,889.00 £ 6,578.00 £ 2,180.00 £ 256,025.00
apr £ 260,135.00 £ 14,112.00 £ 7,210.00 £ 2,258.00 £ 283,715.00
may £ 289,940.00 £ 12,499.00 £ 7,324.00 £ 2,612.00 £ 312,375.00
jun £ 312,692.00 £ 12,102.00 £ 7,688.00 £ 2,407.00 £ 334,889.00
jul £ 323,446.00 £ 13,190.00 £ 7,200.00 £ 2,356.00 £ 346,192.00
aug £ 303,575.00 £ 12,778.00 £ 7,734.00 £ 2,170.00 £ 326,257.00
sep £ 260,336.00 £ 14,232.00 £ 8,114.00 £ 2,004.00 £ 284,686.00
oct £ 212,291.00 £ 15,110.00 £ 8,396.00 £ 1,822.00 £ 237,619.00
nov £ 198,440.00 £ 14,125.00 £ 7,855.00 £ 2,135.00 £ 222,555.00
dec £ 177,783.00 £ 12,667.00 £ 6,320.00 £ 2,337.00 £ 199,107.00

sub total £ 2,987,131.00 £ 159,601.00 £ 86,523.00 £ 25,835.00


tax(20%) £ 597,426.20 £ 31,920.20 £ 17,304.60 £ 5,167.00
total £ 3,584,557.20 £ 191,521.20 £ 103,827.60 £ 31,002.00

avg £ 248,927.58 £ 13,300.08 £ 7,210.25 £ 2,152.92


min £ 177,783.00 £ 11,240.00 £ 5,980.00 £ 1,710.00
max £ 323,446.00 £ 15,110.00 £ 8,396.00 £ 2,612.00
count 12
median £ 246,756.50 £ 13,423.50 £ 7,267.00 £ 2,175.00

You might also like