generic_top.gif (5524 bytes)

Home
Syllabus
Homework
Notes
Excel Hints 
S-PLUS Hints
Announcements
Links
Project
Review

Eric Zivot
Economics 483
Applied Econometric Modeling in Finance

Excel Hints

Fall 2003

 

This is a new page containing hints for various computations using Microsoft Excel. Please note that some of the statistical calculations require the Berk-Carey add-in StatPlus. 

Chapter 1: Return Calculations

Chapter 2: Review of Random Variables

Chapter 3: Descriptive Statistics

Chapter 4: Constant Expected Return Model

Chapter 5: Introduction to Portfolio Theory

Chapter 6: Markowitz Algorithm

Chapter 7: Single Index Model

Excel Links

  • Colin Cameron at UC Davis has a great set of Excel worksheets for data analysis of economic data.