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 organized in a useful way to inform business decision making.

The worksheet, TicketSales (a sheet in the homework folder), contains the ticket sales data for a three month-period. 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.

   (Use Function!)

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).

following is the data

Date Sold,Salesperson,Destination,Tickets Sold 2/15/2012,Lisa,France (Paris and Nice),3 3/3/2012,Bob,Hungary and Poland,2 1/28/2012,Lisa,Thailand or Indonesia,4 1/15/2012,Bob,Japan,2 3/6/2012,Vivien,India,3 2/1/2012,John,"Middle East (UAE, Qatar and Oman)",1 3/5/2012,Andrew,Egypt and South Africa,1 2/11/2012,Bob,India,2 2/9/2012,John,Egypt and South Africa,2 1/19/2012,John,Thailand or Indonesia,3 1/30/2012,Heather,Hungary and Poland,3 2/27/2012,Vivien,"Middle East (UAE, Qatar and Oman)",4 3/13/2012,John,Japan,3 2/13/2012,Lisa,Japan,2 3/1/2012,John,France (Paris and Nice),1 3/28/2012,Lisa,Egypt and South Africa,2 3/16/2012,John,India,4 1/22/2012,Vivien,Thailand or Indonesia,6 2/5/2012,John,Hungary and Poland,2 3/9/2012,Vivien,France (Paris and Nice),1 3/6/2012,Vivien,Egypt and South Africa,2 2/2/2012,Lisa,India,3 1/23/2012,Vivien,Hungary and Poland,1 3/3/2012,Andrew,"Middle East (UAE, Qatar and Oman)",3 1/2/2012,Andrew,Japan,2 1/19/2012,Andrew,France (Paris and Nice),2 1/2/2012,Bob,France (Paris and Nice),1 3/12/2012,Lisa,Hungary and Poland,3 2/1/2012,Lisa,"Middle East (UAE, Qatar and Oman)",3 3/16/2012,Vivien,Japan,3 3/11/2012,Bob,Egypt and South Africa,2 2/11/2012,Andrew,India,1 2/19/2012,Bob,"Middle East (UAE, Qatar and Oman)",2 2/19/2012,Heather,Egypt and South Africa,1 3/15/2012,Heather,Thailand or Indonesia,1