1.The local travel center, Campus Travel, has been losing sales. The presence of online ticketing websites, 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 the data are not summarized or organized in a useful way to inform business decision making. The spreadsheet TicketSales.csv contains the ticket sales data for a 3-month period. Your director has asked you for the following information regarding ticket sales. Modify the TicketSales.csv spreadsheet to provide the following information for your director:

a.The total number of tickets sold.

b.The largest amount of tickets sold by a certain salesperson to any one location.

c.The least amount of tickets sold by a certain salesperson to any one location.

d.The average number of tickets sold.

1.The local travel center, Campus Travel, has been losing sales. The presence of online ticketing websites, 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 the data are not summarized or organized in a useful way to inform business decision making. The spreadsheet TicketSales.csv contains the ticket sales data for a 3-month period. Your director has asked you for the following information regarding ticket sales. Modify the TicketSales.csv spreadsheet to provide the following information for your director:

a.The total number of tickets sold.

b.The largest amount of tickets sold by a certain salesperson to any one location.

c.The least amount of tickets sold by a certain salesperson to any one location.

d.The average number of tickets sold.