This function converts cell values into a number that represents which “bucket” of N buckets, where you specify the value for N. It’s calculated by examining the minimum and the maximum values of the designated axis, and then divided into N equal sized “buckets.”
Syntax:
ChangeValuesToNTile, boolSortAscending, axis, numberFractiles
Parameters:boolSortAscending– lowest values go into bucket 1 (true) or highest values (false)axis – which axis will be used { Row, Column, Page } numberFractiles - Number of even sized divisions between min and max
Examples:
ChangeValuesToNTile,false,Row,4
The example calculates the numeric range between the minimum and maximum value on each row and divides it into 4 groups, group 1 being the lowest range. Then for each cell in the row, it determines which group the cell falls in and puts the group number in the cell.
Comments:
There are many terms used for this kind of operation such as histograms and fractiles. More specifically, the results can be referred to as things like “decile” “quartile” etc.
|
