STATISTICAL Articles: Excel and Google Sheets

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...

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:...

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...

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...

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...

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...

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 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 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...

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...