 Using Worksheet Functions for Statistical Analysis in Excel 2016 - dummies

# Using Worksheet Functions for Statistical Analysis in Excel 2016

Excel 2016b has a variety of functions for statistical analysis. The Function Library area of the Formulas tab shows all categories of Excel worksheet functions. The steps in using a worksheet function are

1. Type your data into a data array and select a cell for the result.
2. Select the appropriate formula category and choose a function from its pop-up menu.
Doing this opens the Function Arguments dialog box.
3. In the Function Arguments dialog box, type the appropriate values for the function’s arguments.
Argument is a term from mathematics. It has nothing to do with debates, fights, or confrontations. In mathematics, an argument is a value on which a function does its work.
4. Click OK to put the result into the selected cell.

Yes, that’s all there is to it.

To give you an example, let’s explore a function that typifies how Excel’s worksheet functions work. This function, `SUM`, adds up the numbers in cells you specify and returns the sum in still another cell that you specify. Although adding numbers together is an integral part of statistical number-crunching, `SUM` is not in the Statistical category. It is, however, a typical worksheet function, and it shows a familiar operation.

Here, step by step, is how to use `SUM`:

1. Enter your numbers into an array of cells and select a cell for the result.
In this example, enter 45, 33, 18, 37, 32, 46, and 39 into cells C2 through C8, respectively, and selected C9 to hold the sum.
2. Select the appropriate formula category and choose the function from its pop-up menu.
This step opens the Function Arguments dialog box.
Select `Formulas | Math & Trig` and scroll down to find and choose `SUM`.
3. In the Function Arguments dialog box, enter the appropriate values for the arguments.
Excel guesses that you want to sum the numbers in cells C2 through C8 and identifies that array in the Number1 box. Excel doesn’t keep you in suspense: The Function Arguments dialog box shows the result of applying the function. In this example, the sum of the numbers in the array is 250.
4. Click OK to put the sum into the selected cell.

Note a couple of points. First, the Formula bar holds

`=SUM(C2:C8)`

This formula indicates that the value in the selected cell equals the sum of the numbers in cells C2 through C8.

After you get familiar with a worksheet function and its arguments, you can bypass the menu and type the function directly into the cell or into the Formula bar, beginning with an equal sign (=). When you do, Excel opens a helpful menu as you type the formula The menu shows possible formulas beginning with the letter(s) you type, and you can select one by double-clicking it.

A value can be another array of cells anywhere in the worksheet, a number, an arithmetic expression that evaluates to a number, a cell ID, or a name that you have attached to a range of cells. you type values, the `SUM` dialog box shows the updated sum. Clicking OK puts the updated sum into the selected cell.