AVEDEV Function in Apple Numbers: Syntax, Examples and Troubleshooting

Given observations x1 through xn and their arithmetic mean x̄, the calculation is the average of ABS(xi − x̄) for all observations. The absolute value makes negative and positive departures add rather than cancel. Apple’s reference describes this exact algorithm: first calculate the mean, then sum the absolute differences, then divide by the number of observations. [D1]

Use AVEDEV for a simple measure of variability in delivery times, measurements, or production totals when you want an answer in the same units as the input. It is not the same as averaging signed differences (which sum to zero around the mean) or squaring deviations to calculate standard deviation.

=AVEDEV(value, value…)

• value (required): a numeric value, date/time value or duration value, or a collection of values such as a range.
• Additional value arguments (optional): one or more additional values or collections. Apple does not specify a replacement default for an omitted optional argument.
• Type consistency (required): Apple requires all supplied values to be of the same value type. A range containing plain numbers is the clearest starting point; do not combine dates, durations, and numbers in a single deviation calculation. [D1]
• Return type: numeric observations produce a numeric deviation; Apple documents that date/time observations produce a duration. Duration-only inputs can also return a duration. [D1]

The comma-separated formula is the English syntax documented by Apple. If your decimal separator is a comma, Apple instructs you to use semicolons between arguments, such as =AVEDEV(2;4;6;8). A single contiguous range B2:B5 still uses a colon. Function names can be entered in lowercase or uppercase. [L1]

Version scope: Official Functions Help 15.4, retrieved 2026-10-12. The help version does not prove the earliest implementation on all versions of Numbers for Mac/iPad/iPhone/iCloud. Formula outputs here are expected, not observed in native Numbers.

Create a table called Measurements. Put the heading Reading in B1, then enter:

In another cell of the same table enter:

=AVEDEV(B2:B5)

Expected result: 2. Arithmetic mean (2+4+6+8)/4 = 5; absolute distances 3+1+1+3 = 8; average distance 8/4 = 2. This example was independently calculated, then checked for consistency against Apple’s definition. It was not executed in Numbers. [D1]

For comparison, this separate formula returns the centre rather than the spread:

=AVERAGE(B2:B5)

Expected result: 5. Two datasets can have the same AVERAGE but very different AVEDEV results; neither function substitutes for the other.

These are documentation-checked expected outputs from Apple, not native execution observations. [D1]

Using a second series 2, 4, 6, 18, place those readings in B8:B11 and enter:

=AVEDEV(B8:B11)

The arithmetic mean is (2+4+6+18)/4 = 7.5. Absolute departures from 7.5 are 5.5, 3.5, 1.5 and 10.5, totaling 21. Thus the expected AVEDEV is 5.25. This is a reproducible independent calculation, not an asserted observation from Numbers.

Compare that with the first series’ 2: an unusually large final reading increases the typical distance from the mean. If comparing measurements across teams, also check whether they use the same units and sampling strategy.

Sanity check: If B14:B17 contains 5, 5, 5, 5, =AVEDEV(B14:B17) should be 0, because every distance to the mean is zero. This is independently calculated using Apple’s described algorithm.

1. Deviation is unexpectedly large. Check for outliers, incorrect units, or unusually high/low numeric cells. Compare the underlying average and inspect every entered observation.
2. Mixing value types. Apple requires same-type values. Separate numbers from durations or dates rather than assuming automatic conversions. [D1]
3. Duration display seems unusual. The documented duration example yields a duration such as 1d 12h; exact visual rendering depends on formatting/locale. This guide makes no claim about the application-specific string output for every setting. [D1]
4. An error or blank after pasting. Check for missing required value, mistaken table/range references and regional comma/semicolon separators. Native error codes for invalid data, error-containing ranges, or wholly empty inputs remain unverified.
5. Text and blanks. Apple’s AVEDEV page does not fully specify every text/blank/error-handling case. Do not copy Excel’s detailed coercion or argument-count limits into a Numbers guide without separate Numbers evidence.
6. Confusing deviation with variance or standard deviation. AVEDEV uses absolute distances and divides by the number of values. Variance and standard deviation use squared distances and may employ a different denominator. Decide which statistic represents the question you are answering.

AVEDEV is also a familiar name in Microsoft Excel and some other spreadsheet packages, but the shared name only supports conceptual compatibility of mean absolute deviation. Apple’s documented argument types include same-type dates and durations. Do not assume an Excel-specific limit on argument count, special text treatment or empty-cell behaviour applies to Numbers. Verify those in the destination application’s official documentation and test migration worksheets before relying on cross-platform numerical agreement. [D1]

• AVERAGE in Apple Numbers — find the centre used in mean-deviation calculations.
• COUNT in Apple Numbers — audit numeric sample counts in a table.
• SUM in Apple Numbers — inspect totals behind the arithmetic.

• [D1] Apple, “AVEDEV,” Functions Help 15.4: https://support.apple.com/guide/functions/avedev-ffa5ab7bf2/15.4/web/1.0 — syntax, accepted same-type inputs, definition, duration return type, official numeric and duration examples. Documentation checked, accessed 2026-10-12.
• [L1] Apple, “Functions overview,” Functions Help 15.4: https://support.apple.com/guide/functions/functions-overview-ffa083bef0c/15.4/web/1.0 — regional separator handling and argument conventions. Documentation checked, accessed 2026-10-12.
• Validation: the four-reading sample, outlier case and all-equal case were independently calculated; Apple’s numeric and duration samples were documentation checked. Native Apple Numbers executions: 0.