Working with AVERAGE function in Excel

Returns the average (arithmetic mean) of the arguments. For example, if the range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

The syntax of the average function is: 
AVERAGE(number1, [number2], ......[number255])

[Number 1] Required. The first numbercell reference or a range for which you want the average.
Other numberscell references or ranges for which you want the average, up to a maximum of 255.

Type the data into cell A1 to A10 (3,5,12,15,3,5,8,9,5,2)
Goto cell A11 (where you want to display the result)

Figure: 1.1 

Goto upper side the Excel file you will see the tabs. Click the Formulas Tab (as shown in Figure 1.1)

                                                                     Figure: 1.2 

After the clicking Formulas Tab the new tab appear on Tab bar.
Step1: Click the More Functions
(when you click the More functions the menu will be appear)
Step2: Click the Statistical (and the sub menu appear)
Step3: Clcik the AVERAGE
(See the figure 1.2 for example)

Figure 1.3
Now you will see the new popup window on your screen (see the figure 1.3 for example)

select the range A1:A10 and then click OK.

                                                                     Figure 1.4
or direct type the cell A11 =AVERAGE() and select the range (A1:A10) (see the figure 1.4)

The answer of 6.7, which corresponds to the average value of data in cells A1 to A10, should appear in cell A11.

No comments:

Post a Comment

Recommended for You


Related Posts Plugin for WordPress, Blogger...