1. (MySQL) Database Model Design

    Reference: MySQL 8.0 Reference Manual

    0009/02/02 Database

  2. Data Cleaning 数据清洗

    Reference: MySQL 8.0 Reference Manual

    0009/01/02 Database

  3. Basis

    0009/01/01

  4. Stationary stochastic processes

    Stochastic Process A stochastic process is a family of random variables ${X_t, t\in\mathcal{T}}$, where $\mathcal{T}$ is an index set. Example: Amount of inventory in stock at the start of day $t$

    0008/04/01

  5. Input Modeling

    Physical Basis of Distribution Discrete: Binomial: model #“success” in $n$ trials when the trials are iid with success probability $p$ e.g. $n$ 个产品中有多少不合格 Negative Binomial: model #trials needed to achieve $k$ ”success“ e.g. 需要检测多少个产品才能检测出 $k$ 个不合格的 Geometric: model #trials until 1st “success” Possion: model #independent events that occur in a fixed time or space e.g. 一个小时内到访商店的顾客数量。

    0008/02/01 Probability-Theory

  6. Probability - Advanced

    1. Model Evaluation R-squared (R squared) \(R^2=1-\frac{\sum(\hat{y}_i-y_i)^2}{\sum(y_i-\bar{y})^2}\)

    0008/01/03 Probability-Theory

  7. Probability - Rules and Distributions

    Probability Distributions

    0008/01/02 Probability-Theory

  8. Probability - Basis

    Probability - Basis

    0008/01/01 Probability-Theory