STATISTICAL Articles: Excel and Google Sheets

Just as you can use other different functions in Excel, there are ways you can use the PERCENTRANK.EXC Function. In this post, you’ll learn how to use the Excel PERCENTRANK.EXC function with syntax approach. Syntax  =PERCENTRANK.EXC (array, y, [significance value]) Where; y - Value to rank Array - Array of...

The MAX function in Microsoft Excel is used to return the largest numeric value among a range of values. The Excel MAX function doesn’t count any empty cell, any values in text or the logical values of TRUE and FALSE. The purpose of the Excel MAX function is to help...

The PERCENTILE.INC function in Excel takes a range and returns the k-th percentile of values. Here, k is a value between 0 and 1, inclusive. It is a great way to calculate percentile from a set of values. In this tutorial, we will learn how to use the PERCENTILE.INC function...

The Excel PERMUT function calculates the number of permutations of a specified number from a given set of number. The permutation is basically the calculation of the number of ways the arrangement of all the items of a set can be made where the order of arrangement is very important....

Figure 1. of Excel Mode Function. Let's say we are required to find the most commonly occurring number among a range of cells in our worksheet. We are going to utilize the MODE Function in Excel. Generic Formula =MODE (number1, [number2], ...) Where number1 = the first number value within...

Percentile is the value below which a percentage of our data falls.  Percentiles describe characteristics of distributions.  This step by step tutorial will assist all levels of Excel users in using the PERCENTILE function.   Figure 1. Final result: Determine the 80th percentile Syntax of the PERCENTILE Function PERCENTILE calculates...

If we want to find the geometric mean of an array of numbers, we can use the Excel GEOMEAN function. Note that this function can only work with positive. This article provides a clear guide with illustrative examples on how to use the Excel GEOMEAN function to calculate the geometric...

The MEDIAN function is one of the measures of central tendency in Excel.  The median of a set of numbers is defined as the middle number.  This tutorial will assist all levels of Excel users in using the MEDIAN function.   Figure 1. Final result of the MEDIAN function Syntax...

If we want to get the most occurring numbers in an excel set in a vertical array, we can deploy the excel MODE.MULT function. Here is an elaborative guide on how to go about it. Figure 1: Using MODE.MULT function General syntax of the formula =MODE.MULT (number1, [number2], …) Where;...

We can use the excel AVERAGEIFS to get the average of numbers in a given range which meets one or more supplied criteria. This article provides a clear guide on how to use the excel AVERAGEIFS function. Figure 1: How to use excel AVERAGEIFS function General syntax of the formula...