0
votes

I can't deduce my error in using google sheets forecast function. I have a range of values by date and am trying to forecast values on future dates. I used the Forecast function, specifying the next value cell, and using the date cells as the y axis and the test values as the x axis. Although my test values are between 187 and 194, my forecast result is 44320.43601. I am clearly making some error in the formula, but I cannot figure out what it is.

Spreadsheet is here: https://docs.google.com/spreadsheets/d/1Y2wmKzIjAv0a3zEa-ITjBPqiO9jMSglGwN2o1V5BYjc/edit?ts=5e8a095d#gid=0

1
44320.43601 is forcasted datevalueplayer0

1 Answers

1
votes

should be:

=FORECAST(A20, B1:B19, A1:A19)

0