How to do Row operations and calculations in TIBCO Statistica?
Article ID: KB0074417
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.
Issue/Introduction
How to do Row operations and calculations in TIBCO 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.
Feedback
Yes
No
Powered by
