FLXCode Average Calculator

FLXCode apps

Appearance

Average Calculator

Paste a list for a plain average, or paste values with their weights for a weighted one.

Paste a column or row from Excel, Google Sheets or a CSV file, or type numbers separated by spaces, commas or new lines. A header word is ignored.

Example Average

21.5 Average (mean)

Read 6 numbers.

Results
Count (n)6
Sum129
Smallest14
Largest31
Median20.5

The steps, with your numbers

Add the numbers: 14 + 18 + 22 + 25 + 31 + 19 = 129

Divide by how many there are: 129 / 6 = 21.5

No ads. No account. Nothing you type or record is uploaded. We count page events with a daily code. Check it.

Problem or idea? Email us

Quick start

  1. Pick Average for a list of numbers, or Weighted average when some numbers count more than others.
  2. For a list, paste the numbers. For weighted, paste two columns: value first, weight second.
  3. The result and the arithmetic appear as you type.

Average of a list

average = (x₁ + x₂ + … + xₙ) / n

NumbersSumCountAverage
14 18 22 25 31 19129621.5
85 90 78 92 88433586.6
3.5 4.25 2.75 3 417.553.5

Weighted average

weighted average = Σ(w × x) / Σw

CaseValues and weightsWeightedPlain
Course grade90 at 40, 82 at 35, 75 at 2583.4582.3333
GPA4.0 at 3, 3.0 at 4, 3.7 at 3, 2.7 at 2 credits3.3753.35
Average price paid2.50 for 4 kg, 3.10 for 2 kg, 1.90 for 6 kg2.32.5

In the last row the plain average of the three prices is 2.5, but you bought more of the cheap one, so the price you actually paid per kg is 2.3.

In a spreadsheet

TaskFormula
Plain average=AVERAGE(A1:A10)
Weighted average=SUMPRODUCT(A1:A10,B1:B10)/SUM(B1:B10)
Average that skips zeros=AVERAGEIF(A1:A10,"<>0")

Numbers this uses

Every constant the tool uses is listed here with its source. Where a number varies, you can edit it in the tool.

  • Limit is 100,000 numbers or pairs. Kept low so the page stays quick on a phone.
  • Weights is any non-negative numbers, not all 0. They are divided by their own sum, so percents, points and credits all work.

Common mistakes

  • Averaging percentages from groups of different sizes. Weight them by group size.
  • Counting an empty cell or a total row as a number. The tool skips text and reports it.
  • Using the average when a few huge values pull it up. Try the median.

Nothing you type or paste is uploaded. We count events without cookies (details).

FAQ

How do I calculate an average?

Add all the numbers and divide by how many there are. For 85, 90, 78, 92, 88 the sum is 433 and there are 5 numbers, so the average is 86.6.

What is a weighted average?

A weighted average gives some numbers more pull than others. Multiply each value by its weight, add those up and divide by the sum of the weights. A course with scores of 90, 82 and 75 weighted 40, 35 and 25 gives 83.45, while the plain average would be 82.3333.

Do the weights have to add up to 100?

No. The division by the sum of the weights takes care of that. Weights of 40, 35 and 25 give the same answer as 0.4, 0.35 and 0.25, or 8, 7 and 5. Only the ratios matter.

How do I calculate a GPA this way?

Use the grade points as the values and the credit hours as the weights. Grades of 4.0, 3.0, 3.7 and 2.7 with 3, 4, 3 and 2 credits give a GPA of 3.375. Pick Weighted average and paste the grade and credits as two columns.

What is the average of averages, and is it right?

Averaging averages is only correct when each group has the same size. Otherwise weight each average by the number of items in its group. Paste each group's average with its count as the value and the weight.

What is the formula in Excel or Google Sheets?

=AVERAGE(A1:A10) for a plain average. For a weighted average with values in A1:A3 and weights in B1:B3, use =SUMPRODUCT(A1:A3,B1:B3)/SUM(B1:B3). Both work in Excel and Google Sheets.

Is the average the same as the mean?

In everyday use, yes. In statistics "average" can also mean the median or the mode, so say "mean" when it matters. The mean median mode calculator shows all three.

Do you keep the numbers I paste?

No. They stay in this page, are not stored and are not sent. We only count which mode you used, plain or weighted.

More from FLXCode

Share Average Calculator