Menu
EXCEL STEYX FUNCTION
Excel STEYX Function Introduction
The Excel STEYX function computes the standard error for the line of best fit using a set of x- and y-values given.
Description of Excel STEYX Function
Syntax :
=STEYX( known_y’s, known_x’s )
Parameters :
- Known y’s – A collection of known y-values (the dependent variables).
- Known x’s – A collection of known x-values (the independent variables). (This must have the same amount of data values as the array of known y.)
Step By Step Guide of STEYX Function
Example :
The preceding spreadsheet’s cells A2-A10 and B2-B10 include a set of known x- and known y-values. These points are also plotted on a chart in the spreadsheet, along with the line of best fit through the points. The Excel Steyx function may determine the Standard Error for the line of best fit. This function has the following syntax, as illustrated in cell C12 of the sample spreadsheet: =STEYX ( B2:B10, A2:A10 ) The value 1.201186347 is returned by this function.
Key Points
- #N/A – Occurs if the known x array is not the same length as the known y array.
- #DIV/0! – Occurs if the given arrays of known x and known y contain fewer than three values.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
