excel线性回归（Excel linear regression）.doc

excel线性回归（Excel linear regression） FORECAST function: to predict the future value The FORECAST function is based on the existing numerical calculation or prediction of future value. The expression of FORECAST function: FORECAST (x, known_ys, known_xs) X said the need to predict the parameters of data points, the parameter known_ys is the dependent variable or array data area; the parameter known_xs represents the argument array or data region. CORREL function: to calculate the correlation coefficient of the data The function of CORREL is to calculate the correlation coefficient between the two arrays. The expression of CORREL function: CORREL (array1, array2) The parameters of array1 and array2 were the first group and the second group of numerical range. GROWTH function: growth prediction index The GROWTH function is based on the data of exponential growth forecast value. The expression of GROWTH function: GROWTH (known_ys, known_xs, new_xs, const) Known_ys: meet a set of known index regression curve of y=b*m^x y. Known_xs: meet a set of known index regression curve y=b*m^x x value is optional. New_xs: a new set of X corresponding to the Y returned by the GROWTH function value. Const: is a logical value that is used to specify whether the constant B is forced to 1. LINEST function: parameter calculation of linear fitting The LINEST function is linear fitting of known data using the least squares method, parameter calculation and linear fitting. The expression of LINEST function: LINEST (known_ys, known_xs, const, stats) The known_ys parameter is known y expressions in y=mx+b value set, the parameter known_xs is the expression of known The x value set; the parameter const is a logical value specifying whether to force the constant B is 0; the parameter stats is a logical value that specifies whether to return additional regression statistics. Intercept calculating linear regression function. INTERCEPT The function of INTERCEPT is calculated through linear intersecti