Environmental Data Analysis EESC BC 3017

Objectives, Project 1

After finishing the intro section you should know how to do the following:

Excel

enter data into Excel from keyboard
work with EXCEL formulas and functions
work with cell references and range names
query and sort data using the AutoFilter and Advanced Filter
import data from text files and databases
make scatter plots
fit straight trendlines to data

Data analysis

calculate error bars and know what they mean
know what confidence intervals are
systematic and statistical errors
perform basic error propagation
fit data with trendlines and understand what a regression does
convert a text problem into a conceptual model and an equation

Communication skills

communicate your results clearly in laboratory report format