MAX(number1,number2…) The largest number in the range MIN(number1,number2…) The smallest number in the range STDEV.P(number1,number2…) The estimated standard deviation of the numbers in the range VAR.P(number1,number2…) The estimated variance of the numbers in the range TABLE 5–2 Commonly used statistical functions Step-by-Step 5.3 1. Click cell B15. On the Formula Bar, click the Insert Function button . The Insert Function dialog box appears. You want to find the average of values in the range B3:B7. 2. Next to the Or select a category box, click the arrow, and then click Statistical. The Statistical functions appear in the Select a function box. 3. In the Select a function box, click AVERAGE, and then click OK. The Function Arguments dialog box appears. 4. Next to the Number1 box, click the Collapse Dialog Box button . The Function Arguments dialog box shrinks to its title bar and Number1 box. 5. In the worksheet, drag to select the range B3:B7. The range reference appears in the Number1 box, as shown in Figure 5–7. TIP
MAX(number1,number2…) The largest number in the range MIN(number1,number2…) The smallest number in the range STDEV.P(number1,number2…) The estimated standard deviation of the numbers in the range VAR.P(number1,number2…) The estimated variance of the numbers in the range TABLE 5–2 Commonly used statistical functions Step-by-Step 5.3 1. Click cell B15. On the Formula Bar, click the Insert Function button . The Insert Function dialog box appears. You want to find the average of values in the range B3:B7. 2. Next to the Or select a category box, click the arrow, and then click Statistical. The Statistical functions appear in the Select a function box. 3. In the Select a function box, click AVERAGE, and then click OK. The Function Arguments dialog box appears. 4. Next to the Number1 box, click the Collapse Dialog Box button . The Function Arguments dialog box shrinks to its title bar and Number1 box. 5. In the worksheet, drag to select the range B3:B7. The range reference appears in the Number1 box, as shown in Figure 5–7. TIP
Excel%20Lesson%205.docx