LOGEST(known_y's [,known_x's] [,const] [,stats]) 
Returns the array of values for an exponential curve that best fits your data. 
known_y's  The set of yvalues for the equation (y = b*m^x). 
known_x's  (Optional) The set of xvalues for the equation (y = b*m^x). 
const  (Optional) True or False to indicate whether the constant b is equal to 1: True = b is calculated normally (default) False = b is set equal to 1 
stats  (Optional) True or False to indicate whether to return additional regression statistics: True = additional statistics are returned False = mcoefficients and the constant b are returned (default) 
Remarks 
* This function can return an array. * This is similar to the LINEST but uses the logarithmic mode ln(y) = xln(xm) + ln(k). * In regression analysis, calculates an exponential curve that fits your data and returns an array of values that describes the curve. Because this function returns an array of values, it must be entered as an array formula. * This function returns an array of values that best describes a relationship among the values. * If "known_y's" is in a single column, then each column of "known_x's" is interpreted as a separate variable. * If "known_y's" is in a single row, then each row of "known_x's" is interpreted as a separate variable. * The "known_x's" can include one or more sets of variables. * If only one variable is used, known_y's and known_x's can be ranges of any shape, as long as they have equal dimensions. * If more than one variable is used, known_y's must be a range of cells with a height of one row or a width of one column (which is also known as a vector). * If "known_x's" is left blank, then it is assumed to be the array {1,2,3,} that is the same size as "known_y's". * If "const" = True, then b is calculated normally. * If "const" = False, b is set equal to 1, and the mvalues are fitted to y = m^x. * If "const" is left blank, then True is used. * If "stats" = True, then additional regression statistics are returned (i.e. the array is {mn,mn1, ,m1,b;sen,sen1, ,se1,seb;r 2,sey; F,df;ssreg,ssresid} ). * If "stats" = False, then only the mcoefficients and the constant b are returned. * If "stats" is left blank, then False is used. * The more a plot of your data resembles an exponential curve, the better the calculated line will fit your data. * Formulas that return arrays must be entered as array formulas * When entering an array constant such as "known_x's" as an argument, use commas to separate values in the same row and semicolons to separate rows. Separator characters may be different depending on your country setting. * You should note that the yvalues predicted by the regression equation may not be valid if they are outside the range of yvalues you used to determine the equation. * For the Microsoft documentation refer to support.office.com 

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top