The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
Returns number rounded up to the nearest odd integer.
Estimates variance based on a sample. VAR assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the variance by using VARP. Arguments can either be numbers or names, arrays, or references that contain numbers. This function has been replaced with one or more new functions. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel.
Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).
Returns the number of combinations (with repetitions) for a given number of items.
Calculates predicted exponential growth by using existing data. GROWTH returns the y-values for a series of new x-values that you specify by using existing x-values and y-values. You can also use the GROWTH worksheet function to fit an exponential curve to existing x-values and y-values.
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
Returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm.
Returns the number of periods required by an investment to reach a specified value.
STOCKHISTORY function
Converts an octal number to binary.
HYPGEOMDIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size. Use HYPGEOMDIST for problems with a finite population, where each observation is either a success or a failure, and where each subset of a given size is chosen with equal likelihood.
Converts a number to Thai text and adds a suffix of "Baht." You can change the Baht format to a different style in the Excel desktop application by using Regional and Language Options (Windows Start menu, Control Panel).
Returns the price per $100 face value of a security that pays periodic interest.
The FIELDVALUE function can be used inside other formulas to extract field data from linked records. This article explains how.
value returned by a previously executed REGISTER or REGISTER.ID function.
Returns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield.
IMPORTTEXT function
Returns the individual term binomial distribution probability.
Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPONDIST to determine the probability that the process takes at most 1 minute.
Converts text to a number, in a locale-independent way.
Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. If p = LOGNORMDIST(x,...) then LOGINV(p,...) = x. Use the lognormal distribution to analyze logarithmically transformed data. For more information about the new function, see LOGNORM.INV function.
The ENCODEURL function returns a URL-encoded string, replacing certain non-alphanumeric characters with the percentage symbol (%) and a hexadecimal number.
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.
The FILTERXML function returns specific data from XML content by using the specified xpath.
Returns a calculated array of a specified row and column size, by applying a LAMBDA function
Returns the number of items in a set.
Returns a normalized value from a distribution characterized by mean and standard_dev.
Returns the inverse of the gamma cumulative distribution. If p = GAMMADIST(x,...), then GAMMAINV(p,...) = x. You can use this function to study a variable whose distribution may be skewed.
Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.
Returns the confidence interval for a population mean, using a Student's t distribution.
Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...* number.
Returns the largest value in a list of arguments. MAXA is similar to MINA. For more information, see the examples for the MINA function.
Returns population covariance, the average of the products of deviations for each data point pair in two data sets. Use covariance to determine the relationship between two data sets.
QUARTILE.EXC returns the quartile of the data set, based on percentile values from 0..1, exclusive.
Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution. For more information about the new functions, see T.DIST.2T function and T.DIST.RT function.
Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation). The currencies available for conversion are those of European Union (EU) members that have adopted the euro. The function uses fixed conversion rates that are established by the EU. If this function is not available, and returns the #NAME? error, install and load the Euro Currency Tools Add-in. Install and load the Euro Currency Tools Add-in add-in
Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered. If the DLL or code resource has not been registered, this function registers the DLL or code resource and then returns the register ID. REGISTER.ID can be used on worksheets (unlike REGISTER), but you cannot specify a function name and argument names with REGISTER.ID. For more information about DLLs and code resources and data types, see Using the CALL and REGISTER functions.
Returns the two-tailed inverse of the Student's t-distribution. This function is provided for backward compatibility; consider using the T.INV.2T function instead.
Returns a number corresponding to one of the error values in Microsoft Excel or returns the #N/A error if no error exists. You can use ERROR.TYPE in an IF function to test for an error value and return a text string, such as a message, instead of the error value.
Returns the logical value FALSE.
Returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.
Converts degrees to radians.
Accepts any array and returns the text representations of the array values.
The CHISQ.TEXT function returns the test for independence. It returns the value from the chi-squared (χ2) distribution for the statistic and the appropriate degrees of freedom. You can use χ2 tests to determine whether hypothesized results are verified by an experiment.
Returns a value converted to a number.
Returns the text referred to by value.
(number, power)
Returns the cosine of the given angle.
Returns a confidence interval for the forecast value at the specified target date.
Returns the one-tailed probability-value of a z-test. For a given hypothesized population mean, μ0, ZTEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) — that is, the observed sample mean.
The MMULT function returns the matrix product or multiplication of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. The way you enter the formula depends on which version of Office 365 you are using.
Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.
With the DETECTLANGUAGE() function, you can easily identify the language used in a specified text or range. This function uses Microsoft Translation Services.
Calculates the average (arithmetic mean) of the values in the list of arguments.
Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price's response to changes in yield.
Returns the sine of the given angle.
Return the cotangent of an angle specified in radians.
EXPAND Function
Checks whether a value is logical (TRUE or FALSE) or not?