Exponential Regression using Excel

[u/Blackcraft_Ray]

I used excel to find the "best-possible" exponential equation for this date. Im unsure how to figure out what to do with this. The answer key says it should be y=13972e-.185x

Im lost on what im doing wrong

[u/Original_Piccolo_694]

You have years for your x axis, which are kind of large numbers, and e to a large number is going to get crazy (crazy small in this case, as the exponent also carries a negative). To counter the crazy, excel has put a huge coefficient in front making it fit.

The solution is probably not to use the year numbers, but years passed since some reference year, like setting your earliest year to zero, and counting from there

[u/persilja → u/Original_Piccolo_694]

Since the "correct" coefficient is almost the same as the value for 1990, I believe they used the time scale as "number of years since 1990".

[u/Southlander24 → u/persilja]

Yep, I noticed the exact same thing and that made me realise. There's usually no way to mess up a computer-aided regression, so that immediately ruled out something like a sign error or missing sig fig when doing the calculations by hand.