hi hi,
let's say you had a graph of X,Y points plotted in excel, with a polynomial trendline defined for the data (in this case it's age of car plotted against price). does anyone know if it's possible to use the trendline as a function or in a formula, so you can bung X values into it and it'll return Y values? in this instance i know it isn't that much more efficient than looking at the trendline manually, but it would be a useful thing to know how to do (if possible).
i've actually got three sets of data on my graph (autotrader data, pistonheads data and approved dealer data) so this would more easily allow for relative price comparison
thanks!
let's say you had a graph of X,Y points plotted in excel, with a polynomial trendline defined for the data (in this case it's age of car plotted against price). does anyone know if it's possible to use the trendline as a function or in a formula, so you can bung X values into it and it'll return Y values? in this instance i know it isn't that much more efficient than looking at the trendline manually, but it would be a useful thing to know how to do (if possible).
i've actually got three sets of data on my graph (autotrader data, pistonheads data and approved dealer data) so this would more easily allow for relative price comparison
thanks!