In "A", rows 1-1000, I generate random numbers using RAND(). I want to pick numbers between say 1-100.
In "B" for 1000 rows I have
In "C" for 1000 rows I use the numbers that I generated in "A", so
The averages in B and C are the same, as expected.
I only want to use the values for 20% of the time, so for each of the 1000 rows:
For B, I use
For C, I use
If I do this, the averages for each of the two columns are vastly different.
Can anybody explain why?
Both approaches are using random numbers. The first approach uses two different random numbers (from column "A" and the one used in the "B" column calculation).