Excel Project 2
yyehuwdah
YodhhewawheYehuwdahYExcelProject1.xlsxAnalysis by
| Name: | Yehuwdah Yodhhewawhe | |
| Class/Section: | IFSM 201 6377 Concepts and Applications of Information Technology (2205) | |
| Project: | Excel Project #1 | |
| Date Due: | 6/9/20 | |
Data
| Year | Quarter | Location | CarClass | Revenue | NumCars |
| 2018 | Q2 | Airport | Premium | $305,996 | 1895 |
| 2018 | Q2 | Airport | Hybrid | $306,364 | 1943 |
| 2018 | Q2 | Airport | SUV | $305,953 | 1987 |
| 2019 | Q2 | Airport | Economy | $371,631 | 2111 |
| 2018 | Q1 | Airport | Premium | $362,646 | 2289 |
| 2018 | Q1 | Downtown | Premium | $357,693 | 2336 |
| 2018 | Q1 | Airport | Hybrid | $363,062 | 2354 |
| 2018 | Q1 | Downtown | Hybrid | $357,967 | 2373 |
| 2018 | Q1 | Airport | SUV | $363,309 | 2439 |
| 2018 | Q1 | Downtown | SUV | $358,062 | 2463 |
| 2019 | Q4 | Downtown | Premium | $435,682 | 2512 |
| 2019 | Q4 | Downtown | Hybrid | $435,056 | 2569 |
| 2019 | Q1 | Downtown | Premium | $428,691 | 2609 |
| 2019 | Q4 | Downtown | SUV | $434,943 | 2655 |
| 2018 | Q1 | Downtown | Economy | $361,977 | 2658 |
| 2019 | Q1 | Downtown | Hybrid | $428,988 | 2675 |
| 2018 | Q2 | Downtown | Economy | $382,948 | 2688 |
| 2019 | Q1 | Downtown | SUV | $428,575 | 2744 |
| 2018 | Q3 | Airport | Premium | $487,711 | 2945 |
| 2019 | Q3 | Downtown | Premium | $499,079 | 2947 |
| 2019 | Q3 | Downtown | Hybrid | $499,161 | 3005 |
| 2019 | Q4 | Airport | Premium | $545,319 | 3022 |
| 2018 | Q3 | Airport | Hybrid | $488,077 | 3029 |
| 2018 | Q2 | Downtown | Premium | $470,558 | 3034 |
| 2019 | Q2 | Downtown | Premium | $504,891 | 3040 |
| 2019 | Q4 | Airport | Hybrid | $546,026 | 3054 |
| 2018 | Q2 | Downtown | Hybrid | $470,951 | 3072 |
| 2019 | Q2 | Downtown | Hybrid | $505,147 | 3110 |
| 2019 | Q3 | Downtown | SUV | $499,871 | 3134 |
| 2018 | Q3 | Airport | SUV | $487,214 | 3138 |
| 2019 | Q4 | Airport | SUV | $545,509 | 3168 |
| 2019 | Q2 | Downtown | SUV | $505,039 | 3187 |
| 2018 | Q1 | Airport | Economy | $453,665 | 3196 |
| 2018 | Q2 | Downtown | SUV | $470,764 | 3213 |
| 2019 | Q1 | Airport | Economy | $503,650 | 3231 |
| 2018 | Q2 | Airport | Economy | $484,954 | 3272 |
| 2018 | Q3 | Downtown | Premium | $521,308 | 3315 |
| 2019 | Q1 | Airport | Premium | $571,105 | 3351 |
| 2018 | Q3 | Downtown | Hybrid | $521,472 | 3376 |
| 2018 | Q4 | Downtown | Economy | $513,442 | 3389 |
| 2019 | Q1 | Airport | Hybrid | $570,859 | 3446 |
| 2019 | Q3 | Airport | Economy | $599,375 | 3485 |
| 2019 | Q2 | Airport | Premium | $605,136 | 3486 |
| 2018 | Q3 | Downtown | SUV | $521,701 | 3532 |
| 2019 | Q1 | Airport | SUV | $570,887 | 3552 |
| 2019 | Q2 | Airport | Hybrid | $604,445 | 3578 |
| 2019 | Q2 | Airport | SUV | $604,825 | 3709 |
| 2018 | Q4 | Downtown | Premium | $602,216 | 3780 |
| 2019 | Q3 | Airport | Premium | $664,353 | 3807 |
| 2018 | Q4 | Airport | Premium | $640,671 | 3816 |
| 2019 | Q3 | Airport | Hybrid | $664,684 | 3850 |
| 2018 | Q4 | Downtown | Hybrid | $601,894 | 3869 |
| 2018 | Q4 | Airport | Hybrid | $640,254 | 3898 |
| 2019 | Q3 | Airport | SUV | $664,219 | 4017 |
| 2018 | Q4 | Downtown | SUV | $601,517 | 4018 |
| 2018 | Q4 | Airport | Economy | $618,064 | 4031 |
| 2018 | Q4 | Airport | SUV | $623,463 | 4034 |
| 2019 | Q2 | Downtown | Economy | $646,991 | 4218 |
| 2019 | Q3 | Downtown | Economy | $687,341 | 4451 |
| 2019 | Q4 | Downtown | Economy | $710,955 | 4529 |
| 2018 | Q3 | Airport | Economy | $708,349 | 4649 |
| 2019 | Q1 | Downtown | Economy | $725,178 | 4802 |
| 2019 | Q4 | Airport | Economy | $926,382 | 5122 |
| 2018 | Q3 | Downtown | Economy | $777,155 | 5280 |
Sorted
| Year | Quarter | Location | CarClass | Revenue | NumCars |
| 2018 | Q2 | Airport | Premium | $305,996 | 1895 |
| 2018 | Q2 | Airport | Hybrid | $306,364 | 1943 |
| 2018 | Q2 | Airport | SUV | $305,953 | 1987 |
| 2019 | Q2 | Airport | Economy | $371,631 | 2111 |
| 2018 | Q1 | Airport | Premium | $362,646 | 2289 |
| 2018 | Q1 | Airport | Hybrid | $363,062 | 2354 |
| 2018 | Q1 | Airport | SUV | $363,309 | 2439 |
| 2018 | Q3 | Airport | Premium | $487,711 | 2945 |
| 2019 | Q4 | Airport | Premium | $545,319 | 3022 |
| 2018 | Q3 | Airport | Hybrid | $488,077 | 3029 |
| 2019 | Q4 | Airport | Hybrid | $546,026 | 3054 |
| 2018 | Q3 | Airport | SUV | $487,214 | 3138 |
| 2019 | Q4 | Airport | SUV | $545,509 | 3168 |
| 2018 | Q1 | Airport | Economy | $453,665 | 3196 |
| 2019 | Q1 | Airport | Economy | $503,650 | 3231 |
| 2018 | Q2 | Airport | Economy | $484,954 | 3272 |
| 2019 | Q1 | Airport | Premium | $571,105 | 3351 |
| 2019 | Q1 | Airport | Hybrid | $570,859 | 3446 |
| 2019 | Q3 | Airport | Economy | $599,375 | 3485 |
| 2019 | Q2 | Airport | Premium | $605,136 | 3486 |
| 2019 | Q1 | Airport | SUV | $570,887 | 3552 |
| 2019 | Q2 | Airport | Hybrid | $604,445 | 3578 |
| 2019 | Q2 | Airport | SUV | $604,825 | 3709 |
| 2019 | Q3 | Airport | Premium | $664,353 | 3807 |
| 2018 | Q4 | Airport | Premium | $640,671 | 3816 |
| 2019 | Q3 | Airport | Hybrid | $664,684 | 3850 |
| 2018 | Q4 | Airport | Hybrid | $640,254 | 3898 |
| 2019 | Q3 | Airport | SUV | $664,219 | 4017 |
| 2018 | Q4 | Airport | Economy | $618,064 | 4031 |
| 2018 | Q4 | Airport | SUV | $623,463 | 4034 |
| 2018 | Q3 | Airport | Economy | $708,349 | 4649 |
| 2019 | Q4 | Airport | Economy | $926,382 | 5122 |
| 2018 | Q1 | Downtown | Premium | $357,693 | 2336 |
| 2018 | Q1 | Downtown | Hybrid | $357,967 | 2373 |
| 2018 | Q1 | Downtown | SUV | $358,062 | 2463 |
| 2019 | Q4 | Downtown | Premium | $435,682 | 2512 |
| 2019 | Q4 | Downtown | Hybrid | $435,056 | 2569 |
| 2019 | Q1 | Downtown | Premium | $428,691 | 2609 |
| 2019 | Q4 | Downtown | SUV | $434,943 | 2655 |
| 2018 | Q1 | Downtown | Economy | $361,977 | 2658 |
| 2019 | Q1 | Downtown | Hybrid | $428,988 | 2675 |
| 2018 | Q2 | Downtown | Economy | $382,948 | 2688 |
| 2019 | Q1 | Downtown | SUV | $428,575 | 2744 |
| 2019 | Q3 | Downtown | Premium | $499,079 | 2947 |
| 2019 | Q3 | Downtown | Hybrid | $499,161 | 3005 |
| 2018 | Q2 | Downtown | Premium | $470,558 | 3034 |
| 2019 | Q2 | Downtown | Premium | $504,891 | 3040 |
| 2018 | Q2 | Downtown | Hybrid | $470,951 | 3072 |
| 2019 | Q2 | Downtown | Hybrid | $505,147 | 3110 |
| 2019 | Q3 | Downtown | SUV | $499,871 | 3134 |
| 2019 | Q2 | Downtown | SUV | $505,039 | 3187 |
| 2018 | Q2 | Downtown | SUV | $470,764 | 3213 |
| 2018 | Q3 | Downtown | Premium | $521,308 | 3315 |
| 2018 | Q3 | Downtown | Hybrid | $521,472 | 3376 |
| 2018 | Q4 | Downtown | Economy | $513,442 | 3389 |
| 2018 | Q3 | Downtown | SUV | $521,701 | 3532 |
| 2018 | Q4 | Downtown | Premium | $602,216 | 3780 |
| 2018 | Q4 | Downtown | Hybrid | $601,894 | 3869 |
| 2018 | Q4 | Downtown | SUV | $601,517 | 4018 |
| 2019 | Q2 | Downtown | Economy | $646,991 | 4218 |
| 2019 | Q3 | Downtown | Economy | $687,341 | 4451 |
| 2019 | Q4 | Downtown | Economy | $710,955 | 4529 |
| 2019 | Q1 | Downtown | Economy | $725,178 | 4802 |
| 2018 | Q3 | Downtown | Economy | $777,155 | 5280 |
Airport
| Year | Quarter | Location | CarClass | Revenue | NumCars | AvgRev | Average Quarterly Revenue per Economy Car (Airport) | 160.0788280767 | |||||||
| 2018 | Q1 | Airport | Economy | $453,665 | 3,196 | $141.95 | Average Quarterly Revenue per Hybird Car (Airport) | 165.4152708461 | |||||||
| 2018 | Q2 | Airport | Economy | $484,954 | 3,272 | $148 | Average Quarterly Revenue per Premium Car (Airport) | 169.0473858637 | |||||||
| 2018 | Q3 | Airport | Economy | $708,349 | 4,649 | $152 | Average Quarterly Revenue per SUV Car (Airport) | 159.2609913687 | |||||||
| 2018 | Q4 | Airport | Economy | $618,064 | 4,031 | $153 | |||||||||
| 2019 | Q1 | Airport | Economy | $503,650 | 3,231 | $156 | |||||||||
| 2019 | Q2 | Airport | Economy | $371,631 | 2,111 | $176 | |||||||||
| 2019 | Q3 | Airport | Economy | $599,375 | 3,485 | $172 | |||||||||
| 2019 | Q4 | Airport | Economy | $926,382 | 5,122 | $181 | |||||||||
| 2018 | Q1 | Airport | Hybrid | $363,062 | 2,354 | $154 | |||||||||
| 2018 | Q2 | Airport | Hybrid | $306,364 | 1,943 | $158 | |||||||||
| 2018 | Q3 | Airport | Hybrid | $488,077 | 3,029 | $161 | |||||||||
| 2018 | Q4 | Airport | Hybrid | $640,254 | 3,898 | $164 | |||||||||
| 2019 | Q1 | Airport | Hybrid | $570,859 | 3,446 | $166 | |||||||||
| 2019 | Q2 | Airport | Hybrid | $604,445 | 3,578 | $169 | |||||||||
| 2019 | Q3 | Airport | Hybrid | $664,684 | 3,850 | $173 | |||||||||
| 2019 | Q4 | Airport | Hybrid | $546,026 | 3,054 | $179 | |||||||||
| 2018 | Q1 | Airport | Premium | $362,646 | 2,289 | $158 | |||||||||
| 2018 | Q2 | Airport | Premium | $305,996 | 1,895 | $161 | |||||||||
| 2018 | Q3 | Airport | Premium | $487,711 | 2,945 | $166 | |||||||||
| 2018 | Q4 | Airport | Premium | $640,671 | 3,816 | $168 | |||||||||
| 2019 | Q1 | Airport | Premium | $571,105 | 3,351 | $170 | |||||||||
| 2019 | Q2 | Airport | Premium | $605,136 | 3,486 | $174 | |||||||||
| 2019 | Q3 | Airport | Premium | $664,353 | 3,807 | $175 | |||||||||
| 2019 | Q4 | Airport | Premium | $545,319 | 3,022 | $180 | |||||||||
| 2018 | Q1 | Airport | SUV | $363,309 | 2,439 | $149 | |||||||||
| 2018 | Q2 | Airport | SUV | $305,953 | 1,987 | $154 | |||||||||
| 2018 | Q3 | Airport | SUV | $487,214 | 3,138 | $155 | |||||||||
| 2018 | Q4 | Airport | SUV | $623,463 | 4,034 | $155 | |||||||||
| 2019 | Q1 | Airport | SUV | $570,887 | 3,552 | $161 | |||||||||
| 2019 | Q2 | Airport | SUV | $604,825 | 3,709 | $163 | |||||||||
| 2019 | Q3 | Airport | SUV | $664,219 | 4,017 | $165 | |||||||||
| 2019 | Q4 | Airport | SUV | $545,509 | 3,168 | $172 | |||||||||
| Question 1: Yes, a trend of increasing average revenue of Hybrid Cars with increase in years is observed. | |||||||||||||||
| As the revenue of hybirds are which leads to become very popular making it a trend. | |||||||||||||||
| Question 2: In that scenario I would recommend Stacked Chart because this type of chart is used to compare parts of a whole. | |||||||||||||||
| Which is why I chose this chart as a representation. | |||||||||||||||
Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 363062 306364 488077 640254 570859 604445 664684 546026 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 2354 1943 3029 3898 3446 3578 3850 3054 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 154.23194562446898 157.67575913535771 161.13469792010565 164.25192406362237 165.65844457341845 168.93376187814422 172.64519480519482 178.79043876882776
Premium Premium Premium Premium Airport Airport Airport Airport Q1 Q2 Q3 Q4 2019 2019 2019 2019 571105 605136 664353 545319 Premium Premium Premium Premium Airport Airport Airport Airport Q1 Q2 Q3 Q4 2019 2019 2019 2019 3351 3486 3807 3022 Premium Premium Premium Premium Airport Airport Airport Airport Q1 Q2 Q3 Q4 2019 2019 2019 2019 170.42823037899134 173.59036144578315 174.50827423167848 180.44970218398413
