Re: Variance question
Answered the excel question for myself, after doing a bit more searching.
Excel's normdist function gives the portion that is less than the argument.
So normdist(1,0,1,true) isn't the distribution from -1 to 1, it's the distrubution from -infinity to 1.
Which would certainly explain the 7 decimal place difference.
|