Excel 2007: Use for Analysis of Economics Data

The following brief handouts, written in January 2009, are ordered similarly to a course sequence.
They assume no knowledge of Excel and relatively little knowledge of statistics.
They emphasize analysis of numerical data rather than categorical data.

They are written for Excel 2007 with the Data Analysis add-in activated.
The main changes for Excel 2007 compared to Excel 97 - Excel 2003 are:

  1. Charts in 2007 are produced using the Insert Tab and Charts Group rather than Chart Wizard for 97-2003.
  2. Formulas in 2007 are stored in the Formulas Tab and Function Library group.
  3. 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
For Excel 97 - Excel 2003: see cameron.econ.ucdavis.edu/excel972003/excel.html

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 Presentation
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/