Statistics - Statistics of Block Data - Block Columns/Rows - 25%'s

Ribbon bar. Select the Statistics tab. In the Tools group, click Block Data Stats and on the Block Columns submenu or the Block Rows submenu, select 25%'s to compute the 25th percentile for each column or row in a selected block in the spreadsheet.

Classic menus. On either the Statistics - Statistics of Block Data - Block Columns submenu or the Statistics - Statistics of Block Data - Block Rows submenu, select 25%'s to compute the 25th percentile for each column or row in a selected block in the spreadsheet.

The 25th percentiles will be computed and displayed in a new spreadsheet as columns or rows. Selecting Statistics of Block Data - Block Columns will display the resulting statistic in a row and the case name will include the name of the selected statistic and the range description. Selecting Statistics of Block Data - Block Rows will display the resulting statistic in a column and the variable name will contain the name of the selected statistic and the range description.

Note that you can also access this option by right-clicking on a selected block in the spreadsheet and selecting Statistics of Block Data - Block Columns/Rows - 25%'s from the Spreadsheet View shortcut menu.