Question

1 Program 2-paramter Weibull distribution with β 100 rows by copying down the equation from Table 4.1. In the next column generate 1000 rows and in the next column 10 000 rows. Calculate the mean and standard deviation for each column. By hitting Recalculate' (typically F9) observe the mean and standard deviation values. What can you say about the variation for each group? 3.0 and η 000 into Excel spreadsheet and generate 2. When simulating the function Z-X where X and Y are random functions. If X and Y are comparable 2.0), will the function Z be more sensitive statistical distribution (e.g. both normal with μ-100, σ to X or Y? Justify your answer.

Answer 1

The Weibull CDF is

Here $\beta =3,\eta =1000$ .

The random numbers are generated using EXCEL and the results are

For $n=100,200$   respcetively,     Mean 902.2941 SD 314.5681 Mean 888.3564 SD 341.0322

As the sample size increases, the mean decreases, the standard deviation increases.

Use functions like =AVERAGE(G5:G104), =STDEV(G5:G104).

Screenshot below.