How do I use the forcast function in excel?

Question

Please provide an example. Thanks in advance!

Ex. Production numbers:
1,2,3,4,5 for the past five days. I would like to predict for the next five. Thanks!

Answer 1

Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x-values and y-values, and the new value is predicted by using linear regression. You can use this function to predict future sales, inventory requirements, or consumer trends.

Syntax
FORECAST(x,known_y's,known_x's)

X is the data point for which you want to predict a value.
Known_y's is the dependent array or range of data.
Known_x's is the independent array or range of data.