Hello, I have the spread sheet all filled out but I am having trouble figuring out questions 1-3 I have the F-35 for last name m-z

Introduction

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:

• If your last name begins with the letter A through L, complete the costs using the B-52data; use theKadenadata point in your z-score and probability calculations.
• If your last name begins with the letter M through Z, complete the costs using the F-35data; use the Charleston 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:

Save your work as separate files to your computer and then read the Canvas instructions onHow do I embed an imagein a discussion reply as a student?

(Links to an external site.)

Links to an external site.

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
5. What were your findings? Hint: focus on the calculated mean, standard deviation and z-score (include probability) to interpret your results.

You should make your initial post before the fourth day of the module week to receive full credit. Return at least once later in the module week to provide meaningful comments to two or more of your classmates' posts. DO NOT "post and run" - making all three posts in the same visit. You need multiple visits to the discussion area to gain multiple perspectives by reading all of the posts and replies.

Review the Discussion Rubric for detailed grading information.

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