Skip to content
Tutorial Reference

How to Calculate the Average of an Array of Numbers in Batch Script

Learn how to compute the mean of an array in Windows Batch using integer division, including sum accumulation, error handling, and limitations like 32-bit overflow and truncated decimal results.

Calculating the Average (Mean) of a data set is a standard way to determine "Typical" performance or usage. In Batch, this requires a two-step process: first, calculating the total sum of all elements in your array, and second, dividing that sum by the number of elements. While Batch math is limited to whole numbers, it is excellent for quick, integer-based averages.

In this guide, we will demonstrate how to calculate the average of an array using an accumulator and a counter.

The Strategy: Sum / Count

  1. Initialize a total variable to 0.
  2. Iterate through the array, adding each item to total.
  3. Store the number of items (count).
  4. Perform the division: set /a "avg=total / count".

Implementation Script

@echo off
setlocal enabledelayedexpansion

:: 1. Define the Array (Sample Scores)
set "size=5"
set "ARR_1=80"
set "ARR_2=95"
set "ARR_3=70"
set "ARR_4=100"
set "ARR_5=85"

:: 2. Verify the array is not empty
if not defined ARR_1 (
    echo [ERROR] Array is empty - nothing to average.
    pause
    exit /b 1
)

set "total=0"

echo Calculating average for: !ARR_1! !ARR_2! !ARR_3! !ARR_4! !ARR_5!

:: 3. Sum the elements
for /L %%i in (1,1,%size%) do (
    :: Use call to resolve the dynamic variable name
    call set "val=%%ARR_%%i%%"
    set /a "total+=val"
)

:: 4. Calculate Average (Sum / Size)
if !size! GTR 0 (
    set /a "avg=total / size"
) else (
    echo [ERROR] Cannot divide by zero - size is 0.
    pause
    exit /b 1
)

echo.
echo ==========================================
echo TOTAL SUM: !total!
echo COUNT:     !size!
echo AVERAGE:   !avg!
echo ==========================================

endlocal
pause

Why Calculate Averages?

  1. Usage Baselines: Finding the average length of a script's execution over a week to identify "Unusually slow" future runs.
  2. Health Auditing: Calculating the average number of files generated per day to predict storage growth.
  3. Benchmarking: Comparing the average performance of several different servers to determine which one is most efficient.

Important Limitations

  1. Integer Math (No Decimals): Batch arithmetic does not support floating point numbers. 85 / 2 will result in 42, not 42.5. The decimal part is simply truncated (thrown away).
  2. 32-Bit Limit: The Sum must not exceed 2.1 billion. If your total is very high, the division will be performed on an incorrect, overflowed sum.
  3. Division by Zero: Always verify that your size is greater than 0 before performing the division, or the script will crash with a "Division by zero" error.

Better Precision (PowerShell Alternative)

If you need accurate decimals (e.g., an average of 42.5), use a PowerShell bridge from within your Batch file:

@echo off
powershell -NoProfile -Command "(80, 95, 70, 100, 85 | Measure-Object -Average).Average"
pause

Conclusion

Calculating an average transforms raw individual numbers into a single, understandable metric of performance. By combining a summation loop with whole-number division, you can quickly baseline your system data and identify outliers. This ability to interpret mathematical trends is essential for building scripts that effectively monitor health and project future resource requirements.

Navigation