Excel Statistics: A Quick Guide / Edition 2

Paperback (Print)
Rent
Rent from BN.com
$6.22
(Save 75%)
Est. Return Date: 02/24/2015
Used and New from Other Sellers
Used and New from Other Sellers
from $17.01
Usually ships in 1-2 business days
(Save 31%)
Other sellers (Paperback)
  • All (20) from $17.01   
  • New (12) from $20.54   
  • Used (8) from $17.01   

Overview

Use real data, and become a pro at using Excel for statistical analysis!

Designed for users already familiar with Excel and basic computer operations, this Second Edition of 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. Part I explores thirty-five Excel functions while Part II of the text contains fifteen Analysis Toolpak tools. The description and use of each function and tool appear on one page with corresponding screen shots of the element in action on the facing page, allowing the user to see what each function or tool looks like as it is being applied. The actual data files used in the examples are also available to readers. Excel novices and experts alike will find this text not only practical but also easy to use and engaging.

Read More Show Less

Product Details

  • ISBN-13: 9781452257921
  • Publisher: SAGE Publications
  • Publication date: 11/20/2012
  • Edition description: Second Edition
  • Edition number: 2
  • Pages: 160
  • Sales rank: 182,964
  • Product dimensions: 7.30 (w) x 9.00 (h) x 0.20 (d)

Meet the Author

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 of public support on various child and family outcomes. He has 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 recently published Encyclopedia of Research Design. He was editor of Child Development Abstracts and Bibliography for 13 years and lives in Lawrence, Kansas, where he likes to read, swim with the River City Sharks, letterpress print using 1820s technology, bake brownies (see the Excel version of Statistics for People Who (Think They) Hate Statistics for the recipe at http://www.statisticsforpeople.com), and poke around old Volvos and old houses.

Read More Show Less

Table of Contents

Part I. Using Excel Functions
1. 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
2. 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
3. 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
4. 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
5. Tests of Independence
Excel QuickGuide 24. The CHISQ.DIST Function
Excel QuickGuide 25. The CHISQ.TEST Function
6. Tests of 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
7. 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
Part II. Using the Analysis Toolpak
8. 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
9. 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
10. Looking at Relationships
Excel QuickGuide 48. The Correlation Tool
Excel QuickGuide 49. The Regression Tool
11. Illustrating Data
Excel QuickGuide 50. The Histogram Tool
Appendix A. Answers to QuickGuide Questions
Appendix B. The Formula Builder (for Mac users)
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)