Microsoft Office Tutorials and References

In Depth Information

**Chapter 10: Descriptive Statistics**

CHAPTER
10

Descriptive Statistics

In this chapter, I start with statistical analysis of the data on the sheet called

Statistics in the Excel workbook Chapter 10 shown in Figure 10.1.

The data in column A contains a list of 500 students

’

IQs. I selected the range

A1:A500 and named the range

I used the procedure described in Chapter

4. If you expand the name box above A1 by clicking the drop-down arrow/menu to

the right of the field and then select the name DATA, it will highlight the range of

named cells A1:A500.

“

DATA.

”

DESCRIPTIVE STATISTICS

In this section I am going to calculate several frequently used statistics functions. I

will start with the mean, the highest value, the lowest value, the standard deviation,

the median, and the mode.

Let me begin with the average. I select the cell D3 where I would like the answer

to be located, and then select f
x
(Insert function) or use Shift

þ

F3. Choose the cate-

gory Statistical, then the function Average. See Figure 10.2.

A menu to insert the function arguments will appear

since the goal is to

compute the average of our data set, I could select the range A1:A500, but as the

range was previously named DATA, I can simply type in the word DATA and click

OK to obtain the average. See Figure 10.3.

The result is shown in Figure 10.4.

—

FIGURE 10.1
Data on the Sheet

“

Statistics

”