Statistical Analysis with Excel For Dummies, 3rd Edition

Statistical Analysis with Excel For Dummies^®

Visit www.dummies.com/cheatsheet/statisticalanalysiswithexcel to view this book's cheat sheet.

Table of Contents

Introduction

About This Book

What You Can Safely Skip

Foolish Assumptions

How This Book Is Organized

Part I: Getting Started with Statistical Analysis with Excel

Part II: Describing Data

Part III: Drawing Conclusions from Data

Part IV: Probability

Part V: The Part of Tens

Appendix A: When Your Worksheet Is a Database

Appendix B: The Analysis of Covariance

Bonus Appendix 1: When Your Data Live Elsewhere

Bonus Appendix 2: Tips for Teachers (And Learners)

Icons Used in This Book

Where to Go from Here

Part I: Getting Started with Statistical Analysis with Excel

Chapter 1: Evaluating Data in the Real World

The Statistical (And Related) Notions You Just Have to Know

Samples and populations

Variables: Dependent and independent

Types of data

A little probability

Inferential Statistics: Testing Hypotheses

Null and alternative hypotheses

Two types of error

What’s New in Excel 2013?

What’s Old in Excel 2013?

Knowing the Fundamentals

Autofilling cells

Referencing cells

What’s New in This Edition?

Chapter 2: Understanding Excel’s Statistical Capabilities

Getting Started

Setting Up for Statistics

Worksheet functions in Excel 2013

Quickly accessing statistical functions

Array functions

What’s in a name? An array of possibilities

Creating your own array formulas

Using data analysis tools

Accessing Commonly Used Functions

For Mac Users

The ...