NTILES subcommand (FREQUENCIES command)

NTILES calculates the percentages that divide the distribution into the specified number of categories and displays the values below which the requested percentages of cases fall. There are no default ntiles.

  • Multiple NTILES subcommands are allowed. Each NTILES subcommand generates separate percentiles. Any duplicate percentiles generated by different NTILES subcommands are consolidated in the output.

Basic Example

FREQUENCIES VARIABLES=V1 /NTILES=4.
  • FREQUENCIES requests quartiles (percentiles 25, 50, and 75) for V1.

Working With Multiple NTILES Subcommands

FREQUENCIES VARIABLES=V1 /NTILES=4 /NTILES=10.
  • The first NTILES subcommand requests percentiles 25, 50, and 75.
  • The second NTILES subcommand requests percentiles 10 through 90 in increments of 10.
  • The 50th percentile is produced by both specifications but is displayed only once in the output.