Airline Price Elasticity Modeling

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Flight_ID	Route	Date	Days_to_Departure	Fare_Class	Ticket_Price	Competitor_Price	Seats_Sold	Total_Seats	Season	Segment_Key	Avg_Ticket_Price	Avg_Seats_Sold	%_Change_Price	%_Change_Qty	Elasticity	Revenue	Price_A	Price_B	Qty_A	Qty_B	Revenue_A	Revenue_B
2	F1000	SEA-DEN	02/06/25	42	Premium	150	132.51	49	180	Peak
3	F1001	ATL-BOS	22/05/25	31	Business	150	155.35	163	200	Off-Peak
4	F1002	JFK-LAX	04/04/25	54	Economy	150	147.19	38	200	Holiday
5	F1003	SEA-DEN	23/04/25	58	Economy	350	344.48	37	220	Peak
6	F1004	SEA-DEN	15/04/25	3	Business	300	315.35	20	200	Holiday
7	F1005	ATL-BOS	13/05/25	40	Premium	350	368.94	97	220	Holiday
8	F1006	JFK-LAX	29/04/25	46	Premium	300	286.74	134	180	Peak
9	F1007	JFK-LAX	06/05/25	24	Economy	350	335.6	132	220	Peak
10	F1008	SEA-DEN	13/04/25	50	Business	350	343.12	133	180	Holiday
11	F1009	ORD-MIA	02/05/25	32	Premium	400	342.45	82	220	Peak
12	F1010	SEA-DEN	10/06/25	47	Business	250	212.12	151	200	Peak
13	F1011	SEA-DEN	29/05/25	22	Business	350	384.17	148	220	Peak
14	F1012	SEA-DEN	25/06/25	23	Economy	400	441.12	27	220	Off-Peak
15	F1013	SEA-DEN	28/04/25	2	Premium	200	193.77	176	180	Holiday
16	F1014	ATL-BOS	05/06/25	27	Economy	250	264.41	74	200	Holiday
17	F1015	JFK-LAX	12/05/25	42	Premium	350	357.78	122	220	Off-Peak
18	F1016	ATL-BOS	15/05/25	2	Premium	450	526.97	150	200	Holiday
19	F1017	ATL-BOS	01/06/25	26	Premium	150	177.99	51	220	Peak
20	F1018	ATL-BOS	27/05/25	17	Premium	200	196.8	29	220	Holiday
21	F1019	SEA-DEN	06/04/25	40	Premium	200	176.11	129	200	Peak
22	F1020	ORD-MIA	28/04/25	33	Business	400	359.84	143	220	Off-Peak
23	F1021	JFK-LAX	28/04/25	9	Economy	200	205.09	106	200	Peak
24	F1022	ORD-MIA	14/05/25	43	Business	250	231.09	74	220	Holiday
25	F1023	ATL-BOS	23/06/25	54	Premium	350	314.44	51	180	Holiday
26	F1024	ATL-BOS	30/04/25	48	Economy	350	333.84	154	200	Holiday
27	F1025	ORD-MIA	01/06/25	39	Premium	450	422.96	112	220	Off-Peak
28	F1026	ORD-MIA	14/06/25	29	Economy	150	192.18	27	220	Off-Peak
29	F1027	ORD-MIA	28/06/25	42	Business	400	422.04	84	180	Holiday
30	F1028	ATL-BOS	01/06/25	55	Economy	150	149.8	76	200	Peak
31	F1029	ATL-BOS	01/04/25	26	Economy	200	237	86	220	Off-Peak
32	F1030	JFK-LAX	27/04/25	35	Economy	450	451.93	91	180	Holiday
33	F1031	JFK-LAX	01/06/25	50	Economy	150	128.47	73	220	Holiday
34	F1032	ATL-BOS	16/06/25	25	Economy	250	288.08	86	200	Off-Peak
35	F1033	ORD-MIA	03/04/25	24	Premium	350	363.47	70	220	Off-Peak
36	F1034	ORD-MIA	09/06/25	13	Economy	200	174.07	116	220	Off-Peak
37	F1035	JFK-LAX	11/06/25	58	Economy	450	445.24	111	220	Peak
38	F1036	ATL-BOS	27/04/25	7	Business	150	128.11	27	220	Peak
39	F1037	JFK-LAX	09/04/25	57	Economy	400	365.43	54	180	Holiday
40	F1038	JFK-LAX	01/06/25	36	Business	250	273.15	115	180	Off-Peak
41	F1039	SEA-DEN	07/05/25	45	Premium	250	297.74	107	200	Peak
42	F1040	SEA-DEN	21/05/25	20	Economy	150	115.04	97	180	Off-Peak
43	F1041	SEA-DEN	14/05/25	1	Business	350	364.07	51	180	Holiday
44	F1042	ORD-MIA	24/04/25	8	Business	150	133.73	139	200	Peak
45	F1043	ATL-BOS	18/06/25	46	Premium	200	187.82	65	180	Peak
46	F1044	ATL-BOS	29/05/25	16	Economy	150	135.19	163	180	Peak
47	F1045	ATL-BOS	02/05/25	14	Economy	250	228.4	161	200	Holiday
48	F1046	ATL-BOS	27/06/25	12	Business	450	451.21	74	200	Off-Peak
49	F1047	SEA-DEN	22/05/25	51	Economy	150	129.23	26	200	Peak
50	F1048	ORD-MIA	01/06/25	23	Business	350	356.76	93	220	Holiday
51	F1049	ORD-MIA	28/05/25	15	Economy	450	448.74	26	220	Off-Peak
52	F1050	SEA-DEN	22/05/25	28	Business	400	394.03	170	200	Holiday
53	F1051	ORD-MIA	12/04/25	34	Economy	300	277.31	104	200	Off-Peak
54	F1052	SEA-DEN	09/05/25	2	Premium	150	135.58	166	200	Holiday
55	F1053	ATL-BOS	02/04/25	32	Economy	350	368.88	131	220	Off-Peak
56	F1054	SEA-DEN	03/04/25	23	Economy	450	462.52	144	220	Peak
57	F1055	ATL-BOS	26/05/25	22	Premium	350	325.56	166	180	Off-Peak
58	F1056	ATL-BOS	20/06/25	51	Economy	400	402.48	55	180	Holiday
59	F1057	JFK-LAX	29/05/25	25	Premium	250	268.78	48	200	Holiday
60	F1058	SEA-DEN	02/04/25	58	Economy	350	308.26	101	220	Off-Peak
61	F1059	JFK-LAX	02/04/25	22	Business	450	463.58	21	220	Peak
62	F1060	SEA-DEN	24/05/25	58	Business	350	333.43	148	220	Peak
63	F1061	SEA-DEN	26/06/25	58	Economy	350	364.26	66	200	Off-Peak
64	F1062	JFK-LAX	01/04/25	22	Economy	350	330.92	167	180	Off-Peak
65	F1063	JFK-LAX	19/04/25	49	Economy	200	154.88	30	200	Holiday
66	F1064	SEA-DEN	02/04/25	52	Business	200	159.31	149	180	Peak
67	F1065	ORD-MIA	23/05/25	42	Economy	250	251.2	138	180	Off-Peak
68	F1066	ATL-BOS	14/05/25	6	Business	150	156.49	159	200	Peak
69	F1067	JFK-LAX	29/06/25	15	Premium	350	327.39	39	180	Off-Peak
70	F1068	ATL-BOS	02/05/25	54	Business	400	415.96	24	180	Off-Peak
71	F1069	ORD-MIA	09/06/25	43	Business	150	108.46	56	220	Peak
72	F1070	ORD-MIA	02/05/25	37	Premium	400	398.35	156	180	Off-Peak
73	F1071	ORD-MIA	07/06/25	33	Business	150	119.72	72	200	Off-Peak
74	F1072	JFK-LAX	25/05/25	8	Economy	250	233.7	118	200	Holiday
75	F1073	ORD-MIA	14/06/25	53	Economy	350	351.18	105	180	Off-Peak
76	F1074	JFK-LAX	26/05/25	44	Business	350	328.49	127	220	Off-Peak
77	F1075	ORD-MIA	17/04/25	44	Economy	300	290.39	43	220	Off-Peak
78	F1076	ATL-BOS	08/05/25	5	Business	400	425.16	100	180	Holiday
79	F1077	ATL-BOS	24/04/25	39	Economy	150	135.58	177	180	Peak
80	F1078	SEA-DEN	08/06/25	4	Economy	150	170.89	139	200	Holiday
81	F1079	ATL-BOS	09/06/25	6	Business	200	171.76	78	180	Holiday
82	F1080	SEA-DEN	25/06/25	45	Economy	300	313.25	147	220	Peak
83	F1081	ATL-BOS	11/04/25	32	Business	450	486.04	133	180	Holiday
84	F1082	JFK-LAX	16/04/25	52	Economy	450	388.21	134	200	Peak
85	F1083	ATL-BOS	12/06/25	30	Economy	200	180.08	33	200	Holiday
86	F1084	SEA-DEN	29/05/25	47	Premium	200	214.43	28	200	Peak
87	F1085	SEA-DEN	09/06/25	35	Premium	200	194.92	59	200	Off-Peak
88	F1086	ORD-MIA	19/06/25	55	Business	400	409.28	44	200	Holiday
89	F1087	JFK-LAX	03/04/25	40	Premium	400	384.9	122	180	Holiday
90	F1088	ATL-BOS	20/04/25	52	Business	250	252.16	41	180	Holiday
91	F1089	ORD-MIA	29/05/25	16	Premium	250	246.11	23	180	Holiday
92	F1090	ATL-BOS	06/05/25	13	Economy	200	229.19	173	180	Off-Peak
93	F1091	ATL-BOS	19/04/25	50	Business	300	306.36	48	200	Holiday
94	F1092	ORD-MIA	29/06/25	42	Business	150	158.44	128	220	Off-Peak
95	F1093	ORD-MIA	06/06/25	30	Economy	400	389.7	117	180	Off-Peak
96	F1094	ORD-MIA	19/04/25	19	Business	300	287.81	56	220	Off-Peak
97	F1095	ORD-MIA	20/04/25	17	Business	350	339.19	94	180	Off-Peak
98	F1096	ORD-MIA	10/06/25	56	Premium	400	409.86	89	180	Peak
99	F1097	ATL-BOS	22/05/25	19	Business	400	389.48	165	220	Peak
100	F1098	ORD-MIA	03/05/25	28	Economy	250	257.24	147	200	Holiday