Microsoft Office Tutorials and References
In Depth Information
Using ABS() to Figure Out the Magnitude of ERROR
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
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.
ABS() to Figure Out the Magnitude of
to Figure Out the Magnitude of 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.