Microsoft Office Tutorials and References

In Depth Information

**Appendix: Descriptive Statistics with the Mac Excel 2011**

FIGURE 10.5
The Calculated Values and the Formulas

—

the Results Are Shown on the Left

and the Formulas Are Shown on the Right

FIGURE 10.6
Using F3 for Named Data

this time I

used the functions for the highest value in the range (Excel function MAX), the

lowest value (MIN), the MEDIAN, the MODE, and the standard deviation

(STDEVP). It is preferable to use STDEVP for the standard deviation as the calcu-

lation applies to a large population. In this example, there are 500 values. If it was a

small sample (

I repeated the process on the same sheet using the Function icon, f
x
—

30) I would have used STDEV. The results are shown in Figure 10.5,

which contains the results on the left and reveals the formulas on the right. I can use

either CTRL

<

þ
0
or CTRL

þ

~
to reveal all the formulas.

this time using shortcuts to calculate the statistics. I chose

to go over it again with shortcuts, since it may save you valuable time when you use

Excel and functions. I am going to demonstrate it with the highest value

Try it one more time

—

—

MAX

—

and the SUM. For the MAX value I used Shift

F3 to activate the Functions menu.

When the menu appeared I used F3 for the Names menu. I chose DATA and pressed

Enter and I had the answer

þ

—

as you can see in Figure 10.6. Try it

—

it saves time.

in the cell where the

result should appear. After SUM appears in the cell, use F3 to call up the name list.

Select DATA and hit Enter. It is demonstrated in Figure 10.7.

For the SUM, I saved time by typing the shortcut ALT

þ¼

APPENDIX: DESCRIPTIVE STATISTICS WITH MAC EXCEL 2011

The only difference when using this version of Excel is the way the function menu

looks. Let me illustrate with one function, the average. I select the cell D3 where I

would like the answer to be located, and then select f
x
(Insert function). I can choose

the category Statistical, or type in the

cell Average. A menu

to insert the function arguments will appear at the bottom of the menu. 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.8.

“

Search for a function

”