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. Use simulation to generate 500 values of this random variable X. A) Use simulation to generate 500 values 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? Use excel to help please and attach... Previous writer did not include part A in excel Note: These probabilities were generated by a binomial distribution,. For now, you can just take these probabilities as given. Number of defective items in a random sample of 15 items # of defectives Probability 0 0.2059 1 0.3432 2 0.2669 3 0.1285 4 0.0428 5 0.0105 6 0.0019 7 0.0003 8 0.0000 9 0.0000 10 0.0000 11 0.0000 12 0.0000 13 0.0000 14 0.0000 15 0.0000
Contingency Table
A contingency table can be defined as the visual representation of the relationship between two or more categorical variables that can be evaluated and registered. It is a categorical version of the scatterplot, which is used to investigate the linear relationship between two variables. A contingency table is indeed a type of frequency distribution table that displays two variables at the same time.
Binomial Distribution
Binomial is an algebraic expression of the sum or the difference of two terms. Before knowing about binomial distribution, we must know about the binomial theorem.
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. Use simulation to generate 500 values of this random variable X.
A) Use simulation to generate 500 values 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?
Use excel to help please and attach... Previous writer did not include part A in excel
Note: These probabilities were generated by a binomial distribution,. For now, you can just take these probabilities as given.
Number of defective items in a random sample of 15 items | ||||
# of defectives | Probability | |||
0 | 0.2059 | |||
1 | 0.3432 | |||
2 | 0.2669 | |||
3 | 0.1285 | |||
4 | 0.0428 | |||
5 | 0.0105 | |||
6 | 0.0019 | |||
7 | 0.0003 | |||
8 | 0.0000 | |||
9 | 0.0000 | |||
10 | 0.0000 | |||
11 | 0.0000 | |||
12 | 0.0000 | |||
13 | 0.0000 | |||
14 | 0.0000 | |||
15 | 0.0000 |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images