STATISTICAL FUNCTIONS
1. AVEDEV:- In Microsoft Excel “AVEDEV” function returns the average
of absolute value of deviations from the mean for a given set of data.
Syntax of AVEDEV function
=AVEDEV(number1,[number2],….)
Arguments:-
Number1:- The first value or reference.
Number2:- The
second value or reference [optional part].
Example of AVEDEV function:-
The
following picture shows the example of the AVEDEV
function.
2. AVERAGE:- In Microsoft Excel “AVERAGE” function calculates the
average of given group of numbers. Average can handle up to 255 arguments. It
can be numbers, range, arrays, cell references and constants.
Syntax of AVERAGE function
=AVERAGE(number1,[number2],……)
Arguments:-
Number1:- A number or cell reference (numeric
values).
Number2:- A number or cell reference (numeric
values) and it is an optional part.
Example of AVERAGE function:-
The
following picture shows the example of the AVERAGE
function.
3. AVERAGEA:- In Microsoft Excel “AVERAGEA” function returns the average of its arguments, evaluating text
and FALSE in arguments as 0; TRUE evaluates as 1. The arguments can be numbers,
names, arrays or references.
Syntax of AVERAGEA function
=AVERAGEA(value1,[value2],…..)
Arguments:-
Value1:- A value or cell reference (evaluated
as number).
Value2:- A value or cell reference (evaluated
as number) and it is an optional part.
Example of AVERAGEA function:-
The
following picture shows the example of the AVERAGEA
function.
4. AVERAGEIF:- In Microsoft Excel “AVERAGEIF” function finds average for
the cells specified by a given condition or criteria. The criteria used for AVERAGEIF can include logical operators
(>, <, <>, =).
Syntax of AVERAGEIF function
=AVERAGEIF(range,criteria,[average_range])
Arguments:-
Range:- The array of values to be tested.
Criteria:- The condition to be tested in the
supplied range against each of the values.
Average_range:- The actual set of cells to average
and it is an optional part if omitted range is used.
Example of AVERAGEIF function:-
The
following picture shows the example of the AVERAGEIF
function.
0 Comments:
Post a Comment