Data Analysis for Excel

The Data Analysis for Excel Video Series is designed to supplement Lesson 3 in the AQ-IQ curriculum. 
 

Learn about units of Air Quality Pollutants

AQ-IQ Mentor Elise Mesenbring explains the concentration units of air quality pollutants.

  Understanding Units of Gas Phase Pollutants 

 

How to Analyze Pod Data in Excel

AQ-IQ Mentor Xavier McIntyre explains how to import pod data (from a .txt file) into Excel.

  How to Import Pod Data into Excel 

 

AQ-IQ Mentor Cindy Yang explains how to create a graph without baseline data using the Microsoft Excel. 

  How to Cut Out Irrelevant Data (ie. Baseline Data) Using Microsoft Excel 

 

In order to compare data collected on two different pods, it's best to subtract baseline data from both measurements. AQ-IQ Mentor Anna Iisa explains how to do this in this video.

  How to Compare Data from Two Different Pods