Using Excel to Predict Value?

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

Hi everone,

Say you have 50 values in A column and you want to predict the 51th
value based on the previous 50 values. What Excel's function you use?

I know FORECAST(x,known_y's,known_x's) but I have only x values in my
example!

Thanks,
John
 
Hi John,

Sounds like you only have known-y's. You could put 1-50 in anther column as
your known-x's. Note Forecast is good only for broadly linear data.

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using the slope function with non contiguous cells 6
3 Weeks Forecast-Excel 2003 4
Forcast Function 8
How to forecast non-numerics? 4
using slope function with non contiguous cells 1
Predictive Text based on cell range? 1
predict text based on cell range? 1
Excel Custom trendlines and R^2 values 0

Back
Top