![excel 2007 tutorial 14 excel 2007 tutorial 14](https://i.ytimg.com/vi/hg3uDf0wK1M/hqdefault.jpg)
Timeline (required) - an array of dates/times or independent numeric data with a constant step between them.Values (required) - a range or array of historical data for which you want to predict future values.It can be represented by a date/time or number. Target_date (required) - the data point for which to forecast a value.The syntax of the Excel FORECAST.ETS is as follows:įORECAST.ETS(target_date, values, timeline,, , ) The FORECAST.ETS function is available in Excel for Office 365, Excel 2019, and Excel 2016. "AAA" stands for additive error, additive trend and additive seasonality. This algorithm smoothes out insignificant deviations in data trends by detecting seasonality patterns and confidence intervals. More precisely, it predicts a future value based on the AAA version of the Exponential Triple Smoothing (ETS) algorithm, hence the function's name.
#EXCEL 2007 TUTORIAL 14 SERIES#
The FORECAST.ETS function is used to do exponential smoothing forecasts based on a series of existing values.
#EXCEL 2007 TUTORIAL 14 HOW TO#
And the next section of our tutorial shows how to do this. If you'd like to predict future values based on the recurring pattern observed in your historical data, then use FORECAST.ETS instead of the Excel FORECAST function. The detailed steps to make such a graph are described in Linear regression forecasting chart. Plotted on a graph, our linear forecast looks as follows: Please pay attention that we lock the ranges with absolute cell references (like $A$2:$A$2) to prevent them from changing when copying the formula to other cells. Where A23 is a new x-value for which you wish to predict a future y-value.ĭepending on your Excel version, insert one of the above formulas in any empty cell in row 23, copy it down to as many cells as needed and you will get this result: of visitors) in B2:B22 and the known x-values (dates) in A2:A22, the forecast formula goes as follows. They work best for linear datasets and in situations when you want to forecast a general trend ignoring insignificant data fluctuations.Īs an example, we will try to predict our web-site traffic for the next 7 days based on the data for the previous 3 weeks. How to use FORECAST function in Excel - formula exampleĪs already mentioned, the Excel FORECAST and FORECAST.LINEAR functions are purposed for linear trend forecasting.
![excel 2007 tutorial 14 excel 2007 tutorial 14](https://4.bp.blogspot.com/-aTg7WjKiXnY/U0IJR2J71WI/AAAAAAAADGE/8PSCREMp1XE/s1600/Screenshot+Studio+capture+%252375.png)
![excel 2007 tutorial 14 excel 2007 tutorial 14](https://laobingkaisuo.com/wp-content/uploads/tutorial-excel-2007-doc-768x413.jpg)
![excel 2007 tutorial 14 excel 2007 tutorial 14](https://i.ytimg.com/vi/tHf08BOUHmA/maxresdefault.jpg)
The tutorial explains how to use Excel FORECAST and other related functions with formula examples.