Skip to Main Content
Microsoft® Excel® 2010: Data Analysis and Business Modeling
book

Microsoft® Excel® 2010: Data Analysis and Business Modeling

by Wayne L. Winston
January 2011
Beginner to intermediate content levelBeginner to intermediate
720 pages
23h 29m
English
Microsoft Press
Content preview from Microsoft® Excel® 2010: Data Analysis and Business Modeling

Chapter 42. Summarizing Data by Using Descriptive Statistics

Questions answered in this chapter:

  • What defines a typical value for a data set?

  • How can I measure how much a data set spreads from its typical value?

  • Together, what do the mean and standard deviation of a data set tell me about the data?

  • How can I use descriptive statistics to compare data sets?

  • For a given data point, can I easily find its percentile ranking within the data set? For example, how can I find the ninetieth percentile of a data set?

  • How can I easily find the second largest or second smallest number in a data set?

  • How can I rank numbers in a data set?

  • What is the trimmed mean of a data set?

  • When I select a range of cells, is there an easy way to get a variety of statistics that ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition

Wayne L. Winston
Microsoft® Excel 2010 On Demand

Microsoft® Excel 2010 On Demand

Steve Johnson - Perspection Inc.

Publisher Resources

ISBN: 9780735656864Purchase book