Statistical

A collection of 10 posts

How to use Weighted Average in Excel

To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function. 1. The AVERAGE function below calculates the normal average of three scores. Suppose your teacher says, “The
06 November 2020

How to use Standard Deviation In Excel

This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel and how to estimate the standard deviation based on a sample using
04 November 2020

How to Generate Random Numbers In Excel

Excel has two useful functions when it comes to generating random numbers. The RAND and RANDBETWEEN function. Rand The RAND function generates a random decimal number between 0 and 1. 1. Select cell
04 November 2020

How to use RANK Function In Excel

The RANK function in Excel returns the rank of a number in a list of numbers. Use RANK.AVG to return the average rank if more than one number has the same rank.
04 November 2020

How to use FREQUENCY function in Excel

The FREQUENCY function in Excel calculates how often values occur within the ranges you specify in a bin table. You can also use the COUNTIFS function to create a frequency distribution. 1. First,
30 October 2020

How To Use AverageIf function In Excel

The AVERAGEIF function in Excel calculates the average of cells that meet one criteria. AVERAGEIFS calculates the average of cells that meet multiple criteria. 1. For example, the AVERAGEIF function below (two arguments)
28 October 2020