Create a crosstab (text table) to summarize the following three volume-related statistics for each airline

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Data Description

In this assignment, we will analyze a relatively large-scale dataset, consisting of all domestic airline flights at the U.S. in a two month period including December 2010 and January 2011. The dataset has approximately 0.66 million records, so be patient if the file is slow to load for the first time use (once loaded, Tableau should be fairly fast).

Each row of the raw dataset represents a single, completed, domestic flight. The dataset captures the following information of each flight:

● The airline that operates this flight (there were 11 domestic airlines during that time period)

● The departure date of this flight

● The origin of this flight, including the origin city’s name, origin airport code, and origin state.

● The destination of this flight, including the destination city’s name, destination airport code, and destination state

● The airtime of this flight, measured in minutes

● The distance of this flight, measured in miles

● The departure delay of this flight, measured in minutes (0 if no delay, negative if the flight leaves before the scheduled time)

Assignment Instructions

● Download the starter file, “Assignment 2_starter.twbx”, from Blackboard (in the folder of Assignment #2), and complete the following steps on the starter file.

● [Task 1] Create a crosstab (text table) to summarize the following three volume-related statistics for each airline, including (1) the count of its flights; (2) the total of airtime of its flights; (3) the total distance covered by its flights; (4) the average departure delays of its flights. An exemplary outcome might be as follows (you do NOT need to exactly duplicate it):

● [Task 2] Create a pie chart to show the breakdown of the U.S. domestic flight market by different airlines, based on the counts of flights they operated. An exemplary outcome might be as follows:

● [Task 3] Create a line graph to visualize the daily flight volumes (the count of flights) of each airline. Add airline as a filter to show only American, Delta, JetBlue, and Southwest airlines. An exemplary outcome might be as follows:

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme