The local travel center, Campus Travel, has been losing sales. The presence of online ticketing Web sites, such as Travelocity.com and Expedia.com, has lured many students away. However, given the complexity of making international travel arrangements, Campus Travel could have a thriving and profitable business if it concentrated its efforts in this area. You have been asked by the director of sales and marketing to help with analyzing prior sales data in order to design better marketing strategies. Looking at these data, you realize that it is nearly impossible to perform a detailed analysis of ticket sales given that it is not summarized or organizaed in a useful way to inform business decision making.
The worksheet, TicketSales (a sheet in this workbook), contains the ticket sales data for fall 2014. Your director has asked you for the following information regarding ticket sales:
1. General aggregate statistics: total number of tickets sold; largest amount of tickets sold together; least amount of tickets sold together (undoubtedly 1, but use a function!); average number of tickets sold.
2. Sales by destination.
3. Sales by salesperson.
4. Sales by month.
Present the data in a professionally formatted worksheet such that it is easily viewed/understood. Since visualization aids in understanding data, include an appropriate chart to illustrate each set of data. Lastly, analyze the data and provide any conclusions you draw. (Analysis may be placed in an area below the data; it does not need to be a separate document.)
HINT FOR CLASSROOM PURPOSES: In addition to traditional functions like SUM, AVERAGE, ROUND, etc., you may find conditional IF functions to be useful problem-solving tools.