Main

This tutorial can also be completed with scripting programming languages like [[Main/MatlabDataAnalysis|MATLAB]] and [[Main/PythonDataAnalysis|Python]]. Click on the appropriate link for additional information and source code.

## Data Analysis with Excel

## Main.ExcelDataAnalysis History

Hide minor edits - Show changes to output

Added lines 15-18:

(:htmlend:)

(:html:)

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

(:html:)

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

Changed lines 7-11 from:

A common task for scientists and engineers is to analyze data from an external source that may be in a text or comma separated value (CSV) format. By importing the data into a spreadsheet program like Excel, data analysis such as statistics, trending, or calculations can be made to synthesize the information into relevant and actionable information. ~~This~~ tutorial demonstrates how to import data, perform a basic analysis, trend the results, and export the results to another text file.

to:

A common task for scientists and engineers is to analyze data from an external source that may be in a text or comma separated value (CSV) format. By importing the data into a spreadsheet program like Excel, data analysis such as statistics, trending, or calculations can be made to synthesize the information into relevant and actionable information. The following worksheet details some of the common data analysis functions within Excel.

* [[Attach:Excel_Data_Analysis.pdf|Excel Data Analysis Worksheet]]

This following tutorial demonstrates how to import data, perform a basic analysis, trend the results, and export the results to another text file.

* [[Attach:Excel_Data_Analysis.pdf|Excel Data Analysis Worksheet]]

This following tutorial demonstrates how to import data, perform a basic analysis, trend the results, and export the results to another text file.

Added lines 7-8:

A common task for scientists and engineers is to analyze data from an external source that may be in a text or comma separated value (CSV) format. By importing the data into a spreadsheet program like Excel, data analysis such as statistics, trending, or calculations can be made to synthesize the information into relevant and actionable information. This tutorial demonstrates how to import data, perform a basic analysis, trend the results, and export the results to another text file.

Added lines 12-13:

This tutorial can also be completed with scripting programming languages like [[Main/MatlabDataAnalysis|MATLAB]] and [[Main/PythonDataAnalysis|Python]]. Click on the appropriate link for additional information and source code.

Changed line 1 from:

(:title~~ Computational Tools for Engineers -~~ Data Analysis with Excel:)

to:

(:title Data Analysis with Excel:)

Added lines 1-28:

(:title Computational Tools for Engineers - Data Analysis with Excel:)

(:keywords big data, data analysis, Microsoft Excel, spreadsheet, nonlinear, optimization, engineering optimization, Excel, Visual Basic, university course:)

(:description Data Analysis with Microsft Excel - Problem-Solving Techniques for Chemical Engineers at Brigham Young University:)

!!!!Spreadsheet Data Analysis

(:html:)

<iframe width="560" height="315" src="//www.youtube.com/embed/FaAgXMnt0QI?list=PLLBUgWXdTBDi-E--rwBujaNkTejLNI6ap" frameborder="0" allowfullscreen></iframe>

(:htmlend:)

----

(: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, nonlinear, optimization, engineering optimization, Excel, Visual Basic, university course:)

(:description Data Analysis with Microsft Excel - Problem-Solving Techniques for Chemical Engineers at Brigham Young University:)

!!!!Spreadsheet Data Analysis

(:html:)

<iframe width="560" height="315" src="//www.youtube.com/embed/FaAgXMnt0QI?list=PLLBUgWXdTBDi-E--rwBujaNkTejLNI6ap" frameborder="0" allowfullscreen></iframe>

(:htmlend:)

----

(: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:)