Question Description

Create a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities for charting. The charts will be copied into a Microsoft PowerPoint file and the student will develop appropriate findings and recommendations based on analysis of the data.

Excel Project 3 – MS Excel
(Summer 2019)
Use the project description HERE to complete this activity. For a review of the complete rubric used in grading this exercise, click on the Assignments tab, then on the title Excel Project #3. Click on Show Rubrics if the
rubric is not already displayed.
Summary
Create a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities for charting.
The charts will be copied into a Microsoft PowerPoint file and the student will develop appropriate findings and recommendations based on analysis of the data.
A large rental car company has two metropolitan locations, one at the airport and another centrally located in downtown. It has been operating since 2015 and each location summarizes its car rental revenue quarterly.
Both locations rent four classes of cars: economy, premium, hybrid, SUV. Rental revenue is maintained
separately for the four classes of rental vehicles.
The data for this case resides in the file summer2019rentalcars.txt and can be downloaded by clicking on the Assignments tab, then on the data tile name. It is a text file (with the file type .txt).
Do not create your own data, you must use the data provided and only the data provided.
Default Formatting. All labels, text, and numbers will be Arial 10, There will be $ and comma and decimal point variations for numeric data, but Arial 10 will be the default font and font size.

Year
2017
2017
2015
2016
2016
2015
2016
2016
2016
2015
2015
2015
2016
2017
2017
2015
2015
2016
2015
2017
2016
2017
2015
2017
2017
2016
2016
2016
2017
2015
2016
2016
2016
2015
2015
2016
2015
2015
2016
2015
2015
2016
2016
2015
2016
2017
2016
2015
2016
2016
2015
2015
2016
2016
2016
2015
2016
2015

Quarter
Location
CarClass
Revenue
Q1
Downtown
Economy
955340
5992
Q1
Airport
Economy
1023868
5680
Q3
Downtown
Economy
786907
5313
Q4
Airport
Economy
937999
5156
Q1
Downtown
Economy
734280
4839
Q3
Airport
Economy
717241
4688
Q4
Downtown
Economy
719879
4569
Q3
Downtown
Economy
695970
4491
Q2
Downtown
Economy
655116
4260
Q4
Airport
SUV
631293
4078
Q4
Airport
Economy
625827
4075
Q4
Downtown
SUV
609073
4062
Q3
Airport
SUV
672559
4061
Q1
Airport
SUV
694337
3968
Q2
Airport
SUV
706080
3963
Q4
Airport
Hybrid
648294
3943
Q4
Downtown
Hybrid
609455
3914
Q3
Airport
Hybrid
673030
3896
Q4
Airport
Premium
648717
3862
Q1
Airport
Hybrid
693613
3858
Q3
Airport
Premium
672695
3853
Q2
Airport
Hybrid
705958
3827
Q4
Downtown
Premium
609781
3826
Q2
Airport
Premium
706252
3773
Q1
Airport
Premium
694130
3769
Q2
Airport
SUV
612423
3756
Q2
Airport
Hybrid
612038
3626
Q1
Airport
SUV
578060
3600
Q2
Downtown
Economy
587507
3580
Q3
Downtown
SUV
528259
3580
Q2
Airport
Premium
612737
3535
Q3
Airport
Economy
606904
3534
Q1
Airport
Hybrid
578032
3495
Q4
Downtown
Economy
519897
3439
Q3
Downtown
Hybrid
528028
3426
Q1
Airport
Premium
578281
3401
Q3
Downtown
Premium
527862
3365
Q2
Airport
Economy
491053
3323
Q1
Airport
Economy
509983
3282
Q2
Downtown
SUV
476686
3264
Q1
Airport
Economy
459373
3247
Q2
Downtown
SUV
511389
3239
Q4
Airport
SUV
552365
3220
Q3
Airport
SUV
493341
3190
Q3
Downtown
SUV
506157
3186
Q2
Airport
Economy
608327
3166
Q2
Downtown
Hybrid
511499
3162
Q2
Downtown
Hybrid
476875
3125
Q4
Airport
Hybrid
552888
3107
Q2
Downtown
Premium
511239
3093
Q2
Downtown
Premium
476477
3087
Q3
Airport
Hybrid
494215
3082
Q4
Airport
Premium
552173
3075
Q3
Downtown
Hybrid
505438
3058
Q3
Downtown
Premium
505355
3001
Q3
Airport
Premium
493845
2999
Q1
Downtown
SUV
433969
2800
Q2
Downtown
Economy
387772
2744

NumCars

2016
2015
2016
2017
2016
2016
2017
2016
2017
2015
2015
2015
2015
2015
2015
2016
2015
2015
2017
2015
2017
2017

Q1
Q1
Q4
Q1
Q1
Q4
Q1
Q4
Q1
Q1
Q1
Q1
Q1
Q1
Q1
Q2
Q2
Q2
Q2
Q2
Q2
Q2

Downtown
Downtown
Downtown
Downtown
Downtown
Downtown
Downtown
Downtown
Downtown
Downtown
Airport
Downtown
Airport
Downtown
Airport
Airport
Airport
Airport
Downtown
Airport
Downtown
Downtown

Hybrid
434387
Economy
366539
SUV
440417
2711
SUV
441608
2699
Premium
434087
Hybrid
440531
Hybrid
442145
Premium
441165
Premium
442215
SUV
362575
2521
SUV
367887
2497
Hybrid
362479
Hybrid
367637
Premium
362201
Premium
367216
Economy
376314
SUV
309815
2049
Hybrid
310231
SUV
337049
1980
Premium
309858
Hybrid
336498
Premium
337130

2731
2714
2666
2626
2573
2570
2558
2432
2413
2395
2349
2172
2006
1958
1936
1901

Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at essayloop.com

Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at essayloop.com. We assure you of a well written and plagiarism free papers delivered within your specified deadline.