7) Use Excel to generate a series of 100 random values from the exponential distribution with...

Free

90.2K

Verified Solution

Question

General Management

7) Use Excel to generate a series of 100 random values from theexponential distribution with a mean of 25? USING EXCEL SHOW ALLWORK

Answer & Explanation Solved by verified expert

4.4 Ratings (778 Votes)

The cumulative distribution function (CDF) of an exponential distribution is:

F(x; lambda) = 1 - exp(-lambda * x)

G(x) = - 1/lambda * logn(1- x) here (1/ lambda = mean)

F(x)=-25*LN(RAND())

Natural logarithm of any set of numbers is a normal distribution to convert a normal distribution into an exponential distribution the set of numbers should be multiplied by negative of the required mean

60.15752504
1.661629654
32.73995611
7.580579137
15.96415152
53.36770277
14.0812872
1.484287902
30.44099364
12.26825001
111.5515469
29.33476013
11.6831418
62.146464
6.163546019
52.71399343
7.459753306
1.616480205
6.247527602
12.47402989
7.201947057
1.395905682
16.53314093
2.188530493
73.92327358
14.20270971
3.684787587
25.64750049
10.6802051
11.6243284
3.529714672
44.80698542
91.97898228
6.304857975
55.47417467
11.28694278
15.73636464
11.16766403
125.6616077
18.59940519
66.61241905
5.564913765
70.72122331
10.30960026
1.411706511
16.73139632
5.58546814
19.24671349
65.77586643
61.28367883
61.39710804
27.46431819
13.49175972
18.89107288
2.607950387
27.36460243
55.66797189
48.39810916
2.235658958
26.29126817
4.852258421
28.44277455
18.38817138
2.402215979
29.46023512
78.72600113
60.85459277
21.95365643
5.018937332
67.40676108
3.238928812
27.33028496
14.5772509
19.89671006
31.3748151
23.25639618
2.903477654
33.77943537
0.677490984
63.27580673
18.0842029
26.61376822
8.31112998
32.41465517
22.74925343
0.029479161
8.956107183
85.35330575
35.33711798
51.56439645
12.5279691
63.62407049
41.99314076
3.293868868
24.7167323
15.19425732
79.00349224
16.56876417
16.65740814
15.98801644

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member