3 hour business statistics review: excel solver, advanced regression, & [ANOVA]

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.

3. Hypothesis Testing:

[ANOVA (Analysis of Variance)] for multiple groups.

Type I/II Errors & Power Calculations.

4. Bayesian Statistics: Conditional probability.