How to obtain R squared value from correlation matrix node in workspace?

How to obtain R squared value from correlation matrix node in workspace?

book

Article ID: KB0074229

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.0 and higher

Description

This article demonstrates how to obtain R squared value from correlation matrix node in workspace.

Environment

Windows

Resolution

1. Open Statistica example dataset (Adstudy.sta) into a workspace for illustration. Import "Correlation Matrices" node from Node browser and link to the Adstudy dataset node. 

2. Double click on Correlation Matrices node to show the parameter specification dialog.

Under "Specifications", click on "One variable list" or "Two lists (rect. matrix)" to specify the variables for correlation. 

The Missing data deletion option "MD Deletion"  is set as "Casewise" by default. "Casewise" refers to excluding cases from analysis as long as there is a missing value for that case in any of the variables specified in above dialog (both first and second variable lists).

User can change it to "Pairwise" option if only want to exclude cases with missing data in the pair of the variables that are being calculated for correlation.

3. In the Correlation Matrices parameter dialog, under "Results" | "Options", tick "Display detailed table of results" to output the table where R square value is shown. 

4. Click OK and run the workspace. In the Reporting Documents, the table "Correlations" displays the pairwise correlation information, including coefficient r, R squared value, significance of coefficient p value, etc.

Issue/Introduction

How to obtain R squared value from correlation matrix node in workspace?