Statistical Analysis with Excel For Dummies, 5th Edition

Chapter 23

Ten Topics (Thirteen, Actually) That Just Don't Fit Elsewhere

IN THIS CHAPTER

Visualizing variability

Going over the odds and ends of probability

Drawing samples

Looking for independence

Working with logs

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.

Graphing the Standard Error of the Mean

When you create a graph and your data are means, it's a good idea to include the standard error of each mean in your graph. This gives the viewer an idea of the spread of scores around each mean.

Figure 23-1 gives an example where this situation arises. The data are (fictional) test scores for four groups of people. ...