Main

## Excel Functions

## Main.ExcelFunctions History

Hide minor edits - Show changes to output

Changed lines 5-6 from:

The following ~~tutorials are~~ an introduction to Excel functions such as average, standard deviation, maximum, minimum, and conditional counting.

to:

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

Changed line 11 from:

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.

to:

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.

Changed line 17 from:

Data analysis can also be completed with scripting programming languages like [[Main/~~MatlabPlots~~|MATLAB]] and [[Main/~~PythonPlots~~|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.

to:

Data analysis can also be completed with scripting programming languages like [[Main/MatlabFunctions|MATLAB]] and [[Main/PythonFunctions|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.

Added lines 1-36:

(:title Excel Functions:)

(:keywords big data, data analysis, Microsoft Excel, spreadsheet, average, min, max, stdev, university course:)

(:description Basic statistical functions in a spreadsheet such as Microsoft Excel are implemented to analyze a data set:)

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

(:html:)

<iframe width="560" height="315" src="https://www.youtube.com/embed/kkd-3zlr1ng" frameborder="0" allowfullscreen></iframe>

(:htmlend:)

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.

(:html:)

<iframe width="560" height="315" src="https://www.youtube.com/embed/jzlImZ7qC-Y" frameborder="0" allowfullscreen></iframe>

(:htmlend:)

Data analysis can also be completed with scripting programming languages like [[Main/MatlabPlots|MATLAB]] and [[Main/PythonPlots|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.

----

(:html:)

<div id="disqus_thread"></div>

<script type="text/javascript">

/* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */

var disqus_shortname = 'apmonitor'; // required: replace example with your forum shortname

/* * * DON'T EDIT BELOW THIS LINE * * */

(function() {

var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;

dsq.src = 'https://' + disqus_shortname + '.disqus.com/embed.js';

(document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);

})();

</script>

<noscript>Please enable JavaScript to view the <a href="https://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>

<a href="https://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>

(:htmlend:)

(:keywords big data, data analysis, Microsoft Excel, spreadsheet, average, min, max, stdev, university course:)

(:description Basic statistical functions in a spreadsheet such as Microsoft Excel are implemented to analyze a data set:)

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

(:html:)

<iframe width="560" height="315" src="https://www.youtube.com/embed/kkd-3zlr1ng" frameborder="0" allowfullscreen></iframe>

(:htmlend:)

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.

(:html:)

<iframe width="560" height="315" src="https://www.youtube.com/embed/jzlImZ7qC-Y" frameborder="0" allowfullscreen></iframe>

(:htmlend:)

Data analysis can also be completed with scripting programming languages like [[Main/MatlabPlots|MATLAB]] and [[Main/PythonPlots|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.

----

(:html:)

<div id="disqus_thread"></div>

<script type="text/javascript">

/* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */

var disqus_shortname = 'apmonitor'; // required: replace example with your forum shortname

/* * * DON'T EDIT BELOW THIS LINE * * */

(function() {

var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;

dsq.src = 'https://' + disqus_shortname + '.disqus.com/embed.js';

(document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);

})();

</script>

<noscript>Please enable JavaScript to view the <a href="https://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>

<a href="https://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>

(:htmlend:)