STEYX

Syntax:

STEYX ( known-ys , known-xs )

Description: Computes 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.

Mathematical Formula:

where x and y are the sample means AVERAGE(known-xs) and AVERAGE(known-ys), and n is the sample size.

Arguments:

Name

Type

Description

known-xs

number, name, array, or reference to number, text, logical

Designate a set of numeric dependent data points. Logical values and text representations of numbers entered directly into the list of arguments are included. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.

known-ys

number, name, array, or reference to number, text, logical

Designate a set of numeric independent data points. Logical values and text representations of numbers entered directly into the list of arguments are included. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.

Return Type and Value: number – The standard error of the predicted y-value for each x in the regression.

However, if

  • known-ys and known-xs have a different number of data points, the return value is unspecified.

  • known-ys and known-xs are empty or have less than three data points, the return value is unspecified.

example: