
Random Normal and BoxplotsExcel 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
. 
Login
