Home Application Office information

TREND - The function returns values ​​in a linear trend in Excel

TREND: The function returns values ​​in a linear trend. Syntax: TREND (known_ys, [known_xs], [new_xs], [const])

The following article introduces you to TREND function - one of the functions in the statistical function group is very popular in Excel.

Picture 1 of TREND - The function returns values ​​in a linear trend in Excel

Description: The function returns values ​​in a linear trend.

Syntax: TREND (known_y's, [known_x's], [new_x's], [const])

Inside:

- known_y's : The set of known y values ​​in the relationship y = b * m ^ x , is a required parameter.

+ If known_y's is in a single column or row -> each known_y's column or row is interpreted as a separate variable.

- known_x's: The set of known x values ​​in the relationship y = b * m ^ x , is a required parameter.

+ known_x's may include 1 or more sets of variables.

+ If known_x's is omitted -> it is assumed to be an array of the same size as known_y's

- new_x's:  Are the new x values ​​that you want the function to return the values ​​corresponding to the values ​​of y.

+ new_x's must include a column (row) for each independent variable.

+ If new_x's is omitted -> it is assumed to be the same as known_x's.

+ If known_x's and new_x's are omitted -> it is assumed to be the same as known_y's size .

- const: The logical value determining the value of the constant b, is an optional value including the following values:

+ const = True or ignore -> b is calculated normally.

+ const = False or ignore -> b = 1 and m are adjusted such that: y = m ^ x.

Attention:

- The value of the returned formulas has the array formula type -> the function must be entered as an array formula.

- If known_y's ≤ 0 -> the function returns the #NUM! Error value

- When entering values ​​for an argument with the following convention:

+ Use commas to separate values ​​in the same row.

+ Use semicolons separating between rows together.

For example:

Revenue estimates for June, July and August are based on previous months as described in the following data table:

Picture 2 of TREND - The function returns values ​​in a linear trend in Excel

- In the cell to calculate enter the formula : = TREND (D6: D10, C6: C10)

Picture 3 of TREND - The function returns values ​​in a linear trend in Excel

- Press Enter -> return value is:

Picture 4 of TREND - The function returns values ​​in a linear trend in Excel

- Highlight the sales areas in June, July and August (D11: D13 areas) -> press F2:

Picture 5 of TREND - The function returns values ​​in a linear trend in Excel

- Press the key combination Ctrl + Shift + Enter -> estimated revenue for June, July and August is:

Picture 6 of TREND - The function returns values ​​in a linear trend in Excel

Above are instructions and some specific examples when using TREND function in Excel.

Good luck!

You've just finished reading the article "TREND - The function returns values ​​in a linear trend in Excel" edited by the TipsMake team. You can save trend-the-function-returns-values-​​in-a-linear-trend-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
NEXT » T.TEST function - The function returns the probability associated with Student's t-Test in Excel
Read more