Revision as of 11:11, 4 May 2011 edit Dandv (talk \| contribs) Extended confirmed users 2,937 edits →Accuracy and binary storage: Fix labeling to read 9000 instead of 900, per the figure's edit as of 16:12, 11 March 2011 ← Previous edit		Revision as of 20:46, 7 February 2012 edit undo Sigma0 1 (talk \| contribs) 1,771 edits →Statistical functions Next edit →
Line 60: [[File:Excel Std Dev Error.PNG\|thumb\|450px\|Error in Excel 2007 calculation of standard deviation. All four columns have the same deviation of 0.5]] Accuracy in Excel-provided functions can be an issue. [[Micah Altman]] ''et al.'' provide this example:<ref name=Altman> {{cite book \|title=Numerical issues in statistical computing for the social scientist \|author= Micah Altman, Jeff Gill, Michael McDonald \|year=2004 \|publisher=Wiley-IEEE \|isbn=0471236330 \|url=http://books.google.com/books?id=j_KevqVO3zAC&pg=PA12 \|chapter=§2.1.1 Revealing example: Computing the coefficient standard deviation \|page=12}}

Numeric precision in Microsoft Excel: Difference between revisions