Calculates the expected y-value for a specified x based on a linear regression of a dataset.
81% OFF online library of tutorials for mastering Google Sheets
FORECAST()
Description
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 featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.