Excel 97: Use for Analysis of Economics Data

The following brief handouts 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 97 and more recent versions with Tools | Data Analysis add-in.
They are fine for versions of Excel up to and including Excel 2003.
They were written in September 1999.

For more recent Excel 2007 see Excel 2007: Use for Analysis of Economics Data

Excel Getting-Started Tutorial:

Excel Basics:

Excel Univariate: Visual Data Inspection Excel Univariate: Data Summary and Statistical Inference Excel Univariate: Differences in Means

The following two methods are used little in analysis of economics data. They are given for completeness.

Excel Bivariate: Visual Data Presentation Excel Bivariate: Data Summary and Statistical Inference Excel Multivariate: Data Summary and Statistical Inference Excel Categorical Data

The following methods are used little in analysis of economics data. They are given for completeness.
IT is important, however, to know categorical regressors.


A. Colin Cameron / UC-Davis Economics / http://www.econ.ucdavis.edu/faculty/cameron