The STDEVP function calculates standard deviation based on the entire population given as arguments. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
Returns the sum of two or more complex numbers in x + yi or x + yj text format.
PERCENTOF function
Scans an array by applying a LAMBDA function to each value and returns an array that has each intermediate value
The DOLLAR function, one of the TEXT functions, converts a number to text using currency format, with the decimals rounded to the number of places you specify. DOLLAR uses the $#,##0.00_);($#,##0.00) number format, although the currency symbol that is applied depends on your local language settings.
Returns the quartile of a data set. Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use QUARTILE to find the top 25 percent of incomes in a population. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, you should consider using the new functions from now on, it may not be available in future versions of Excel.
Returns the most frequently occurring, or repetitive, value in an array or range of data.
Returns the geometric mean of an array or range of positive data. For example, you can use GEOMEAN to calculate average growth rate given compound interest with variable rates.
Returns the sum-of-years' digits depreciation of an asset for a specified period.
Averages the values in a field (column) of records in a list or database that match conditions you specify.
Converts all uppercase letters in a text string to lowercase.
The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can use the following formula:
Returns the rank of a number in a list of numbers: its size relative to other values in the list. If more than one value has the same rank, the average rank is returned.
Converts text to uppercase.
You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS(2,3) returns $C$2. As another example, ADDRESS(77,300) returns $KN$77. You can use other functions, such as the ROW and COLUMN functions, to provide the row and column number arguments for the ADDRESS function.
Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile. If k is non-numeric, PERCENTILE returns the #VALUE! error value. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel.
RAND returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the worksheet is calculated.
The MINVERSE function returns the inverse matrix for a matrix stored in an array. Array can be given as a cell range, such as A1:C3; as an array constant, such as {1,2,3;4,5,6;7,8,9}; or as a name for either of these. Inverse matrices, like determinants, are generally used for solving systems of mathematical equations involving several variables. The product of a matrix and its inverse is the identity matrix — the square array in which the diagonal values equal 1, and all other values equal 0.
Returns the slope of the linear regression line through data points in known_y's and known_x's. The slope is the vertical distance divided by the horizontal distance between any two points on the line, which is the rate of change along the regression line.
The TRANSLATE() function allows you to translate text from one language to another in Microsoft Excel by using Microsoft Translation Services.
Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set.
Returns the decimal number of the time represented by a text string. The decimal number is a value ranging from 0 (zero) to 0.99988426, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).
Returns the principal value of the arccotangent, or inverse cotangent, of a number.
The VAR.S function estimates variance based on a sample (ignores logical values and text in the sample).
Counts the cells that contain numbers in a field (column) of records in a list or database that match conditions that you specify. The field argument is optional. If field is omitted, DCOUNT counts all records in the database that match the criteria.
Returns the largest number in a field (column) of records in a list or database that matches conditions you that specify.
Returns the smallest number in a field (column) of records in a list or database that matches conditions that you specify.
Returns a formula as a string.
WRAPCOLS function
Counts the nonblank cells in a field (column) of records in a list or database that match conditions that you specify. The field argument is optional. If field is omitted, DCOUNTA counts all records in the database that match the criteria.
Returns the probability associated with a Student's t-Test. Use T.TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. Results from the test shows if the difference is statistically significant or from chance. This function is provided for backward compatibility; consider using the T.TEST function instead.
Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure. This function is provided for backward compatibility; consider using the WEIBULL.DIST function instead.
Returns the error function.
The function described in this Help topic converts half-width (single-byte) letters within a character string to full-width (double-byte) characters. The name of the function (and the characters that it converts) depends upon your language settings. For Japanese, this function changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters.
Returns the exponential of a complex number in x + yi or x + yj text format.
Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute. This function is provided for backward compatibility; consider using the POISSON.DIST function instead.
Returns a number shifted right by the specified number of bits.
Calculates variance based on the entire population.
Return the hyperbolic cotangent of a hyperbolic angle.
The SUMXMY2 function returns the sum of squares of differences of corresponding values in two arrays.
Returns the Bessel function, which is also called the Weber function or the Neumann function.
Returns the rank of a value in a data set as a percentage of the data set. This function can be used to evaluate the relative standing of a value within a data set. For example, you can use PERCENTRANK to evaluate the standing of an aptitude test score among all scores for the test. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel.
Returns the argument (theta), an angle expressed in radians, such that:
Returns the real coefficient of a complex number in x + yi or x + yj text format.
Returns the difference of two complex numbers in x + yi or x + yj text format. If you just want to subtract two numbers that are not complex, see Subtract numbers.
Returns the base-2 logarithm of a complex number in x + yi or x + yj text format.
Returns the hyperbolic secant of an angle.
Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. The intercept point is based on a best-fit regression line plotted through the known x-values and known y-values. Use the INTERCEPT function when you want to determine the value of the dependent variable when the independent variable is 0 (zero). For example, you can use the INTERCEPT function to predict a metal's electrical resistance at 0°C when your data points were taken at room temperature and higher.
Checks whether an input value is text or not?
Returns the ratio of the factorial of a sum of values to the product of factorials.
Checks whether there is a reference to a cell that contains a formula, and returns TRUE or FALSE.
Returns the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59.
Returns the inverse hyperbolic cosine of a number. The number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is number, so ACOSH(COSH(number)) equals number.
Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range -pi/2 to pi/2.
The PRODUCT function multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT(A1, A2) to multiply those two numbers together. You can also perform the same operation by using the multiply (*) mathematical operator; for example, =A1 * A2. The PRODUCT function is useful when you need to multiply many cells together. For example, the formula =PRODUCT(A1:A3, C1:C3) is equivalent to =A1 * A2 * A3 * C1 * C2 * C3.
Reduces an array to an accumulated value by applying a LAMBDA function to each value and returning the total value in the accumulator
Returns the probability associated with a Student's t-Test. Use T.TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. Results from the test shows if the difference is statistically significant or from chance.
Returns the Unicode character that is referenced by the given numeric value.
Returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom tails of a data set. You can use this function when you wish to exclude outlying data from your analysis.