{"id":79,"date":"2008-10-16T12:38:04","date_gmt":"2008-10-16T20:38:04","guid":{"rendered":"http:\/\/blog.11h.net\/erich\/79"},"modified":"2008-10-16T12:38:04","modified_gmt":"2008-10-16T20:38:04","slug":"excel-trendline-formula-is-inaccurate","status":"publish","type":"post","link":"https:\/\/11h.net\/blog\/excel-trendline-formula-is-inaccurate\/","title":{"rendered":"excel trendline formula is inaccurate"},"content":{"rendered":"

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.<\/p>\n

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

After some Google searches there was a link<\/a> 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.” <\/strong>Great.\u00a0 Well, at least I didn’t waste too much time on it and it was an easy fix.\u00a0 However, why didn’t MSFT’s Excel team not grey out the trendline option for non-scatter charts?!<\/p>\n","protected":false},"excerpt":{"rendered":"

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.<\/p>\n

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.<\/p>\n

After some Google searches there was a link to Microsoft’s Help and Support website that indicated that …<\/p>\n

[Continue reading]<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/posts\/79"}],"collection":[{"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/comments?post=79"}],"version-history":[{"count":0,"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/posts\/79\/revisions"}],"wp:attachment":[{"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/media?parent=79"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/categories?post=79"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/tags?post=79"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}