Excel 2007: Use for Analysis of Economics
The following brief handouts, written in January 2009, are ordered
similarly to a course
They assume no knowledge of Excel and relatively little knowledge of
They emphasize analysis of numerical data rather than categorical data.
They are written for Excel 2007 with the Data
Analysis add-in activated.
main changes for Excel 2007 compared to Excel 97 - Excel 2003 are:
For Excel 97 - Excel 2003: see cameron.econ.ucdavis.edu/excel972003/excel.html
- Charts in 2007 are produced using the Insert Tab and Charts Group
rather than Chart Wizard for 97-2003.
- Formulas in 2007 are stored in the Formulas Tab and Function
- The Data Analysis Add-in (for histogram, descriptive statistics,
regression, .... )
in 2007 appears on the Data Tab and Analysis Group rather than under
Tools | Data Analysis
Excel 2007 Getting-Started Tutorial:
Excel 2007 Basics:
Excel 2007 Univariate: Visual Data Inspection
Excel 2007 Univariate: Data Summary and Statistical Inference
Excel 2007 Bivariate: Visual Data
Excel 2007 Bivariate: Data Summary and Statistical Inference
Excel 2007 Multivariate: Data Summary and Statistical Inference
A. Colin Cameron / UC-Davis Economics / http://cameron.econ.ucdavis.edu/