Overview
1. Portfolio Optimization: Using Solver with weight constraints.
2. Advanced Regression:
Creating [Dummy Variables] for categorical data.
Creating [Interaction Terms] and [Quadratic Terms].
Interpreting [Residual Plots] and checking assumptions.
[ANOVA (Analysis of Variance)] for multiple groups.
Type I/II Errors & Power Calculations.
4. Bayesian Statistics: Conditional probability.