The CONFIDENCE.T function returns the confidence interval for the mean value of a sample of a population, using a Student's t distribution, given an alpha confidence value.

The function returns a real number x, with the associated confidence interval being given by the range [mean value - x, mean value + x]. This means that, for any sample in the population, the probability of obtaining a sample mean further than x from the mean of the original sample will be the alpha value.

The TREATAS function applies the values contained in the columns of a table as filters on columns of another table not necessarily related to the first one.

The SUBSTITUTEWITHINDEX function theoretically returns the result of a semi-join between two tables made using the common fields that have the same type (see description of a semi-join below) in which the common fields of the left table are replaced by a single column that contains an index to the row in the right table with which the "match" was found.

The EARLIEST function is used in calculated columns and allows access to the value of a column (of the row being analyzed) in nested calculations, this value being the one corresponding to the outermost evaluation level.

The ALLNOBLANKROW function receives as an argument the name of one or more columns, or a table, and returns a table containing the rows of the indicated table, column or columns without including the rows formed by blank values and ignoring the possible filters that could be applied to the table, column or columns.