In your formula you have = -$B$s3*LN( 1- A15) it should simply be = -2*LN( 1- A15)

So you insert “2” as the population mean. (Try some other values like 5 and 9) The mean of many values should be around 2.

Create in one row 2 uniformly distributed values. Transform that to 2 exponentially distributed values on the same excel row. Copy that downwards till 100 rows. Calculate the histogram.

(Or create the exponentially distributed values directly by = -2*LN( 1- RAND())

Do the same for 3 random values etc.

So you insert “2” as the population mean. (Try some other values like 5 and 9) The mean of many values should be around 2.

Create in one row 2 uniformly distributed values. Transform that to 2 exponentially distributed values on the same excel row. Copy that downwards till 100 rows. Calculate the histogram.

(Or create the exponentially distributed values directly by = -2*LN( 1- RAND())

Do the same for 3 random values etc.

Hi!

I Think I managed to do it now, please see the Pictures I did above (The Pictures are from the task where one should do 5). THUS

There is something here that is not right, look at my histogram, the closer they get to zero, they should not look like that then…?

Also; please note that what I mean with SD in the Exel is σx (just not possible to do the symbol in the Excel at the time)

Wish you the best