!array,x,significance!!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the rank of a value in a data set as a percentage of the data set!is the array or range of data with numeric values that defines relative standing!is the value for which you want to know the rank!is an optional value that identifies the number of significant digits for the returned percentage, three digits if omitted (0.xxx%)!
array,x,sigma!Returns the one-tailed P-value of a z-test!is the array or range of data against which to test X!is the value ...
array,x,sigma!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the one-tailed P-value ...
array,x,significance!Returns the rank of a value in a data set as a percentage of the data set as a percentage (0.1, exclusive) ...
array,x,significance!Returns the rank of a value in a data set as a percentage of the data set as a percentage (0.1, inclusive) ...
array,x,significance!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the rank of ...
array1,array2!Returns population covariance, the average of the products of deviations for each data point pair in two data ...
array1,array2!Returns sample covariance, the average of the products of deviations for each data point pair in two data sets!is ...
array1,array2!Returns the correlation coefficient between two data sets!is a cell range of values. The values should be numbers, ...
array1,array2!Returns the matrix product of two arrays, an array with the same number of rows as array1 and columns as array2!is ...