Excel 97: Use for Analysis of Economics Data
The following brief handouts are ordered similarly to a course
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:
The following two methods are used little in analysis of economics data. They are given for completeness.
The following methods are used little in analysis of economics data.
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