FORECAST Function

FORECAST Function in Excel

by

Part 1: IntroduceDefinitionThe FORECAST function in Excel calculates or predicts a future value using existing values. It’s based on linear regression and can be used to predict future sales, inventory requirements, or consumer trends.PurposeTo predict a y-value for a given x-value using known x-values and y-values.Syntax & ArgumentssyntaxFORECAST(x, known_y’s, known_x’s) x: The data point for … Read more