Excel Project

profilepipernan
fall2018rentalcars.txt
Year Quarter Location CarClass Revenue NumCars
2017 Q1 Downtown Economy $977,700 6,290
2017 Q1 Airport Economy $1,047,832 5,963
2015 Q3 Downtown Economy $805,325 5,577
2016 Q4 Airport Economy $959,953 5,413
2016 Q1 Downtown Economy $751,466 5,080
2015 Q3 Airport Economy $734,028 4,922
2016 Q4 Downtown Economy $736,727 4,796
2016 Q3 Downtown Economy $712,259 4,715
2016 Q2 Downtown Economy $670,449 4,472
2015 Q4 Airport Economy $640,474 4,278
2017 Q2 Downtown Economy $601,257 3,758
2016 Q3 Airport Economy $621,108 3,710
2015 Q4 Downtown Economy $532,065 3,610
2015 Q2 Airport Economy $502,546 3,489
2016 Q1 Airport Economy $521,919 3,445
2015 Q1 Airport Economy $470,125 3,408
2017 Q2 Airport Economy $622,565 3,324
2015 Q2 Downtown Economy $396,848 2,881
2015 Q1 Downtown Economy $375,118 2,849
2016 Q2 Airport Economy $385,122 2,280
2015 Q4 Airport Premium $663,901 4,055
2016 Q3 Airport Premium $688,440 4,045
2015 Q4 Downtown Premium $624,053 4,016
2017 Q1 Airport Premium $710,376 3,957
2017 Q2 Airport Premium $722,782 3,961
2016 Q2 Airport Premium $627,078 3,711
2016 Q1 Airport Premium $591,816 3,570
2015 Q3 Downtown Premium $540,217 3,533
2016 Q2 Downtown Premium $523,205 3,247
2015 Q2 Downtown Premium $487,629 3,241
2016 Q4 Airport Premium $565,096 3,228
2015 Q3 Airport Premium $505,403 3,148
2016 Q3 Downtown Premium $517,183 3,150
2016 Q1 Downtown Premium $444,247 2,798
2016 Q4 Downtown Premium $451,490 2,698
2017 Q1 Downtown Premium $452,565 2,685
2015 Q1 Downtown Premium $370,679 2,514
2015 Q1 Airport Premium $375,811 2,466
2015 Q2 Airport Premium $317,110 2,056
2017 Q2 Downtown Premium $345,020 1,996
2015 Q4 Airport SUV $663,548 4,299
2016 Q3 Airport SUV $688,301 4,263
2015 Q4 Downtown SUV $623,328 4,264
2017 Q1 Airport SUV $710,588 4,166
2017 Q2 Airport SUV $722,606 4,160
2016 Q2 Airport SUV $626,757 3,943
2016 Q1 Airport SUV $591,590 3,779
2015 Q3 Downtown SUV $540,623 3,758
2016 Q2 Downtown SUV $523,359 3,400
2015 Q2 Downtown SUV $487,843 3,427
2016 Q4 Airport SUV $565,293 3,381
2015 Q3 Airport SUV $504,888 3,349
2016 Q3 Downtown SUV $518,004 3,345
2016 Q1 Downtown SUV $444,127 2,939
2016 Q4 Downtown SUV $450,725 2,846
2017 Q1 Downtown SUV $451,944 2,833
2015 Q1 Downtown SUV $371,061 2,646
2015 Q1 Airport SUV $376,497 2,621
2015 Q2 Airport SUV $317,066 2,151
2017 Q2 Downtown SUV $344,938 2,078
2015 Q4 Airport Hybrid $663,467 4,139
2016 Q3 Airport Hybrid $688,782 4,089
2015 Q4 Downtown Hybrid $623,719 4,109
2017 Q1 Airport Hybrid $709,847 4,050
2017 Q2 Airport Hybrid $722,481 4,018
2016 Q2 Airport Hybrid $626,363 3,807
2016 Q1 Airport Hybrid $591,561 3,669
2015 Q3 Downtown Hybrid $540,387 3,597
2016 Q2 Downtown Hybrid $523,471 3,320
2015 Q2 Downtown Hybrid $488,036 3,281
2016 Q4 Airport Hybrid $565,829 3,261
2015 Q3 Airport Hybrid $505,782 3,236
2016 Q3 Downtown Hybrid $517,267 3,210
2016 Q1 Downtown Hybrid $444,554 2,867
2016 Q4 Downtown Hybrid $450,842 2,757
2017 Q1 Downtown Hybrid $452,493 2,702
2015 Q1 Downtown Hybrid $370,963 2,554
2015 Q1 Airport Hybrid $376,241 2,533
2015 Q2 Airport Hybrid $317,492 2,106
2017 Q2 Downtown Hybrid $344,374 2,033