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 is computed and displayed in a new spreadsheet as columns or rows. Selecting Statistics of Block Data - Block Columns displays the resulting statistic in a row and the case name includes the name of the selected statistic and the range description. Selecting Statistics of Block Data - Block Rows displays the resulting statistic in a column and the variable name contains the name of the selected statistic and the range description.

Note: 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.