Data Analysis with Excel

Spreadsheet Data Analysis

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.

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.

comments powered by Disqus