March 1 - 5, 2020
McCormick Place
Chicago, Illinois, USA

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

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

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.

Enter your name to be emailed when registration opens.

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


Notify me!

Give us your name, and we’ll email you as soon as registration opens.

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