Mean absolute deviation calculator ( mad)
Welcome to our Mean Absolute Deviation (MAD) Calculator, a user-friendly tool designed to help you compute the MAD of a data set quickly and accurately.
Result :
What is Mean Absolute Deviation (MAD)?
Mean Absolute departure (MAD) is a statistical measure that calculates the average absolute departure of individual data points from the mean. It is an effective statistic for determining the variability or dispersion in a data collection.
Formula for calculating MAD
The formula for calculating MAD is:
\( \mathrm{ \mbox{MAD} = \frac{ \sum |x_{i}-\bar{x} | }{n} } \)
- \( \mathrm{ x_i} \): Represents each data point.
- \( \mathrm{ \bar{x} }\): Represents the mean of the data points.
- \( \mathrm{ n} \): Represents the total number of data points.
This formula calculates the absolute deviation of each data point from the mean, sums these deviations, and then divides by the total number of data points to find the average absolute deviation, which is the Mean Absolute Deviation (MAD).
How to Use the Mean absolute deviation ( MAD ) Calculator
- Enter Your Data: Input your numbers separated by commas or spaces in the provided text box.
- Specify Rounding: Choose the number of decimal places to round the MAD result, if desired.
- Calculate: Click the "Calculate" button to get your results instantly.
How to Calculate Mean Absolute Deviation (MAD) in Excel
Input your data into an Excel spreadsheet (e.g., cells A1 to A5).
Use the AVERAGE function to find the mean of your data points:
=AVERAGE(A1:A5)
Compute the absolute deviation of each data point from the mean using the ABS function:
=ABS(A1 - Mean)
Replace Mean with the cell reference of the mean value calculated in Step 2.
Find the Mean Absolute Deviation (MAD) by averaging the absolute deviations:
=AVERAGE(B1:B5)
Where B1 to B5 are the cells containing the absolute deviations calculated in Step 3.