We need to predict sales for the next three months. This function helps you extrapolate data that contains two sets of numerical values which correspond to each other.īelow is the Syntax of the Forecast.Linear function:Īssume we have a set of data that shows the number of sales for nine-month. Forecast.LinearĮxtrapolation adjudges that the relationship between known values will also apply to unknown values.
#Excel trendline function how to#
Here we’re going to learn how to use the Forecast.linear, and the Forecast.ETS functions and how to extrapolate a sheet. Also, you can extrapolate a periodical template or even extrapolate a sheet. The Forecast function helps you extrapolate numerical data over a linear trend. If you need a function to predict your data without creating charts and graphs in Excel, use the Excel Forecast function. Data Extrapolation by the Forecast Function This trendline uses the average of the particular number of data points by the Period option. This trendline is used when you compare measurements that increase at a specific rate. Fluctuation is the main reason for using this trendline. PolynomialĪssume you have a large data set that is analyzing gains and losses. When you have a swift data decrease or increase, use the Logarithmic trendline. When your plotted data set is similar to a line, in other words, when the data is increasing or decreasing at a steady rate, use the Linear trendline. When data values rise or fall at increasingly higher rates, and there are no zero or negative Y values, we use the Exponential trendline. In Excel, we have six types of trendlines. Point: Do not use trendlines for Radar, Pie, Doughnut, Bubble, and 3D graphs. When you have a data set, you need to detect the data change trend and forecast them in a graph.