Using a spreadsheet generate 1000 exponentially distributed


Question: Using a spreadsheet, generate 1000 exponentially distributed random values with a mean of 10. What is the maximum of the simulated values? What fraction of the generated values is less than the mean of 10? Plot a histogram of the generated. values. (Hint: If you cannot find an exponential generator in the spreadsheet you use, use the formula -10*LOG(1-R), where Ris a uniformly distributed random number · from 0 to 1 and LOG is the natural logarithm. The rationale for this formula is explained in Chapter 8 on random-variate generators.)

Solution Preview :

Prepared by a verified Expert
Mathematics: Using a spreadsheet generate 1000 exponentially distributed
Reference No:- TGS02415359

Now Priced at $15 (50% Discount)

Recommended (97%)

Rated (4.9/5)