FALL MATERIALS

Stock Portfolio Hildings Submission Form 


UNIVARIATE DATA ANALYSIS

Mandatory Reading Assignment

Best of Class Notes - Thank You To Alyssa, Victor, Kyla & Hayley

Past Year Class Notes On Univariate Data Analysis (Excel File)*

Univariate Graphic Display Practice Problems

Practice Tests


BIVARIATE DATA ANALYSIS

#1  Practice Midterm Excel Spreadsheet

#1  Practice Bivariate Midterm PDF            Answers Practice Bivariate Midterm PDF


#2  Practice Midterm Excel Spreadsheet

#2  Practice Bivariate Midterm PDF                              Answers Practice Bivariate Midterm PDF



BIVARIATE DISCETE PROBABILITY

Conditional and Marginal Probabilities (Categorical Bivariate Data)

Answers for Conditional & Marginal Probabilities (EXCEL File)

Answers for Conditional & Marginal Probabilities (PDF File)



PROBABILITY RULES, EXPECTED VALUE 

(Note: Normal Probability will be taught in the spring semester.)

#1 Basic Probability Rules, Normal Curves, & Expected Value (Stock)

#1 Answers for Basic Probability, Normal & EV (Excel File)

#1 Answers for Basic Probability, Normal & EV (PDF File)


#2 Basic Probability Rules, Normal Curves, & Expected Value (Stock)

#2 Answers for Basic Probability, Normal & EV (Excel File)

#2 Answers for Basic Probability, Normal & EV (PDF File)



EXCEL TERMS

Excel Terms Handouts: Definitions will match those provided in the hand-outs below.  

       Lesson One         Lesson Two         Lesson Three      Lesson Four   

       Lesson Five             Lesson Six         Lesson Seven         Lesson Eight  


Socrative Room# GHCDF2  -  Take the practice test as many times as necessary.  These terms will be 


Other Excel Vocabulary Sources

Quilt: Make Studying Vocabulary Fun

How Excel Converts Dates To Numbers

Chase’s Quizlet For Excel Vocab!!!



FINANCIAL FUNCTIONS

(Don't be concerned about the difference in the title above the annotated answers.) 

Practice Financial Functions Practice Test #A1

Practice Financial Functions Test #A1 Annotated Answers

Practice Financial Functions Test #A1 Answers PDF Format


Practice Financial Functions Practice Test #A2

Practice Financial Functions Test #A2 Annotated Answers

Practice Financial Functions Test #A2 Answers PDF Format


Practice Financial Functions Practice Test #A3

Practice Financial Functions Test #A3 Annotated Answers

Practice Financial Functions Test #A3 Answers PDF Format


Practice Financial Functions Practice Test #A4

Practice Financial Functions Test #A4 Annotated Answers

Practice Financial Functions Test #A4 Answers PDF Format


Practice Financial Functions Practice Test #A5

Practice Financial Functions Test #A5 Annotated Answers

Practice Financial Functions Test #A5 Answers PDF Format


Practice Financial Functions Practice Test #A6

Practice Financial Functions Test #A6 Annotated Answers

Practice Financial Functions Test #A6 Answers PDF Format


Practice Financial Functions Practice Test #A7

Practice Financial Functions Test #A7 Annotated Answers

Practice Financial Functions Test #A7 Answers PDF Format



Identification of present value (PV), future value (FV), payment (PMT), rate, and number of periods (Nper).  Here's anexample of how a strong student would  use color coding of the worksheets to help match the prompts in the question with their correct interpretation. 

Financial Function Color Coded Prompt Identification Example

NEW & IMPROVED FOR 2014!!!

Financial Function Annotation Guide


© Andrew Nelson 2012