Excel 2007 Data Analysis Tutorials

Here are several well written Excel 2007 Data Analysis Tutorials that will assist you in analyzing economic data. These tutorials help explain Excel’s power and give you insight into Excel’s analysis tool set. Advanced Excel topics covered include data inspection, and statistical inference  for univariate, bivariate and multivariate expressions. Each of these Excel tutorials is complemented with visual examples to better explain the concepts presented. As a quick crash course, also included is a ‘Getting Started’ tutorial as well. These Excel tutorials are hosted by the University of California at Davis.


Excel 2007 Getting-Started Tutorial:
  - Excel: Tutorial (covers first half of below)

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 Univariate: Visual Data Inspection:
  - Excel 2007: Histogram
  - Excel 2007: Charts (column, pie, line)

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

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

Excel 2007 Bivariate: Data Summary and Statistical Inference:
  - 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

Excel 2007 Multivariate: Data Summary and Statistical Inference:
  - Excel 2007: Multiple Regression