Ebook: Excel 2010 Guide To Accompany Understandable Statistics

Tenth Edition, 185 pages
Content:
Getting started with Excel
Entering Data
Using Formulas
Saving Workbooks
Lab Activities for Getting Started
Lab Activities for Random Samples
Frequency Distributions and Histograms
Lab Activities for Frequency Distributions and Histograms
Bar Graphs, Circle Graphs, and Time-Series Graphs
Lab Activities for Bar Graphs, Circle Graphs, and Time-Series Graphs
Central Tendency and Variation of Ungrouped Data
Lab Activities for Central Tendency and Variation of Ungrouped Data
Box-and-Whisker Plots
Simulations
Lab Activities for Simulation
The Binomial Probability Distribution
Lab Activities for Binomial Probability Distributions
Graphs of Normal Probability Distributions
Standard Scores and Normal Probabilities
Lab Activities for Normal Distribution
Introduction to Sampling Distributions
Confidence Intervals for the Mean – When σ is Known
Confidence Intervals for the Mean – When σ is Unknown
Lab Activities for Confidence Intervals for the Mean
Testing a Single Population Mean – When σ is Known
Lab Activities for Testing a Single Population Mean
Tests Involving Paired Differences – Dependent Samples
Lab Activities for Tests Involving Paired Differences
Testing of Differences of Means
Lab Activities for Testing Differences of Means
Linear Regression – Two Variables
Lab Activities for Two-Variable Linear Regression
Multiple Regression
Lab Activities for Multiple Regression
Chi-Square Test of Independence
Lab Activities for Chi-Square Test of Independence
Testing Two Variances
Lab Activities for Testing Two Variances
Analysis of Variance – One-Way
Lab Activities for Analysis of Variance – One-Way
Analysis of Variance – Two-Way
Lab Activities for Analysis of Variance – Two-Way
Table of Excel Functions
Appendix AUsing With /file/687163/