Excel Statistics

Neil J. Salkind received his PhD in human development from the University of Maryland, and after teaching for 35 years at the University of Kansas, he was Professor Emeritus in the Department of Psychology and Research in Education, where he collaborated with colleagues and work with students. His early interests were in the area of children’s cognitive development, and after research in the areas of cognitive style and (what was then known as) hyperactivity, he was a postdoctoral fellow at the University of North Carolina’s Bush Center for Child and Family Policy. His work then changed direction to focus on child and family policy, specifically the impact of alternative forms of public support on various child and family outcomes. He delivered more than 150 professional papers and presentations; written more than 100 trade and textbooks; and is the author of Statistics for People Who (Think They) Hate Statistics (SAGE), Theories of Human Development (SAGE), and Exploring Research (Prentice Hall). He has edited several encyclopedias, including the Encyclopedia of Human Development, the Encyclopedia of Measurement and Statistics, and the Encyclopedia of Research Design. He was editor of Child Development Abstracts and Bibliography for 13 years. He lived in Lawrence, Kansas, where he liked to read, swim with the River City Sharks, work as the proprietor and sole employee of big boy press, bake brownies (see www.statisticsforpeople.com for the recipe), and poke around old Volvos and old houses.

"The explanations are simple, concise, thorough, and easy to follow. The book covers everything you would want a book like this to cover. It is an excellent resource…"

• PART I: Using Excel Functions1. Computing AveragesThe AVERAGE FunctionThe AVERAGE A FunctionThe MEDIAN FunctionThe MODE.SNGL FunctionThe MODE.MULT FunctionGEOMEAN Function2. Looking at VariabilityThe STDEV.S FunctionThe STDEV.P FunctionThe VAR.S FunctionThe VAR.P Function3. Describing DataThe FREQUENCY FunctionThe NORM.DIST FunctionThe PERCENTILE.INC FunctionThe PERCENTRANK.INC FunctionThe QUARTILE.INC FunctionThe RANK.AVG FunctionThe STANDARDIZE Function4. Looking at RelationshipsThe COVARIANCE.S FunctionThe CORREL FunctionThe PEARSON FunctionThe INTERCEPT FunctionThe SLOPE FunctionThe TREND FunctionThe FORECAST FunctionThe RSQ Function5. Testing IndependenceThe CHISQ.DIST FunctionThe CHISQ.TEST Function6. Testing SignificanceThe F.DIST FunctionThe CONFIDENCE.NORM FunctionThe F.TEST FunctionThe T.DIST FunctionThe T.TEST FunctionThe Z.TEST Function7. Looking at DataThe SMALL FunctionThe LARGE FunctionThe AVERAGEW IF FunctionThe COUNT FunctionThe COUNTA FunctionThe COUNTBLANK FunctionThe COUNTIF FunctionPART II: Using the Analysis ToolPak8. Describing DataDescriptive StatisticsMoving AverageRandom Number GenerationRank and PercentileSampling9. Comparing Meansz-Test: Two-Sample for Meanst-Test: Paired Two-Sample for Meanst-Test: Two-Sample Assuming Unequal Variancest-Test: Two-Sample Assuming Equal VariancesAnova: Single FactorAnova: Two-Factor With ReplicationAnova: Two-Factor Without Replication10. Looking at RelationshipsThe Correlation ToolThe Regression Tool11. Illustrating DataThe Histogram Tool