Week 12: Applications - Portfolio Optimization

This week we will explore an application for optimizing a stock portfolio (VBA file)

Optimizing Stock Portfolio Part 1 of 2: Introduction

Optimizing Stock Portfolio Part 2 of 2: Solution Walk-through

and also a simulation of a simple learning neuron

Single Neuron VBA file

Single Neuron on Google Sheets

Additional References
Efficient Frontier Theory

MMULT function (Microsoft documentation)

Lectures and quizzes on Summarizing Quantitative Data (Khan Academy)

Lectures and quizzes on Correlation (i.e., Standardized Covariance), Covariance, & Scatterplot (Khan Academy)