Statistical functions in excel 2010/Statistical functions in excel with example

Statistical functions in excel 2010/Statistical functions in excel with example

Statistical functions in excel 2007/2010

1.Max function/ How to use the Excel Max function

Returns the largest value in a set of values.Ignores logical values and tex

Max(number1,number2,…)

Examples of max function in excel as bellow :

2.Min function/H ow to use the Excel Min function

Returns the smallest number in a set of values.Ignores logical values and tex

Min(number1,number2,…)

Examples of min function in excel as bellow :

3.Average function/H ow to use the Excel Average function

Returns the average of its arguments, which can be number or names, arrays, or r eferences that contain numbers

Average(number1,number2,…)

Examples of Average function in excel as bellow :

4. Count function/ H ow to use the Excel Count function

Counts the number of cells in a range that contain numbers.

Count(value1, value2,…)

Examples of count function in excel as bellow :

5.Countif function/ H ow to use the Excel Count if function

Counts the number of cell within a range that meet the given condition

Countif(range, criteria)

Examples of countif function in excel as bellow :

6.Sum function/H ow to use the Excel Sum function

Returns the sum of a supplied list of numbers

Examples of sum function in excel as bellow :

SUM(number1, [number2, ... number_n] )