January 2014
Beginner to intermediate
888 pages
25h 6m
English
Content preview from Microsoft Excel 2013: Data Analysis and Business ModelingBecome 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,
Start your free trial
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 ...