How to do Row operations and calculations in TIBCO Statistica?

How to do Row operations and calculations in TIBCO Statistica?

book

Article ID: KB0074417

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.1 and higher

Description

This article provides an alternative workaround to do row operations and calculations in Statistica. 

Environment

Windows

Resolution

Statistica supports column operations and calculations in spreadsheets. 

To do Row operations/calculations in Statistica, for example, in below table, calculate Row2/Row1 and store the calculated values in a new Row,

1. Go to Statistica "Data | Transpose | Transpose File", rows will become column variables. 

2. Create a new column variable, in the long name text box, enter the calculation formula, e.g. =V2/V1

3. Click OK. The new column variable is then calculated.

4. Go to "Data | Transpose | Transpose File", the table is restored with newly calculated row. 

Issue/Introduction

How to do Row operations and calculations in TIBCO Statistica?