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

Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Chapter11: Data Analysis And Probability
Section: Chapter Questions
Problem 8CR
icon
Related questions
Topic Video
Question

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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Discrete Probability Distributions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning