Elementary Statistics Using Excel

• ISBN13:

• ISBN10:

0201699427

• Edition: CD
• Format: Hardcover w/CD
• Copyright: 1/1/2001
• Publisher: Addison Wesley
• View Upgraded Edition
• Purchase Benefits
• Free Shipping On Orders Over \$59!
Your order must be \$59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
• Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: \$106.00

Summary

"Elementary Statistics Using Excel" is a complete introduction to basic statistics, with a strong emphasis on understanding statistics concepts and the inclusion of Excel spreadsheet technology for the analysis of data. Statistics topics are presented with illustrative examples, many which use real data; identification of required assumptions; and underlying theory. Extensive Excel instructions are provided along with typical displays of results, as well as information about Excel' s limitations and alternative approaches. DDXL (Version 2.0), a software add-in that enhances and expands the capability of Excel, and Appendix B data sets in the form of Excel workbooks are featured on the CD-ROM included with each copy of the book.

Table of Contents

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