Advanced Excel Statistical - STEYX Function

Description

The STEYX function returns the standard error of the predicted y-value for each x in the regression. The standard error is a measure of the amount of error in the prediction of y for an individual x.

Syntax

STEYX (known_y's, known_x's)

Arguments

Argument Description Required/Optional
Known_y's An array or range of dependent data points. Required
Known_x's An array or range of independent data points. Required

Notes

  • The equation for the standard error of the predicted y is −

    $$\sqrt{\frac{1}{2}\left [ \sum \left ( y-\bar{y} \right )^2 - \frac{\left [ \sum \left ( x-\bar{x} \right )\left ( y-\bar{y} \right ) \right ]^2}{\sum \left ( x-\bar{x} \right )^2} \right ]}$$

    Where x and y are the sample means AVERAGE (known_x’s) and AVERAGE (known_y’s), and n is the sample size.

  • Arguments can either be numbers or names, arrays, or references that contain numbers.

  • Logical values and text representations of numbers that you type directly into the list of arguments are counted.

  • 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.

  • Arguments that are error values or text that cannot be translated into numbers cause errors.

  • If known_y's and known_x's have a different number of data points, STEYX returns the #N/A error value.

    • If known_y's and known_x's are empty or have less than three data points, STEYX returns the #DIV/0! error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

Steyx Function
advanced_excel_statistical_functions.htm
Advertisements