In this module, you explore the normal distribution. A standard normal distribution has a mean of zero and standard deviation of one. The z-score statistic converts a non-standard normal distribution into a standard normal distribution allowing us to use Table A-2 in your textbook and report associated probabilities.

This discussion combines means, standard deviation, z-score, and probability. You are encouraged to complete the textbook reading and start the MyStatLab Homework before starting this discussion.

Scenario

The following table reports simulated annual flying squadron costs (in millions of dollars) at the following locations:

Text description of the Annual Squadron Flying Costs in Millions (PDF)

Complete

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

• Complete the costs using the B-52 data; use the Kadena data point in your z-score and probability 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).

Your StatDisk results should look similar to this image:

Post & Discuss

Post the images of your spreadsheet and StatDisk results in the discussion area along with a narrative of your findings and the responses to the questions below.

1. Do these costs appear to come from a population that has a normal distribution? Why or why not?
2. Can the mean of your data sample be treated as a value from a population having a normal distribution? Why or why not?
3. Did an “unusually low” or “unusually high” z-score value occur?
4. Was the associated z score probability value less than 0.05 (p < 0.05); meaning a “significantly low” or “significantly high” event? If yes, what are the implications for the base and/or aircraft?
5. What were your findings? Hint: focus on the calculated mean, standard deviation and z-score (include probability) to interpret your results.

Transport Bomber Fighters
Location KC-135 KC-10 C-17 B-52 F-15 F-16 F-22

Altus 12.50
wichita Falls 10.40

Fairchild 9.30
Castle 7.00

Jacksonville 4.00
Barksdale 3.10 17.30

Corpus Christi 2.90 7.00
Clinton 2.10 7.00

Lackland 1.80 7.00
Dover 1.40 8.10

Kadena 1.10 6.80 40.7
Mildenhall 1.10 44.30
Charleston 0.90 34.20

Miami 32.50
Enid 38.50
Hill

Beale
Mean

Standard Deviation
Z-Score Value

Probability

Tankers

FLYING SQUADRON COSTS

Location Location
F-35 Mean Standard Deviation TBD

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

• Sheet1

Sheet1

Location

7

4

7 6

7

7

1.1

0.9

0.9