Statistical Analysis with Excel For Dummies

Paperback
from $0.00

Author: Joseph Schmuller

ISBN-10: 0470454067

ISBN-13: 9780470454060

Category: Microsoft Applications

Search in google:

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. 1Statistics and Excel : a marriage made in heaven5Ch. 1Evaluating data in the real world7Ch. 2Understanding Excel's statistical capabilities21Pt. IIDescribing data35Ch. 3Show and tell : graphing data37Ch. 4Finding your center61Ch. 5Deviating from the average71Ch. 6Meeting standards and standings83Ch. 7Summarizing it all97Ch. 8What's normal?113Pt. IIIDrawing conclusions from data123Ch. 9The confidence game : estimation125Ch. 10One-sample hypothesis testing141Ch. 11Two-sample hypothesis testing155Ch. 12Testing more than two samples183Ch. 13Slightly more complicated testing207Ch. 14Regression : linear and multiple219Ch. 15Correlation : the rise and fall of relationships253Pt. IVWorking with probability271Ch. 16Introducing probability273Ch. 17More on probability295Ch. 18A career in modeling307Pt. VThe part of tens323Ch. 19Ten statistical and graphical tips and traps325Ch. 20Ten (or so) things that didn't fit in any other chapter331AppWhen your worksheet is a database357