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.

Bringing Down the Banking System: Lessons From Iceland

I was very fortunate today to attend the STOR Collquium at UNC. Gudrun Johnsen of the University of Iceland gave a talk, "If you look close enough you can see a whole lot: Data collection and analysis of the Parliamentary Investigation Commission looking into the Icelandic Banking Collapse in 2008."