excel trendline formula is inaccurate

While trying to create a graph with trendline to predict what a thermistor reading for a Prius’s radiator/engine temperature would be at certain temperatures I started battling MSFT’s Excel.

I created a chart with the known data collected about the voltage at the thermistor for  a list of temperatures.  I wanted a trendline to show the calculation so that I could use it to calculate the resistance of the thermistor at those temperatures.  However, after creating a chart and looking at the trendline formula’s calculation of known data, something was completely screwed up.

After some Google searches there was a link to Microsoft’s Help and Support website that indicated that “the trendline formula should only be used when your chart is an XY Scatter chart.” Great.  Well, at least I didn’t waste too much time on it and it was an easy fix.  However, why didn’t MSFT’s Excel team not grey out the trendline option for non-scatter charts?!

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>