This function predicts values based on data that will come value of data is now an ascending linear. FORECAST function usually used to predict subsequent sales, stock of goods, or consumer interest. The equation for the FORECAST function is
Syntax : FORECAST(X, Data_y, Data_x)
X : The value of data to be predicted.
Data_y : Array dependent, range of data, or observational data in the form of numbers.
Data_x : Array independent, range of data, or observational data in the form of numbers.
No comments:
Post a Comment