Average function in excel


A quick way to get average of data is by use of average function. The average function returns the average of data in a given range. Most data require average to be done as a way of analysing data or a way of giving central tendency of data. The other way of getting average is by adding the values then dividing by their number.

Note that for average function to work the data must be continous. The illustration below illustrates the stardard use of average function.

Type “=” without quotes from the key board then word average which can be selected from pop up menu which appears after you start typing

Then select the range of data that requires to be averaged

Then enter from the keyboard

Last auto fill the formula to the other cells










Leave a Reply

Your email address will not be published. Required fields are marked *