Category Books

Statistical Analysis with Excel For Dummies »

Authors: Joseph Schmuller
ISBN-13: 9780470454060, ISBN-10: 0470454067
Format: Paperback
Publisher: Wiley, John & Sons, Incorporated
Date Published: June 2009
Edition: (Non-applicable)

Author Biography: Joseph Schmuller

Joseph Schmuller, PhD, is a technical architect at Blue Cross-Blue Shield of Florida. A former member of the American Statistical Association, he has taught statistics at the undergraduate, honors undergraduate, and graduate levels, and has been honored with an award for excellence in teaching.

Book Synopsis

Schmuller's (U. of North Florida) addition to the For Dummies series is an introduction to using Excel's statistical tools. He discusses how to use and graph data; probability; means, median and averages; hypotheses and testing; correlation; and modeling. In addition, he explains using databases in Excel. There is no bibliography. Annotation ©2005 Book News, Inc., Portland, OR

Pt. 1	Statistics and Excel : a marriage made in heaven	5
Ch. 1	Evaluating data in the real world	7
Ch. 2	Understanding Excel's statistical capabilities	21
Pt. II	Describing data	35
Ch. 3	Show and tell : graphing data	37
Ch. 4	Finding your center	61
Ch. 5	Deviating from the average	71
Ch. 6	Meeting standards and standings	83
Ch. 7	Summarizing it all	97
Ch. 8	What's normal?	113
Pt. III	Drawing conclusions from data	123
Ch. 9	The confidence game : estimation	125
Ch. 10	One-sample hypothesis testing	141
Ch. 11	Two-sample hypothesis testing	155
Ch. 12	Testing more than two samples	183
Ch. 13	Slightly more complicated testing	207
Ch. 14	Regression : linear and multiple	219
Ch. 15	Correlation : the rise and fall of relationships	253
Pt. IV	Working with probability	271
Ch. 16	Introducing probability	273
Ch. 17	More on probability	295
Ch. 18	A career in modeling	307
Pt. V	The part of tens	323
Ch. 19	Ten statistical and graphical tips and traps	325
Ch. 20	Ten (or so) things that didn't fit in any other chapter	331
App	When your worksheet is a database	357