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