Create a range named AE that includes every AvgRev value for Economy cars, and Create a range
Fantastic news! We've Found the answer you've been seeking!
Question:
Create a range named AE that includes every AvgRev value for Economy cars, and Create a range named AP that includes every AvgRev value for Premium cars.
On the third row, below the final row of the data, create a label called Average Quarterly Revenue per Economy Car (Airport).
In the first fully visible cell to the right of the label, calculate the Average Quarterly Revenue per Economy Car (Airport) using the average function and the named range AE
In the next line create a label called Average Quarterly Revenue per Premium
| Year | Quarter | Location | CarClass | Revenue | NumCars | "AvgRev " | |
| 2017 | Q1 | Airport | Premium | $349,852 | 3,205 | $3,205.00 | |
| 2017 | Q2 | Airport | Premium | $370,128 | 3,487 | $186,807.50 | |
| 2017 | Q3 | Airport | Premium | $752,272 | 3,581 | $377,926.50 | |
| 2017 | Q4 | Airport | Premium | $496,840 | 3,192 | $250,016.00 | |
| 2018 | Q1 | Airport | Premium | $701,460 | 3,787 | $352,623.50 | |
| 2018 | Q2 | Airport | Premium | $626,232 | 3,392 | $314,812.00 | |
| 2018 | Q3 | Airport | Premium | $665,548 | 3,474 | $3,474.00 | |
| 2018 | Q4 | Airport | Premium | $687,844 | 3,327 | $345,585.50 | |
| 2019 | Q1 | Airport | Premium | $912,900 | 3,602 | $458,251.00 | |
| 2019 | Q2 | Airport | Premium | $561,124 | 3,371 | $282,247.50 | |
| 2019 | Q3 | Airport | Premium | $752,720 | 3,581 | $378,150.50 | |
| 2019 | Q4 | Airport | Premium | $521,234 | 3,345 | $262,289.50 | |
| 2017 | Q1 | Airport | Economy | $342,140 | 3,267 | $172,703.50 | |
| 2017 | Q2 | Airport | Economy | $422,192 | 4,068 | $213,130.00 | |
| 2017 | Q3 | Airport | Economy | $580,576 | 3,214 | $291,895.00 | |
| 2017 | Q4 | Airport | Economy | $533,744 | 3,576 | $268,660.00 | |
| 2018 | Q1 | Airport | Economy | $486,252 | 3,440 | $244,846.00 | |
| 2018 | Q2 | Airport | Economy | $486,056 | 3,424 | $3,424.00 | |
| 2018 | Q3 | Airport | Economy | $503,212 | 3,287 | $253,249.50 | |
| 2018 | Q4 | Airport | Economy | $555,768 | 3,848 | $279,808.00 | |
| 2019 | Q1 | Airport | Economy | $589,668 | 3,524 | $3,524.00 | |
| 2019 | Q2 | Airport | Economy | $427,320 | 3,947 | $215,633.50 | |
| 2019 | Q3 | Airport | Economy | $650,765 | 3,909 | $327,337.00 | |
| 2019 | Q4 | Airport | Economy | $598,767 | 3,699 | $3,699.00 |
Expert Answer:
To create the named ranges and calculate the average quarterly revenue per car class you can follow ... View the full answer
Related Book For 
Posted Date:
