Hinweis：Dieser Abschnitt ist nur in englischer Sprache verfügbar. Wir bitten um Ihr Verständnis.
3.5.2.10 Forecast
Description
Minimum Origin Version Required: 2019 SR0
This function performs linear regression on a group of XY data to calculate or predict Y at the given X value. The Y value is predicted as /math-b950071c596ff7bd093667a5ad9c91d9.png?v=0 "a + bx")
:
where,
/math-82cf10eee6fa9feaacb137cff874409c.png?v=0 "b = \frac{\sum{(x-\bar{x})(y-\bar{y})}}{\sum{(x-\bar{x})^2}}")
/math-c75b87bb81a8a965731448ed99a28db3.png?v=0 "a = \bar{y} - b \bar{x}")
/math-6fbdf291cda891b99cf211417ad1df18.png?v=0 "\bar{x}")
and /math-bacfc7141fdfd692244b6c50891d1f7b.png?v=0 "\bar{y}")
are the means of x and y.
Syntax
double Forecast( double x, vector vx, vector vy)
Parameters
x
- The x coordinate(s) for calculating y coordinate(s).
vx
- The source x coordinates used for linear regression.
vy
- The source y coordinates used for linear regression.
Return
Return the calculated or predicted y coordinate at specified x coordinate.
Example
newbook; worksheet -a 2; col(a)={0:0.5:10}; col(b)=10*col(a)-20*rnd(); col(c)={20:1:25}; col(d)=forecast(col(c),col(a),col(b));