project

Bfh
data_dictionary.xlsx

Sheet 1

Table 1
Field Description
ID Unique passenger identifier
Gender Gender of the passenger (Female/Male)
Age Age of the passenger
Customer Type Type of airline customer (First-time/Returning)
Type of Travel Purpose of the flight (Business/Personal)
Class Travel class in the airplane for the passenger seat
Flight Distance Flight distance in miles
Departure Delay Flight departure delay in minutes
Arrival Delay Flight arrival delay in minutes
Departure and Arrival Time Convenience Satisfaction level with the convenience of the flight departure and arrival times from 1 (lowest) to 5 (highest) - 0 means "not applicable"
Ease of Online Booking Satisfaction level with the online booking experience from 1 (lowest) to 5 (highest) - 0 means "not applicable"
Check-in Service Satisfaction level with the check-in service from 1 (lowest) to 5 (highest) - 0 means "not applicable"
Online Boarding Satisfaction level with the online boarding experience from 1 (lowest) to 5 (highest) - 0 means "not applicable"
Gate Location Satisfaction level with the gate location in the airport from 1 (lowest) to 5 (highest) - 0 means "not applicable"
On-board Service Satisfaction level with the on-boarding service in the airport from 1 (lowest) to 5 (highest) - 0 means "not applicable"
Seat Comfort Satisfaction level with the comfort of the airplane seat from 1 (lowest) to 5 (highest) - 0 means "not applicable"
Leg Room Service Satisfaction level with the leg room of the airplane seat from 1 (lowest) to 5 (highest) - 0 means "not applicable"
Cleanliness Satisfaction level with the cleanliness of the airplane from 1 (lowest) to 5 (highest) - 0 means "not applicable"
Food and Drink Satisfaction level with the food and drinks on the airplane from 1 (lowest) to 5 (highest) - 0 means "not applicable"
In-flight Service Satisfaction level with the in-flight service from 1 (lowest) to 5 (highest) - 0 means "not applicable"
In-flight Wifi Service Satisfaction level with the in-flight Wifi service from 1 (lowest) to 5 (highest) - 0 means "not applicable"
In-flight Entertainment Satisfaction level with the in-flight entertainment from 1 (lowest) to 5 (highest) - 0 means "not applicable"
Baggage Handling Satisfaction level with the baggage handling from the airline from 1 (lowest) to 5 (highest) - 0 means "not applicable"
Satisfaction Overall satisfaction level with the airline (Satisfied/Neutral or unsatisfied)

&"Helvetica,Regular"&12&K000000&P