![]() ![]() The equation for the standard error of the predicted y is: If known_y's and known_x's are empty or have less than three data points, STEYX returns the #DIV/0! error value. If known_y's and known_x's have a different number of data points, STEYX returns the #N/A error value. 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.Īrguments that are error values or text that cannot be translated into numbers cause errors. Logical values and text representations of numbers that you type directly into the list of arguments are counted. An array or range of independent data points.Īrguments can either be numbers or names, arrays, or references that contain numbers. An array or range of dependent data points. The STEYX function syntax has the following arguments: The standard error is a measure of the amount of error in the prediction of y for an individual x. Returns the standard error of the predicted y-value for each x in the regression. This article describes the formula syntax and usage of the STEYX function in Microsoft Excel. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More.
0 Comments
Leave a Reply. |