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