Random variates and expected value

Hi all.

I have a spreadsheet with standard normally distributed random variates in one column. How do I find the expected value and variance based on x number of simulations?


TS Contributor
If you're using simulation the law of large numbers should help you get an estimated expected value and variance. The expected value and variance in your case is basically the mean and variance parameters as stated in the distribution function, which is zero and one.

If your asking how to find the sample mean and standard deviation then there are built in functions that you can utilize in Excel. Search the menus for a minute and you'll find it.