JMP002: Baggage Complaints

发布时间 2023-04-13 17:28:28作者: erik_r

JMP002: Baggage Complaints

 

这是一个关于航空公司行李投诉的数据分析报告。报告中提到了三家航空公司:American Eagle,Hawaiian和United。报告分析了这三家航空公司的行李投诉率,以及它们的航班数量和乘客数量。报告还分析了行李投诉率随时间的变化,以及它们是否有季节性变化。报告中提供了数据集和图表,以便更好地理解分析结果。

 

Data:

Baggage The total number of passenger complaints for theft of baggage contents, or for lost, damaged, or misrouted luggage for the airline that month

Scheduled The total number of flights scheduled by that airline that month

Cancelled The total number of flights cancelled by that airline that month

Enplaned The total number of passengers who boarded a plane with the airline that month

 

分析:

1.行李投诉数目随时间的趋势,用Graph Builder,

(Graph > Graph Builder; drag and drop Baggage in Y, Date in X and Airline in Overlay. Click on the smoother icon at the top to remove the smoother, and click on the line icon. Or, right-click in the graph, and select Smoother > Remove, and Points > Change to > Line. Then, click Done.)

 

2.表格化分析

(Analyze > Tabulate; drag Airline in drop zone for rows, and Scheduled and Enplaned in the drop zone for column as analysis columns. Then, drag Mean from the middle panel to the middle of the table. JMP versions 10 and earlier Tabulate is under the Tables menu.)

 

 

 

2.1 使用table下的summary来汇总统计信息:

Table ->summary, put airline to group, select baggage% statistics choose mean std. 

 

 

 

3.新增数据列表示行李投诉率百分比,

(Create a new column in the data table, and rename it Baggage %. Right click on the column header, and select Formula to open the Formula Editor. To create the formula: 1. Type 100 2. Select multiply on the keypad 3. Select Baggage from the columns list 4. Select divide by on the keypad 5. Select Enplaned from the columns list 6. Click OK.)

 

 

 

 

4.列出各公司行李投诉率时间趋势图