Parameter | Type | Description |
---|---|---|
ys | decimal, double | The independent variable |
xs | decimal, double | the dependent variable. |
Returns: decimal
Example
query:
SELECT REGR_AVGY(flux, time_bjd_2454833)
FROM tabbysstarflux
result:
regr_avgy |
---|
1 |
Calculates the linear regression coefficient for the average of y where x and y are not null.
Parameter | Type | Description |
---|---|---|
ys | decimal, double | The independent variable |
xs | decimal, double | the dependent variable. |
query:
SELECT REGR_AVGY(flux, time_bjd_2454833)
FROM tabbysstarflux
result:
regr_avgy |
---|
1 |