Chapter 20

Ten Things (Thirteen, Actually) That Just Didn’t Fit in Any Other Chapter

In This Chapter

arrow Forecasting help

arrow Visualizing variability

arrow Going over the odds and ends of probability

arrow Looking for independence

arrow Working with logs

arrow Sorting

I wrote this book to show you all of Excel’s statistical capabilities. My intent was to tell you about them in the context of the world of statistics, and I had a definite path in mind.

Some of the capabilities don’t neatly fit along that path. I still want you to be aware of them, however, so here they are.

Forecasting Techniques

Here are a couple of useful techniques to help you come up with some forecasts. Although they didn’t quite fit into the regression chapter, and they really didn’t go into the descriptive statistics chapters, they deserve a section of their own.

A moving experience

In many contexts, it makes sense to gather data over periods ...

Get Statistical Analysis with Excel For Dummies, 3rd Edition 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.