This method can be modified for the degree of the polynomial by selecting the correct amount of cells and by inserting the correct sequence in the exponent of the linest function. This puts the coefficients a,b&c in the three selected cells. =linest(known y's, known x's^,1,) and hit control shift enter. =linest(known y's, known x's, const, stats) The standard linest function is as follows: this formula must be entered as an array formula, otherwise it will not work. although i've not readily notice this technique widely publisized, here it is. I trust u have plotted data and incorporated the trendline capabilities, but how to obtain the coefficients is the question.Ī technique is by the linest function. Determining the coefficients of a polynomial equation is determined by using the "LINEST" function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |