Excel: 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.

Excel Getting-Started Tutorial:

• Excel: Tutorial (covers first half of below)

Excel Basics:

• Excel: Access and Documentation
• Windows: Basics
• Excel: Data Types and Data Input
• Excel: Data Manipulation
• Excel: Formatting, Saving, Printing and Copying Results
• Excel: Sample text data set (cars.asc)
• Excel: Sample Excel worksheet (cars.xls)

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

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

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

• Excel: Difference in Two Means
• Excel: ANOVA (differences in k means)

• Excel: Two-way Plots including Regression using Add Trendline
• Excel: Further Plots

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

• Excel: Multiple 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: Proportions
• Excel: ANOVA
• Excel: Categorical Regressors (dummy or indicator variables)
• Excel: Complete Categorical (chisquare test of independence)
• Excel: Categorical Dependent Variable

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