Friday, July 27, 2012

How to Use the LINEST Function in Vista and Excel


1. Highlight a set empty cells in your spreadsheet which composes 5 rows and 3 columns. Click on the 'Formulas' tab, and then select the 'More Functions' menu. Select 'Statistical' sub-menu, and then select the 'LINEST' function. The LINEST 'Function Arguments' dialog will open.
2. Click on the red arrow next to the 'Known_y's' argument, and highlight the column or row of data on your spreadsheet that represent the y-axis of your argument. Click on the downward pointing red arrow in the 'Function Arguments' dialog when done.
3. Click on the red arrow next to the 'Known_x's' argument, and highlight the column or row of data on your spreadsheet that represent the x-axis of your argument. Click on the downward pointing red arrow in the 'Function Arguments' dialog when done.
4. Type 'TRUE' without the quote marks in both the 'Const' and 'Stats' boxes. Click 'OK' to close the 'Function Arguments' dialog.
5. Highlight the formula in the formula bar, and hold down Control, Shift, and Press Enter. Starting with the top left cell and going from left to right, the following information will be calculated: slope, intercept, the standard error of all values, the standard error of all values except the last, the R-squared value, the standard error for the y estimate, the F statistic, degrees of freedom, the regression sum of squares, and the residual sum of squares.

Blogger news