Section I: Financial Functions (NPV, IRR, PV, FV, PMT, cash flow estimation)
See Week 9 posted practice test above.
Section II: Probability (Basic Rules, Conditional, Marginal, Normal Distributions, Expected Value)
Here's some practice probability problems.
Conditional and Marginal Probabilities (Categorical Bivariate Data)
Answers for Conditional & Marginal Probabilities (EXCEL File)
Answers for Conditional & Marginal Probabilities (PDF File)
Basic Probability Rules, Normal Curves, & Expected Value (Stock)
Answers for Basic Probability, Normal & EV (Excel File)
Answers for Basic Probability, Normal & EV (PDF File)
Section III Bivariate Analysis:
Optional Text Reading: Page 121-122 (Response Variable vs. Explanatory Variable); bottom Page 123 - 124 & Pages 126-128(Scatterplots); Pages 140-145 (Correlation); bottom Page 149 - 156 & bottom Page 157 - 165 (Least Square Regression Line or LSRL); Page 167 - 172 (Residuals & Influential Points). IGNORE ALL EXERCISES & CALCULATOR INSTRUCTIONS.
Practice Midterm Excel Spreadsheet
Practice Bivariate Midterm PDF Answers Practice Bivariate Midterm PDF
Section IV Excel Vocabulary:
Definitions will match those provided in the hand-outs. Review all key terms for lessons 1, 2, 3, and 5. Here's the lists.
Key Terms: Lesson Four Lesson Six Lesson Seven Lesson Eight
Section V Big Data:
Chapters Three & Four (Open Note) - Notes will be collected for a grade upon completion of this section of the midterm.