The FORECAST.LINEAR function predicts a future value along a linear trend based on existing values. It is commonly used in data analysis and forecasting to estimate trends and make projections.


=FORECAST.LINEAR(x, known_y's, known_x's)

x The x-value for which you want to forecast a corresponding y-value.
known_y's The known y-values associated with the known x-values.
known_x's The known x-values corresponding to the known y-values.


When you're dealing with data sets and seeking to predict future values based on historical trends, turn to FORECAST.LINEAR in Excel. This function equips you with the ability to model linear relationships and estimate upcoming values, making it a valuable tool in various fields such as finance, marketing, and scientific research. By analyzing the existing data points and their relationships, you can leverage FORECAST.LINEAR to generate reliable forecasts and guide decision-making processes effectively. Whether you're projecting sales figures, stock prices, or test scores, this function simplifies the process of trend analysis and prediction, enabling you to plan ahead with confidence in the projected outcomes.


Suppose you have data points representing the number of units sold and corresponding months. You want to forecast the number of units that will be sold in the next month. If your known y-values are in cells A2:A7 (100, 110, 120, 130, 140, 150) and known x-values are in cells B2:B7 (1, 2, 3, 4, 5, 6), the FORECAST.LINEAR formula would be: =FORECAST.LINEAR(7, A2:A7, B2:B7)

Consider you have sales data from previous quarters, and you want to predict the sales figure for the next quarter. If your known y-values are in cells E2:E5 (5000, 6000, 7000, 8000) and known x-values are in cells F2:F5 (1, 2, 3, 4), the FORECAST.LINEAR formula would be: =FORECAST.LINEAR(5, E2:E5, F2:F5)


How does the FORECAST.LINEAR function determine the forecasted value?

The FORECAST.LINEAR function assesses the linear relationship between the known x-values and known y-values. It then uses this relationship to predict the corresponding y-value for the provided x-value by extending the linear trend.

Can I use the FORECAST.LINEAR function for nonlinear data patterns?

No, the FORECAST.LINEAR function is specifically designed for linear relationships. If your data exhibits nonlinear patterns, consider using other forecasting functions that cater to such trends.

What should I do if the data points for the FORECAST.LINEAR function are scattered and not forming a clear trend?

If your data points do not show a clear linear relationship, the forecast provided by the FORECAST.LINEAR function may not be accurate. In such cases, you may need to explore other analytical methods or regression techniques to capture the underlying pattern more effectively.

Related functions