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

7) Use Excel to generate a series of 100 random values from the exponential distribution with a mean of 25? USING EXCEL SHOW ALL WORK

Expert Solution

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

keosha answered 1 year ago

Use Excel to generate 100 N (10,5) distributed random values (that is 100 values of a...

Use Excel to generate 100 N (10,5) distributed random values (that is 100 values of a Normally distributed random variable with mean 10 and standard deviation 5). Plot histogram for your data. See Appendix on how to generate these values.

Use Excel to generate the probability distribution for a binomial random variable for which there are...

Use Excel to generate the probability distribution for a binomial random variable for which there are 20 trials (n = 20) and the probability of success is 0.5 (p = 0.5), and show the graph.

Use Excel to generate 70 values from Normal distribution with mean 18 and standard deviation 5....

Use Excel to generate 70 values from Normal distribution with mean 18 and standard deviation 5. Construct a histogram for them [Note: first generate 100 uniformly distributed random values from [0,1]; then use them as the first input for NORMINV( ) function, two other inputs are mean and standard deviation of given Normal distribution]

Use R and perform following: Generate 1000 observations from an exponential distribution with mean 10. Generate...

Use R and perform following: Generate 1000 observations from an exponential distribution with mean 10. Generate 1000 observations from a central t-distribution with 8 degree of freedom. Make a qqplot of observations in problem 1 versus quantiles generated from a t-distribution with 8 degree of freedom. Can the t distribution be used to approximate data in part 1?Submit the plot. Repeat above part but submit a qqplot of the observations in 1 versus quantiles from an exponential with mean 1....

1. (a) Simulate a random sample of size 100 from the exponential distribution with the rate...

1. (a) Simulate a random sample of size 100 from the exponential distribution with the rate parameter λ = 10. Then make a histogram of the simulated data. (b) We use the simulated data as a data set to construct the log-likelihood function as an R function. We will find the MEL of the value λ = 10. Choose the appropriate range for the parameter λ, then make a plot of the log-likelihood function. (c) Use R function ‘optim‘ to...

Generate 100 samples of size n=8 from an exponential distribution with mean 3 . Each row...

Generate 100 samples of size n=8 from an exponential distribution with mean 3 . Each row of your data will denote an observed random sample of size 8, from an exponential distribution with mean 3. Obtain sample mean for each sample, store in another column and make a histogram for sample means. Repeat for n=100. Compare and interpret the histograms you obtained for n=8 and n=100. Submit the histograms along with your one small paragraph comparison. Can you solve it...

Use Excel to generate a column of x values from 0 to 2.5 in steps of...

Use Excel to generate a column of x values from 0 to 2.5 in steps of 0.05 (that means your column must have numbers like 0, 0.05, 0.1, 0.15, . . . , 2.5). Plot the PDF f(x) on your computer screen for the different values of x mentioned above for the following distributions. (a) Uniform (use A = 0 and B = 2.5) (b) Exponential (use mean = 2) (c) Gamma (use parameters 1.7 and 1.2) (d) Normal (use...

Using MS Excel and the random number generator function, generate values for 30 observations for the...

Using MS Excel and the random number generator function, generate values for 30 observations for the following columns with average daily: Body weight with random values between 100 and 250lbs Calories intake with random values between 1000 and 3000 calories Workout duration with random values between 0 and 60 minutes Sleep duration with random values between 2 and 12 hours Work duration with random values between 0 and 12 hours Assuming that the values are averages over 1 year, conduct...

Develop a random number generator for a Poisson distribution with mean = 10. Generate five values...

Develop a random number generator for a Poisson distribution with mean = 10. Generate five values manually with a random number table. Please show work.

Suppose we wish to generate a sample from the exponential ($\beta$) distribution, and only have access...

Suppose we wish to generate a sample from the exponential ($\beta$) distribution, and only have access to a computer which generates numbers from the skew logistic distribution. It turns out that if $X$~SkewLogistic ($\beta$), then log(1+exp($-X$)) is exponential ($\beta$). Show that this is true and check by simulation that this transformation is correct.

Question