Welcome
Last Updated: 25 Mar 2024
This site has open-access CC-BY-SA materials (PDF or via LaTex source files) for an introductory Business Analytics course that heavily emphasizes Microsoft Excel. There are no prerequisites and the target audience is first- or second-year undergraduate students who have used a spreadsheet before, but have no specialized training in Excel, calculus, statistics, or programming.
Chapter |
Title |
Description |
1 |
Introduction |
Defining Business Analytics |
2 |
Optimization |
Lifeguard Problem Solver add-in |
3 |
Monte Carlo Simulation |
MCSim add-in Parrondo's Paradox Pooled testing Economic Mobility |
4 |
Growth |
CAGR & Rule of 70 Economic Growth PV & IRR |
5 |
Unemployment |
FRED add-in Seasonal Adjustment Bloomberg terminal |
6 |
Constrained Optimization |
2D & 3D Data Visualization Solver add-in Comparative Statics Wizard add-in Elasticity |
7 |
Yield Curve |
3D Visualization FRED add-in Python Bloomberg terminal |
8 |
GDP |
Y = C + I + G + NX FRED add-in International comparisons of Investment |
9 |
VBA |
Introducing Macros in Excel Functions |
10 |
Demography |
Population Pyramids Demographic Analytics |
Proceed by clicking on the Menu items (top-right) to access the materials.
All comments welcome.
Humberto Barreto
DePauw University
hbarreto@depauw.edu