Now that you have the coefficients you can calculate the maximum. The formula calculates the linear least squares regression and fills all selected cells simultaneously. It's an array function which means that you select several cells, enter the formula and press Ctrl+Shift+Enter to enter it simultaneously into all cells. Use the LINEST function which calculates a linear regression. To do something with the coefficients, you will have to calculate them yourself. The trendline generated automatically by Excel only draws the line and prints the calculated coefficients. Looking at your picture, it seems that you have very few points and finding the largest of them is not enough.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |