Data Analysis with Excel
Main.ExcelDataAnalysis History
Show minor edits - Show changes to markup
This tutorial can also be completed with scripting programming languages like MATLAB and Python. 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:)
(:htmlend:)
(:html:) <iframe width="560" height="315" src="https://www.youtube.com/embed/ASs3bnK3BC8" frameborder="0" allowfullscreen></iframe>
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.
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.
This following tutorial demonstrates how to import data, perform a basic analysis, trend the results, and export the results to another text file.
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.
(:title Computational Tools for Engineers - Data Analysis with Excel:)
(:title Data Analysis with Excel:)
(: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:)