General aggregate statistics: total number of tickets sold

Assignment Help Basic Computer Science

Reference no: EM13731729

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.

Reference no: EM13731729

Questions Cloud

How much each country consume each good : Think of a 2 country world, say the US and the UK. Each country produces two goods, say food and cloth. Suppose 7 hours of labour are required to produce one unit of either good in the UK, whereas in the US it takes 2 hours to produce one unit food a..

Explain what are the critical path activities : What are the critical path activities. What is the project's scheduled completion time. What is the slack or float for Activity C

About database design and methodology : We learned about database design and methodology. You are the database administrator for your company, which has just acquired a company called SNHU Appliances. You are deciding what the best approach is. Should you merge your database with the new c..

Specify the most significant advantages and disadvantages : Specify the most significant advantages and disadvantages that could be realized by the organization in adopting a server virtualization infrastructure. Prepare a plan for implementing Hyper-V (or an alternate solution, such as VMware) as a solution ..

General aggregate statistics: total number of tickets sold : 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 c..

What strategies could you and new soft drink company use : According to Porter's discussion of industry analysis, is Pepsi Cola a substitute for Coca Cola? what strategies could you and your new soft drink company use to impact the dominance of Pepsi and Coke in the global marketplace? Why

Nonresetting finite state machine : Design a Mealy, nonresetting finite state machine that has one binary input X and one binary output Z. The output Z = 1 occurs whenever the last five bits on input X have been 11101; otherwise, the output Z = 0. This machine recognizes overlapping s..

Completion of the feasibility analysis : Tasks that will need to be accomplished from the completion of the feasibility analysis up to the date of launch in the order of their completion and with actual time frames included of how long each will take

Describe the advantages of a total rewards approach : This research-based assignment focuses on the latest available information about creating, organizing, and managing a total rewards program. Envision a service-based (insurance, telemarketing, or other) profit organization that employs 20,000 empl..

User Account

All Pages