{"id":18911,"date":"2016-11-28T16:45:32","date_gmt":"2016-11-28T16:45:32","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=18911"},"modified":"2016-11-28T16:45:32","modified_gmt":"2016-11-28T16:45:32","slug":"spreadsheets-regression-curves-power-vs-exponential","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-regression-curves-power-vs-exponential\/","title":{"rendered":"Spreadsheets:  regression curves:  power vs exponential"},"content":{"rendered":"<h1>The tutor explains the difference between power and exponential curves.<\/h1>\n<p>According to Excel, a power equation has the form<\/p>\n<p style=\"text-align:center;font-size:120%\">y=ax<sup>b<\/sup><\/p>\n<p>whereas an exponential equation has the form<\/p>\n<p style=\"text-align:center;font-size:120%\">y=ae<sup>kx<\/sup><\/p>\n<p><strong>Example: <\/strong><\/p>\n<p>I tried both options on the following data:<\/p>\n<table style=\"width:20%;margin:auto\">\n<tr>\n<td>x<\/td>\n<td>y<\/td>\n<\/tr>\n<tr>\n<td>0.5<\/td>\n<td>0.9<\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>2.9<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>10.1<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>18.7<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>40<\/td>\n<\/tr>\n<\/table>\n<p style=\"white-space:pre-wrap\"><\/p>\n<p>Excel gave me the following regression equations:<\/p>\n<p>Power:  y=2.5804x<sup>1.514<\/sup><\/p>\n<p>Exponential:  y=0.902e<sup>0.7707x<\/sup><\/p>\n<p>To my observation, Excel will not offer a power equation if x=0 is in the data.  It will not offer an exponential if (0,0) is in the data.<\/p>\n<p>I&#8217;ll be telling how to get an equation for a given data set in future posts:)<\/p>\n<p>Jack of <a href=\"https:\/\/www.oracletutoring.ca\">Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The tutor explains the difference between power and exponential curves. According to Excel, a power equation has the form y=axb whereas an exponential equation has the form y=aekx Example: I tried both options on the following data: x y 0.5 &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-regression-curves-power-vs-exponential\/\"> <span class=\"screen-reader-text\">Spreadsheets:  regression curves:  power vs exponential<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[371,3,1065],"tags":[2053,2054],"class_list":["post-18911","post","type-post","status-publish","format-standard","hentry","category-business","category-math","category-spreadsheets","tag-when-excel-wont-offer-exponential-curve","tag-when-excel-wont-offer-power-equation"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/comments?post=18911"}],"version-history":[{"count":16,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18911\/revisions"}],"predecessor-version":[{"id":18927,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18911\/revisions\/18927"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=18911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=18911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=18911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}