1. statistical functions in excel

statistical functions in excel

1. Statistical Functions

2. 1. Average
To calculate the average of a group of numbers, use the AVERAGE function.

3. 2. Averageif
•To average cells based on one criteria, use the AVERAGEIF
function. For example, to calculate the average excluding
zeros

4. 3. Median
•To find the median (or middle number), use
the MEDIAN function.

5. 4.Mode
•To find the most frequently occurring number,
use the MODE function.

6. 5. Standard Deviation
•To calculate the standard deviation, use the
STEDV function.
•standard deviation is a number that tells you
how far numbers are from their mean.

7. 6. Min
•To find the minimum value, use the MIN
function.

8. 7. Max
•To find the maximum value, use the MAX
function.
•

9. 8. Large
•To find the third largest number, use the
following LARGE function.

10. 9. Small
•To find the second smallest number, use the
following SMALL function.

11. 10. future value function
•TheExcelFVfunctionisafinancialfunctionthatreturnsthefuturevalueofan
investment.
•YoucanusetheFVfunctiontogetthefuturevalueofaninvestmentassuming
periodic,constantpaymentswithaconstantinterestrate.

12. 11. Count Function
•We use the count function when we need to count the number of cells containing
a number. RememberONLY NUMBERS! Let’s see the function:
•COUNT(value1, [value2], …)

13. Thank you