Online Test Banks
Score higher
See Online Test Banks
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Statistical Analysis with Excel For Dummies Extras

Sorted by:  

Statistical Analysis with Excel For Dummies Cheat Sheet

Excel offers a wide range of statistical analysis tools and functions you can use to add a single value or an array of values to your Excel worksheets. You can download even more tools with the Excel Analysis [more…]

Stem-and-Leaf Plots Present a Distribution of Scores in Excel

Stem-and-leaf displays organize data so that an entire distribution of scores is quickly and easily comprehensible. The display breaks each score into two components: a [more…]

Box-and-Whisker Charts for Excel

Excel doesn’t offer a box-and-whisker chart. Instead, you can cajole a type of Excel chart into boxes and whiskers. Instead of showing the mean and the standard error, the [more…]

Data Smoothing in Excel

Statisticians typically have to look at large masses of data and find hard-to-see patterns. Sometimes an overall trend suggests a particular analytic tool. And sometimes that tool, although statistically [more…]

How to Perform Analyses of Variance with Two Kinds of Variables

What happens when you are performing analyses of variance (ANOVA) and you have a Between Groups variable and a Within Groups variable . . . at the same time? How can that happen? [more…]

How to Perform Analyses of Variance in Excel

Someday, Excel’s Analysis ToolPak might have a choice labeled ANOVA: Mixed Design. That day, unfortunately, is not today. To run two ANOVAs on the same data and combine the ANOVA tables, follow these steps [more…]

How to Graph the Results of Analyses of Variance in Excel

Because analyses of variance (ANOVA) isn’t a built-in tool, Excel doesn’t produce the descriptive statistics for each combination of conditions. You have to have those statistics [more…]

Post-Analysis after an Analysis of Variance

A significant result in an analysis of variance (ANOVA) in Excel tells you that an effect is lurking somewhere in the data. Post-analysis tests tell you where. Two types of tests are possible — either [more…]

Analysis of Variance for Mac Users of Excel

You can use StatPlus LE to do analysis of variance in Excel on a Mac. The first thing you have to do, however, is rearrange the data the way StatPlus likes it — in columns. The second thing is to recode [more…]

Sign Up for RSS Feeds

Education & Languages
Win $500. Easy. Enter to win now.

Inside Sweepstakes

Win $500. Easy.