Statistical Functions

Statistical Functions

Statistical functions perform calculations based on certain criteria. Countif is used to count a range of selected cells that meet a specified criteria. Countblank counts the number of blank cells in a range of cells. Rank.Eq displays the rank of a selected cell within a range of cells. These are useful functions to perform calculations on data contained within a worksheet.

Countif

1. Create the following table:

2. Select cell B16

3. On the Formulas tab in the Function Library, select More Functions then Statistical

4. Select CountIf

5. Select the Range B2:B14

6. Enter the Criteria as >30

7. Click OK

8. This will Count the cells with a value greater than 30

Countblank

Select cell B17 On the Formulas tab in the Function Library, select More Functions then Statistical Select CountBlank Select the cell Range B2:B14 Click OK This Counts the Blank cells in the Range

Rank.Eq

Select cell B18 On the Formulas tab in the Function Library, select More Functions then Statistical Select Rank.Eq In the Number text box select cell B13 In the Ref text box select the range B2:B14 Click OK This will find the rank of the selected number in that range Save the spreadsheet as “Statistical Functions”

For more information about Advanced Spreadsheet features, click on the paperback cover below: