Question

business analysis stimulation problem 1

here is the question and solutions...i would like the steps on how they got there

Refresh Properties Query - Lo Recent Sources All Edit Links EEE From Table Get External New Get & Transform Connections Sort & Filte A1 Back Simulation Problem 1 Che Calculate the expected number of breakdowns over the 10 week sirmulated period and the average number of breakdowns per week during that period Cumulati reguenesRelativeRN Interval Number of Breakdovns Breakdown Probability Probabilit of 50 4 140 10 6 Random Numbers Use these Random Numbers Ready Properties Edit Links From Table Refresh SortFilter New Query Lo Recent SourcesAll Sort & Filter Get & Transform Connections te the expected number of breakdowns over the 10 week simmulated period and the average mmber of owns per week during that period: Cumulati Frequeneg of Number of Breakdovns Breakdovn Probabilitg Probabilit Relative 0.65 41 0.85 66 85 50 0.25 10 100 96 100 6 0.05 Solution Weeks RandomProecea The expected number of breakdowns is 27 27 The average number of breakdowns is 2.7 Random Numbers are giten 2.7 Booki-Excel X BUS 322 12 $19 Samp

Answer 1

No down Breatedown 010 0.10 0.40 0.6S 0.85 0.95 20 10 2. 60 0.30 11 40 3 A0 020 0 10 86 | 75 (o0 1 0 9 6 ZFebs to刮tup the above, tabte ob owin St limi (b) Lower 4L

NumbersBrtakdown AS 25 자3 12 equalto 6 2. 2 tha. Prajeeted breakdown for thalt ondow mumbers 23 Rondewno 1% ios is FIN Q (total Iw there ae. 2 breakdouww Sor Rrojeoted breakdaun obte So, topal exbec tedno.of bYeakdouons 2부 tan, Average noo breakdoun is trfol.oh Prajded Breakdouon Ne. ab Weates breakdown isa