Skip to content Skip to footer

Using Excel for graphical analysis of data

Chemistry LibreTexts features this excellent guided activity for introducing general chemistry students to data analysis using Microsoft Excel as contributed by Santa Monica College. In addition to learning how to determine averages, standard deviations, and outliers, students learn how to create simple scatter plots, as well as plots containing multiple data sets. The exercise features detailed instructions and a series of questions for students to complete and turn in.

Graphing independent data series

At Maryville University, we have adapted this activity for use with an iPad (Excel for iPad is quite a bit different than the desktop version):

Excel for iPad
Minimum 4 characters