Dragging across the values to include them in theformula is just a convenience, you can simply type the "linest" statementif you wish. " 0" in place ofthe second " 1" cuts off uncertaintiesin A, B, C. If you type " 0"in place of the first " 1" it forcesA to be zero. Now type " ,1,1)" and holddown the open-apple key (next to the space bar) while you hit Enter. values from upper left to lower right tohilite the whole block - this is just one column if you have a linearequation - and now the text should look like " = linest(B2:B12,C2:C12" or " = linest(B2:B12,C2:E12"if you have cubic terms. Type a comma, then drag across all of the X,X^2, X^3. Type " = linest(" andthen drag down to hilite your column of Y-values- this should now look like " = linest(B2:B12". Have your Y values ina vertical column (column B), the Xvalues in the next column to the right (column C), the X^2values to the right of the X values (column D), etc.īelow this block of numbers select a block just as wideas that one and 2 to 4 rows high - so if you just have Yand X values (linear equation)the new highlighted block is 2 columns by 2 to 4 rows. To use Excel to fit an equation by LinearLeast Squares Regression: Y = A + BX + CX^2+ DX^3 +.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |