re please delete t B Mean defective products per Hour: 36 TO SC A. In the periods mean cells BE B. Crea previou Betwee C. SOL less tha Answer the actu formula 2 3 Time between defective Cumulative 4 products (hours) Probability 5 0.01 6 0.02 7 0.03 8 0.04 9 0.05 10 0.06 11 0.07 12 0.08 13 0.09 14 0.1 15 0.11 16 0.12 170.13 18 0.14 19 0.15 20 0.16 21 0.17 22 0.18 23 0.19 24 0.2 25 0.21 26 0.22 27 0.23 28 0.24 29 0.25 30 0.26 31 0.27 2009 Exponential distrib ected View View Help ess you need to edit, it's safer to stay in Protected View. Enable Editing se delete the contents of this cell and then enter the actual formula for your answer here, i.e. in the form C5+G M O F G TO SOLVE THIS PROBLEM: A. In the column titled "Cumulative Probability" calculate the probability values for specific periods of time elapsed between two defective products produced at a factory, where the mean rate of defective products is stated in cell B1. You will enter your probability values in cells B5 through B32 B. Create a chart to plot the distribution of probability values you have obtained in the previous step. The probability values will be represented by the 'Y' axis, and the 'Time Between Defective Products" will be represented by the 'X axis C. SOLVE THIS QUESTION FOR EXTRA 10 TEN POINTS: What is the probability that less than 12 minutes have passed between the production of two defective products? Answer to Bonus Goes here (please delete the contents of this cell and then enter the actual formula for your answer here, i.e. In the form C5 + G5, or 1+H5, etc. If your formula is right the actual answer will show in this cell) 39 re please delete t B Mean defective products per Hour: 36 TO SC A. In the periods mean cells BE B. Crea previou Betwee C. SOL less tha Answer the actu formula 2 3 Time between defective Cumulative 4 products (hours) Probability 5 0.01 6 0.02 7 0.03 8 0.04 9 0.05 10 0.06 11 0.07 12 0.08 13 0.09 14 0.1 15 0.11 16 0.12 170.13 18 0.14 19 0.15 20 0.16 21 0.17 22 0.18 23 0.19 24 0.2 25 0.21 26 0.22 27 0.23 28 0.24 29 0.25 30 0.26 31 0.27 2009 Exponential distrib ected View View Help ess you need to edit, it's safer to stay in Protected View. Enable Editing se delete the contents of this cell and then enter the actual formula for your answer here, i.e. in the form C5+G M O F G TO SOLVE THIS PROBLEM: A. In the column titled "Cumulative Probability" calculate the probability values for specific periods of time elapsed between two defective products produced at a factory, where the mean rate of defective products is stated in cell B1. You will enter your probability values in cells B5 through B32 B. Create a chart to plot the distribution of probability values you have obtained in the previous step. The probability values will be represented by the 'Y' axis, and the 'Time Between Defective Products" will be represented by the 'X axis C. SOLVE THIS QUESTION FOR EXTRA 10 TEN POINTS: What is the probability that less than 12 minutes have passed between the production of two defective products? Answer to Bonus Goes here (please delete the contents of this cell and then enter the actual formula for your answer here, i.e. In the form C5 + G5, or 1+H5, etc. If your formula is right the actual answer will show in this cell) 39
