{{sidenavigation.sidenavigationExpandLabel}}
{{getMsg('Help_YouAreHere')}}: {{page.title}} {{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}} {{helpModel.downloadHelpPdfDataStatus}}

Covariance

Returns the covariance value of the field which defines the measure of linear coherence of two field values.

Usage:

Covariance( fld1, fld2 )
Covariance( fld1, fld2, condFld )
Covariance( fld1, fld2, condFld, cond )

Parameters:

fld1 The first of two fields needed for calculating the covariance.
fld2 The second of two fields needed for calculating the covariance.
condFld The name of the field that groups the values of fld (if fld isn't an array).
cond A string declaring the type of grouping to be used on condFld. This only makes sense for groups based on Date, DateTime, Time, and Boolean fields. See Summary Field Conditions for a list of strings you can use here.

Returns:

A fractional number.

Examples:

//calculates the coherence of the count of the average income and the average output.
Covariance({Prod.income},{Prod.output})
//calculates the same coherence, but grouped by time
Covariance({Prod.income},{Prod.output}, {Prod.messurment_time})

Notes:

  • If the values in fld should be grouped, a group based on condFld is needed. If the group does not exist in the report, you can add it using i-net Designer or using API method: Engine.addGroup.
  • An undefined covariance due to a variance of zero will result in a value of 1.

See also:

i-net Clear Reports
This application uses cookies to allow login. By continuing to use this application, you agree to the use of cookies.


Help - Covariance