STEYX(known_y's, known_x's)

Returns the standard error of a regression.

known_y'sThe array or range of dependent data points.
known_x'sThe array or range of dependent data points.

Remarks

* The standard error is a measure of the amount of error in the prediction of y for an individual x.
* The arguments must be either numbers or names, arrays, or references that contain numbers.
* If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
* If "known_y" and "known_x" are empty or have a different number of data points, then #N/A is returned.
* For the Microsoft documentation refer to support.office.com

 A
1=STEYX({2,3,9,1,8,7,5},{6,5,11,7,5,4,4}) = 3.306


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top