LOGEST - The function returns an array of data that describes an exponential curve that fits the data given in Excel
The following article introduces you to the LOGEST function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the array of data describing the exponential curve in accordance with the given data.
- The equation of the curve is:
y = b * m ^ x
or
y = (b * (m1 ^ x1) * (m2 ^ x2) * _)
Syntax: LOGEST (known_y's, [known_x's], [const], [stats])
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
- 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.
- stats: The logical value that determines the return value with additional regression statistics, is an optional value that includes:
+ stats = True -> returns additional regression statistics.
+ stats = False -> returns the coefficient m and the constant b .
Attention:
- The more similar the graph to the exponential curve -> the better the calculated straight line is for your data.
- Where there is only 1 independent variable x -> find the value of the intersection y according to the following formula:
+ Crossing Y (b): INDEX (LOGEST (known_y's, known_x's), 2)
- When entering array constants, you must use commas to separate.
- If the values y are outside the values used to define the equation -> the regression equation may be invalid.
For example:
Find the value as described in the data table below:
1. Calculate the value of the LOGEST function with additional regression statistics (corresponding to stats = True).
- In the cell to calculate enter the formula : = LOGEST (D6: D10, C6: C10, TRUE, TRUE)
- Press Enter -> the return value of the function is:
2. Calculate the value of the LOGEST function with stats = False.
- In the cell to calculate enter the formula: = LOGEST (D6: D10, C6: C10, TRUE, FALSE)
- Press Enter -> return value is:
Above are instructions and some specific examples when using the LOGEST function in Excel.
Good luck!
You should read it
- MODE.MULT function - The function returns a vertical array of the most common values in Excel
- MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values in an array or data range in Excel
- How to use the Match function in Excel
- TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
- The EXPON.DIST function - The function returns the exponential distribution in Excel
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
- GROWTH function - The function calculates the exponential growth value using existing data in Excel
- QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel
May be interested
- QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excelquartile.inc function: the function returns the quartile of a data set, with percentile values from 0 to 1 including 0 and 1. support functions from execl 2010 onwards. syntax: quartile.inc (array, quart)
- ZTEST function - Returns the probability value on one side of the z test in Excelztest function: the function returns the one-sided probability value of the z test. for the hypothetical population mean, the function returns the probability that the sample mean will be greater than the sample mean observed in the data set or array.
- LOOKUP function searches in Excelthe lookup () function returns a value from a data range consisting of 1 column or 1 row, or from an array. the lookup () function is an improvement of the two functions vlookup () and hlookup () because it has the additional function to distinguish the search area as rows or columns.
- GROWTH function - The function calculates the exponential growth value using existing data in Excelgrowth function: the function calculates the exponential growth value using existing data. syntax: growth (known_ys, [known_xs], [new_xs], [const])
- Instructions for using Index function in Excelindex is a function that returns an array in excel. when using the index function, you get the values in a cell between the column and the row.
- TTEST - Returns the probability associated with a Student's t-Test in Exceldescription: the function returns the one-sided probability value of the z test. for the hypothetical population mean, the function returns the probability that the sample mean will be greater than the sample mean observed in the data set or array.
- The Match function (the function searches for a specified value in an array or cell range) in Excelthe match function helps you search for a specified value in an array, a range of cells, and then returns the position of the value in that array or range.
- 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])
- How to Create a Curve in Excelyou will learn to research and locate a curve of interest, then set up the data for graphing (charting) it in microsoft excel in the following steps. the example curve in the photo from the text was chosen at random from a standard...
- How to use the NORMDIST function in Excel - Function that returns the distribution in Excelthe normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.