![]() Right-click the trendline equation or the R-squared text, and then click Format. To display a greater number of digits, use one of the following methods: Method 1: Microsoft Office Excel 2007 Open the worksheet that contains the chart. Also, I discovered that LINEST only seems to work if the X and Y data are in columns (not rows), with no empty cells within the range, so be aware of that if you get a #VALUE error. The trendline equation and R-squared value are initially displayed as rounded to five digits. I did notice that the three coefficients are very close but not quite identical to those derived by using the graphical trendline feature under the charts tab. ![]() Lastly, in the next cell over, again type the same formula but change the last number to a 3. ![]() In an adjacent cell, type the same formula again but change the final 1 to a 2. of course you'd change these ranges appropriately to match your data). Using the formula: =LINEST(B2:B21, A2:A21^1.2)Įxcel's LINEST function can also calculate multiple regressions, with different exponents on x at the same time, e.g.: =LINEST(B2:B21,A2:A21^,TRUE,FALSE),1) (by the way, the B2:B21 and A2:A21 I used are just the same values the first poster who answered this used. You can also use Excel to calculate a regression with a formula that uses an exponent for x different from 1, e.g. ![]() Which returns a single value, the linear slope ( m) according to the formula: You need to use an undocumented trick with Excel's LINEST function: =LINEST(known_y's,, , )Ī regular linear regression is calculated (with your data) as: =LINEST(B2:B21,A2:A21) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |