Note that this discussion is due on Day 6. Although the initial post is due on Day 6, you are encouraged to start working on it early, as it includes performing operations in Excel, prior to being abl

Note that this discussion is due on Day 6. Although the initial post is due on Day 6, you are encouraged to start working on it early, as it includes performing operations in Excel, prior to being able to answer the questions.

Complete Problem 18 in Chapter 4 on page 159.

A quality inspector picks a sample of 15 items at random from a manufacturing process known to produce 10% defective items. Let X be the number of defective items found in the random sample of 15 items. Assume that the condition of each item is independent of that of each of the other items in the sample. The probability distribution of X is provided in the file P04_18.xlsx.

1. Use simulation to generate 500 values of this random variable X.
2. Calculate the mean and standard deviation of the simulated values. How do they compare to the mean and standard deviation of the given probability distribution? (Albright, 2017, p. 159).

In the discussion area, answer both questions in Parts a and b. Attach the Excel document.

Guided Response: Review several of your classmates’ posts, and provide answers or suggestions to at least one of your classmate’s questions by Day 7. This discussion area is a place to collaborate so everyone can gain applicable knowledge of the material. You are encouraged to post your required replies early during the week to promote more meaningful and interactive discourse in this discussion. In your responses, post at least one question or “tip” related to the material.