Statistical Functions in Excel

Statistical Functions in Excel

Statistical Functions in Excel Tutorial

---------

Statistics plays a vital role in decision making. Before we make the report ready we must use some of the statistical functions in excel.



How do you find the maximum value from the lot ?

Use MAX function.

How do you find the Xth small value from the lot ?

Use SMALL function.

How do you find the Xth largest value from the lot ?

Use LARGE function.



Like this we can use statistical tests like P Value, F Test, Trend line, Frequency function, Forecast function etc.…