How to find optimal data range to fit exponential trendline?

EliasLundstrom

New Member
Joined
Jun 13, 2018
Messages
1
Hi, Excel pros!

I am looking through various datasets of Google Trends to find the most optimal data range that fits an exponential trend line. Do you know of an automated way to identify the most fitting data range in a graph (i.e. with the trend line R2 value closest to 1)?

Currently, I have to guess and try out various data ranges manually and see which ones provide the highest R2-value.

It's a simple x-y graph. X-axis consists of dates in monthly intervals, Y-axis of search volume in relative terms for the given keyword.

Here's a photo of what it looks like for the search term "chatbot":

Sk_rmbillede_2018_06_13_kl_11_30_11.png

As you can see, the R2 value is 0,84275 for the selected interval (the range of the entire dataset goes further back). I selected the interval simply by roughly guessing where the exponential trend is most present.

What I am looking for is a way of determining the data range that provides the highest R2 - in other words, the part of the data that resembles an exponential trend the most.

Do you know of any way to do this systematically, so I don't have to guess my way through?

Thank you in advance.

Elías
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,223,893
Messages
6,175,248
Members
452,623
Latest member
cliftonhandyman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top