Statistics - Statistics of Block Data - Block Columns/Rows - All

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 All to compute all of the Statistics of Block Data 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 All to compute all of the Statistics of Block Data for each row or column in a selected block in the spreadsheet.

The statistics will be computed and displayed in a new spreadsheet as columns or rows. Selecting Statistics of Block Data - Block Columns will display the resulting statistics in rows and each case name will include the name of the statistic and the range description. Selecting Statistics of Block Data - Block Rows will display the resulting statistics in columns and each variable name will contain the name of the 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 - All from the Spreadsheet View shortcut menu.