apoc.math.regr

Procedure

apoc.math.regr(label STRING, propertyY STRING, propertyX STRING) - returns the coefficient of determination (R-squared) for the values of propertyY and propertyX in the given label.

Signature

apoc.math.regr(label :: STRING, propertyY :: STRING, propertyX :: STRING) :: (r2 :: FLOAT, avgX :: FLOAT, avgY :: FLOAT, slope :: FLOAT)

Input parameters

Name Type Default

label

STRING

null

propertyY

STRING

null

propertyX

STRING

null

Output parameters

Name Type

r2

FLOAT

avgX

FLOAT

avgY

FLOAT

slope

FLOAT

Usage Examples

The examples in this section are based on the following sample graph:

CREATE (:REGR_TEST {x_property: 1 , y_property: 2 })
CREATE (:REGR_TEST {x_property: 2 , y_property: 3 })
CREATE (:REGR_TEST {y_property: 10000 })
CREATE (:REGR_TEST {x_property: 3 , y_property: 6 });
CALL apoc.math.regr('REGR_TEST', 'y_property', 'x_property');
Table 1. Results
r2 avgX avgY slope

0.9854227405247813

2.0

3.6666666666666665

1.8571428571428572