Math Refresher Outline

Session I: Solving Equations, Excel, Lines, Slopes, Logs

I.

II.

III.

IV.

VI.

Solving for Variables: Linear Equations

a. Review of linear models

b. Understanding units and terms in linear functions

Solving Two-Equation and Two-Unknown Problems

a. Approach 1) Substitution.

b. Approach 2) Elimination

Dealing with Exponents and Powers

a. Working with Exponents

b. Exponents in Excel

Introduction to Net Present Value

a. Application of NPV to business problems

b. NPV via Excel

Working with Logs

a. Concavity of Logs

b. Working with Logs

c. Tricks with Logs

We will review multiple Excel functions in Session I, including:

SUMPRODUCT NPV

IF

LN

Session II: Working With Probabilities and Statistics

I. Complimentary Probabilities a. "Exactly One event" b. "At least One event"

c. "At Most X events"

II. Joint Probabilities

a. Combinations

b. Conditional

III. Interpretation of Probability in a Business Problem

IV. Working with Sample Statistics

a. Median

b. Mode

c. Difference between Average and Mean

d. Standard Deviation

e. V ariance

We will review the following Excel Functions:

A VERAGE MEDIAN MODE STDEV VAR

Session III: Working with Random Variables in Distributions

I. Review of difference between continuous and discrete random variables

II. Uniform Distribution

a. PMF

b. CMF

c. Mean, Variance

III. Binomial Distribution

a. PMF

b. CMF

c. Mean, Variance

IV. Poisson Distribution

a.