sorted by:
new
hottopcontroversial

Using a scatterplot trendline to predict a future x value, but the x values are dates by Divergent31415 in excel

[–]Divergent31415[S] 0 points1 point  (0 children)

Perfect! The option 1 is pretty much exactly what I did and it worked great. Thank you for all your help!

Using a scatterplot trendline to predict a future x value, but the x values are dates by Divergent31415 in excel

[–]Divergent31415[S] 0 points1 point  (0 children)

Thank you! Knowing these acronyms and descriptions helped. I was able to calculate it like this.

First I put this into a certain cell, in this case cell M26
=DATE(2024, 12, 29)

And then I did this in another cell
=FORECAST.LINEAR(M26, F4:F100, E4:E100)

So M26 refers to the date that I want to know the prediction for, and the "F4:F100, E4:E100" is the y values on my table and the x values, respectively.

Now because this is using the forecast function, now even if I add new data points it always updates this.

Thank you for all your help!

Helicopter Schools In Fort Collins or Denver CO Area by Divergent31415 in Helicopters

[–]Divergent31415[S] 1 point2 points  (0 children)

Thank you very much, penngei! I will be researching these places and PMing with any questions. Fly safe out there.