Microsoft Office Tutorials and References

In Depth Information

**Using ABS() to Figure Out the Magnitude of ERROR**

Note

Romans did have a way to represent 5000 and 10000, but the format

cannot be typed on a modern keyboard; hence, the programmers behind

ARABIC are apparently allowing nonsensical numbers like

MMMMMIV.

The text can be a Roman numeral in any of the formats in cells A9:A14. Even

though you are not allowed to repeat M more than four times in a number, the

ARABIC function attempts to convert the text to a number. Use ARABIC on a

string of 255 M
’
s and you get 255,000, even though this is against all the

rules. Similarly, a minus sign and 254 M
’
s will produce
–
254000.

Figure 11.23
shows various uses (and misuses) of ROMAN and ARABIC. For-

mulas in E6, E11, and E13 allow you to do math with Roman numerals.

Using

Using
ABS()

ABS()
to Figure Out the Magnitude of

to Figure Out the Magnitude of
ERROR

ERROR

Suppose that you work for a local TV station, and you want to prove that

your forecaster is more accurate than those at the other stations in town.

The forecaster at the rival station in town is horrible
—
some days he misses

high, and other days he misses low. The rival station uses
Figure 11.24
to

say that his average forecast is 99% accurate. All those negative and pos-

itive errors cancel each other out in the average.