excel

You CAN use Excel to do Statistics, but should you?

When I was an undergraduate, I learned to distrust the statistical functions in Excel. Back then, we didn’t use software in statistics class, we had to learn how to do all the calculations with paper, pencil, and a basic four-function calculator. When we were taught to calculate quartiles, a classmate discovered that Excel gave the “wrong” answer for some of our homework problems. Our instructor just said, “Don’t use Excel, use the method I taught you.