{"id":18902,"date":"2016-11-27T16:54:06","date_gmt":"2016-11-27T16:54:06","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=18902"},"modified":"2016-11-27T16:54:06","modified_gmt":"2016-11-27T16:54:06","slug":"spreadsheets-excel-the-logest-function","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-excel-the-logest-function\/","title":{"rendered":"Spreadsheets: Excel: the logest() function"},"content":{"rendered":"

The tutor shows how to use the logest() function to get an exponential curve from data.<\/h1>\n

Excel’s logest() function returns parameters for the equation y=bm^x, according to data fed for x and y values. Let’s imagine the data is as follows:<\/p>\n\n\n\n\n\n\n\n
x<\/td>\ny<\/td>\n<\/tr>\n
0<\/td>\n3<\/td>\n<\/tr>\n
1<\/td>\n5<\/td>\n<\/tr>\n
3<\/td>\n16<\/td>\n<\/tr>\n
4<\/td>\n27<\/td>\n<\/tr>\n
5<\/td>\n61<\/td>\n<\/tr>\n<\/table>\n

<\/p>\n

Here’s how to get the parameters for the y=bm^x equation to fit the data:<\/p>\n

    \n
  1. Let’s imagine the x-data is in range a1:a5; the y-data, b1:b5.<\/li>\n
  2. Go to a cell somewhere else, then select it and drag to the one next door, so that both cells are selected.<\/li>\n
  3. Key in =logest(b1:b5,a1:a5)<\/span> but don’t hit enter!<\/strong><\/li>\n
  4. Now, press Ctrl+Shift+Enter<\/strong> (all at once).<\/li>\n
  5. Hopefully, you receive two entries: 1.805018 and 2.834844<\/li>\n
  6. The form of the equation is y=2.834844*1.805018^x<\/li>\n<\/ol>\n

    HTH:)<\/p>\n

    Jack of Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"

    The tutor shows how to use the logest() function to get an exponential curve from data. Excel’s logest() function returns parameters for the equation y=bm^x, according to data fed for x and y values. Let’s imagine the data is as …<\/p>\n

    Spreadsheets: Excel: the logest() function<\/span> Read More »<\/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,1065],"tags":[2051,2052],"class_list":["post-18902","post","type-post","status-publish","format-standard","hentry","category-business","category-spreadsheets","tag-excel-logest-function","tag-fitting-a-curve-to-data-in-excel"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18902","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=18902"}],"version-history":[{"count":8,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18902\/revisions"}],"predecessor-version":[{"id":18910,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18902\/revisions\/18910"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=18902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=18902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=18902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}