Skip to content

Excel Statistics

Best in textbook rentals since 2012!

ISBN-10: 1452257922

ISBN-13: 9781452257921

Edition: 2nd 2013

Authors: Neil J. Salkind

List price: $25.00
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Designed for users already familiar with basic computer operations, Neil J. Salkind’s Excel Statistics: A Quick Guide shows readers how to utilize the features of Microsoft Excel to answer both simple and complex questions about data analysis. Excel novices and experts alike will find this text not only practical but easy to use and engaging. Key features: - Each function and tool is accompanied by an Excel file, accessible through the SAGE Web site, to be used as an example of each analysis. Access these files through the SAGE website or through www.onlinefilefolder.com. - The screenshots and steps feature Microsoft Excel 2010 and are compatible with Microsoft 97–2003 and Excel 5.0/95.
Customers also bought

Book details

List price: $25.00
Edition: 2nd
Copyright year: 2013
Publisher: SAGE Publications, Incorporated
Publication date: 11/26/2012
Binding: Paperback
Pages: 160
Size: 7.50" wide x 9.50" long x 0.25" tall
Weight: 0.594
Language: English

Neil J. Salkind received his PhD from the University of Maryland in Human Development. After teaching for 35 years at the University of Kansas, he remains a professor emeritus in the department of psychology and research in education, where he continues to collaborate 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…    

How to Use This Book
Acknowledgments
About the Author
Using Excel Functions
Computing Averages
Excel QuickGuide 1 The Average Function
Excel QuickGuide 2 The Median Function
Excel QuickGuide 3 The Mode.sngl Function
Excel QuickGuide 4 The Geomean Function
Looking at Variability
Excel QuickGuide 5 The Stdev.S Function
Excel QuickGuide 6 The Stdev.P Function
Excel QuickGuide 7 The Var.S Function
Excel QuickGuide 8 The Var.P Function
Describing Data
Excel QuickGuide 9 The Frequency Function
Excel QuickGuide 10 The Norm.dist Function
Excel QuickGuide 11 The Percentile.inc Function
Excel QuickGuide 12 The Percentrank.inc Function
Excel QuickGuide 13 The Quartile.inc Function
Excel QuickGuide 14 The Rank.avg Function
Excel QuickGuide 15 The Standardize Function
Looking at Relationships
Excel QuickGuide 16 The Covariance.S Function
Excel QuickGuide 17 The Correl Function
Excel QuickGuide 18 The Pearson Function
Excel QuickGuide 19 The Intercept Function
Excel QuickGuide 20 The Slope Function
Excel QuickGuide 21 The Trend Function
Excel QuickGuide 22 The Forecast Function
Excel QuickGuide 23 The RSQ Function
Testing Independence
Excel QuickGuide 24 The Chisq.Dist Function
Excel QuickGuide 25 The Chisq.Test Function
Testing Significance
Excel QuickGuide 26 The F.Dist Function
Excel QuickGuide 27 The F.Test Function
Excel QuickGuide 28 The T.Dist Function
Excel QuickGuide 29 The T.Test Function
Excel QuickGuide 30 The Z.Test Function
Looking at Data
Excel QuickGuide 31 The Averageif Function
Excel QuickGuide 32 The Count Function
Excel QuickGuide 33 The Counta Function
Excel QuickGuide 34 The Countblank Function
Excel QuickGuide 35 The Countif Function
Using the Analysis Toolpak
Describing Data
Excel QuickGuide 36. Descriptive Statistics
Excel QuickGuide 37. Moving Average
Excel QuickGuide 38. Random Number Generation
Excel QuickGuide 39. Rank and Percentile
Excel QuickGuide 40. Sampling
Comparing Means
Excel QuickGuide 41. z-Test: Two-Sample for Means
Excel QuickGuide 42. t-Test: Paired Two-Sample for Means
Excel QuickGuide 43. t-Test: Two-Sample Assuming Unequal Variances
Excel QuickGuide 44. t-Test: Two-Sample Assuming Equal Variances
Excel QuickGuide 45. Anova: Single Factor
Excel QuickGuide 46. Anova: Two-Factor With Replication
Excel QuickGuide 47. Anova: Two-Factor Without Replication
Looking at Relationships
Excel QuickGuide 48. The Correlation Tool
Excel QuickGuide 49. The Regression Tool
Illustrating Data
Excel QuickGuide 50. The Histogram Tool
Answers to QuickGuide Questions
Using the Macintosh Excel Formula Builder
Index