Spring Semester Weeks 7-12


TYRA BANKS FINAL DATA - Use This File For Histograms & Two-Sample Tests of Significance




EXCEL






PRACTICE Financial Functions EXAMS #A, #B, #C, #D

Excel Answer Calculations


SCDC 2017 - Time To Dominate

ICDC Finance 2013-2016

ICDC Principles 2013-2016


My FICO

ONLINE DATA ROBERT SHILLER



Screen Shot 2017-01-19 at 9.15.09 PM



RAW DATA From Video Example of Pivot Tables


Spring Midterm #1 

Dates TBD


Section #1 Composite Financial Functions

Pensions: Defined Benefit Vs. Defined Contribution

Pensions: Underfunded State Obligations

Chart Comparing Defined Benefit & Defined Contribution


Financial Functions #1

Financial Functions #2

Financial Functions #1 & #2 Excel

Financial Functions Annotated Answers #1 

Financial Functions Annotated Answers #2


Financial Functions #3     

Financial Functions Annotated Answers #3 (Excel)  

Financial Functions Annotated Answers #3 (PDF) 



Section #2 Mathematical Modeling: 

Linear         Exponential         Logarithmic       Quadratic      Power

Practice Tests #1A, #1B, #2A, #2B



Section #3 Big Data Chapter Five & Six (Open Note) 



Section #4 Statistical Symbols    

Practice Symbols Test



Section #5 Normal  Probability Distributions: Population & Sampling

Normal Probability Practice Test

Normal Probability Test Annotated Answers (Excel) 

Normal Probability Test Annotated Answers (PDF)



Section #6 EXCEL Vocabulary

Definitions will match those provided in the hand-outs.  Review all key terms for all lessons.  Here's the lists.

Key Terms:        Lesson One         Lesson Two         Lesson Three      Lesson Four   

       Lesson Five             Lesson Six         Lesson Seven         Lesson Eight  

CHASE's QUIZLET Lessons 1-3 & 5

HANNAH's QUIZLET Lessons 4-8





DON'T WORRY ABOUT STUFF BELOW THIS LINE!!!!!!!!

Sampling Surveys

ASSIGNMENT #1: 

PERIODS ONE, THREE & FOUR  DUE  Monday January 26

PERIODS ZERO & TWO  DUE Wednesday January 28 

Observational Study Design Glossary Assignment

Students will create a custom glossary by copying the definitions of terms from the two links below.  The list of terms to be included in the Glossary are provided in the first posted document below.  Understanding these terms will be critical when students soon begin designing their own sampling surveys.  These terms and symbol notations will comprise the majority of the vocabulary section of the first spring midterm.  ALL GLOSSARIES MUST BE HANDWRITTEN, & TERMS NUMBERED AS SHOWN .  THE GLOSSARY SHOULD BE ORGANIZED IN OUTLINE FORM AS SHOWN IN THE "LIST OF TERMS".  

LIST OF TERMS TO BE INCLUDED IN GLOSSARY

Stat Trek Survey Sampling Source: stattrek.c0m

Additional Survey Terms  Source: sciencebuddies.org

Khan Academy Video: Sampling Methods & Forms of Bias 



ASSIGNMENT #2: DUE   TBD

Survey Design Tutorial

Students submit notes from reading assignment, "Designing Surveys & Questionairres".  Here's the sections you DO NOT have to read.

"Pre-Notification Letters", "Notification of Cut-off Date", "Reply Envelopes and Postage", "The Outgoing Envelope and Postage", "The Meaning of Significance" 





How to Analyze Apartment Building Financials

11922 Runnymede Street, North Hollywood

5252 Cahuenga Blvd., North Hollyood

1819 S. Gramercy Place, Los Angeles

Apartment Finder



Great Depression vs. 'Great Recession'

Great Depression Versus Great Recession Powerpoint


Is today's economic crisis another Great Depression?  

Wordle Of Article             USA Today November 2008


Economy: Depressing but not a Great Depression


Tent Cities Spring Up in LA


Practice #A

Practice #B

Practice #C

Note: Answer to Practice Test B #8 NPV = $1,281,392  (Use 9%, not 8%)

Here's more instructional materials for your review of financial functions.  This practice was provided earlier in the semester. 

Practice Problems ANSWERS For Tests #1 & #2 EXCEL File                      

Practice Test #1 ANSWERS PDF File

Practice Test #2 ANSWERS PDF Fil


HERE’S THE FIRST STEP TO FINISHING BUSINESS STATISTICS

© Andrew Nelson 2012