Index linest r2
I happened to visit your site while I am drafting my web page for a program (finding the best fit regression equation out of 9 equations) and to display the trend line of best fit on X-Y chart) in order to explain Linest function and Index function referring to Linest function's result matrix. LINEST in Excel Example #2 – Simple Linear Regression. = SUM (LINEST(B1:B6, A1:A6)*{9,1}) As shown in the above LINEST formula in excel, A1:A6 is the month number and B2:B6 indicates the corresponding sales figures. So, based on the sales data of 6 months, sales data for the 9 th month is to be estimated.