Excel trendline equation more decimals7/31/2023 in the chart, to see more digits, right-click on the trendline equation box and change the format of the numbers (for ex. 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 |