Main > Knowledge Base > 1C:Enterprise documentation > 1C:Enterprise User Manual > Appendix 1. Data composition system expression language > Aggregate functions > Regr_SXY > 1C:Enterprise documentation > 1C:Enterprise User Manual > Appendix 1. Data composition system expression language > Aggregate functions > Regr_SXY > 1C:Enterprise documentation > 1C:Enterprise User Manual > Appendix 1. Data composition system expression language > Aggregate functions > Regr_SXY

Regr_SXY

This function calculates the following expression: Regr_Count(Y, X) * Var_Pop(Y, X). The value is calculated after discarding all pairs with NULL.

Syntax:

Regr_SXY(Y, X)

Parameters:

Example:

X

Y

1

7

2

1

3

2

4

5

5

7

6

34

7

32

8

43

9

87

SELECT Regr_SXY(Y, X) FROM Table

Result:

535

Next page: Rank




© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.