Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11TREND - 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!
Jessica TannerYou should read it
- 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
May be interested
- TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
trimmean function: the function returns the average of the inside of the data set. the function calculates by removing which percentage of the value is in the first or last boundary of the data set. syntax: trimmean (array, percent) - VAR.P function - Function that calculates variance based on the entire set, ignoring logical values and text in Excelvar.p function: function that calculates variance based on the entire set, ignoring logical values and text. support functions from excel 2010 onwards. syntax: var.p (number1, [number2], ...)
- VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excelvar.s function: function that calculates variance based on a sample, ignoring logical values and text. support functions from excel 2010 onwards. syntax: var.s (number1, [number2], ...)
- VARA - Function that calculates variance based on a sample, including logical values and text in Excelvara function: the function performs a calculation of variance based on a sample, including logical values and text. syntax: vara (value1, [value2], ...)
- VARPA function - Function that calculates variance based on the entire set, including logical values and text in Excelvarpa function: function that calculates variance based on the entire set, including logical values and text. syntax: varpa (value1, [value2], ...)
- Z.TEST function - The function returns one-sided value of the z test in Excelz.test: the function returns the one-sided p value of the z test. support functions from excel 2010 onwards. syntax: z.test (array, x, [sigma])
Office information
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
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