Datasheet

25
Chapter 1: Evaluating Data in the Real World
reference for both the row and column in the address ($H$11), absolute refer-
ence for the row-part only (H$11), and absolute reference for the column-part
only ($H11).
What’s New in This Edition?
Although Excel’s statistical functions haven’t changed, I’ve restructured the
instructions for every statistical function. The instructions in this edition fit
in with the steps I outlined in the preceding section.
With the disappearance of the Chart Wizard I’ve restructured the instruc-
tions for creating a chart, too. (See Chapter 3.)
One of my points in both editions is that when you report an average, you
should also report variability. For this reason I believe Excel 2007 should also
offer the functions STDEVIF and STDEVIFS in addition to the new functions
AVERAGEIF and AVERAGEIFS. Unfortunately, these functions do not exist in
Excel 2007. To fill the void, I show you how to do what these functions would
do, and in the process take you through some of Excel’s Logical Functions.
(See Chapter 5.)
It’s easier to assign a name to a cell range in Excel 2007 (it takes . . . you
guessed it . . . just-a-few-steps-now). So I rely much more on named cell
ranges in this edition. (See Chapter 2.)
In the Part of Tens, I’ve added a section on importing data from the Web. (See
Chapter 20.)
I pointed out in the Introduction that I’ve added Appendix B and Appendix C.
Each one shows how to do some nifty statistical work that doesn’t come pre-
packaged in Excel.
05 454060-ch01.indd 2505 454060-ch01.indd 25 4/21/09 7:18:00 PM4/21/09 7:18:00 PM