0.018693 Inputted Data Sample Size (# of Rows) = Max 100
0.158325 Screen Refreshing (enter True or False) FALSE Bootstrap This!
 
  BootStrap Histogram Frequencies Input Data Histogram Frequencies
0.116454 Enter Desired # of Histogram Bars      (Min 5 to Max 30) 30
0.906508 Enter Bootstrap Draw Size 2 0.21445754 0.770798 0.04 11. 0.04 11
0.024062 Enter # of Trials (Min 75, 25000 is OK)   Fixed @ 999 0.03067854 0.505243 0.08 12. 0.08 2
0.528646 0.20593718 0.720343 0.11 15. 0.11 2
0.78878 Mean of Your Input Sample Size 0.488 0.70417966 0.959797 0.14 26. 0.14 3
0.115652 StDev of Your Input Sample Size 0.303 0.3765326 0.138027 0.17 12. 0.17 3
0.027427 …for crosscheck (they should be same) 0.20 29. 0.21 3
0.574693 XL Mean of Your Full Sample 0.488 0.23 29. 0.24 5
0.26873 XL StDev of Your Full Sample 0.303
 
0 0.27 32. 0.27 1
0.404091   Random Seed 0.30 37. 0.30 2
0.78878 0.33 43. 0.34 1
0.817869 Bootstrapped Mean of Medians 0.486
 
1 0.36 37. 0.37 4
0.498072   Bootstrapped StDev of Medians 0.210   95% 0.39 57. 0.40 2
0.771766 Confidence Interval Limits 0.42 45. 0.43 5
0.722854 Sampling Counter 2 0.075 0.897 0.46 43. 0.47 1
0.364275 Iteration Counter 999 0.49 55. 0.50 5
0.752441
0.52 63. 0.53 5
0.933945 0.55 67. 0.57 2
0.484608 0.58 49. 0.60 4
0.55051 0.61 43. 0.63 5
0.771861 0.65 50. 0.66 2
0.660411 0.68 32. 0.70 1
0.105151 0.71 52. 0.73 3
0.899546 0.74 42. 0.76 4
0.651629 0.77 32. 0.79 6
0.85918 0.80 27. 0.83 2
0.217637 0.84 21. 0.86 1
0.622492 0.87 15. 0.89 4
0.709927 0.90 8. 0.92 3
0.401639 0.93 10. 0.96 4
0.703779 0.96 5. 0.99 4
0.021442
0.793774 Rounded Rectangle: 1. Copy and Paste your input data columun in Column A of this sheet (no header,spaces,text)
2. Do not enter or alter info in ANY grey zones
3. Make relevant entries in E3: E5, they are in YELLOW
4. Select Fixed / Random Seed
5. Choose Confidence Level
6.  Enter FALSE in E2, to speed up execution

 © 2005 Advanced Portfolio Solutions
Copying/Redistribution without permission is a violation of copyright laws.
0.866701
0.078228
0.493386
0.758615
0.567127
0.963058          
0.401469   Download Bootstrapping VBA XL file here
0.034515          
0.179551
0.583525
0.011886
0.93901
0.226281
0.514411
0.238408
0.615515     This is a fully functional application, however it is limited by maximum data length and max. no of iterations.  Contact  http://AdvancedPortfolioSolutions.Com for a full version.