Business, 14.05.2021 04:00 jghdvine

In the Filter Analysis worksheet: a. Select Economy ONLY and Quarter 1 ONLY in their respective columns.
b. In row 34, the next blank row after the data, in the revenue and number of cars columns, calculate the sum of that column by adding the contents of the addresses of the cells resulting from the filter action (should be two values for Revenue and two values for NumCars).
c. Format the two values to match the data above in the particular respective column.
Year Quarter Location CarClass Revenue NumCars
2019 Q2 Airport Economy $368,286 2153
2019 Q4 Downtown Premium $431,761 2562
2019 Q4 Downtown Hybrid $431,140 2620
2019 Q1 Downtown Premium $424,833 2661
2019 Q4 Downtown SUV $431,029 2708
2019 Q1 Downtown Hybrid $425,127 2729
2019 Q1 Downtown SUV $424,718 2799
2019 Q3 Downtown Premium $494,587 3006
2019 Q3 Downtown Hybrid $494,669 3065
2019 Q4 Airport Premium $540,411 3082
2019 Q2 Downtown Premium $500,347 3101
2019 Q4 Airport Hybrid $541,112 3115
2019 Q2 Downtown Hybrid $500,601 3172
2019 Q3 Downtown SUV $495,372 3197
2019 Q4 Airport SUV $540,599 3231
2019 Q2 Downtown SUV $500,494 3251
2019 Q1 Airport Economy $499,117 3296
2019 Q1 Airport Premium $565,965 3418
2019 Q1 Airport Hybrid $565,721 3515
2019 Q3 Airport Economy $593,981 3555
2019 Q2 Airport Premium $599,690 3556
2019 Q1 Airport SUV $565,749 3623
2019 Q2 Airport Hybrid $599,005 3650
2019 Q2 Airport SUV $599,382 3783
2019 Q3 Airport Premium $658,374 3883
2019 Q3 Airport Hybrid $658,702 3927
2019 Q3 Airport SUV $658,241 4097
2019 Q2 Downtown Economy $641,168 4302
2019 Q3 Downtown Economy $681,155 4540
2019 Q4 Downtown Economy $704,556 4620
2019 Q1 Downtown Economy $718,651 4898
2019 Q4 Airport Economy $918,045 5224

Answers: 2

Show answers

Another question on Business

Business, 21.06.2019 16:10

Acustomer has come to your department with an urgent question. you promised her that you would collect information about her question and answer it by noon. it will take you at least 20 minutes to gather the information needed to provide an answer. it is now 11: 50 a.m. your supervisor just scheduled a 30-minute meeting to start at noon. this meeting is for all employees in your department. you decide to:

Answers: 2

Answer

Business, 22.06.2019 09:40

The wall street journal reported that walmart stores inc. is planning to lay off 2,300 employees at its sam's club warehouse unit. approximately half of the layoffs will be hourly employees (the wall street journal, january 25-26, 2014). suppose the following data represent the percentage of hourly employees laid off for 15 sam's club stores. 55 56 44 43 44 56 60 62 57 45 36 38 50 69 65 (a) compute the mean and median percentage of hourly employees being laid off at these stores. (b) compute the first and third quartiles. (c) compute the range and interquartile range. (d) compute the variance and standard deviation. (e) do the data contain any outliers? (f) based on the sample data, does it appear that walmart is meeting its goal for reducing the number of hourly employees?

Answers: 1

Answer

Business, 22.06.2019 10:30

Marketing1. suppose the average price for a new disposable cell phone is $20, and the total market potential for that product is $4 million. topco, inc. has a planned market share of 10 percent. how many phones does topco have the potential to sell in this market? 20,0002. use the data from question 3 to calculate topco, inc.'s planned market share in dollars. $400,0003. atlantic car rental charges $29.95 per day to rent a mid-size automobile. pacific car rental, atlantic's main competitor, just reduced prices on all its car rentals. in response, atlantic reduced its prices by 5 percent. now how much does it cost to rent a mid-size automobile from atlantic? $28.45

Answers: 1

Answer

Business, 22.06.2019 17:40

Adamson company manufactures four lines of garden tools. as a result of an activity analysis, the accounting department has identified eight activity cost pools. each of the product lines is produced in large batches, with the whole plant devoted to one product at a time. classify each of the following activities or costs as either unit-level, batch-level, product-level, or facility-level. activities (a) machining parts. (b) product design. (c) plant maintenance. (d) machine setup. (e) assembling parts. (f) purchasing raw materials. (g) property taxes. (h) painting.

Answers: 2

Answer

You know the right answer?

In the Filter Analysis worksheet: a. Select Economy ONLY and Quarter 1 ONLY in their respective col...

Questions