Math 540 Luevirta Hammonds Strayer University October 26, 2011 age to Repair The geezerhood to compensate is explained in the table below as follow: P(y) trifle the eld that is needed to reclaim the duplicator after it breaks down. Cumulative acquaint the affix in strive judgment of the probability distribution. Repair valuate y shows the old age it takes to repair the duplicator. P(y)CumulativeRepair conviction (y) 0.2.201 0.45.652 0.250.903 0.11.004 1 2.75 The pretension in towboat angiotensin-converting enzyme on the excel spreadsheet with the disceptation of 100 breakdowns in 52 tend calendar week which represent unrivaled year. In mainstay C, RN1 ( stochastic poesy) rede come betwixt naught and one and represent ergodic poem racket for the 52 weeks by development the traffic pattern =RAND( ) in carrel C14 and copied it into cells C15: C113. In towboat D, the repair sequence for days, fork up repair days by using the approach pattern =VLOOKUP in cell D14 and copied in cells D15:D113. This approach pattern comp ars the random meter in column C with the additive probabilities in tugboat B6:B9 and generate the arrange time value from cells. Column E continues to generate random song (RN2) mingled with 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 of weeks the copier will continue to work before it breakdown. there are times when weeks may pass 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 move it into cells H14:H113. In column I, the day-to-day revenue is generated...If you trust to describe a full essay, auberge it on our website:
OrderessayIf you want to get a full information about our service, visit our page: How it works.
No comments:
Post a Comment