i am having a difficult time replicating Excel 365 trendlines for the original data set x values.
manually inputting the data set into the trendline equation that excel gave me does not
reproduce the curve that excel drew for me when i asked for a trendline.
However, inputting the data set with the x values of integers from 1 to 20 reproduces the
at least the shape of the curve that excel 365 gave me.
i am graphing the trendline with a graph type of "scatter". I tried two forms of fit.
polynomial to the second degree and logarithmic. neither can be reproduced with the original
x values.
here is the data set that i can not reproduce
x values y values
2005 0.00089
2006 0.00364
2007 0.00420
2008 0.00385
2009 0.00430
2010 0.00474
2011 0.00495
2012 0.0049shape
2013 0.00545
2014 0.00556
2015 0.00533
2016 0.00588
2017 0.00619
here is the data set that produces at least the excel curve shape
x values y values
1 0.00089
2 0.00364
3 0.00420
4 0.00385
5 0.00430
6 0.00474
7 0.00495
8 0.00497
9 0.00545
10 0.00556
11 0.00533
12 0.00588
13 0.00619
when i fit the data set with a logarithmic tendline, the equation excel
365 gave me was: y = 0.0017ln(x) + 0.0017
when i fit the data set with a polynomial trendline, the equation excel
365 gave me was: y = -3.0E-05x^2 + 0.0007x + 0.0014
Please help me understand what is going on. thank you
Bookmarks