Let’s see another example with a graphical chart format using multiple values. So we have predicted the upcoming sales value for the next three months. Here the Trend function with the next month sales has been shown below. In this example, we have month wise sales data from Jan-18 to Sep-18 where we need to find the next month sales by using the TREND Function in Excel. You can download this TREND Function Excel Template here – TREND Function Excel Template Example #1 Let us understand the working of TREND in Excel by Some Examples. TREND Function in Excel is very simple and easy to use. Go to formulas–>Choose More Function–>Statistical–>TREND In the advanced version, we will have a shortcut in the formula bar called more function and follow the below procedure.
We can find the TREND Function under Statistical function here we are going to see step by step procedure on how to use it : New_X-: This new x value is used to return corresponding y values.Ĭonst-: This const is a logical value, i.e. Known_ X-: This Known x_values is an independent array or range of data. Known_ Y-: This Known y_values is a dependent array or range of data.
Note: The existing data needs to be linear data otherwise the output will be inaccurate.