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
þ
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