PERCENTILE function - Microsoft Support
WEBSyntax. PERCENTILE (array,k) The PERCENTILE function syntax has the following arguments: array Required. The array or range of data that defines relative standing. k Required. The percentile value in the range 0..1, inclusive. Remarks. If k is non-numeric, PERCENTILE returns the #VALUE! error value.
QUARTILE function - Microsoft Support
WEBThe QUARTILE function syntax has the following arguments: Array Required. The array or cell range of numeric values for which you want the quartile value. Quart Required. Indicates which value to return. Remarks. If array is empty, QUARTILE returns the #NUM! error value. If quart is not an integer, it is truncated.
PERCENTILE.INC function - Microsoft Support
WEBThe PERCENTILE.INC function syntax has the following arguments: Array Required. The array or range of data that defines relative standing. K Required. The percentile value in the range 0..1, inclusive. Remarks. If array is empty, PERCENTILE.INC returns the #NUM! error value. If k is nonnumeric, PERCENTILE.INC returns the #VALUE! error value.
QUARTILE.INC function - Microsoft Support
WEBThe QUARTILE.INC function syntax has the following arguments: Array Required. The array or cell range of numeric values for which you want the quartile value. Quart Required. Indicates which value to return. Parameters. Remarks. If array is empty, QUARTILE.INC returns the #NUM! error value. If quart is not an integer, it is truncated.
PERCENTILE.EXC function - Microsoft Support
WEBThe PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. Syntax. Notes: If array is empty, PERCENTILE.EXC returns …
QUARTILE.EXC function - Microsoft Support
WEBThe QUARTILE.EXC function syntax has the following arguments: Array Required. The array or cell range of numeric values for which you want the quartile value. Quart Required. Indicates which value to return. Remarks. If array is empty, QUARTILE.EXC returns the #NUM! error value. If quart is not an integer, it is truncated.
PERCENTRANK function - Microsoft Support
WEBThis 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.
LOGNORM.DIST function - Microsoft Support
WEBThe equation for the lognormal cumulative distribution function is: LOGNORM.DIST (x,µ,o) = NORM.S.DIST (1n (x)-µ / o) Example. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.
ROUND function - Microsoft Support
WEBDescription. The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND (A1, 2) The result of this function is 23.78. Syntax. ROUND (number, num_digits)
TDIST function - Microsoft Support
WEBThis article describes the formula syntax and usage of the TDIST function in Microsoft Excel. Description. Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t …
RANK function - Microsoft Support
WEBThe RANK function syntax has the following arguments: Number: Required. The number whose rank you want to find. Ref: Required. A reference to a list of numbers. Nonnumeric values in ref are ignored. Order: Optional. A number specifying how to rank number.
Skip to content