Statistics - Statistics of Block Data - Block Columns/Rows - 75%'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 75%'s to compute the 75th percentile for each row or column 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 75%'s to compute the 75th percentile for each row or column in a selected block in the spreadsheet.

The 75th 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 - 75%'s from the Spreadsheet View shortcut menu.