Question
Not all probability distributions or their inverse are always easy to calculate, e.g. using Excel functions. In such cases, simulation can often be used. Here
Not all probability distributions or their inverse are always easy to calculate, e.g. using Excel functions. In such cases, simulation can often be used. Here are a couple of such problems for you to simulate. For each example, simulate 500-1000 replications of the experiment. a) You observe a sequence of parts from a manufacturing line. These parts use a component that is supplied by one of two suppliers. Each part made with a component from supplier 1 works properly with probability 0.95, and each part made with a component from supplier 2 works properly with probability 0.98. Assuming that 100 of these parts are made, 60 from supplier 1 and 40 from supplier 2, you want to find the probability that at least 97 of them work properly. b) Here we look at a more generic example such as coin flipping. There is a sequence of trials where each trial is a success with probability p and a failure with probability 1 p. A run is a sequence of consecutive successes or failures. For most of us, intuition says that there should not be long runs. Test this by finding the probability that there is at least one run of length at least six in a sequence of 15 trials. (The run could be of 0s or 1s.) You can use any value of p you likeor try different values of p.
Step by step excel formulas needed.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started