It would be great if you can help explain it in more detail Thank you for looking into this! I'm not sure how the above formula forms though, like why would we need to subtract 1 in the logest formula? (sorry I am really new to logest formula ><). Again, exactly how this is interpreted as a percentage or a growth rate or a decay rate depends on exactly what known_ys represent.įrom there, we've probably got to see exactly how you are using these formulas and understand exactly what you are trying to do with these regressions. Your second formula takes the known_ys range, performs the regression to get m, uses the COLUMNS() or ROWS() function to determine how many entries are in known_ys, raises m to that power less 1, the subtracts 1 from the final result. Exactly what that means for your particular problem depends on exactly what your known_ys represent. So the first formula takes your known_ys range, performs the regression to get m, then subtracts 1 from the resulting m. When you use the function as a non=array function, it ony returns the m result and b is discarded. When you only provide one range of values (for the known_ys argument), Excel assumes values for known_xs. Since both formulas are based on the LOGEST() function, maybe start by understanding the LOGEST() function: The LOGEST() function performs a linear regression and returns m and b for the equation ln(y)=ln(b)+x*ln(m). Your file does not include either of those formulas, so I'm not exactly sure how you are using them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |