Submitted by: Submitted by naja0268
Views: 701
Words: 800
Pages: 4
Category: Other Topics
Date Submitted: 04/11/2011 05:12 AM
In Excel, use a suitable method for generating the number of days needed to repair the copier, when it is out of service, according to the discrete distribution shown.
Assuming the following discrete distribution
Repair Time (days) | Probability |
1 | 0.2 |
2 | 0.45 |
3 | 0.25 |
4 | 0.1 |
We can use the following formulas in Excel to generate the number of days needed to repair the copier.
A1 = RANDBETWEEN(1,100)
=IF(A1<=20,1,IF(A1<=65,2,IF(A1<=90,3,4)))
Result: (Answers vary)
Numbers generated
(first15)
# | Repair Time (days) |
1 | 2 |
2 | 1 |
3 | 3 |
4 | 4 |
5 | 2 |
6 | 2 |
7 | 2 |
8 | 2 |
9 | 2 |
10 | 3 |
11 | 2 |
12 | 3 |
13 | 3 |
14 | 3 |
15 | 3 |
In Excel, use a suitable method for simulating the interval between successive breakdowns, according to the continuous distribution shown.
Assuming the following continuous distribution
The pdf of the interval between successive breakdowns in weeks is (The equation of the straight line is y=x/18)
,
To get the CDF we compute
We can randomly select probability value between 0 and 1 using Rand()
So Rand()
Solving for y
We can use the following formulas in Excel to generate the interval between successive breakdowns in weeks.
=6*SQRT(RAND())
Result: (Answers vary)
Numbers generated
(first15)
# | Interval between successive break |
1 | 5.5234 |
2 | 2.5619 |
3 | 4.3147 |
4 | 2.8446 |
5 | 3.7834 |
6 | 5.6542 |
7 | 3.5611 |
8 | 3.9544 |
9 | 5.5027 |
10 | 3.8307 |
11 | 2.3811 |
12 | 3.9102 |
13 | 3.1875 |
14 | 4.6555 |
15 | 4.6505 |
In Excel, use a suitable method for simulating the lost revenue for each day the copier is out of service
Assuming a uniform distribution we can use the following formulas in Excel to generate the revenue lost for each day the copier is out of service.
=(RAND()*(8000-2000)+2000)*0.1
Result: (Answers vary)
Numbers generated
(first15)
#...