O'Reilly logo

Statistical Analysis: Microsoft Excel 2016 by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

5Charting Statistics

Charts have been an integral part of Excel ever since the earliest releases. They are particularly valuable for statistical analysis, for reasons that have little to do with Excel. It often happens that there’s some aspect of a distribution of numbers that is not apparent from simply looking at the numbers themselves, or even at their summary statistics. You might be working with a distribution that has not one but two modes, or you might be misled when you see a correlation of .90 that is due primarily to one extreme outlier. In cases like these, the summary statistic won’t set you straight, but charts can help keep you from misinterpreting ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required