Forcast formula is used to predict anything in excel.
For example- We sale somthing and we have the detail of sale for the month of jan, feb, March, April and now we want to know that what will be the sale in December month. So then we use forcast formula. You Can't totally Dependent that result which is given by the formula but It will give you the approx value.
So here is an Example.
SYNTEX- (X,Known_y's, known x_'s)
X =is month you want to know the sale like october
known_y's= known result (the Sale )
known_x's= known Result( month)
For example- We sale somthing and we have the detail of sale for the month of jan, feb, March, April and now we want to know that what will be the sale in December month. So then we use forcast formula. You Can't totally Dependent that result which is given by the formula but It will give you the approx value.
So here is an Example.
SYNTEX- (X,Known_y's, known x_'s)
X =is month you want to know the sale like october
known_y's= known result (the Sale )
known_x's= known Result( month)
No comments:
Post a Comment
Thank you for comment.