How to use Weighted Average in Excel

Nov 06, 2020

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

#Tutorial#How To#Functions#Statistical

How to use RANK Function In Excel

Nov 04, 2020

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

How to Generate Random Numbers In Excel

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

How to use Percentiles and Quartiles In Excel

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

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.

How to change Negative Numbers to Zero In Excel

Nov 01, 2020

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

How to Use MaxIfs and MinIfs Function In Excel

Oct 31, 2020

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

How to use FREQUENCY function in Excel

Oct 30, 2020

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

How To Create a Box and Whisker Plot In Excel

Oct 28, 2020

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

How To Use AverageIf function In Excel

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