Talk:Documentation/Calc Functions/STEYX
SF comments
- (1) General. The information at https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_STEYX_function may be helpful.
- (2) Summary. Suggest the following replacement – “Fits a straight line to supplied data using linear regression and returns the standard error of actual y-values compared to y-values on the straight line found”.
- (3) Arguments, DataY. Is a matrix different from an array in this context? Suggest change “the predicted values” to “real values representing the y-components of points in a data set”.
- (4) Arguments, DataX. Is a matrix different from an array in this context? Suggest change “the values for which the corresponding y values are predicted” to “real values representing the x-components of points in a data set”.
- (5) Arguments, 1st bullet. It would be worth clarifying what the text “Numbers can also be entered directly” refers to.
- (6) Arguments, 2nd bullet. As with other functions where similar text occurs, I am not sure whether “a name/array/reference to” is necessary or not. Also, are we sure that logical values like TRUE and FALSE are ignored?
- (7) Arguments, 3rd bullet. Change “has” to “contains” and “considers” to “includes”.
- (8) Arguments, 4th bullet. I suspect that “length” should be changed to “dimensions” and “is” should be changed to “are”.
- (9) Additional details. Please advise where this formula comes from – it is not the same as that in the ODF or that on the relevant Microsoft page.
- (10) Examples, 1st example. Error in formula – semicolon after B1 should be a colon. Also change “reference to a range of cells” to “references to ranges of cells”.
- (11) Examples, 2nd example. “array” should be plural.
--Stevefanning (talk) 2020-11-06T16:21:57 (UTC)
Ronnie
all points addressed.
--Ronnie rg8888 (talk) 2020-11-29T16:50:57 (UTC)