Introducing Excel's Statistical Capabilities
  • Built-in Functions and the Data Analysis ToolPak
  • Working with the Built-in Statistical Functions
  • Working with the Data Analysis ToolPak
Working with Data
  • Grouping Data into Distributions
  • Sorting Data in Tables
  • Summarizing Data
  • Show and Tell: Using Excel Graphics
  • Bar Charts and Scatter Charts
  • Working with Tables, Sparklines, and PowerView
  • Instant Statistics: Statistics on the Status Bar and Quick Analysis
Statistical Concepts
  • Statistics in the Center: Mean, Median, and Mode
  • Statistics out of the Center: Variance and Standard Deviation
  • Using the Mean and the Standard Deviation Together: Standard Scores
The Normal Distribution
  • What is "The" Normal Distribution and Why Do We Care?
  • Working With Excel's Normal Distribution Functions
Applying the Normal Distribution
  • Understanding Sampling Distributions
  • Finding Confidence Limits For a Mean
  • When The Normal Distributio Isn't Practical: The t Distribution
Introducing Hypothesis Testing
  • Hypotheses and Sampling Distributions
  • Working with Hypotheses - Related Excel Functions About Means
  • Working with Hypotheses - Related Excel Functions About Variances