Regr_AvgY

This function calculates the average X after excluding X and Y pairs where either X or Y is blank. The average (Y) is calculated after discarding pairs with NULL.

Syntax:

Regr_AvgY(Y, X)

Parameters:

• Y. Type: Number.
• X. Type: Number.

Example:

X	Y
1	7
2	1
3	2
4	5
5	7
6	34
7	32
8	43
9	87

SELECT Regr_AvgY(Y, X) FROM Table

Result:

24.2222222

Next page: Regr_SXX