Linear forecast - predicting future values using linear regression. For example, in the example shown, data is quarterly, so seasonality is given as 4, since there are 4 quarters in a year, and the seasonal pattern is 1 year. The seasonality argument is optional and represents the length of the seasonal pattern expressed in timeline units.
The timeline can also be a simple list of numeric periods, as in the example shown. For example, the timeline could be yearly, quarterly, monthly, daily, etc. The timeline, must consist of numeric values with a constant step interval.
We are at the end of this guide to implement forecast sheets in Excel. To use another calculation method, such as Median or Count, pick the calculation you want from the list. To treat the missing points as zeros instead, click Zeros in the list.
