__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 97: Access and Documentation
- Windows 97: Basics
- Excel 97: Data Types and Data Input
- Excel 97: Data Manipulation
- Excel 97: Formatting, Saving, Printing and Copying Results
- Excel 97: Sample text data set (cars.asc)
- Excel 97: Sample Excel worksheet (cars.xls)

- Excel 97: Histogram
- Excel 97: Charts (bar, column, pie, line)
- Excel 97: Chart Wizard
- Excel 97: pdf file of Charts Output (requires Adobe Acrobat Reader)

- Excel 97: Descriptive Statistics
- Excel 97: Statistical Inference for univariate data
- Excel 97: TDIST, TINV, NORMSDIST and NORMSINV

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

- Excel 97: Correlation and Covariance
- Excel 97: Two-Variable Regression using Tools | Data Analysis
- Excel 97: Statistical Inference for Two-Variable Regression
- Excel 97: Two Variable Regression using Excel Functions
- Excel 97: Two-Variable Nonlinear Regression

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

IT is important, however, to know categorical regressors.

- Excel 97: Proportions
- Excel 97: ANOVA
- Excel 97: Categorical Regressors (dummy or indicator variables)
- Excel 97: Complete Categorical (chisquare test of independence)
- Excel 97: Categorical Dependent Variable

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