Skip to content
Analytical Sciences Digital Library
  • Home
  • Collection
    • Techniques
    • Resources by Format
    • Applications
    • Teaching Resources
  • Active Learning
    • TBD – Classroom Activities
    • Laboratory Activities
    • Textual Material
    • NSF Support for Active Learning
    • Newsletters
  • Remote Labs
    • At home Hands-on Experiments
    • Virtual Experiment/Simulation
    • Skill-Building Exercises
  • JASDL
    • Courseware
    • Labware
    • Educational Practices
  • Exchange
    • Data Set Exchange
    • Lab Experiments Exchange
    • Image and Video Exchange
    • Problem Exchange
    • All Forum Posts
  • About
    • About ASDL
    • Managing Editors
    • Associate Editors
    • ASDL Remembers Our Founder and Friend
    • Community
    • Contact
Analytical Sciences Digital Library
  • Home
  • Collection
    • Techniques
    • Resources by Format
    • Applications
    • Teaching Resources
  • Active Learning
    • TBD – Classroom Activities
    • Laboratory Activities
    • Textual Material
    • NSF Support for Active Learning
    • Newsletters
  • Remote Labs
    • At home Hands-on Experiments
    • Virtual Experiment/Simulation
    • Skill-Building Exercises
  • JASDL
    • Courseware
    • Labware
    • Educational Practices
  • Exchange
    • Data Set Exchange
    • Lab Experiments Exchange
    • Image and Video Exchange
    • Problem Exchange
    • All Forum Posts
  • About
    • About ASDL
    • Managing Editors
    • Associate Editors
    • ASDL Remembers Our Founder and Friend
    • Community
    • Contact
Home / Active Learning / Statistics: Excel Exercise

Statistics: Excel Exercise

6 April 2022
Tom Wenzel
d. Statistical analysis of data

Excel StatisticsDownload

Students use a dataset for pennies to explore basic statistical concepts.

Elise Heiss, Kings College (EliseHeiss@kings.edu)

Share this page
Facebook LinkedIn X / Twitter Email

About the Author

ASDL Contributor

Tom Wenzel

View contributions

Post navigation

Previous: Lithia Water Springs Project
Next: Concentration Determination

Recent Resources

  • Analytical Chemistry 2.1 Online Textbook with Activities
  • Data Analysis
  • Quality Control Analysis for a Local Brewery
  • Chemical Equilibrium
  • Signals and Noise

Categories

  • 00. Complete Active Learning Units with Supporting Text
  • 01. Introduction to Analytical Chemistry
  • 04. Standardizing Analytical Methods
  • 06. Sample Collection and Preparation
  • 07. Gravimetric methods
  • 09. Signal and Noise
  • 18. Analytical Method Development
  • 19. Simulations
  • 20. Activities that Use Primary Literature
  • 21. Case Studies
  • 22. Contextual Modules
  • 23. Capstone and Exam Review
  • a. Acid-base titrations
  • a. Basic chromatographic concepts
  • a. Basic Concepts in Mass Spectrometry
  • a. Basic electrochemical concepts
  • a. Basic spectroscopic concepts
  • a. Designing a sampling plan
  • a. General Coverage of GC
  • a. General Coverage of HPLC
  • a. General equilibrium concepts
  • a. Ion Chromatography
  • a. Microfluidics
  • a. Significant figures
  • a. Solution preparation and dilutions
  • b. Acid-base equilibria
  • b. Beer's Law
  • b. Biological Mass Spectrometry
  • b. Characterizing experimental errors
  • b. Complexation titrations
  • b. Electrochemical cells
  • b. GC Retention Order
  • b. HPLC Retention Order
  • b. Immunoassays
  • b. Liquid-liquid extraction
  • b. Sample preparations
  • b. Steric Exclusion chromatography
  • b. Use of glassware
  • c. Affinity chromatography
  • c. Complexation equilibria
  • c. Electrochemical titrations
  • c. GC Instrument Components
  • c. Mass Spectrometry Imaging
  • c. Microscopy
  • c. Peak broadening
  • c. Propagation of uncertainty
  • c. Redox titrations
  • c. Spreadsheets and computational software
  • c. Use of a Simulator
  • c. UV/Vis
  • Contextual Modules
  • d. Capillary electrophoresis
  • d. Fundamental resolution equation
  • d. Gas Chromatography-Mass Spectrometry
  • d. GC-MS
  • d. HPLC Method Development
  • d. Infrared
  • d. Potentiometric Methods
  • d. Solubility equilibria
  • d. Statistical analysis of data
  • e. Activity effects
  • e. Fluorescence/Luminescence
  • e. GC Method Development
  • e. HPLC - Literature Article Analysis
  • e. Mass Spec - Literature Article Analysis
  • e. Statistical methods for normal distribution
  • e. Ultracentrifugation
  • e. Voltammetric Methods
  • f. Detection limits
  • f. Electrochemical Sensors
  • f. GC - Literature Article Analysis
  • f. Method selection in chromatography
  • f. Raman
  • g. Choosing the right graph
  • g. NMR
  • h. Atomic Spectroscopy
  • i. X ray fluorescence (XRF)
  • In Class Activities
  • j. Spectroscopic method selection
  • Laboratory Activities
  • Shorter Activities
  • Textual Material
  • Uncategorized
Analytical Sciences Digital Library

The Analytical Sciences Digital Library collects, catalogs, and peer-reviews open-access digital educational materials covering all aspects of analytical science, instrumentation, curriculum development, and active pedagogy.

Explore

  • ASDL Weblink Collection
  • ASDL Active Learning Materials
  • Remote Labs and Simulations
  • JASDL Peer-Reviewed Journal
  • Community Exchange

Resources

  • Submit a Resource
  • Peer-Review Guidelines
  • Managing Editors
  • Associate Editors

Governance & Grants

  • About the ASDL
  • NSF Grant History
  • ACS Division Partnership
  • Contact Editorial Office

Materials licensed under Creative Commons CC BY-NC-SA 4.0 unless noted.

Supported by the National Science Foundation & the ACS Division of Analytical Chemistry

  • Privacy Policy
  • Accessibility
© 2026 ASDL Consortium. CC BY-NC-SA 4.0