How to use Weighted Average in Excel2020-11-6Functions StatisticalTo calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function.
How to use RANK Function In Excel2020-11-4Functions StatisticalThe RANK function in Excel returns the rank of a number in a list of numbers.
How to Generate Random Numbers In Excel2020-11-4Functions StatisticalExcel has two useful functions when it comes to generating random numbers.
How to use Percentiles and Quartiles In Excel2020-11-4Functions StatisticalThis example teaches you how to use the PERCENTILE and QUARTILE function in Excel.
How to use Standard Deviation In Excel2020-11-4Functions StatisticalThis 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 Excel2020-11-1Functions StatisticalA clever Excel trick to change negative numbers to zero but leave positive numbers unchanged.
How to Use MaxIfs and MinIfs Function In Excel2020-10-31Functions StatisticalUse 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 Excel2020-10-30Functions StatisticalThe 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 Excel2020-10-28Functions StatisticalThis example teaches you how to create a box and whisker plot in Excel.
How To Use AverageIf function In Excel2020-10-28Functions StatisticalThe AVERAGEIF function in Excel calculates the average of cells that meet one criteria.