0 of 46 lessons complete.
Module 4: Engineering Calcs · Lesson 22 of 46
Percent Error
Compare measured results to expected values.
Step 1 of 20%
Percent error = |measured − expected| ÷ expected. ABS gives the absolute value. In D2, calculate the percent error for trial 1.
Target: D2
D2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Trial | Expected (m/s²) | Measured (m/s²) | % Error | ||
| 2 | 1 | 9.81 | 9.65 | |||
| 3 | 2 | 9.81 | 9.9 | |||
| 4 | 3 | 9.81 | 9.78 | |||
| 5 | 4 | 9.81 | 9.6 | |||
| 6 | ||||||
| 7 | ||||||
| 8 |
Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $