Screen Shot 2023-11-02 at 9

———p — ——— ——— —— m—— = o ——— Normal Distribution - =NORM.DIST(x, mean, stdev, cumulative) - This function provides the cumulative normal probability of x. It requires 4 inputs: - X - the value you want the probability for. - mean(p) — mean of the normal distribution of interest - stdev(o) — standard deviation of the distribution of interest - Cumulative - if FALSE, returns probability mass function (probability that x will occur). If TRUE, it returns the cumulative probability function (the probability that the value will be less than or equal to x) - Note: the probability mass function (PMF) gives the probability that a discrete random variable is exactly equal to some value. Inverse of the Normal Cumulative Distribution - =NORM.L.INV(probability, mean, stdev) - This calculates the x value given a probability. - =NORM.S.INV(probability) is similar to NORMINV but assumes that the distribution is standard normal. - =STANDARDIZE (x, mean, stdev) returns the z score for a specified value, mean, and standard deviation. Student T- Distribution - =T.DIST(t value, deg freedom, cumulative) - Given the T-value and degrees of freedom, this function returns the t distribution probability. Student T- Distribution Inverse - =T.INV(probability, df) - Given a left tail probability and df degrees of freedom, it returns the T-value. For instance, T.INV(0.01, 45)=-2.412