Parameter | Type | Description |
---|---|---|
ys | decimal, double | the independent variable. |
xs | decimal, double | The dependent variable |
Returns: decimal
Example
query:
SELECT REGR_AVGX(flux, time_bjd_2454833)
FROM tabbysstarflux
result:
regr_avgx |
---|
763.46 |
Calculates the linear regression coefficient for the average of x 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_AVGX(flux, time_bjd_2454833)
FROM tabbysstarflux
result:
regr_avgx |
---|
763.46 |