Elementary Statistics Using Excel

by Triola, Mario F.

• ISBN13: 9780201775693
• ISBN10: 0201775697
• Edition: 2nd
• Format: Hardcover
• Copyright: 2004-01-01
• Publisher: Addison Wesley

Table of Contents

Introduction to Statistics	p. 2
Overview	p. 4
The Nature of Data	p. 5
Uses and Abuses of Statistics	p. 11
Design of Experiments	p. 16
Introduction to Excel	p. 25
Describing, Exploring, and Comparing Data	p. 40
Overview	p. 42
Summarizing Data with Frequency Tables	p. 43
Pictures of Data	p. 52
Measures of Center	p. 68
Measures of Variation	p. 83
Measures of Position	p. 99
Exploratory Data Analysis (EDA)	p. 109
Probability	p. 126
Overview	p. 128
Fundamentals	p. 128
Addition Rule	p. 143
Multiplication Rule: Basics	p. 150
Multiplication Rule: Complements and Conditional Probability	p. 159
Probabilities Through Simulations	p. 166
Counting	p. 170
Probability Distributions	p. 194
Overview	p. 196
Random Variables	p. 197
Binomial Probability Distributions	p. 211
Mean, Variance, and Standard Deviation for the Binomial Distribution	p. 221
The Poisson Distribution	p. 226
Normal Probability Distributions	p. 240
Overview	p. 242
The Standard Normal Distribution	p. 242
Normal Distributions: Finding Probabilities	p. 256
Normal Distributions: Finding Values	p. 264
The Central Limit Theorem	p. 270
Normal Distribution as Approximation to Binomial Distribution	p. 282
Determining Normality	p. 294
Estimates and Sample Sizes	p. 310
Overview	p. 312
Estimating a Population Mean: Large Samples	p. 312
Estimating a Population Mean: Small Samples	p. 328
Determining Sample Size Required to Estimate [mu]	p. 339
Estimating a Population Proportion	p. 345
Estimating a Population Variance	p. 358
Hypothesis Testing	p. 380
Overview	p. 382
Fundamentals of Hypothesis Testing	p. 383
Testing a Claim about a Mean: Large Samples	p. 397
Testing a Claim about a Mean: Small Samples	p. 416
Testing a Claim about a Proportion	p. 427
Testing a Claim about a Standard Deviation or Variance	p. 435
Inferences from Two Samples	p. 454
Overview	p. 456
Inferences about Two Means: Independent and Large Samples	p. 456
Inferences about Two Means: Matched Pairs	p. 467
Inferences about Two Proportions	p. 476
Comparing Variation in Two Samples	p. 487
Inferences about Two Means: Independent and Small Samples	p. 496
Correlation and Regression	p. 520
Overview	p. 522
Correlation	p. 522
Regression	p. 541
Variation and Prediction Intervals	p. 554
Multiple Regression	p. 565
Modeling	p. 573
Multinomial Experiments and Contingency Tables	p. 588
Overview	p. 590
Multinomial Experiments: Goodness-of-Fit	p. 591
Contingency Tables: Independence and Homogeneity	p. 605
Analysis of Variance	p. 630
Overview	p. 633
One-Way ANOVA	p. 635
Two-Way ANOVA	p. 648
Statistical Process Control	p. 670
Overview	p. 672
Control Charts for Variation and Mean	p. 672
Control Charts for Attributes	p. 686
Nonparametric Statistics	p. 700
Overview	p. 702
Sign Test	p. 705
Wilcoxon Signed-Ranks Test for Matched Pairs	p. 715
Wilcoxon Rank-Sum Test for Two Independent Samples	p. 721
Kruskal-Wallis Test	p. 729
Rank Correlation	p. 738
Runs Test for Randomness	p. 748
Projects, Procedures, Perspectives	p. 773
A Statistics Group Project	p. 773
Which Procedure Applies?	p. 776
A Perspective	p. 778
Appendices	p. 780
Tables	p. 781
Data Sets	p. 799
Excel References	p. 825
Glossary	p. 827
Bibliography	p. 833
Answers to Odd-Numbered Exercises (and All Review Exercises and All Cumulative Review Exercises)	p. 834
Credits	p. 865
Index	p. 867
Table of Contents provided by Syndetics. All Rights Reserved.