When weekly airfare summaries are enough: Sharp risk bounds and decision certificates from aggregated quotes

Abstract Weekly airfare feeds preserve price extrema, means and observation counts, but discard the underlying quote histories. This paper asks which historical risk comparisons remain defensible after that compression. We construct sharp bounds on empirical conditional value-at-risk by retaining both the finite quote count and the requirement that the reported extrema were observed. A majorization argument yields explicit extremal quote vectors; an integer formulation accommodates cent-denominated fares and rounded means. The bounds support itinerary-ranking certificates and exact minimax regret for selecting one alternative. Exhaustive enumeration and 1,400 independent linear-programming solves verify the implementation, followed by 6,000 synthetic aggregation experiments. A case study uses 2,000 Altus records collected over two weeks for Alaska Airlines itineraries departing San Francisco. At the upper-half tail criterion, average identification width falls from USD~14.88 under a support-and-mean relaxation to USD~4.17. Among 182 matched economy return-trip cells, 180 have a certified minimum, versus 174 under the relaxation; three selections differ from the mean-fare rule. The findings support selective investigation of ambiguous comparisons, while establishing no forecast accuracy, realised procurement saving or industry-wide effect.

Authors

Institutions

Publication Details

Journal
Research Square
Published
2026-11-11
DOI
https://doi.org/10.21203/rs.3.rs-11529453/v1
Primary Topic
Risk and Portfolio Optimization
Type
preprint
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
preprint

When weekly airfare summaries are enough: Sharp risk bounds and decision certificates from aggregated quotes

Sajad Saraygord Afshari
Research Square
Risk and Portfolio Optimization
preprint

When weekly airfare summaries are enough: Sharp risk bounds and decision certificates from aggregated quotes

Sajad Saraygord Afshari
preprint en

Abstract

Abstract Weekly airfare feeds preserve price extrema, means and observation counts, but discard the underlying quote histories. This paper asks which historical risk comparisons remain defensible after that compression. We construct sharp bounds on empirical conditional value-at-risk by retaining both the finite quote count and the requirement that the reported extrema were observed. A majorization argument yields explicit extremal quote vectors; an integer formulation accommodates cent-denominated fares and rounded means. The bounds support itinerary-ranking certificates and exact minimax regret for selecting one alternative. Exhaustive enumeration and 1,400 independent linear-programming solves verify the implementation, followed by 6,000 synthetic aggregation experiments. A case study uses 2,000 Altus records collected over two weeks for Alaska Airlines itineraries departing San Francisco. At the upper-half tail criterion, average identification width falls from USD~14.88 under a support-and-mean relaxation to USD~4.17. Among 182 matched economy return-trip cells, 180 have a certified minimum, versus 174 under the relaxation; three selections differ from the mean-fare rule. The findings support selective investigation of ambiguous comparisons, while establishing no forecast accuracy, realised procurement saving or industry-wide effect.

Research Square
Mount Royal University (CA)
Risk and Portfolio Optimization
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon