# Question: The Excel functions discussed in this chapter are useful for

The Excel functions discussed in this chapter are useful for solving a lot of probability problems, but there are other problems that, even though they are similar to normal or binomial problems, cannot be solved with these functions. In cases like this, simulation can often be used. Here are a couple of simulate 500 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 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 like—or try different values of p.

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 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 like—or try different values of p.

## Answer to relevant Questions

You have a device that uses a single battery, and you operate this device continuously, never turning it off. Whenever a battery fails, you replace it with a brand new one immediately. Suppose the lifetime of a typical ...Ascorbic acid, or vitamin C(C6H8O6), is an essential vitamin. It cannot be stored by the body and must be present in the diet. What is the molar mass of ascorbic acid? Vitamin C tablets are taken as a dietary supplement. If ...Consider the following gas samples: 4.0 g of hydrogen gas, 4.0 g of helium gas, 1.0 mole of fluorine gas, 44.0 g of carbon dioxide gas, and 146 g of sulfur hexafluoride gas. Arrange the gas samples in order of increasing ...Arrange the following substances in order of increasing mass percent of carbon. a. Caffeine, C8H10N4O2 b. Sucrose, C12H22O11 c. Ethanol, C2H5OH A sample of urea contains 1.121 g N, 0.161 g H, 0.480 g C, and 0.640 g O. What is the empirical formula of urea?Post your question