Wednesday, November 27, 2019

Small (Returns the k-th smallest value in a data set for Statistical Purpose)












What Does It Do?
This function examines a list of values and picks the value at a user specified position in the list.
Syntax
=SMALL(ListOfNumbersToExamine,PositionToPickFrom)
Formatting
No special formatting is needed.
Example
The following table was used to calculate the bottom 3 sales figures between Jan, Feb and Mar.


















Note
Another way to find the Highest and Lowest values would have been to use the =MAX() and =MIN() functions.

No comments:

Post a Comment