If set to FALSE, b is excluded by essentially setting it to 1. If the last argument 'constant' is set to TRUE, you want the regression model to include the multiplicative coefficient b in the regression model. , mp are determined that give the best fit to the y data. The GROWTH Help file discusses rare cases where the second or third argument may be omitted.Īssuming that there are p predictor variables, GROWTH essentially calls LOGEST. Known_y's represent data on the 'dependent variable' and known_x's represent data on one or more 'independent variables'.

A least squares criterion is used, and GROWTH tries to find the best fit under that criterion. The GROWTH(known_y's, known_x's, new_x's, constant) function is used to perform a regression analysis where an exponential curve is fitted. Any information in this article that describes how a function works or how a function was modified for Excel 2003 or for later versions of Excel also applies to Excel 2004 for Mac. The statistical functions in Excel 2004 for Mac were updated by using the same algorithms that were used to update the statistical functions in Excel 2003 and in later versions of Excel. Microsoft Excel 2004 for Macintosh information

Extensive changes to LINEST for Excel 2003 and for later versions of Excel are summarized, and their implications for GROWTH are noted. GROWTH is evaluated by calling the related function, LINEST. This article describes the GROWTH function in Microsoft Office Excel 2003 and in later versions of Excel, illustrates how the function is used, and compares results of the function for Excel 2003 and for later versions of Excel with results of GROWTH in earlier versions of Excel. Excel statistical functions: GROWTH Summary

How to get the linest on excel for mac