How to calculate percent error
Subtract, divide by the accepted value, and multiply by 100. The accepted value always goes on the bottom, because it is the one treated as correct. Here are your numbers:
Here it is with your numbers:
- Find how far off the measurement is, ignoring any minus sign: 9.81 − 10.2, which is 0.39.
- Divide by the accepted value: 0.39 ÷ 9.81 = 0.0398.
- Multiply by 100 to turn it into a percent: 3.98%.
It means the measurement is 3.98% above the accepted value.
Source NC State University · Appendix B: Percent Error and Percent Difference (physics lab manual) ↗
Measured value and accepted value
The measured value (also called experimental or observed) is what you got in the lab. The accepted value (true, theoretical or literature value) is the one in your textbook or data table. Percent error ignores the direction, so it is never negative: 9.6 and 10.02 against 9.81 are both about 2% off. The Direction tile tells you whether you came in high or low, which helps when you discuss sources of error.
If you are comparing two of your own measurements and neither is “correct”, use percent difference instead: it divides by the average of the two. The Percent Difference Calculator does both.
Percent error in Excel or Google Sheets
With the measured value in A2 and the accepted value in B2, type =ABS(B2-A2)/ABS(B2) and format the cell as a percentage. ABS removes the minus sign.
Source Microsoft Support · ABS function ↗
FAQs
What is the formula for calculating percentage error?
Percent error = |accepted − measured| ÷ accepted × 100. Subtract to find how far off you are, drop any minus sign, divide by the accepted value, and multiply by 100. For 10.2 against 9.81: 0.39 ÷ 9.81 × 100 is 3.98%.
Source NC State University · Appendix B: Percent Error and Percent Difference (physics lab manual) ↗
Sources
- NC State University: Appendix B: Percent Error and Percent Difference (physics lab manual)
- Microsoft Support: ABS function