How to calculate simple moving average in Excel

How to calculate simple moving average in Excel

Moving average calculations is a common way of smoothing data to reduce the effects of random, short-term fluctuations. In this guide, we’re going to show you how to calculate simple moving averages in Excel using three methods. Download Workbook What is Simple Moving...
AVERAGEA in Excel

AVERAGEA in Excel

The AVERAGEA in Excel is a Statistical function that can calculate and return the average (arithmetic mean) of the values of a range of cells. AVERAGEA differs from the AVERAGE function in its ability to include numbers in string format and logical values in the...
Function: MEDIAN

Function: MEDIAN

The MEDIAN Excel function is a Math formula that calculates and returns the median of the selected values. The median in statistics represents the middle value in a dataset. In this guide, we’re going to show you how to use the Excel MEDIAN function and also go over...
Function: AVERAGE

Function: AVERAGE

The AVERAGE function can calculate the average (arithmetic mean) of the values in a range of cells. In this guide, we’re going to show you how to use the function and also throw in some tips and error handling methods. Supported versions All versions Syntax...
Function: AVERAGEIF

Function: AVERAGEIF

AVERAGEIF function takes the average of the values in a range of cells that match a criteria. In this guide, we’re going to show you how to use the AVERAGEIF function and also go over some tips and error handling methods. Supported versions All Excel versions Syntax...
How to calculate average by week number

How to calculate average by week number

Calculating averages by week number is a bit different than doing this by month. Instead of finding start and end dates of date range, we focus on the exact week number using the WEEKNUM function. Syntax =AVERAGEIFS( range of values to calculate average, range of week...
How to calculate monthly averages

How to calculate monthly averages

This article shows you how to calculate monthly averages from a data table containing dates and values using AVERAGEIFS and EOMONTH functions. If you only want to calculate the number of days in a month, please refer to the article: How to find number of days in month...