Note: In order to use the spreadsheet examples, you need to download Business Functions
|BestPoly (YValues, XValues, [MaxDegPoly])|
|Find the best degree for regressing a polynomial|
|Calculates the best polynomial fit to a set of data|
BestPoly returns a number which is the order of the best match of polynomila it finds. It looks for the bestfitting polynomial. This function is called by PolyReg if you ask PolyReg to find the best fitting polynomial, and that function actually returns the parameters of the polynomial. This function just returns the order of the polynomial.
TemplatesThis function features in the following downloadable spreadsheet template(s):