Module 1_Ticket Sales

.xlsx

School

University of Alabama *

*We aren’t endorsed by this school

Course

200

Subject

Marketing

Date

Apr 3, 2024

Type

xlsx

Pages

6

Uploaded by DoctorInternet13806

Report
Date Sold Salesperson Destination Tickets Sold 2/15/2022 Lisa France (Paris and Nice) 3 3/4/2022 Bob Hungary and Poland 2 1/28/2022 Lisa Thailand or Indonesia 4 1/15/2022 Bob Japan 2 3/7/2022 Vivien India 3 2/1/2022 John Middle East (UAE, Qatar and Oman) 1 3/6/2022 Andrew Egypt and South Africa 1 2/11/2022 Bob India 2 2/9/2022 John Egypt and South Africa 2 1/19/2022 John Thailand or Indonesia 3 1/30/2022 Heather Hungary and Poland 3 2/27/2022 Vivien Middle East (UAE, Qatar and Oman) 4 3/14/2022 John Japan 3 2/13/2022 Lisa Japan 2 3/2/2022 John France (Paris and Nice) 1 3/29/2022 Lisa Egypt and South Africa 2 3/17/2022 John India 4 1/22/2022 Vivien Thailand or Indonesia 6 2/5/2022 John Hungary and Poland 2 3/10/2022 Vivien France (Paris and Nice) 1 3/7/2022 Vivien Egypt and South Africa 2 2/2/2022 Lisa India 3 1/23/2022 Vivien Hungary and Poland 1 3/4/2022 Andrew Middle East (UAE, Qatar and Oman) 3 1/2/2022 Andrew Japan 2 1/19/2022 Andrew France (Paris and Nice) 2 1/2/2022 Bob France (Paris and Nice) 1 3/13/2022 Lisa Hungary and Poland 3 2/1/2022 Lisa Middle East (UAE, Qatar and Oman) 3 3/17/2022 Vivien Japan 3 3/12/2022 Bob Egypt and South Africa 2 2/11/2022 Andrew India 1 2/19/2022 Bob Middle East (UAE, Qatar and Oman) 2 2/19/2022 Heather Egypt and South Africa 1 3/16/2022 Heather Thailand or Indonesia 1
Total Tickets Sold 81 Most Tickets Sold 6 Least Tickets Sold 1 Average Number of Tickets Sold 2.31 Module 1: Spreadsheet Application: Ticket Sales at Campus Travel The local travel center, Campus Travel, has been losing sales. The presence of online ticketing websites Travelocity.com and Expedia.com, has lured many students away. However, given the complexity of ma international travel arrangements, Campus Travel could have a thriving and profitable business if it conc its efforts in this area. You have been asked by the director of sales and marketing to help with analyzing sales data to design better marketing strategies. Looking at these data, you realize that it is nearly impos perform a detailed analysis of ticket sales given that the data are not summarized or organized in a usefu inform decision making. This spreadsheet contains the ticket sales data for a 3-month period. Your director has asked you for the information regarding ticket sales. Modify the TicketSales.csv spreadsheet to provide the following information: 1) In cell H2, calculate the total number of ticket sales sold i. Use the “SUM” function to calculate the total number of tickets sold 2) In cell H3, calculate the largest amount of tickets sold by a certain salesperson to any one location i. Use the “MAX” function to calculate each salesperson’s highest ticket total in one transaction 3) In cell H4, calculate the least amount of tickets old by a certain salesperson to any one location i. Use the “MIN” function to calculate each salesperson’s least tickets sold 4) In cell H5, calculate the average number of tickets sold i. Use the “AVERAGE” function to calculate the average number of all of the tickets sold
s, such as aking centrated g prior ssible to ul way to e following n
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help