This example is based the following regrtbl data. Nulls are indicated by the QUESTION MARK character.
c1 height weight -- ------ ------ 1 60 84 2 62 95 3 64 140 4 66 155 5 68 119 6 70 175 7 72 145 8 74 197 9 76 150 10 76 ? 11 ? 150 12 ? ?
The following SELECT statement returns the sum of products of height and weight where neither height nor weight is null.
SELECT REGR_SXY(weight,height) FROM regrtbl; Regr_Sxy(weight,height) ----------------------- 1200