Figure 83: Cell-specific Error Checking and Debugging

In the example shown in the figure, the options show:

” the error type (“Number Error”),

” a link to assistance on understanding and debugging the error (“Help

on this error”),

” a step-by-step debugger to catch the calculation step at which the error

occurred (“Show Calculation Steps”),

” the option to ignore and thereby keep the error as is (“Ignore Error”),

” a link to directly edit the formula in the cell (“Edit in Formula Bar”),

84

Chapter 5: Tracing Cell References & Debugging Formula Errors

” the overall error-checking options (“Error Checking Options”), and

” direct access to the Formula Auditing Toolbar (“Show Formula

Auditing Toolbar”) and, thereby, to all the features of Auditing (these

features are taught in this chapter)

ERROR CHECKING OPTIONS

5.8

The Error Checking options can be assessed through

TOOLS/OPTIONS/ERROR CHECKING or through TOOLS/ERROR

CHECKING/OPTIONS. The dialog is reproduced in the next figure.

Figure 84: Error Checking options

You can inform Excel to show as an error any cell: that contains:

85

Statistical Analysis with Excel

• A formula that evaluates to an error value

• A formula that refers to an empty cell

• A formula that is not consistent with the other formulas and cell

references in neighboring cells

• A two-digit year (like “02”) instead of a four-digit year (like “2002”)

A number stored as text

•

The other options are beyond the scope of this book. I recommend sticking

with the default settings reproduced in the next figure.

86

Page for Notes

Statistical Analysis with Excel

CHAPTER 6

FUNCTIONS FOR BASIC STATISTICS

This chapter discusses the following topics:

” “AVERAGED” MEASURES OF CENTRAL TENDENCY

” AVERAGE, TRIMMED MEAN, HARMONIC MEAN, GEOMETRIC

MEAN

” LOCATION MEASURES OF CENTRAL TENDENCY

” MEDIAN, MODE

” OTHER LOCATION PARAMETERS

” QUARTILE, PERCENTILE

” MAXIMUM VALUE, MINIMUM VALUE, LARGE, SMALL

” RANK OR RELATIVE STANDING OF EACH CELL WITHIN THE

RANGE OF A SERIES

” MEASURES OF DISPERSION (STANDARD DEVIATION &

VARIANCE)

” STDEV, VAR, STDEVA, VARA, STDEVP, VARP, STDEVPA,

VARPA

” SHAPE ATTRIBUTES OF THE DENSITY FUNCTION

” SKEWNESS, KURTOSIS

” FUNCTIONS ENDING WITH AN “A” SUFFIX

I am presuming that the reader is familiar with basic statistical functions

and/or has access to a basic statistics reference for learning more about

88

Chapter 6: Functions for Basic Statistics