Calculates the expected y-value for a specified x based on a linear regression of a dataset.
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 yet. Stay tuned!