Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. It appears that excel has displayed the wrong coefficients on the chart. It is not because of a lack of significant digits in the coefficients. However, the equation displayed on the chart does not appear to match the data (at all). Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. The trendline displayed on the plot looks good and even looks reasonable when extrapolated (to a point).
#EXCEL TRENDLINE IS WRONG CODE#
You can select code in your VBA window, press Tab, then copy and paste into your post or comment. To apply code formatting Use 4 spaces to start each line This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified
LINEST often gets the wrong answer for polynomials of order 3 or above.
See my explanation dated to a similar question in another discussion ( click Setting sig fig to 16 or so ought to do it for the trendline equation on the graph.
I uploaded part of the data to skydrive, please check the link below. It looks quite a bit different so there will be some relearning, but it should. However, when I tried to use the original x data to calculate y using the trendline equation, it doesn't appear right. Excel 2007 does have an Analysis ToolPak which can be added in Excel options under add-ins. I used excel to fit a curve to some data points (x,y).