Business Analytics with Excel

Excel Workbooks

These two workbooks are prepared, macro-enabled files used in the chapters on growth and demography. Click to download, then be sure to enable macros when you open the file in Excel:

Chapter 4: LongRunGrowth.xlsm

Chapter 10: PopulationPyramid.xlsm

 

More Excel Workbooks

The Excel workbooks below are the files you create by following the steps in the book. These completed files can be used to check your work or if you get stuck in doing a step. Professors can use them for in-class demonstration (saving the time needed to construct the workbook). I also have cases and other materials for the course that I am happy to share, just email me at the link below.

Chapter
Title
Description
2
Optimization

LifeguardProblem.xlsx

Solver.xlsx

PracticeProblem.xlsx
3
Monte Carlo Simulation

FreeThrowSim.xlsx

Parrondo.xlsm

PooledTesting.xlsm

Search.xlsx
4
Growth
5
Unemployment
6
Constrained Optimization
7
Yield Curve

YieldCurve.xlsx
8
National Income Accounting

GDPInvestment.xlsx

International.xlsx
9
VBA
10
Demography

All comments welcome.

Humberto Barreto
DePauw University
hbarreto@depauw.edu