Short Course Webinar: Analytical Data Treatment Using the Excel Analysis ToolPak
September 19, 2019 (9:00 am to 11:00 am EST)
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.
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.