TREND - The function returns values in a linear trend in Excel
The following article introduces you to TREND function - one of the functions in the statistical function group is very popular 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:
- In the cell to calculate enter the formula : = TREND (D6: D10, C6: C10)
- Press Enter -> return value is:
- Highlight the sales areas in June, July and August (D11: D13 areas) -> press F2:
- Press the key combination Ctrl + Shift + Enter -> estimated revenue for June, July and August is:
Above are instructions and some specific examples when using TREND function in Excel.
Good luck!
You should read it
- FORECAST function - The function returns a value along a linear trend in Excel
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
- MODE.MULT function - The function returns a vertical array of the most common values in Excel
- QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel
- SLOPE function - The function returns the slope of a linear regression line through data points in Excel
- RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excel
- MAX function - The function returns the largest value in a set of values in Excel
- STDEV.P function - The function returns the standard deviation based on the whole in Excel
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
- FREQUENCY function - Function that calculates and returns the frequency of occurrences of values in a range in Excel
- PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel
- PERCENTRANK.EXC function - The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1 in Excel