Written by Calculates covariance, the mean of the products of paired deviations.
Counts the number of cells in a given range that satisfy multiple conditions.
Counts the number of cells in a specified range that satisfy a specified condition.
Counts the quantity of empty cells in a specified range.
Counts the number of non-empty values in the specified arguments.
Counts the quantity of numeric values present among the arguments provided.
Calculates the correlation coefficient of two datasets.
Calculates the confidence interval for a population mean using Student’s t distribution.
Generates the confidence range for a mean value within a population.
Written by The RSQ function in Excel calculates the square of the Pearson product-moment correlation coefficient, providing a statistical measure that indicates how well a regression model fits a dataset. It is essential for evaluating the strength of a linear relationship between two variables, making it invaluable in data analysis and predictive modeling.