LINEST is an array formula. You have to select a range of cells large enough to contain the desired information, enter the function and its arguments, then press Ctrl+Shift+enter. ask help about array formula.
Example, simple linear regression of y against x. x values in column A, say A1 to A11. Corresponding values of y in columnB, B1 to B11. select cells C1:D5; type =LINEST(B1:B11,A1:A11,,TRUE); press Ctrl+shift+enter simultaneously, you'll get the regression data. look for help LINEST to see what the cell entries mean. If you choose a larger than required range of cells, the superfluous ones are filled with #N/A.
JRosenfeld
2 Intern
•
4.4K Posts
0
November 19th, 2003 19:00
LINEST is an array formula. You have to select a range of cells large enough to contain the desired information, enter the function and its arguments, then press Ctrl+Shift+enter. ask help about array formula.
Example, simple linear regression of y against x. x values in column A, say A1 to A11. Corresponding values of y in columnB, B1 to B11. select cells C1:D5; type =LINEST(B1:B11,A1:A11,,TRUE); press Ctrl+shift+enter simultaneously, you'll get the regression data. look for help LINEST to see what the cell entries mean. If you choose a larger than required range of cells, the superfluous ones are filled with #N/A.