My last name begin with a M through Z...

Use Microsoft Excel and StatDisk to complete the Flying Squadron Costs table for the aircraft type listed below:

If your last name begins with the letter A through L, complete the costs using the B-52 data; use the Kadena data point in your z-score and probability (right-tail) calculations.

If your last name begins with the letter M through Z, complete the costs using the F-35 data; use the Mildenhall data point in your z-score and probability (right-tail) calculations.

Report your values to two decimal places (i.e., 0.12) except for probability. Report probability values to four decimal places (i.e. p = 0.1234).

FLYING SQUADRON COSTS Tankers KC-135 KC-10 Transport C-17 Bomber B-52 Fighters F-16 F-22 Location Mean Location Standard Deviation F-15 F-35 Location Altus Wichita Falls Fairchild Castle Jacksonville Barksdale Corpus Christi Clinton Lackland Dover Kadena Mildenhall Charleston Miami Enid Hill Beale Mean Standard Deviation Z-Score Value Probabilit TBD 12.50 10.40 9.30 7.00 4.00 3.10 2.90 2.10 1.80 1.40 1.10 1.10 0.90 23.40 22.50 11.50 7.10 6.00 4.10 3.30 2.80 2.60 1.70 1.60 1.30 0.90 0.90 0.60 17.30 7.00 7.00 7.00 8.10 6.80 40.70 44.30 34.20 32.50 38.50