TREND Excel Formula

Author Zaheer    Category Formulas     Tags ,

In Microsoft Excel, the TREND function utilizes the least squares method fitting the line to the particular known points. Thus, it takes back the corresponding value of y, which might be considered a range for the particular values of x. Here are the following helpful steps to show you how to use the TREND function in Microsoft Excel.


  • Learn the formula of the TREND function in Microsoft Excel.
  • Next, you have to enter the array, which is for “known_y_values. Moreover, the set of the identified values of y for the particular equation y is equal to mx + b. Every column of the given values of x is definitely interpreted as the separate variable since the known_y_values appears in the single row.
  • Then, you have to supply the elective array for the known_x_values. A set of identified values of x for y is equivalent to mx plus b. Additionally, the known_x_values array consists of additional sets of variables. The known_y_values and known_x_values might have various dimensions, which are equal if it uses only single variable.
  • Present new_ x_values as the values you like for x match up with y values. The new_x_values requires to have a column or even a row in every autonomous variable. Consequently, the new_x_variables and known_x_variables have similar number of columns and rows if the known_y_value is within the single column or row.
  • Then you have to include ‘const’ as the logical value, which sets the constant b into zero. Moreover, the value given for b calculates typically if the const is TRUE then you have to set it to zero of the const is considered FALSE. Therefore, the said argument might be omitted or deleted and uses the default value of zero.

TREND Function in Microsoft Excel returns the values of the linear trend. Thus, it fits the straight line through the least squares method down to the arrays of ‘known_x’s’ and ‘know_y’s’. Therefore, it returns the values of y to that line within the specified new_x’s array.

  • Known_y’s is considered the set values of y that the user already knows within the relationship of y equal to mx plus b.
  • If the known_y’s array is within the single column, that’s why every known_x’s column is being read as separate variable.
  • If an array of known_y’s is within the single row. Then every known_x’s row is being read as separate variable.
  • The known_x’s is considered as an optional value, which you might know within the relationship of y equal to mx plus b.

The known_x’s array includes one or even more sets of the variables. The known_x’s and known_y’s can be the ranges of some shape, thus it’s only required if one of the variable is being used as long as these variables have similar dimensions. The known_y’s is considered the vector if over one variable’s being used.

  • If the known_x’s is excluded then it’s presumed to be 1,2,3,….. array, which is the similar size as the known_y’s.
  • New_x’s are the latest values of x, which the user want the function TREND to return with the corresponding values of y.
  • Const is considered the logical value, which specifies whether the constant value of b should be forced to be equal to zero.

Post comment