![]() ![]() If this is something you will do frequently, I would recommend that you become familiar with using the LOGEST() (or LINEST()) function: įrom there, I'm not sure what to suggest, without a better idea of what you are having trouble with. Pointer 2: This is the same equation as the LOGEST() function uses (technically y=B*M^x or ln(y)=ln(B)+x*ln(M) but you should be able to show that these are equivalent). If you are going to use chart trendlines, always expand the number format to show more significant figures. Below, you will find a brief description of each trendline type with chart examples. R-squared value measures the trendline reliability - the nearer R 2 is to 1, the better the trendline fits the data. That could be 3.00000E+7 or that could be 2.500000E+7 or that could be 3.40000E+7. Trendline equation is a formula that finds a line that best fits the data points. Pointer 1: What is the exact value of A? Excel's chart trendlines have a bad habit of giving results to one or two significant figures, like in this case. ![]() ![]() ![]() What specifically are you having trouble with? It looks like a straightforward exponential equation y=B*exp(Mx) (you should be able to show that this is the same as ln(y)=ln(B)+Mx, which is the actual "linear" equation the regression algorithm uses). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |