__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:

- Charts in 2007 are produced using the Insert Tab and Charts Group rather than Chart Wizard for 97-2003.
- Formulas in 2007 are stored in the Formulas Tab and Function Library group.
- 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

**Excel 2007 Getting-Started Tutorial:**

**Excel 2007 Basics:**

- Excel 2007: Access and Activating the Data Analysis Add-in
- Excel 2007: The Windows 2007 Fluent Interface
- Excel 2007: Workbooks and Worksheets
- Excel 2007: Data Types and Data Input
- Excel 2007: Data Manipulation
- Excel 2007: Formatting, Saving, Printing and Copying Results
- Excel 2007: Sample text data set (carsdata.txt)
- Excel 2007: Sample comma-separated values text data set (carsdata.csv)
- Excel 2007: Sample Excel worksheet (carsdata.xls)

- Excel 2007: Descriptive Statistics
- Excel 2007: Statistical Inference for univariate data
- Excel 2007: DIST, TINV, NORMSDIST and NORMSINV

- Excel 2007: Two-way Plots
- Excel 2007: Two-plots with
nonlinear trend (logarithmic, exponential, power, polynomial)

- Excel 2007: Correlation and covariance
- Excel 2007: Two-Variable
Regression using Data Analysis Add-in

- Excel 2007: Statistical Inference for Two-Variable Regression
- Excel 2007: Two-Variable Regression using Excel function LINEST

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