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.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Name:
Class/Section:
Project:
Date Due:
Student's Name
Year
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
Quarter
Q3
Q3
Q4
Q4
Q4
Q4
Q4
Q4
Q4
Q3
Q4
Q3
Q3
Q2
Q2
Q1
Q3
Q2
Q2
Q3
Q3
Q2
Q1
Q1
Q1
Q1
Q1
Q1
Q1
Q2
Q2
Q2
Location
Downtown
Airport
Airport
Airport
Downtown
Airport
Downtown
Airport
Downtown
Downtown
Downtown
Downtown
Downtown
Airport
Downtown
Airport
Airport
Downtown
Downtown
Airport
Airport
Downtown
Downtown
Downtown
Airport
Downtown
Airport
Downtown
Airport
Airport
Airport
Airport
CarClass
Economy
Economy
SUV
Economy
SUV
Hybrid
Hybrid
Premium
Premium
SUV
Economy
Hybrid
Premium
Economy
SUV
Economy
SUV
Hybrid
Premium
Hybrid
Premium
Economy
Economy
SUV
SUV
Hybrid
Hybrid
Premium
Premium
SUV
Hybrid
Premium
Revenue
NumCars
$786,907
5,313
$717,241
4,688
$631,293
4,078
$625,827
4,075
$609,073
4,062
$648,294
3,943
$609,455
3,914
$648,717
3,862
$609,781
3,826
$528,259
3,580
$519,897
3,439
$528,028
3,426
$527,862
3,365
$491,053
3,323
$476,686
3,264
$459,373
3,247
$493,341
3,190
$476,875
3,125
$476,477
3,087
$494,215
3,082
$493,845
2,999
$387,772
2,744
$366,539
2,714
$362,575
2,521
$367,887
2,497
$362,479
2,432
$367,637
2,413
$362,201
2,395
$367,216
2,349
$309,815
2,049
$310,231
2,006
$309,858
1,958
Year
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2...