How to Calculate Percentage Difference
Unlike percentage change, which has a clear starting point and a clear ending point, percentage difference is used when you're comparing two values that sit on equal footing — neither one is the "original" and neither is the "result." To find it, you take the absolute difference between the two numbers and divide it by their average, rather than by either value alone. That's the key distinction: because the denominator is a shared average instead of a fixed starting value, the order you list the numbers in never changes the answer. Swap A and B and you'll get the exact same percentage difference every time, which makes this formula the right tool whenever you're stacking two competing quotes, two lab readings, or two survey results side by side rather than tracking growth over time.
When Would I Use a Percentage Difference?
- Product comparisons: Evaluating the pricing variance between two store competitors.
- Experimental errors: Comparing measured labs data vs standard values in chemistry or physics.
- Demographics statistics: Evaluating population numbers differences between two adjacent towns.
Worked Example: Comparing Two Prices
To find the percentage difference between 10 and 15:
- Absolute Difference: |10 - 15| = 5
- Average: (10 + 15) / 2 = 12.5
- Divide difference by average: 5 / 12.5 = 0.4
- Multiply by 100: 0.4 × 100 = 40% difference.
Worked Example: Comparing Two Test Scores
Two students scored 72 and 78 on the same exam. Here's the percentage difference between their results:
- Absolute Difference: |72 - 78| = 6
- Average: (72 + 78) / 2 = 75
- Divide difference by average: 6 / 75 = 0.08
- Multiply by 100: 0.08 × 100 = 8% difference.
Percentage Difference FAQ
Q: How do I calculate percentage difference in Excel?
Use the formula =ABS(A2-B2)/AVERAGE(A2,B2) in an empty cell, and then change the formatting to a percentage style.
Q: What is the difference between percentage difference and percentage change?
Percentage change has a directional start value and final value, while percentage difference is a relative comparison of two numbers regardless of order.
Q: Can percentage difference be negative?
No. Since the formula uses the absolute difference, the resulting percentage difference is always positive or zero.
Q: When should I use percentage difference instead of percentage error?
Use percentage difference when neither value is treated as the 'true' or accepted one — like comparing two competing measurements. Use percentage error instead when one value is a known, accepted standard and you're checking how far an experimental or estimated value strays from it.