Calculates the expected y-value for a specified x based on a linear regression of a dataset.

How To Use in Sheets

FORECAST(x, data_y, data_x)

External Links

How to use the Forecast Linear Function in Google Sheets and add a Trendline in a Chart

This short video shows you how to add a trend line to a chart in Google Sheets and also how to forecast the date at which you would reach a daily spending goal based on actual historical data.

0Better Sheets Tutorials

No videos yet. Stay tuned!