Business Analytics with Excel

Excel Workbooks

Last Updated: 16 May 2024

These two workbooks are prepared, macro-enabled files used in the chapters on growth and demography. Click to download:

LongRunGrowth.xlsm

PopulationPyramid.xlsm

 

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).

Chapter
Title
Description
2
Optimization

LifeguardProblem.xlsx

Solver.xlsx

PracticeProblem.xlsx

3
Monte Carlo Simulation

FreeThrowSim.xlsx

Parrondo.xlsm

PooledTesting.xlsm

Mobility.xlsm

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