FALL FINAL STUDY MATERIALS

Stock Portfolio Hildings Submission Form 


Exam dates are shown next to the fall semester topics below.  Time has been budgeted in class to study for these exams.  Study time outside of class will be minimized if you make good use of the classtime devoted to prepare over the next two weeks.  These finals are deisgned for you to succeed but you must review and practice to meet your grade expectations.  Each section of the final matches the format of the midterm and/or reading exams previously taken in class. 


STOCK MARKET TECHNICAL ANALYSIS & EMPLOYMENT MARKET READING ASSIGNMENTS 

Wednesday, November 28

SMG Technical Analysis Practice Test - Socrative Room GHCDF1

Employment Market Reading Practice Test - Socrative Room GHCDF2

For those doing make-up quizzes, go to Socrative room GHCDF3  for The Human Factor & Socrative room GHCDF4 for The Quant Crunch


UNIVARIATE DATA ANALYSIS   Wednesday, December 5  

Mandatory Reading Assignment - Ignore for now, Not on final

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 - Study these materials



BIVARIATE DATA ANALYSIS  Wednesday, December 5

#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


MORE PRACTICE - REVIEW MIDTERM BIVARIATE DATA ANALYSIS 

(FYI:Make-up test students may be in the other class period.)

Periods One & Three Bivariate Data Analysis Midterm

Periods Two & Four  Bivariate Data Analysis Midterm




BIVARIATE DISCETE PROBABILITY  Wednesday, December 5

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 

Day of Final 

(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  1st Take Thursday - all 120

Retake Option - Day of Final - 60 items

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# GHCDP3  -  You may take the practice tests as many times as needed. 


Other Excel Vocabulary Sources

Quilt: Make Studying Vocabulary Fun

How Excel Converts Dates To Numbers

Chase’s Quizlet For Excel Vocab!!!



FINANCIAL FUNCTIONS  Day of Final

(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