All resources related to STATISTICAL for Excel and Google Sheets.

Excel PERCENTRANK.EXC Function

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

Excel MAX Function

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

Excel PERCENTILE.INC Function

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

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

Excel MODE Function

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

Excel PERCENTILE Function

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

Excel GEOMEAN Function

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

Excel MEDIAN Function

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

Excel MODE.MULT Function

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

How to use the excel AVERAGEIFS function

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