From past experience, an airline has found the luggage weight for individual air travelers on its trans-Atlantic route to have a
mean of 80 pounds and a standard deviation of 20 pounds. The plane is consistently fully booked and holds 100 passengers.
The pilot insists on loading an extra 500 pounds of fuel whenever the total luggage weight exceeds 8300 pounds. On what percentage of the flights will she end up having the extra fuel loaded? the extra fuel loaded?
NOTE: Please use an Excel spreadsheet for response. Please do not just
provide the answer but show in complete detail how you arrived at the
answer, step-by-step, from the beginning to the end of the solution.
The solution provides step by step method for the calculation of probability using the Z score. Formula for the calculation and Interpretations of the results are also included. Interactive excel sheet is included. The user can edit the inputs and obtain the complete results for a new set of data.