Menu [Hide]

Random Normal and Boxplots

Print

Excel users should use this formula to calculate a random number from a normal distribution:

=Mean+Std*SQRT(-2*LN(RAND()))*SIN(2*PI()*RAND())

Source: http://www.exceluser.com/explore/statsnormal.htm

The attached Excel spreadsheet compares two small samples taken at random from normally distributed data using boxplots.

Last edited by System Administrator .
Page last modified on Monday 06 of June, 2011 15:10:45 NZDT.


RSS feed Wiki