 |
Downloads |
|
|
Downloads |
Files Used in Class
| Charts, Summary Statistics | 02.xls |
| Jobs Raw Data | jobs.txt |
| Monty Hall simulation, Discrete probability examples | 04.xls |
| Binomial examples | 06.xls |
| Portfolios, Correlation examples | 08.xls |
| Binomial Approx. with CLT | 10.xls |
| Mark McGwire, Bead Box Simulation | 14.xls |
| Reynolds-Curran Problem | reynolds-curran.doc |
| Blank z and t template | template-z-and-t.doc |
| Simple Regression -- Real Estate data | 18.xls |
| Jenny Tsai problem | jenny.doc |
| Jenny Tsai data | jenny.xls |
| Regression Type II Error problem | reg-type-II.doc |
Course Packet Contents
| BOOK I | |
| Syllabus | 6014syll.htm |
| Notes - Part 1 (Introduction to Data Analysis) | part1.doc |
| Notes - Part 2 (Probability and Random Variables) | part2.doc |
| Notes - Part 2a (Decision Analysis) | part2a.doc |
| Notes - Part 3 (Continuous Distributions and Portfolio Analysis) | part3.doc |
| Standard Normal Distribution I | z-table1.doc |
| Standard Normal Distribution II | z-table2.doc |
| Notes - Part 4 (Sampling) | part4.doc |
| Confidence Interval Formulae | cisheet.doc |
| Critical Values of Student's t | t-table1.doc |
| Notes - Part 5 (Hypothesis Testing) | part5.doc |
| Hypothesis Testing Formulae | htsheet.doc |
| A p-value approach to Student's t | t-table2.doc |
| Notes - Part 5a (Supplement: Goodness- of- Fit Tests | part5a.doc |
| Notes - Part 6 (Simple Regression) | part6.doc |
| Regression Statistics | regforms.doc |
| Notes - Part 7 (Multiple Regression) | part7.doc |
| Sample Problem Set 1 | kalosha.doc |
| Data File | empsat.xls |
| Sample Problem Set 1 Solution | skalosha.doc |
| Sample Problem Set 2 | soup.doc |
| Data File | soup.xls |
| Sample Problem Set 2 Solution | ssoup.doc |
| Problem Set 0 | probset0.doc |
| Rick Beck case | rbcc.doc |
| Problem Set 1 | probset1.doc |
| Data File | rbcc.xls |
| Problem Set 2 | probset2.doc |
| Data File | qod.xls |
| Problem Set 3 | probset3.doc |
| Data File | napster.xls |
| Problem Set 4 | probset4.doc |
| Data File | cfsshell.xls |
| Problem Set 5 | probset5.doc |
| Standard Normal Distribution I | z-table1.doc |
| Standard Normal Distribution II | z-table2.doc |
| Critical Values of Student's t | t-table1.doc |
| A p-value approach to Student's t | t-table2.doc |
| Confidence Interval Formulae | cisheet.doc |
| Hypothesis Testing Formulae | htsheet.doc |
| Regression Statistics | regforms.doc |
| BOOK II | |
| Microsoft Excel: A Self-Assessment | selfassess.doc |
| Solution to Excel Self-Assessment | sselfassess.doc |
| Introduction to Pivot Tables | pivot.doc |
| Pivot Table Data File | pivot0.xls |
| Pivot Table results | spivot.xls |
| Documenting Excel Calculations in Word | excel-word.doc |
| AutoFormulaBox Excel Add-in | click here |
| Correlation Fixer Excel Add-in | click here |
| What Happens If We're Wrong? | risk05.pdf |
| To Financial Advisors ... | geometric.doc |
| Taleb Outsells Greenspan ... | taleb-01.doc |
| Discovering the Odds | ross01.doc |
| Why Game Shows Have Economists Glued to Their TVs | gameshows.doc |
| Geico's Two Rates: White-collar and Blue-collar | geico-01.doc |
| Site Calculates Risk Factors ... | risk04.doc |
| The Prosecutor’s Fallacy | prosec-01.doc |
| Linear functions of random variables | linear.doc |
| Gotham Bank Investment Services | markwitz.doc |
| Recipe for Disaster | quant.pdf |
| The Polling: Report Says Problems Led to Skewed Surveying Data | polls02.doc |
| How Insiders Were Fooled | polls03.doc |
| Deja Vu | polls04.doc |
| Hurdles Emerge ... | hurdles.pdf |
| Fingerprint Matches Come Under More Fire As Potentially Fallible | finger02.doc |
| Federal Agency Warns that Alcohol Test ... | screening01.doc |
| The Truth Wears Off | truth-wears-off.pdf |
| Cheaters Find an Adversary | cheaters.pdf |
| You Might Already Know This ... | you-might-already.pdf |
| Z and T template | z-and-t-template.xls |
| Freakonomics | freak01.doc |
| Sex, Love and Voting | reg01.doc |
| The Formula | movies01.doc |
| How Good Are Zillow's Estimates? | zillow.doc |
| Practice Problems - Part 1 | pract1.doc |
| Practice Problems - Part 2 | pract2.doc |
| Practice Problems - Part 2a | pract2a.doc |
| Practice Quiz | quiz5.doc |
| Practice Problems - Part 3 | pract3.doc |
| Practice Midterm (Midterm 2) | midterm2.doc |
| Practice Midterm (Midterm 3) | midterm3.doc |
| Practice Problems - Part 4 | pract4.doc |
| Practice Problems - Part 5 | pract5.doc |
| Practice Problems - Part 6 | pract6.doc |
| Practice Problems - Part 7 | pract7.doc |
| Practice Quiz (#5) | quiz5.doc |
| Practice Midterm I (#2) | midterm2.doc |
| Practice Midterm II (#3) | midterm3.doc |
| Practice Final III (A) | finala.doc |
| Practice Final II (B) | finalb.doc |
| Data for Final B (separate document) | finalb.xls |
| Practice Final I (F) | finalf.doc |
| Data for Practice Final I (F) (separate document) | finalf-data.doc |
| Yoavi's Cheat Sheet I | joavi1.doc |
| Rajeev's cheat sheet | rajeev-da.doc |
| Yoavi's Cheat Sheet II | joavi2.doc |
| Standard Normal Distribution I | z-table1.doc |
| Standard Normal Distribution II | z-table2.doc |
| Critical Values of Student's t | t-table1.doc |
| A p-value approach to Student's t | t-table2.doc |
| Confidence Interval Formulae | cisheet.doc |
| Hypothesis Testing Formulae | htsheet.doc |
| Regression Statistics | regforms.doc |
| BOOK III | |
| Solutions to Practice Problems - Part 1 | spract1.doc |
| Solutions to Practice Problems - Part 2 | spract2.doc |
| Solutions to Practice Problems - Part 2a | spract2a.doc |
| Solutions to Practice Problems - Part 3 | spract3.doc |
| Solutions to Practice Problems - Part 4 | spract4.doc |
| Solutions to Practice Problems - Part 5 | spract5.doc |
| Solutions to Practice Problems - Part 6 | spract6.doc |
| Solutions to Practice Problems - Part 7 | spract7.doc |
| Solution to Practice Quiz | squiz5.doc |
| Solution to Practice Midterm (Midterm 2) | smidterm2.doc |
| Solution to Practice Midterm (Midterm 3) | smidterm3.doc |
| Solutions to Practice Final I (F) | sfinalf.doc |
| Solutions to Practice Final II (B) | sfinalb.doc |
| Solutions to Practice Final III (A) | sfinala.doc |
| Yoavi's Cheat Sheet I | joavi1.doc |
| Rajeev's cheat sheet | rajeev-da.doc |
| Yoavi's Cheat Sheet II | joavi2.doc |
| Standard Normal Distribution I | z-table1.doc |
| Standard Normal Distribution II | z-table2.doc |
| Critical Values of Student's t | t-table1.doc |
| A p-value approach to Student's t | t-table2.doc |
| Confidence Interval Formulae | cisheet.doc |
| Hypothesis Testing Formulae | htsheet.doc |
| Regression Statistics | regforms.doc |
[ CBS
Home Page |
Description
| Syllabus |
Mission | Downloads ]
[ David
Juran Home Page | B6014
Home Page |
About
the Instructor ]
email: dj114@columbia.edu | tel: (203) 876-0086 | 73 Minuteman Drive, Milford, CT 06460