Manuals/calci/STEYX

From ZCubes Wiki
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)
Jump to navigation Jump to search
 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"