Create a pivotchart from the original dataset

Assignment Help Operation Management
Reference no: EM131732066

You want to research morning flight departures from Tulsa International Airport (TUL) using data obtained from flightstats.com website. Find the airport’s departing flight schedule for yesterday morning and copy the flight information of a worksheet in a new workbook. Name the workbook e05b1Tulsa_LastFirst. Clean up the data after copying it. Name the worksheet Departures. Copy the worksheet and name the duplicate sheet Morning Departures. Sort the data on the Departures sheet by destination and then by airline. Insert subtotals at a change in destination, counting the number of flights. Collapse the subtotals to display the subtotals and grand totals.

Create a blank PivotTable from the Morning Departures sheet. Display the Destination and Airline fields in rows. Display the Status field in columns to display canceled, on-time, and delayed flights. Display the Flight field in the values area and change the field settings to the Count function. Display the Departure Time as a filter and set a filter to include only departure times from 6 to 9 a.m. Name the PivotTable Morning Departure Status. Apply PivotStyle Medium 1 3 style. Adjust column widths as needed. Name the worksheet PivotTable.

Create a PivotChart from the original dataset. Name the sheet PivotChart. Use the Destination field as the axis and the Flight # as the value. Change the value to the count function. Change the chart type to a bar chart. Set 3.75” chart height and 5.75” chart width. Insert a slicer for the Status field and click the slicer button only on-time departures. Add a chart title On-Time Departures. Create a footer with your name, the sheet name code, and the file code on each worksheet.

Reference no: EM131732066

Questions Cloud

Representation from a variety of different cultures : How do you prepare for an event you are hosting where there will be representation from a variety of different cultures?
Enforceable according to the bargaining theory of contracts : According to the story, who is the promisor and promisee? Is the contract enforceable according to the bargaining theory of contracts?
How would you classify the products that CHOBANI sells : Select one of the products marketed by CHOBANI – what functions does the package perform? How would you classify the products that CHOBANI sells?
Assessment of the organization resources : Identify the most important strengths and weaknesses of your organization including an assessment of the organization's resources.
Create a pivotchart from the original dataset : Create a PivotChart from the original dataset. Name the sheet PivotChart.
How is scheduling important in your organization : How is scheduling important in your organization.
The response and the other variables as predictors : Using the happy dataset in library (faraway) in R, fit a model with happy as the response and the other variables as predictors.
Violating confidentiality agreements : What are some federal/state laws that are for violating confidentiality agreements?
Investigate some design-for-environment practices : Investigate some design-for-environment practices in some of your local industries.

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd