View Single Post
  #15  
Old 11-01-2007, 02:59 PM
TNixon TNixon is offline
Senior Member
 
Join Date: Apr 2007
Posts: 616
Default Re: Variance question

[ QUOTE ]

Where did you get this?

=normdist(10,0,1,true) in Excel just gave me 1.000.. (a total of 30 0's). Is Excel unreliable for this many decimal places?

[/ QUOTE ]

If excel's normdist function can be used to determine the how likely you are to be within X std deviations, then shouldn't

=normdist(1,0,1,true)

give .68?

It gives me .8413.
Reply With Quote