70

Chapter 4: Inserting functions

Type a comma, and then go to INSERT/FUNCTION and choose the

function “Count” from the function category “Statistical” to get the final

formula.

Figure 63: The completed formula

There are two other ways to write this formula.

Select the option INSERT/FUNCTION, choose the function

CONFIDENCE from the category “Statistical” and type in the formulae

“STDEV(E:E)” and “COUNT(E:E)” as shown in Figure 64.

This method is much faster but requires that you know the function

names STDEV and COUNT.

Figure 64: If sub-functions are required in the formula of a function, the sub-functions may be

typed into the relevant text-box of the function™s dialog

The third way to write the formula is to type it in. This is the fastest

method.

Figure 65: The result is the same

71

Statistical Analysis with Excel

NEW FUNCTION-RELATED FEATURES IN THE XP

4.5

VERSION OF EXCEL

Searching for a function

Type a question (like “estimate maximum value”) into the box “Search for

a function” utility and click on the button “Go.” Excel will display a list of

functions related to your query.

Figure 66: Search for a function utility is available in the XP version of Excel

4.5.A ENHANCED FORMULA BAR

After you enter a number or cell reference for the first function

“argument” (or first “requirement”) and type in a comma, Excel

automatically converts to bold format the next argument/requirement. In

the example shown in the next figure, Excel makes bold the font for the

argument placeholder pmt after you have entered a value for nper and a

comma.

Figure 67: The Formula Bar Assistant is visible below the Formula Bar

Similarly, the argument/requirement after pmt has a bold font after you

have entered a value or reference for the argument pmt

72

Chapter 4: Inserting functions

Figure 68: The next “expected” argument/requirement if highlighted using a bold font

The square brackets around the argument/requirement “fv” indicate that

the argument is optional. You need not enter a value or reference for the

argument.

Figure 69: An optional argument/requirement

4.5.B ERROR CHECKING AND DEBUGGING

The basics of this topic are taught in the next chapter. Advanced features

are in Volume 3: Excel”Beyond the basics.

73

Page for Notes

Chapter 5: Tracing Cell References & Debugging Formula Errors

CHAPTER 5

TRACING CELL REFERENCES &

DEBUGGING FORMULA ERRORS

This short chapter demonstrates the following topics:

” TRACING THE CELL REFERENCES USED IN A FORMULA

” TRACING THE FORMULAS IN WHICH A PARTICULAR CELL

IS REFERENCED

” WATCH WINDOW

” ERROR CHECKING

” FORMULA EVALUATION