The following tutorial is an introduction to Excel functions such as average, standard deviation, maximum, minimum, and conditional counting.

There are many functions in Excel that extend the power of spreadsheet analysis. One additional function is VLOOKUP or HLOOKUP to retrieve values from large tables. This tutorial covers sorting and lookup functions to programmatically select desired data from larger sets.

Data analysis can also be completed with scripting programming languages like MATLAB and Python where the data sets are arrays or matrices instead of tables in a spreadsheet. Click on the appropriate link for additional information and source code.

comments powered by Disqus

Retrieved from http://apmonitor.com/che263/index.php/Main/ExcelFunctions

Page last modified on September 02, 2015, at 10:23 AM