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 ...
Get Statistical Analysis: Microsoft Excel 2016 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
