All resources related to STATISTICAL for Excel and Google Sheets.

Excel FREQUENCY Function

Excel allows a user to check how many values from an array are less or equal than the limit, using the FREQUENCY function. This step by step tutorial will assist all levels of Excel users in counting values that meet a condition. Figure 1. The result of the FREQUENCY function...

Excel AVERAGEIF Function

While working with Excel, we are able to average values that satisfy a given criteria by using the AVERAGEIF function. This step by step tutorial will assist all levels of Excel users in the usage and syntax of AVERAGEIF function. Figure 1. Final result: Excel AVERAGEIF function Formula 1:...

How to Use the Excel MINA Function

We can use the excel MINA Function to get the LEAST VALUE in a range of cells. The values could be numbers, text, and logical text like TRUE or FALSE. TRUE is read as 1 and FALSE is read as 0 by excel. Text values are read as 0. The...

How to Use the DEVSQ Function

We can use the DEVSQ function to calculate the sum of squares of deviations from the mean value of a data range. The steps below will walk through the process. Figure 1: How to Use the DEVSQ Function Syntax =DEVSQ([number1], [number2], [number2] ...) Formula =DEVSQ(A4:A11) Setting up the Data We...

Excel COUNT Function

There are times when we just want to count the number of cells that contain numbers in a given range. This is best done by the use of Excel COUNT Function. But without a deeper knowledge of this formula, one might not be able to count the cells that contain...

Excel COUNTA Function

The powerful Excel COUNTA Function stands for the count all. The function counts not only empty text, “ ”, text and numbers but also logical/error values. Look at the easy to follow COUNTA examples. Formula =COUNTA(my_Arg1,[my_Arg2],...) Example 1 How to count cells with text using Excel COUNTA Function in a...

How to Use the COUNTIF Function

We can use the excel COUNTIF Function to count cells in a range that meet a criteria. We can count cells with dates, numbers, and text that match the specified criteria. This function supports logical operators like >, <, <>, = but not wildcards like * and ? where partial...

Excel AVEDEV Function

Excel has several built-in functions that measure variability in a data set, and AVEDEV is one of them. AVEDEV returns the average of the absolute deviations of data points relative to the mean. This tutorial will assist Excel users in using Avedev to measure variability of the given data. ...

Excel COUNTBLANK Function

Excel allows a user to count all cells from a range that are blank, by using the COUNTBLANK function. The function takes in count texts, numbers, spaces, results of other function, etc. This step by step tutorial will assist all levels of Excel users in counting blank cells in a...

How to Use the Excel PERCENTRANK Function

Excel allows us to get a rank of a value in a list, using the PERCENTRANK function. The rank presents a percentage of values which are lower than a selected value. This step by step tutorial will assist all levels of Excel users in finding a relative position of a...