!array,row_num,column_num!reference,row_num,column_num,area_num!!Returns a value or reference of the cell at the intersection of a particular row and column, in a given range!is a range of cells or an array constant.!selects the row in Array or Reference from which to return a value. If omitted, Column_num is required!selects the column in Array or Reference from which to return a value. If omitted, Row_num is required!is a reference to one or more cell ranges!selects the row in Array or Reference from which to return a value. If omitted, Column_num is required!selects the column in Array or Reference from which to return a value. If omitted, Row_num is required!selects a range in Reference from which to return a value. The first area selected or entered is area 1, the second area is area 2, and so on!
array,k!Returns the k-th percentile of values in a range!is the array or range of data that defines relative standing!is ...
array,k!Returns the k-th smallest value in a data set. For example, the fifth smallest number!is an array or range of numerical ...
array,percent!Returns the mean of the interior portion of a set of data values!is the range or array of values to trim and ...
array,quart!Returns the quartile of a data set!is the array or cell range of numeric values for which you want the quartile ...
array,row_num,column_num!reference,row_num,column_num,area_num!Returns a value or reference of the cell at the intersection ...
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,significance!Returns the rank of a value in a data set as a percentage of the data set!is the array or range of data ...
array1,array2!Returns 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, ...