- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Statistical - FORECAST.LINEAR Function
Description
The FORECAST.LINEAR function calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x-values and y-values, and the new value is predicted by using linear regression.
Syntax
FORECAST.LINEAR(x, known_y's, known_x's)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| X | The data point for which you want to predict a value. | Required |
| Known_y's | The dependent array or range of data. | Required |
| Known_x's | The independent array or range of data. | Required |
Notes
FORECAST.LINEAR Function is added in Excel 2016 and replaces the FORECAST Function of the earlier Excel Versions.
Applicability
Excel 2016
advanced_excel_statistical_functions.htm
Advertisements