ZCubes Wiki

Manuals/calci/STEYX

Revision as of 20:45, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''STEYX'''</font></font></font><font color="#48484...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
 STEYX(AY, AX)Where AY is the Array or range of dependent data points and AX is the independent data points.
 This function calculates the amount of error of the predicted y values for an individual x.
 
  • The Arguments can be numbers or names, arrays, or references.
  • Empty cells, logical values, text, or error values are ignored. STEYX shows error value when AY and AX are empty or have less than three
  • data points.



STEYX

B C

25 15

10 16

12 11

18 20

28 25

=STEYX(B2:B6,C2:C6) is 6.9

Syntax
Remarks
Examples
Description
Column1 Column2 Column3 Column4
Row1 25 15 6.895143
Row2 10 16
Row3 12 11
Row4 18 20
Row5 28 25
Row6
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/STEYX&oldid=607"