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).
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.
example of what statdisk results should look like attached below!
a. do these costs appear to come from a population that has a normal distribution? why or why not?
b. can the mean of your data sample be treated as a value from a population having a normal distribution? why or why not?
c. did an "unusually low" or "unusually high" z-score value occur?
d. 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?
e. what were your findings? hint: focus on the calculated mean, standard deviation and z-score (include probability) to interpret your results.