michaelt747
New member
- Joined
- Jul 23, 2012
- Messages
- 1
I am working on a report involving airline delays during a specific period of time at an airport and trying to figure out the weighted average of the flight delays per airline given their total number of operations from an airport.
Airline A accounts for 52% of the total operations, their delays account for 59% of the total delays at the airport.
Airline B accounts for 40.5% of the total operations, their delays account for 31.4% of the total delays at the airport.
Airline C accounts for 2.4% of the total operations, their delays account for 2.98% of the total delays
Airline D accounts for 2.5% of the total operations, their delays account for 3.3% of the total delays
Airline E accounts for 2.01% of the total operations, their delays account for 2.2% of the total delays
Airline F accounts for .17% of the total operations, their delays account for .25% of the total delays
Airline G accounts for .20% of the total operations, their delays account for .38% of the total delays
Airline H accounts for .49% of the total operations, their delays account for .42% of the total delays
I feel like I'm making this way more complicated than it has to be. Essentially, I'm trying to show the percentage of delays airline A has given the fact that they have the majority of the flights/operations. Airline F, for example, has the least amount of delays, but that's because they have the fewest number of flights/operations.
Any help would be awesome, thanks in advance!
Airline A accounts for 52% of the total operations, their delays account for 59% of the total delays at the airport.
Airline B accounts for 40.5% of the total operations, their delays account for 31.4% of the total delays at the airport.
Airline C accounts for 2.4% of the total operations, their delays account for 2.98% of the total delays
Airline D accounts for 2.5% of the total operations, their delays account for 3.3% of the total delays
Airline E accounts for 2.01% of the total operations, their delays account for 2.2% of the total delays
Airline F accounts for .17% of the total operations, their delays account for .25% of the total delays
Airline G accounts for .20% of the total operations, their delays account for .38% of the total delays
Airline H accounts for .49% of the total operations, their delays account for .42% of the total delays
I feel like I'm making this way more complicated than it has to be. Essentially, I'm trying to show the percentage of delays airline A has given the fact that they have the majority of the flights/operations. Airline F, for example, has the least amount of delays, but that's because they have the fewest number of flights/operations.
Any help would be awesome, thanks in advance!
Last edited: