| 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 tabbysstarfluxresult:
| 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 tabbysstarfluxresult:
| regr_avgx | 
|---|
| 763.46 |