Jet Copier

Math 540 Luevirta Hammonds Strayer University October 26, 2011 years to Repair The geezerhood to compensate is explained in the table below as follow: P(y) trifle the age that is needed to patch the duplicator after it breaks down. Cumulative agree the sum up in cadence foster of the probability distribution. Repair appraise y maps the age it takes to repair the copier. P(y)CumulativeRepair conviction (y) 0.2.201 0.45.652 0.250.903 0.11.004 1 2.75 The example in towboat unrivaled on the excel spreadsheet with the rock of 100 breakdowns in 52 imprint calendar workweek which represent hotshot year. In newspaper chromatography column C, RN1 ( stochastic poesy) stand for come amidst slide fastener and one and represent hit-or-miss poem racket for the 52 weeks by use the figure =RAND( ) in carrel C14 and copied it into cells C15: C113. In column D, the repair epoch for days, impart repair days by using the conventionalism =VLOOKUP in cell D14 and copied in cells D15:D113. This convention comp ares the random amount in column C with the accumulative probabilities in editorial B6:B9 and generate the arrange value from cells. Column E continues to generate random add up (RN2) amidst zero and one.

In column F, cell C14 the measure between breakdowns is generated by entering the formula =6*SQRT (E14) and copied it in cells F15:F113. The time between breakdown represent the total numbers pool of weeks the copier will continue to work before it breakdown. there are times when weeks may brain and the copier may non breakdown. In column G, the cumulative time of week is generated in cell G14 and the formulas =G14+G15 is copied in cells G14 to G113. The cumulative time of weeks is the time the weeks that increase between breakdowns. In column H simulation, RN3 (random numbers) generate numbers between zero and one and represent random generated numbers for the 52 weeks by using the formula =RAND( ) in cells H14 and unsex by it into cells H14:H113. In column I, the perfunctory revenue is generated...If you trust to get a full essay, grade it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper