March 1 - 5, 2020
McCormick Place
Chicago, Illinois, USA
Don’t miss the world’s leading conference and expo.
Your career demands this Short Course – only $99!

Short Course Webinar: Analytical Data Treatment Using the Excel Analysis ToolPak

September 19, 2019 (9:00 am to 11:00 am EST)

Cost: $99

This online Short Course will explore the use of the Analysis ToolPak, a Microsoft® Excel™ add-in for analysis of data and results from quantitative chemical analyses. The Analysis ToolPak contains several data analysis tools for mathematical and statistical treatment of data and results from analytical experiments.

Among the analysis tools to be covered in this course are a descriptive statistics tool for obtaining basic statistics (e.g., mean, standard deviation, confidence interval) for datasets, tools for two-sample significance testing (e.g., the t test, F test, and z test), tools for one-way and two-way analysis of variance (i.e., ANOVA), and a regression tool for workup of calibration data from analytical methods.

A basic operational knowledge of Excel™ is assumed. Participants will engage in spreadsheet setup and use the Analysis ToolPak to perform statistical analysis of datasets provided by the instructor. Participants will also receive materials relevant to the course.


Dr. Mark T. Stauffer
Associate Professor
of Chemistry
University of Pittsburgh
– Greensburg


Why Should You Take This Course?

Dr. Mark Stauffer explains the benefits of taking his course.

Dr. Mark Stauffer Bio

Dr. Mark T. Stauffer is Associate Professor of Chemistry, and currently chair of the Division of Natural Sciences, Mathematics, and Engineering (NSME), at the University of Pittsburgh – Greensburg. He received his B.S. (1979) and Ph.D. (1998) degrees in Chemistry from the University of Pittsburgh. Prior to pursuing a doctorate in chemistry, Dr. Stauffer was employed by the Ethyl Corporation as an analytical chemist. Dr. Stauffer has held teaching positions at the University of Wisconsin-Madison, Shippensburg University, and Carnegie Mellon University. He joined the Pitt-Greensburg faculty in 2001 as an assistant professor of chemistry, and was promoted to Associate Professor with tenure in 2007. Dr. Stauffer has managed a successful undergraduate research effort at Pitt-Greensburg that has, since 2002, involved nearly 100 students and produced over 90 oral papers and posters delivered at various technical conferences. He is author/coauthor/editor of nearly 20 publications. Dr. Stauffer has presented short courses on analytical data treatment at Pittcon since 2009, and has presented workshops on graphing and data/results manipulation using Excel™ in various venues over the past 17 years. His research interests involve metals and anions in abandoned mine drainage and other natural waters and soils; metals in foods, beverages, and animal and human hair; phytoremediation of metals in waters and soils; stability constant studies for metal-ion chelates; UV-visible and atomic absorption spectrophotometry; electrochemistry; analytical method development; and field analytical methods. His interests in chemometrics focus on analytical data treatment, including outlier identification in univariate and multivariate datasets, significance testing, pattern recognition, signals/noise, and univariate and multivariate calibration/validation. Dr. Stauffer is a member of the American Chemical Society, the Society for Analytical Chemists of Pittsburgh (SACP), and the Spectroscopy Society of Pittsburgh (SSP). He received an Honorable Mention at the 2016 Carnegie Science Awards in the University/Post-Secondary Educator award category. He is a former Executive President of the Gamma Sigma Epsilon national chemistry honor society, a former president of the Pitt-Greensburg Faculty Senate, and a recipient of the Pitt-Greensburg Faculty Awards for Service and Professional Development.




Back to Top