CH%2013_p3

CH%2013_p3 - beat market >=11 years even if all...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Ch 13 p3 Page 1 Chapter 13 Problem 3 Year Fund# 1 2 3 4 12 13 #beat 1 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? 2 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? 3 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? 5 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? 46 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? 47 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? 48 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? 49 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? 50 #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? #ADDIN? max #ADDIN? max>=11? #ADDIN? Simulation Results for Book2 Iterations= 100 Simulations= 1 # Input Variables= 650 # Output Variables= 1 Sampling Type= Latin Hypercube Runtime= 00:03:46 Summary Statistics Cell Name Minimum Mean !O56 max>=11?/ 0 0.44 It appears that there is a 44% chance that at least one fund of 50 would
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: beat market >=11 years even if all funds were tossing darts to choose stocks! Ch 13 p3 Excel Page 2 Chapter 13 Problem 3 Year Fund# 1 2 3 4 12 13 #beat 1 1 1 1 1 6 2 1 1 5 3 1 1 1 7 5 1 1 1 7 46 1 1 1 6 47 1 3 48 1 1 1 1 6 49 1 1 5 50 1 1 1 7 max 10 max>=11? Trials 1 2 3 4 5 6 7 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Mean 0.41 Ch 13 p3 Excel Page 3 8 9 10 1 1 1 1 1 1 1 1 1 1 1 1...
View Full Document

Page1 / 3

CH%2013_p3 - beat market >=11 years even if all...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online