Sign in Subscribe

Stats

Excel Stats Errors

If you use Excel to do statistics of any type, you should know that Excel has a large variety of known errors in its statistical functions. Excel is popular and widely used, but it is not a statistical software package.

Microsoft Excel 2000, 2003, and 2007 Faults, Problems, Workarounds, and Fixes

h/t John D Cook

Read next

Has Intelligence Declined in the Modern Era?

Has Intelligence Declined in the Modern Era?

I mentioned this subject a couple of times before. Simple reaction time data from Woodley et al.Bruce Charlton is the first person I know of to discuss the implications of the change in simple reaction time data in the paper by Woodley et al. Charlton claims the data shows

Fermi Problems

Fermi Problems

Geoff Canyon has a post about Google's tricky interview questions. Microsoft is also known for asking these kind of questions during interviews, and you can run into them anywhere in the technical world. Also known as Fermi problems or back-of-the-envelope calculations, I ran into these a lot during college because

Stats Package Comparison

A fun post exploring the differences between a number of statistical computation packages. As one of the commenters said, this is an awesome flame war! The comments are very informative, with all sorts of historical information explaining how and why certain packages turned out the way they are. I use

Comments ()