STATISTICA Blogs

If you need to sum rows, you can add a new Total variable to your STATISTICA spreadsheet. Then you use a formula to sum the data.

If you use Excel, you are probably familiar with this idea. The Total variable is a "calculated" variable. And because you are using a formula, there is great flexibility in creating the total. The variables don't have to be next to each other. You could add variable 10 to variable 22.

Here is a quick example based on an example dataset. The  STATISTICA application comes with hundreds of example datasets.

I opened the Cat Clinic Measurements (2000).sta data file via the File - Open Examples menu - Datasets folder.

Next right click on a variable name. This pops open a context menu. Select Add Variables...

Now you can add the Total variable and formula to calculate it. All variables can be referenced as V1, V2, V3, etc... Or you can use their variable name.

I decided to add my variable after variable 4 (V4). I named it Total. I am creating a sum of variable 2 and variable 3. I could have also written the formula as "=V2+V3".

Related Blogs:

How to sum rows in STATISTICA using block statistics