How can values be standardized in a block?

How can values be standardized in a block?

book

Article ID: KB0081509

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.0 and above

Description

This article explains how to standardize values in a block.
 

Resolution

1. Select a block of values in the spreadsheet, right-click, 

2. Select either Fill/Standardize Block - Standardize Columns or Fill/Standardize Block - Standardize Rows from the shortcut menu. The standardized values are computed as follows:

Standard Value = (raw value - mean of highlighted row/column)/standard deviation.

Note: Selected variables can also be standardized by selecting Data|Standardize. This procedure operates independent of the currently selected block, but takes into account the current case selection conditions and weights.

Issue/Introduction

How can values be standardized in a block?