O'Reilly logo

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 37. Summarizing Data by Using Descriptive Statistics

  • 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 90th 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 describe the data in those cells?

  • Why do ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required