Statics – probability | Management homework help

Use the attached excel sheet to complete the below problem:

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 excel file attached.

A.  Use the excel file attached to generate 500 vales of this random variable X.

B.  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).

Please answer both questions A & B in full within the excel sheet attached. 

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer