creating tables in Microsoft excel sheet

Use the Module 1 Assignment Excel file, available from Moodle, to complete the following steps:

1) Use the Flight Data tab to create a Pivot Table that will allow you to answer the following questions:

a. Which city of Origin has the highest average First Class ticket prices, and how much is that average?

b. Which destination city receives more flights by United Airlines than any other city, and how many does it receive?

c. Which month has the most flights?

d. Which combination of city and airline has the most on time departures?

2) Use the OnlineArticles tab to complete the following:

a. Create descriptive statistics for all variables except Person ID.

b. Create a correlation matrix. Which variables seem to have the biggest influence on one another? Which don’t seem to have much influence on one another at all?

3) Use the CallCenter tabl to complete the following:

a. Use the Scenario Manager to create all three of the scenarios given in cells B16 to E20. List the Total Expenses the call center will incur based on each scenario.

b. Use the Goal Seek Function to determine how many staff you will schedule in order to maintain total expenses of $50,000,000. Assume Salary Costs of $10,000,000 and Operational Costs of $12,500,000.

c. Set your number of staff to 180, your Salary Costs to $7,500,000 and your Operational Costs to $12,500,000. Use the Data Table feature to determine your Total Expenses at each Salary Expense level listed in cells B25 to B37. Make a line graph of the results.

Once you’ve completed the exercises, create a ZIP file containing your spreadsheet (save your changes) and a Word Document with your answers to the questions above. Submit your ZIP file to Moodle by the end of Module 1.