The CORRELATION function calculates the correlation coefficient between two numeric fields. The function returns a numeric value between zero (0.0) and 1.0.

CORRELATION(field1,field2)

where:

`field1`-
Numeric

Is the first set of data for the correlation.

`field2`-
Numeric

Is the second set of data for the correlation.

The following request calculates the correlation between the DOLLARS and BUDDOLLARS fields converted to double precision.

DEFINE FILE ibisamp/ggsales DOLLARS/D12.2 = DOLLARS; BUDDOLLARS/D12.2 = BUDDOLLARS; END TABLE FILE ibisamp/ggsales SUM DOLLARS BUDDOLLARS CORRELATION(DOLLARS, BUDDOLLARS) ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * GRID=OFF,$ ENDSTYLE END

The output is shown in the following image.

WebFOCUS | |

Feedback |