Jet Copier

Math 540 Luevirta Hammonds Strayer University October 26, 2011 Days to resort The geezerhood to cook up is explained in the table below as follow: P(y) micturate the days that is needed to rectify the copier after it breaks down. accumulative patch up the increase in value of the probability distribution. Repair quantify y represents the days 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 simulation in towboat one on the jump out spreadsheet with the list of 100 dislocations in 52 work calendar week which represent one year. In mainstay C, RN1 ( stochastic poesy) interpret come between range in and one and represent random poem racket for the 52 weeks by exploitation the formula =RAND( ) in carrel C14 and copied it into cells C15: C113. In chromatography column D, the repair duration for days, ge nerate repair days by utilize the formula =VLOOKUP in cell D14 and copied in cells D15:D113. This formula compares the random numbers in column C with the cumulative probabilities in Column B6:B9 and generate the arrange value from cells. Column E progresss to generate random numbers (RN2) between zero and one.

In column F, cell C14 the measure between breakdowns is generated by ledger entry the formula =6*SQRT (E14) and copied it in cells F15:F113. The time between breakdown represent the total numbers of weeks the copier will continue to work before it breakdown. there are times when weeks whitethorn pass and the copier may not breakdown. In column G, the cumulative ti! me 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 coping it into cells H14:H113. In column I, the daily revenue is generated...If you trust to get a secure essay, order it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay