Written by Determines the covariance of a dataset, specifically focusing on a sample drawn from a larger population.
Calculates the probability regarding a Pearson’s chi-squared test applied to two data ranges, assessing the chance that the observed categorical data originates from a specified distribution.
Finds the inverse of the cumulative distribution of the chi-squared variable for a specified confidence level.
Calculates the average of a specified range based on multiple criteria.
Calculates the average of a dataset, including numbers, text, and boolean values.
Calculates the weighted average for a group of values, utilizing both the values and their associated weights.
Determines the average of the absolute deviations of values from their overall mean.
Returns distinct rows from the specified source range while omitting duplicates. The order of rows in the result reflects their initial appearance in the source range.
Calculates the total of a specified range based on various criteria.
Calculates the factorial of the total sum of values, divided by the factorials of each individual value multiplied together.