# How to use Weighted Average in Excel

To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function.

To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function.

The RANK function in Excel returns the rank of a number in a list of numbers.

Excel has two useful functions when it comes to generating random numbers.

This example teaches you how to use the PERCENTILE and QUARTILE function in Excel.

This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel.

A clever Excel trick to change negative numbers to zero but leave positive numbers unchanged.

Use MAXIFS and MINIFS in Excel 2016 or later to find the maximum and minimum value based on one criteria or multiple criteria.

The FREQUENCY function in Excel calculates how often values occur within the ranges you specify in a bin table.

This example teaches you how to create a box and whisker plot in Excel.

The AVERAGEIF function in Excel calculates the average of cells that meet one criteria.