![]() You can get the coefficients directly in the worksheet using Linest(). ![]() With these equation you'll get a much better result. I calculated in the worksheet coefficients for the equation and got (displaying with 10 significant digits), setting the intercept to 0 as I believe you also did: You have data with 9 significant digits and are using coefficients in you equation with 1 or 2 significant digits! This means that you cannot trust the values your equation calculates. I'll post the scatterploy and calculated data below, let me know if any further information is needed. I don't know what I'm missing here, please help if you can. ![]() ![]() ![]() The problem I'm getting is that when I try to graph my calculated cells, I get a totally different graph from my original trendline. I then put this formula into cells in order to plot where I fall on the trenline for a given timeframe in my attrition model (e.g. I have made a scatterplot of employee attrition, and I've also created (using excel) a 4th degree polynomial trendline that best matches the data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |