Microsoft Office Tutorials and References
In Depth Information
Chapter 10: Descriptive Statistics
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.
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
Search JabSto ::

Custom Search