Navigation:  Formula Reference > Spreadsheet Formula Functions >

STEYX

Previous pageReturn to chapter overviewNext page

 

This function returns the standard error of the predicted y value for each x. The standard error is a measure of the amount of error in the prediction of y for a value of x.

Syntax

STEYX(array_dep,array_ind)

Arguments

This function has these arguments:

Argument

Description

array_dep

Array of dependent values (y’s)

array_ind

Array of independent values (x’s)

The arrays must be the same size.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

STEYX(A1:A17,B1:B17)

STEYX({22,33,49,21,32,37,43},{31,28,29,42,35,37,34]) gives the result 10.14406

 

See Also

ERF

PEARSON