Elementary Statistics Using Excel, Second Edition with CD / Edition 2 available in Hardcover
- Pub. Date:
In this text for students majoring in any field, Triola (mathematics, Dutchess Community College) uses Excel as a tool for introducing basic statistics, presenting topics with illustrative examples, identification of required assumptions, and underlying theory. Excel instructions are provided along with typical displays of results, based on Excel 2002. The companion CD-ROM contains a statistical package for both Windows and Macintosh, an Excel data analysis add-in, TI-83 programs, and data sets in five different formats. The only prerequisite is a previous elementary algebra course, making the text useful for students in social science, education, allied health fields, business, and liberal arts. This second edition includes new material on sampling distributions and proportions. Annotation © 2004 Book News, Inc., Portland, OR
Table of Contents1. Introduction to Statistics.
The Nature of Data.
Uses and Abuses of Statistics.
Design of Experiments.
Introduction to Excel.
2. Describing, Exploring, and Comparing Data.
Summarizing Data with Frequency Tables.
Pictures of Data.
Measures of Center.
Measures of Variation.
Measures of Position.
Exploratory Data Analysis.
Multiplication Rule: Basics.
Multiplication Rule: Complements and Conditional Probability.
Probabilities Through Simulations.
4. Probability Distributions.
Binomial Probability Distributions.
Mean, Variance, and Standard Deviation for the Binomial Distribution.
The Poisson Distribution.
5. Normal Probability Distributions.
The Standard Normal Distribution.
Nonstandard Normal Distributions: Finding Probabilities.
Nonstandard Normal Distributions: Finding Values.
The Central Limit Theorem.
Normal Distribution as Approximation to Binomial Distribution.
6. Estimates and Sample Sizes.
Estimating a Population Mean: Large Samples.
Estimating a Population Mean: Small Samples.
Determining Sample Size.
Estimating a Population Proportion.
Estimating a Population Variance.
7. Hypothesis Testing.
Fundamentals of Hypothesis Testing.
Testing a Claim about a Mean: Large Samples.
Testing a Claim about a Mean: Small Samples.
Testing a Claim about a Proportion.
Testing a Claim about a Standard Deviation or Variance.
8. Inferences from TwoSamples.
Inferences about Two Means: Independent and Large Samples.
Inferences about Two Means: Matched Pairs.
Inferences about Two Proportions.
Comparing Variation in Two Samples.
Inferences about Two Means: Independent and Small Samples.
9. Correlation and Regression.
Variation and Prediction Intervals.
10. Multinomial Experiments and Contingency Tables.
Multinomial Experiments: Goodness-of-Fit.
Contingency Tables: Independence and Homogeneity.
11. Analysis of Variance.
12. Statistical Process Control.
Control Charts for Variation and Mean.
Control Charts for Attributes.
13. Nonparametric Statistics.
Wilcoxon Signed-Ranks Test for Matched Pairs.
Wilcoxon Rank-Sum Test for Two Independent Samples.
Runs Test for Randomness.
14. Projects, Procedures, Perspectives.
A Statistics Group Project.
Which Procedure Applies?
B: Data Sets.
C: Excel References.
F: Answers to Odd-Numbered Exercises (and All Review Exercises and All Cumulative Review Exercises).