About: This article introduces the Quantile node, a Compile node within Construct.
Location: Node panel
Table of Contents
Feature Overview
The Quantile node creates a new column indicating the relative location of a record based on the other records in the same field. The quantile assignment is created by ranking the data in the selected field, and then splitting the records into X equal groups based on the number of quantiles the user selects.
For example, a Decile creates ten groups. The default number of quantiles is Decile (10). In the example above, a Decile is created based on the GPA variable. A record that is assigned to the 1st Decile is ranked in the top 10% of the dataset. Quantiles can also be assigned in Ascending or Descending order. In the same example above, if the Sort Order was changed to Descending, a record assigned to the 1st Decile would be ranked in the bottom 10% of the dataset.
Below is a list of all of the quantile options:
- Quartile (4)
- Quintile (5)
- Nonile (9)
- Decile (10)
- Vingtile (20)
- Percentile (100)
To create a Quantile, choose the variable that you want to be ranked and grouped into quantiles, choose the # of Quantiles and name the new variable (or leave it as the default name) under New Quantile Column Name.
Video Tutorial
Comments
0 comments
Article is closed for comments.