Main

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>
May 06, 2014, at 08:26 PM by 10.5.113.178 -
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.
April 28, 2014, at 11:57 AM by 4.28.34.254 -
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.
April 27, 2014, at 08:39 PM by 197.149.171.26 -
Changed line 1 from:
(:title Computational Tools for Engineers - Data Analysis with Excel:)
to:
(:title Data Analysis with Excel:)
April 27, 2014, at 08:35 PM by 197.149.171.26 -
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 = 'http://' + 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="http://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
    <a href="http://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>
(:htmlend:)