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

Name

Type

Default

label

STRING?

null

propertyY

STRING?

null

propertyX

STRING?

null

Output parameters

Name	Type
r2	FLOAT?
avgX	FLOAT?
avgY	FLOAT?
slope	FLOAT?

Name

Type

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