Elementary Statistics Using Excel

by Triola, Mario F.

• ISBN13: 9780321365132
• ISBN10: 0321365135
• Edition: 3rd
• Format: Hardcover w/Disk
• Copyright: 2007-01-01
• Publisher: Addison Wesley

Summary

The following supplements from Addison-Wesley are designed to help you succeed in your statistics course. The CD-ROM bound inside the back cover of every new textbook includes STATDISK, statistical software for both Windows and Macintosh; DDXL, an Excel add-in; and TI-83/84 Plus programs. Data sets are included in formats for Microsoft Excel, MINITAB, SPSS, SAS, and ASCII, and in a TI-83/84 Plus graphing calculator application. Book jacket.

Table of Contents

Introduction to Statistics	2	(46)
Overview	4	(1)
Types of Data	5	(6)
Critical Thinking	11	(10)
Design of Experiments	21	(12)
Introduction to Excel	33	(15)
Summarizing and Graphing Data	48	(42)
Overview	50	(1)
Frequency Distributions	50	(11)
Histograms	61	(8)
Statistical Graphics	69	(21)
Statistics for Describing, Exploring, and Comparing Data	90	(64)
Overview	92	(1)
Measures of Center	92	(17)
Measures of Variation	109	(18)
Measures of Relative Standing	127	(10)
Exploratory Data Analysis (EDA)	137	(17)
Probability	154	(64)
Overview	156	(1)
Fundamentals	156	(14)
Addition Rule	170	(8)
Multiplication Rule: Basics	178	(9)
Multiplication Rule: Complements and Conditional Probability	187	(6)
Probabilities Through Simulations	193	(5)
Counting	198	(11)
Bayes' Theorem (on CD-ROM)	209	(9)
Discrete Probability Distributions	218	(46)
Overview	220	(1)
Random Variables	221	(13)
Binomial Probability Distributions	234	(12)
Mean, Variance, and Standard Deviation for the Binomial Distribution	246	(5)
Poisson Probability Distributions	251	(13)
Normal Probability Distributions	264	(76)
Overview	266	(1)
The Standard Normal Distribution	267	(13)
Applications of Normal Distributions	280	(9)
Sampling Distributions and Estimators	289	(12)
The Central Limit Theorem	301	(11)
Normal as Approximation to Binomial	312	(10)
Assessing Normality	322	(18)
Estimates and Sample Sizes	340	(68)
Overview	342	(1)
Estimating a Population Proportion	342	(18)
Estimating a Population Mean: σ Known	360	(12)
Estimating a Population Mean: σ Not Known	372	(15)
Estimating a Population Variance	387	(21)
Hypothesis Testing	408	(74)
Overview	410	(1)
Basics of Hypothesis Testing	411	(20)
Testing a Claim About a Proportion	431	(11)
Testing a Claim About a Mean: σ Known	442	(9)
Testing a Claim About a Mean: σ Not Known	451	(12)
Testing a Claim About a Standard Deviation or Variance	463	(19)
Inferences from Two Samples	482	(62)
Overview	484	(1)
Inferences About Two Proportions	484	(13)
Inferences About Two Means: Independent Samples	497	(16)
Inferences from Matched Pairs	513	(11)
Comparing Variation in Two Samples	524	(20)
Correlation and Regression	544	(80)
Overview	547	(1)
Correlation	547	(24)
Regression	571	(18)
Variation and Prediction Intervals	589	(12)
Multiple Regression	601	(10)
Modeling	611	(13)
Multinomial Experiments and Contingency Tables	624	(48)
Overview	626	(1)
Multinomial Experiments: Goodness-of-Fit	627	(15)
Contingency Tables: Independence and Homogeneity	642	(15)
McNemar's Test for Matched Pairs	657	(15)
Analysis of Variance	672	(40)
Overview	674	(1)
One-Way ANOVA	675	(17)
Two-Way ANOVA	692	(20)
Nonparametric Statistics	712	(60)
Overview	714	(2)
Sign Test	716	(12)
Wilcoxon Signed-Ranks Test for Matched Pairs	728	(6)
Wilcoxon Rank-Sum Test for Two Independent Samples	734	(7)
Kruskal-Wallis Test	741	(6)
Rank Correlation	747	(10)
Runs Test for Randomness	757	(15)
Statistical Process Control	772	(28)
Overview	774	(1)
Control Charts for Variation and Mean	774	(14)
Control Charts for Attributes	788	(12)
Projects, Procedures, Perspectives	800	(9)
Projects	800	(5)
Procedures	805	(2)
Perspectives	807	(2)
Appendices	809	(92)
Appendix A: Tables	810	(17)
Appendix B: Data Sets	827	(24)
Appendix C: Excel References	851	(2)
Appendix D: Glossary	853	(8)
Appendix E: Bibliography	861	(1)
Appendix F: Answers to Odd-Numbered Exercises (and All Review Exercises and All Cumulative Review Exercises)	862	(39)
Credits	901	(2)
Index	903