Skip to content Skip to footer

Tag: Statistics

Conductivity probe available from Amazon

Charged with a salt: exploring conductivity

Students use household materials and a conductivity probe to explore factors that affect the conductivity of electrolytic solutions. Students gain experience in molarity and dilution calculations, solution preparation, nomenclature, statistical analysis, and graphical presentation of data. This hands-on activity is flexible and can be modified to accommodate both high school and undergraduate courses. Students can safely…

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…

Lab-in-a-Box: A Guide for Remote Laboratory Instruction in an Instrumental Analysis Course

Hands-on learning in a remote laboratory environment. This Journal of Chemical Education Article by Deon T. Miles and William G. Wells of the Department of Chemistry, Sewanee: The University of the South describes a homemade kit with at home, hands on laboratory experiments in spectroscopy and chromatography. The paper and supporting information describe both hands on…
Alka seltzer fizzing

Determination of Percent by Mass of NaHCO3 in Alka-Seltzer Tablets

Use the (really fun!) reaction between the sodium bicarbonate in Alka-Seltzer tablets and vinegar to explore stoichiometry, percent composition, and limiting reactants. This experiment is easily and safely reproduced at home using household materials and this $12 balance. Students also gain experience with data manipulation, error analysis, and graphical presentation in Excel. This laboratory can be…

A Beginner’s Guide to Microsoft Excel Spreadsheets and Graphs

Two tutorials on spreadsheets, equations, graphs and trendlines This post contains two Microsoft Excel tutorials. The first one shows some basics of Excel spreadsheets, such as equations and formatting. The second one shows how to make an x-y scatter plot and trendline on Microsoft Excel. Sample data is also provided so students can apply what they…
Penny Statistics Lab

Penny Statistics Lab

This lab is an introduction to statistics and error analysis for a quantitative analysis course.  It has been adapted from an experiment included with Quantitative Chemical Analysis , 9th Ed. by Daniel C. Harris. The instructions found here start with the student being supplied a large set of penny mass data in Excel. Alternatively, students…
Minimum 4 characters