NOTES ENVIRONMENTAL DATA ANALYSIS BC 3017 X97/98 ------------------------------------------- Thu 9/11/1997 Need to bring: Paper for printers Pens Handouts: newspaper articles about local ozone issues Go over certain tricks with excel etc: Bring a disk for your files as a backup! How to download files and save them right Formulas, references, $s Copying cells How to make a plot How to print Finish up the water supply example Check if readings have been done? Send an e-mail with summary in 3 sentences? Did you all send us an e-mail with your personal information? ------------------------------------------- Tue 9/16/97 Need to bring disks to transfer the data and make a summary table data to be typed in explanation of notation Problemset with unit conversions handout, ozone articles (NYT), weather Ozone lecture Start to type in ozone data "DLTEMP" means T(2m)-T(10m) -> inversion there are two ozone channels that should give you similar results "SD1" is the standard deviation of the wind direction "SCAWSP" is the scalar windspeed (not needed here) "WETNES" is an indicator of fog "D" air flow was turned off, data should not be used "<" less than full set to calculate average "F" failure Calibration results Show template on screen What are things to look out for when typing in the data? Discuss outliers, bad data points ------------------------------------------- Thu 9/18/97 Need to bring disk print-out of first part of ozone lab New York State map map with transparency (NE US) Discuss problem set first Meteorology lecture Work on ozone lab finish up data entry general remarks on handout different kind of plots: scatter plot and time series have students show some of their plots in front of the class USA at night map? ------------------------------------------- Tue 9/23/97 Need to bring: disk print-out of second part of ozone lab map with transparency (NE US) general: collect home work grading: 1 day late 1/3rd grade substracted password issue collect e-mail addresses lec: brief introduction to lab reports? lab: Questions about lab? Work on Excel skills - all students should keep notes on techniques minimum and maximum functions Finish part 1 & discuss results in front of class start working on part 2? ------------------------------------------- Thu 9/25/97 Need to bring: disk, NYS map general: problem sets on Tuesday have students show plots in class what is important: clearly label axis (units!) legend make optimal use of the plot area plot dependent parameter(s) on Y-axis label axes (units!), multiple axes, scales organize plots so that underlying story is revealed lec: talk about Excel tricks lab: finish O3-1, begin O3-2 ------------------------------------------- Tue 9/30/97 lecture by Prof. Lorenz ------------------------------------------- Thu 10/2/97 Need to bring: disk plain paper problem sets general: talk about relevance of Lorenz lecture lec: problem sets how to write a lab report how to use min/max functions lab: work with complete data set ------------------------------------------- Thu 10/2/97 Need to bring: general: lec: lab: ------------------------------------------- Thu 10/9/97 finsih up the particulate matter lab ------------------------------------------- Tue 10/14/97 bring: PM handouts, magnifying glasses, etc. lec: Introduction to particulate matter science lec: Introduction to PM experiment big question: What is the dry deposition flux of particulate matter in NYC? how to measure PM? 2 groups (6 and 5) monitoring on different days, 36 hours Fr 9pm to Su 9am, Su 9pm to Tu 9am samples counted until if there is extra time: all experiments are imperfect every result has an error there are different kinds of errors: statistical errors statistics of particle deposition statistics of measurement process systematic errors circumstances of the experiment subjective judgement of the observer drifts of instruments relative and absolute errors how errors are influenced by mathematical manipulations additions and substraction: addition of absolute errors multiplication and division: addition of relative errors ------------------------------------------- Thu 10/16/97 lec: histograms, mean, median, SD statistics handout exam review what are the major points? ------------------------------------------- Tue 10/21/97 midterm exam ------------------------------------------- Thu 10/23/97 bring: disk, lab2/3 lec: SE, Normal distribution, Student's curve, ttest? mention variance (forgot that last time) individual measurement=exact value + bias + chance error random/systematic error, precision/accuracy standard error error propagation histogram, increased number of measurements -> normal distribution characteristics, Standard units, 68/95% students distribution degrees of freedom=number of measurements -1 lab: count paricles on other students sheets and put the data into the table ------------------------------------------- Tue 10/28/97 questionaire (background of students) discussion of the exam lec: go through ppt presentation to bring everybody up to speed, ttest confidence interval and normal distribution lab: count paricles on other students sheets and put the data into the table (template) make bar diagrams of your own counts and overlay the normal distribution collect data on disk students should download the ttestex.xls file and go through the examples by Thursday Thu Thu lec: sediments in Hudson, PCBs, Cs137 lab: inventories of Tue: lec: regression, lines, t-test regression ------------------------------------------- Thu 12/2 Evaluations lab report due next week (Tue) hand it in in Yee's office questions TA Climate semester Mona Chin Leone McCreary Debika Shome Exam: Tue Dec 16 4-7 statistics Science, PM and sediments data sets to be manipulated