€¦ · xls file · web view · 2009-02-26samplex sdx for x randomly distributed between 0 and...

45
Parameter Population Sample N 1000 10 Pearson r 0.950 0.949 0.951 Coef. of Det 0.903 0.900 0.905 SDx 2.887 2.859 2.632 SDy 2.887 2.877 2.919 Alpha 0.1 T-critical 1.6449 Standard Error of Estimate 0.9565 Std. Error of Slope 0.1211 Generation Settings

Upload: dodan

Post on 11-May-2018

217 views

Category:

Documents


2 download

TRANSCRIPT

Page 1: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

Par

amet

er

Popu

latio

n

Sam

ple

N 1000 10Pearson r 0.950 0.948 0.891Coef. of Det 0.903 0.899 0.794SDx 2.887 2.874 2.777SDy 2.887 2.856 2.626

Alpha 0.1T-critical 1.64485Standard Error of Estimate 1.26492Std. Error of Slope 0.15183

Gen

erat

ion

Setti

ngs

Page 2: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

0 1 2 3 4 5 6 7 8 9 10

-4

-2

0

2

4

6

8

10

12

Y PopReg Sample Samp Reg Lower Upper

Page 3: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

Generation Settings Population SampleN 10 1000 10Pearson r 0.95 0.948386 0.890925SDx 2.886751 2.874154 2.777097SDy 2.886751 2.855938 2.625958

X Y Y_Hat True_reg Smuhat1 0 0.390994 0.040576 1.03139186511 1 1.233432 0.982951 0.88558489641 2 2.07587 1.925326 0.74586538891 3 2.918308 2.867702 0.61638696321 4 3.760746 3.810077 0.50508785271 5 4.603183 4.752452 0.42644780431 6 5.445621 5.694828 0.40020602331 7 6.288059 6.637203 0.43593019261 8 7.130497 7.579578 0.5210264341 9 7.972935 8.521953 0.63597570511 10 8.815373 9.464329 0.7674795049

Source 5.241298 0.107851 Residual SampleX1 5.120827 0.278195 1 5.120827 4.334579 4.704973 -0.370394 5.12082690011 4.830361 0.182247 1 4.830361 3.771432 4.460273 -0.68884 4.83036071111 7.94874 0.780585 1 7.94874 8.249132 7.087313 1.161819 7.94873957951 9.914525 0.707615 1 9.914525 9.911344 8.743365 1.167978 9.91452522341 1.213952 0.994266 1 1.213952 3.432041 1.413673 2.018368 1.21395198391 7.117497 0.046702 1 7.117497 5.249356 6.387043 -1.137687 7.11749694271 4.990529 0.749245 1 4.990529 5.346838 4.595205 0.751633 4.99052939251 5.330015 0.133827 1 5.330015 4.064341 4.8812 -0.816859 5.33001482231 9.710511 0.110006 1 9.710511 8.119438 8.571496 -0.452058 9.71051130751 3.030093 0.040883 1 3.030093 1.3097 2.943659 -1.633959 3.03009269411 9.602877 0.526756 0 0 9.183232 #DIV/0!1 0.868428 0.116067 0 0 -0.252044 #DIV/0!1 5.756176 0.233559 0 0 4.812899 #DIV/0!1 1.009184 0.327478 0 0 0.555906 #DIV/0!1 0.172567 0.469209 0 0 0.094299 #DIV/0!1 3.810862 0.664799 0 0 4.003947 #DIV/0!1 3.833491 0.643816 0 0 3.974138 #DIV/0!1 2.151486 0.605553 0 0 2.285255 #DIV/0!1 3.16118 0.288496 0 0 2.500342 #DIV/0!1 8.581326 0.815705 0 0 8.962713 #DIV/0!1 0.638123 0.511432 0 0 0.632051 #DIV/0!1 9.002354 0.648455 0 0 8.895804 #DIV/0!1 4.319196 0.812429 0 0 4.902662 #DIV/0!1 5.608764 0.804362 0 0 6.101092 #DIV/0!1 9.214482 0.507545 0 0 8.770805 #DIV/0!1 0.986391 0.865435 0 0 1.933168 #DIV/0!1 3.279037 0.86441 0 0 4.106929 #DIV/0!1 2.799718 0.717122 0 0 3.177411 #DIV/0!1 3.781632 0.112324 0 0 2.498031 #DIV/0!1 3.274457 0.429136 0 0 2.949769 #DIV/0!1 7.556496 0.687962 0 0 7.620424 #DIV/0!1 4.151282 0.976322 0 0 5.731268 #DIV/0!1 4.96226 0.266505 0 0 4.152207 #DIV/0!

Page 4: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 2.589061 0.137315 0 0 1.474875 #DIV/0!1 5.282954 0.932015 0 0 6.362745 #DIV/0!1 2.967776 0.4547 0 0 2.716813 #DIV/0!1 9.245142 0.942587 0 0 10.20426 #DIV/0!1 6.480645 0.272954 0 0 5.612261 #DIV/0!1 4.939411 0.263038 0 0 4.120955 #DIV/0!1 9.970529 0.370276 0 0 9.173532 #DIV/0!1 0.932538 0.981644 0 0 2.768863 #DIV/0!1 5.868475 0.735596 0 0 6.14277 #DIV/0!1 8.572278 0.610559 0 0 8.396753 #DIV/0!1 0.972783 0.710241 0 0 1.423594 #DIV/0!1 0.953804 0.609575 0 0 1.156891 #DIV/0!1 4.497265 0.3401 0 0 3.900859 #DIV/0!1 5.719656 0.313316 0 0 4.995173 #DIV/0!1 7.52211 0.276144 0 0 6.610278 #DIV/0!1 1.538751 0.031917 0 0 -0.208762 #DIV/0!1 0.942625 0.671713 0 0 1.296294 #DIV/0!1 3.892804 0.964866 0 0 5.329838 #DIV/0!1 6.535542 0.451784 0 0 6.099557 #DIV/0!1 5.414973 0.680246 0 0 5.566422 #DIV/0!1 1.420977 0.694397 0 0 1.808151 #DIV/0!1 3.893809 0.6287 0 0 3.995146 #DIV/0!1 7.916929 0.617199 0 0 7.789816 #DIV/0!1 4.521865 0.326903 0 0 3.891518 #DIV/0!1 3.234608 0.634516 0 0 3.38281 #DIV/0!1 6.821617 0.352005 0 0 6.138089 #DIV/0!1 1.249815 0.22512 0 0 0.506763 #DIV/0!1 0.731765 0.969755 0 0 2.387265 #DIV/0!1 0.786656 0.040351 0 0 -0.82707 #DIV/0!1 2.374036 0.339966 0 0 1.88346 #DIV/0!1 7.349893 0.43957 0 0 6.845334 #DIV/0!1 4.34352 0.746793 0 0 4.725255 #DIV/0!1 9.414198 0.766288 0 0 9.598506 #DIV/0!1 0.87311 0.554865 0 0 0.953811 #DIV/0!1 9.152146 0.590179 0 0 8.900061 #DIV/0!1 3.596861 0.968644 0 0 5.094708 #DIV/0!1 9.981632 0.777373 0 0 10.17062 #DIV/0!1 3.265807 0.043871 0 0 1.563463 #DIV/0!1 0.921094 0.27839 0 0 0.345356 #DIV/0!1 8.370989 0.386109 0 0 7.691511 #DIV/0!1 0.611391 0.672929 0 0 0.984657 #DIV/0!1 9.012013 0.945876 0 0 10.00915 #DIV/0!1 4.074491 0.174908 0 0 3.028017 #DIV/0!1 3.370806 0.689776 0 0 3.648648 #DIV/0!1 2.827881 0.975756 0 0 4.464977 #DIV/0!1 4.420206 0.878537 0 0 5.25175 #DIV/0!1 0.969676 0.660643 0 0 1.294565 #DIV/0!1 1.474474 0.902495 0 0 2.568857 #DIV/0!1 6.699158 0.041966 0 0 4.806324 #DIV/0!1 9.425701 0.367256 0 0 8.648729 #DIV/0!1 5.959912 0.520368 0 0 5.707957 #DIV/0!

Page 5: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 4.127255 0.26276 0 0 3.348637 #DIV/0!1 8.15888 0.470555 0 0 7.684345 #DIV/0!1 7.214599 0.0459 0 0 5.334145 #DIV/0!1 8.729278 0.011556 0 0 6.245237 #DIV/0!1 4.932709 0.617861 0 0 4.95637 #DIV/0!1 2.393134 0.176079 0 0 1.434814 #DIV/0!1 3.643834 0.796644 0 0 4.209517 #DIV/0!1 8.8691 0.973751 0 0 10.17346 #DIV/0!1 3.436746 0.308264 0 0 2.813513 #DIV/0!1 3.864586 0.556568 0 0 3.7996 #DIV/0!1 8.900545 0.811844 0 0 9.252985 #DIV/0!1 8.740979 0.694704 0 0 8.762944 #DIV/0!1 9.294295 0.667361 0 0 9.219555 #DIV/0!1 0.328906 0.268371 0 0 -0.24437 #DIV/0!1 3.672619 0.286693 0 0 2.981442 #DIV/0!1 2.805065 0.745804 0 0 3.260939 #DIV/0!1 6.025926 0.672268 0 0 6.126815 #DIV/0!1 7.378627 0.949734 0 0 8.490028 #DIV/0!1 4.969862 0.617976 0 0 4.991938 #DIV/0!1 1.165751 0.10891 0 0 -0.00336 #DIV/0!1 0.258383 0.815636 0 0 1.055683 #DIV/0!1 3.705994 0.466484 0 0 3.444878 #DIV/0!1 2.254508 0.548122 0 0 2.250777 #DIV/0!1 4.711052 0.396374 0 0 4.238666 #DIV/0!1 1.980525 0.530923 0 0 1.951438 #DIV/0!1 2.680722 0.692096 0 0 2.999003 #DIV/0!1 6.074114 0.973524 0 0 7.51488 #DIV/0!1 3.215493 0.395555 0 0 2.815967 #DIV/0!1 1.933403 0.417416 0 0 1.648786 #DIV/0!1 3.493406 0.949802 0 0 4.799657 #DIV/0!1 3.203363 0.308148 0 0 2.591503 #DIV/0!1 2.973115 0.767559 0 0 3.483221 #DIV/0!1 5.00543 0.972111 0 0 6.479305 #DIV/0!1 8.107285 0.81609 0 0 8.513679 #DIV/0!1 9.011149 0.614188 0 0 8.822221 #DIV/0!1 2.915056 0.931426 0 0 4.10921 #DIV/0!1 1.60588 0.432649 0 0 1.372681 #DIV/0!1 0.87274 0.715841 0 0 1.343371 #DIV/0!1 8.129621 0.393542 0 0 7.479676 #DIV/0!1 6.041718 0.348157 0 0 5.38782 #DIV/0!1 5.221165 0.540473 0 0 5.05171 #DIV/0!1 7.604046 0.775192 0 0 7.905344 #DIV/0!1 2.009398 0.855791 0 0 2.86584 #DIV/0!1 4.522144 0.061789 0 0 2.907966 #DIV/0!1 4.798848 0.343705 0 0 4.196212 #DIV/0!1 6.627482 0.577493 0 0 6.472314 #DIV/0!1 4.768391 0.970788 0 0 6.235854 #DIV/0!1 2.398876 0.418458 0 0 2.093391 #DIV/0!1 2.937073 0.745685 0 0 3.386012 #DIV/0!1 6.068819 0.688746 0 0 6.209131 #DIV/0!1 4.143634 0.542704 0 0 4.033124 #DIV/0!

Page 6: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 3.548895 0.875635 0 0 4.411147 #DIV/0!1 5.721526 0.214374 0 0 4.722151 #DIV/0!1 4.563081 0.635283 0 0 4.646696 #DIV/0!1 0.137162 0.081873 0 0 -1.124954 #DIV/0!1 6.979908 0.235231 0 0 5.980357 #DIV/0!1 7.016277 0.310377 0 0 6.219473 #DIV/0!1 6.233793 0.71986 0 0 6.447093 #DIV/0!1 2.871901 0.822682 0 0 3.562661 #DIV/0!1 8.063813 0.154901 0 0 6.745137 #DIV/0!1 2.606857 0.184065 0 0 1.665282 #DIV/0!1 8.820547 0.913351 0 0 9.606922 #DIV/0!1 6.341346 0.116623 0 0 4.949788 #DIV/0!1 9.895246 0.537447 0 0 9.485218 #DIV/0!1 2.830518 0.575153 0 0 2.859812 #DIV/0!1 6.50614 0.159365 0 0 5.282085 #DIV/0!1 6.10224 0.918616 0 0 7.055309 #DIV/0!1 7.987612 0.767558 0 0 8.246991 #DIV/0!1 1.71839 0.812294 0 0 2.431443 #DIV/0!1 8.338356 0.269616 0 0 7.36801 #DIV/0!1 7.204595 0.927185 0 0 8.156013 #DIV/0!1 4.175759 0.024978 0 0 2.199943 #DIV/0!1 7.526771 0.467675 0 0 7.077317 #DIV/0!1 2.30288 0.164313 0 0 1.307182 #DIV/0!1 0.139649 0.494169 0 0 0.119492 #DIV/0!1 9.666441 0.830922 0 0 10.04648 #DIV/0!1 8.284957 0.004225 0 0 5.496839 #DIV/0!1 1.912381 0.699707 0 0 2.288691 #DIV/0!1 6.491169 0.13047 0 0 5.153295 #DIV/0!1 9.83913 0.895678 0 0 10.48049 #DIV/0!1 2.172434 0.337154 0 0 1.685012 #DIV/0!1 8.009073 0.334698 0 0 7.223748 #DIV/0!1 5.498211 0.476957 0 0 5.171206 #DIV/0!1 0.712493 0.582247 0 0 0.864038 #DIV/0!1 3.410847 0.246051 0 0 2.621079 #DIV/0!1 1.860971 0.433189 0 0 1.616253 #DIV/0!1 5.184811 0.081427 0 0 3.667649 #DIV/0!1 2.424668 0.849174 0 0 3.234476 #DIV/0!1 6.286891 0.065459 0 0 4.611011 #DIV/0!1 5.815261 0.981251 0 0 7.399647 #DIV/0!1 9.64399 0.155845 0 0 8.249871 #DIV/0!1 1.567938 0.263694 0 0 0.919866 #DIV/0!1 3.98305 0.772252 0 0 4.456589 #DIV/0!1 9.597845 0.01917 0 0 7.251004 #DIV/0!1 9.538873 0.071899 0 0 7.744288 #DIV/0!1 1.817455 0.877564 0 0 2.774801 #DIV/0!1 6.508756 0.12926 0 0 5.164843 #DIV/0!1 2.631128 0.271622 0 0 1.951603 #DIV/0!1 0.294149 0.42414 0 0 0.106993 #DIV/0!1 9.85106 0.438486 0 0 9.218965 #DIV/0!1 0.92189 0.584379 0 0 1.06789 #DIV/0!1 8.181319 0.670801 0 0 8.17078 #DIV/0!

Page 7: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 3.686113 0.383904 0 0 3.235678 #DIV/0!1 8.235623 0.072737 0 0 6.511687 #DIV/0!1 1.635906 0.504299 0 0 1.563825 #DIV/0!1 9.935546 0.050524 0 0 7.960678 #DIV/0!1 4.953899 0.043409 0 0 3.162646 #DIV/0!1 9.180939 0.414853 0 0 8.528023 #DIV/0!1 5.001155 0.890577 0 0 5.859448 #DIV/0!1 3.591984 0.623698 0 0 3.69651 #DIV/0!1 6.150186 0.618253 0 0 6.1139 #DIV/0!1 1.987548 0.363378 0 0 1.573186 #DIV/0!1 0.823563 0.254457 0 0 0.18699 #DIV/0!1 1.082434 0.592034 0 0 1.238138 #DIV/0!1 6.735582 0.143571 0 0 5.439354 #DIV/0!1 2.763831 0.476121 0 0 2.571653 #DIV/0!1 1.57007 0.744865 0 0 2.085057 #DIV/0!1 8.267062 0.969004 0 0 9.536018 #DIV/0!1 8.749994 0.589964 0 0 8.517516 #DIV/0!1 8.127698 0.41466 0 0 7.526996 #DIV/0!1 3.596938 0.605317 0 0 3.657883 #DIV/0!1 6.282879 0.495424 0 0 5.958395 #DIV/0!1 4.5439 0.675235 0 0 4.726309 #DIV/0!1 0.861739 0.323517 0 0 0.40592 #DIV/0!1 7.041577 0.787499 0 0 7.408602 #DIV/0!1 0.868827 0.158849 0 0 -0.075281 #DIV/0!1 9.360361 0.681277 0 0 9.317143 #DIV/0!1 1.059182 0.490944 0 0 0.985759 #DIV/0!1 9.544926 0.342474 0 0 8.701968 #DIV/0!1 9.255388 0.536922 0 0 8.876162 #DIV/0!1 0.889379 0.708442 0 0 1.339627 #DIV/0!1 4.16229 0.384137 0 0 3.688596 #DIV/0!1 2.44639 0.639401 0 0 2.645739 #DIV/0!1 3.525551 0.072001 0 0 2.032299 #DIV/0!1 9.585426 0.46414 0 0 9.025021 #DIV/0!1 4.889071 0.670242 0 0 5.041752 #DIV/0!1 3.237112 0.481639 0 0 3.033757 #DIV/0!1 9.74764 0.661871 0 0 9.636654 #DIV/0!1 8.05161 0.052554 0 0 6.188264 #DIV/0!1 4.554034 0.599933 0 0 4.554541 #DIV/0!1 6.838101 0.050529 0 0 5.018152 #DIV/0!1 9.096065 0.159705 0 0 7.743776 #DIV/0!1 2.517137 0.997594 0 0 4.932605 #DIV/0!1 0.736703 0.101025 0 0 -0.450063 #DIV/0!1 8.326743 0.307492 0 0 7.457035 #DIV/0!1 6.488875 0.379518 0 0 5.887933 #DIV/0!1 5.119065 0.361191 0 0 4.542869 #DIV/0!1 6.867497 0.084261 0 0 5.282942 #DIV/0!1 8.90932 0.486124 0 0 8.432496 #DIV/0!1 2.341186 0.550082 0 0 2.337583 #DIV/0!1 3.569465 0.31436 0 0 2.955144 #DIV/0!1 5.685617 0.32327 0 0 4.987982 #DIV/0!1 3.63235 0.690436 0 0 3.8988 #DIV/0!

Page 8: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 6.980711 0.204023 0 0 5.885925 #DIV/0!1 0.490695 0.978239 0 0 2.285766 #DIV/0!1 3.623645 0.329551 0 0 3.044812 #DIV/0!1 0.146169 0.849685 0 0 1.071871 #DIV/0!1 9.4068 0.839361 0 0 9.830487 #DIV/0!1 4.413463 0.280909 0 0 3.669856 #DIV/0!1 5.739767 0.562292 0 0 5.594101 #DIV/0!1 9.583328 0.177655 0 0 8.270975 #DIV/0!1 8.901193 0.989208 0 0 10.52719 #DIV/0!1 7.004661 0.241665 0 0 6.022595 #DIV/0!1 7.265585 0.291818 0 0 6.408271 #DIV/0!1 4.495949 0.318644 0 0 3.846152 #DIV/0!1 6.22964 0.721268 0 0 6.446923 #DIV/0!1 1.816651 0.296969 0 0 1.245254 #DIV/0!1 2.178337 0.165182 0 0 1.192027 #DIV/0!1 5.803754 0.766704 0 0 6.169808 #DIV/0!1 5.934459 0.016281 0 0 3.711061 #DIV/0!1 7.626417 0.85927 0 0 8.21593 #DIV/0!1 1.714353 0.995071 0 0 3.954937 #DIV/0!1 8.578318 0.899033 0 0 9.299629 #DIV/0!1 2.093378 0.327321 0 0 1.585499 #DIV/0!1 3.757847 0.627667 0 0 3.863521 #DIV/0!1 1.173906 0.92763 0 0 2.429763 #DIV/0!1 8.407403 0.557291 0 0 8.116925 #DIV/0!1 7.341726 0.363371 0 0 6.65964 #DIV/0!1 1.008951 0.733256 0 0 1.51979 #DIV/0!1 4.510278 0.740321 0 0 4.865558 #DIV/0!1 3.739318 0.072865 0 0 2.241031 #DIV/0!1 8.015404 0.955557 0 0 9.148167 #DIV/0!1 5.037787 0.177292 0 0 3.951451 #DIV/0!1 5.421495 0.546263 0 0 5.255184 #DIV/0!1 0.62384 0.109104 0 0 -0.517237 #DIV/0!1 5.333936 0.881123 0 0 6.131434 #DIV/0!1 7.28396 0.016666 0 0 5.001544 #DIV/0!1 4.036126 0.045914 0 0 2.314733 #DIV/0!1 5.542457 0.056452 0 0 3.836384 #DIV/0!1 2.165573 0.612374 0 0 2.314653 #DIV/0!1 0.70302 0.129027 0 0 -0.351602 #DIV/0!1 1.465802 0.108752 0 0 0.280928 #DIV/0!1 6.777783 0.407337 0 0 6.227607 #DIV/0!1 1.738932 0.905776 0 0 2.837474 #DIV/0!1 1.541656 0.923067 0 0 2.749957 #DIV/0!1 7.023682 0.094043 0 0 5.486032 #DIV/0!1 7.883045 0.098 0 0 6.32337 #DIV/0!1 3.994404 0.668605 0 0 4.187748 #DIV/0!1 9.594732 0.512618 0 0 9.14351 #DIV/0!1 0.9553 0.946441 0 0 2.359925 #DIV/0!1 6.06597 0.709812 0 0 6.26099 #DIV/0!1 6.166265 0.055818 0 0 4.423952 #DIV/0!1 8.207115 0.065075 0 0 6.432497 #DIV/0!1 8.56254 0.234246 0 0 7.480966 #DIV/0!

Page 9: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 9.364335 0.414264 0 0 8.700887 #DIV/0!1 4.736668 0.303268 0 0 4.035599 #DIV/0!1 9.985391 0.385025 0 0 9.222637 #DIV/0!1 7.454005 0.140691 0 0 6.110311 #DIV/0!1 1.377669 0.158169 0 0 0.405583 #DIV/0!1 5.314271 0.387707 0 0 4.791391 #DIV/0!1 3.252246 0.725687 0 0 3.630304 #DIV/0!1 7.383758 0.817045 0 0 7.829571 #DIV/0!1 9.513968 0.008306 0 0 6.879288 #DIV/0!1 2.184511 0.2706 0 0 1.524538 #DIV/0!1 3.551936 0.977211 0 0 5.176469 #DIV/0!1 2.170177 0.005518 0 0 -0.229249 #DIV/0!1 7.392026 0.217382 0 0 6.318382 #DIV/0!1 8.123939 0.783379 0 0 8.424119 #DIV/0!1 8.734736 0.832161 0 0 9.1658 #DIV/0!1 1.073223 0.886678 0 0 2.109383 #DIV/0!1 7.562932 0.512379 0 0 7.21276 #DIV/0!1 9.990066 0.583531 0 0 9.680698 #DIV/0!1 1.789416 0.754998 0 0 2.322175 #DIV/0!1 5.219312 0.532037 0 0 5.030809 #DIV/0!1 1.624464 0.921962 0 0 2.821762 #DIV/0!1 7.863226 0.192209 0 0 6.68605 #DIV/0!1 2.585171 0.090984 0 0 1.252809 #DIV/0!1 3.324975 0.710521 0 0 3.658912 #DIV/0!1 6.446368 0.34321 0 0 5.760144 #DIV/0!1 8.666113 0.130379 0 0 7.219108 #DIV/0!1 2.161656 0.987058 0 0 4.061805 #DIV/0!1 0.482879 0.198854 0 0 -0.30359 #DIV/0!1 6.045101 0.057696 0 0 4.32369 #DIV/0!1 7.903446 0.530625 0 0 7.577538 #DIV/0!1 5.426284 0.524148 0 0 5.209565 #DIV/0!1 6.639724 0.490078 0 0 6.285317 #DIV/0!1 3.785485 0.024709 0 0 1.82501 #DIV/0!1 0.228347 0.618417 0 0 0.488541 #DIV/0!1 5.572022 0.214792 0 0 4.58141 #DIV/0!1 9.301836 0.364066 0 0 8.523411 #DIV/0!1 8.394132 0.734288 0 0 8.538545 #DIV/0!1 0.134748 0.561815 0 0 0.268241 #DIV/0!1 7.08436 0.827531 0 0 7.581459 #DIV/0!1 6.133042 0.708146 0 0 6.32033 #DIV/0!1 5.467908 0.128749 0 0 4.17385 #DIV/0!1 8.831425 0.84284 0 0 9.296827 #DIV/0!1 8.373549 0.743448 0 0 8.544391 #DIV/0!1 6.970577 0.82478 0 0 7.463705 #DIV/0!1 7.91172 0.59196 0 0 7.725787 #DIV/0!1 5.664247 0.301834 0 0 4.913094 #DIV/0!1 2.602235 0.954229 0 0 3.993051 #DIV/0!1 8.684462 0.870305 0 0 9.266854 #DIV/0!1 4.969907 0.757568 0 0 5.351033 #DIV/0!1 2.532871 0.325641 0 0 1.998817 #DIV/0!1 8.048461 0.656299 0 0 8.008742 #DIV/0!

Page 10: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 4.088061 0.263021 0 0 3.312126 #DIV/0!1 7.60579 0.585958 0 0 7.421246 #DIV/0!1 0.025134 0.927433 0 0 1.337142 #DIV/0!1 2.484508 0.953926 0 0 3.878375 #DIV/0!1 9.34274 0.93767 0 0 10.25968 #DIV/0!1 9.965344 0.703471 0 0 9.948789 #DIV/0!1 7.15241 0.932572 0 0 8.142569 #DIV/0!1 2.509276 0.042743 0 0 0.833688 #DIV/0!1 6.686748 0.056499 0 0 4.923839 #DIV/0!1 3.318143 0.906843 0 0 4.343474 #DIV/0!1 0.009122 0.046206 0 0 -1.508197 #DIV/0!1 8.217847 0.448125 0 0 7.689414 #DIV/0!1 6.110283 0.619727 0 0 6.079479 #DIV/0!1 6.279372 0.3226 0 0 5.550367 #DIV/0!1 8.581438 0.993349 0 0 10.38381 #DIV/0!1 9.789893 0.03426 0 0 7.658453 #DIV/0!1 7.335366 0.012831 0 0 4.95733 #DIV/0!1 3.21321 0.753866 0 0 3.671536 #DIV/0!1 7.699188 0.912109 0 0 8.534578 #DIV/0!1 3.137892 0.292361 0 0 2.488389 #DIV/0!1 7.74344 0.084388 0 0 6.115827 #DIV/0!1 5.074403 0.317399 0 0 4.392539 #DIV/0!1 6.782428 0.719913 0 0 6.968441 #DIV/0!1 0.159155 0.28912 0 0 -0.349935 #DIV/0!1 4.039977 0.93593 0 0 5.209423 #DIV/0!1 1.636356 0.922091 0 0 2.833859 #DIV/0!1 9.41761 0.410362 0 0 8.742463 #DIV/0!1 4.225004 0.760152 0 0 4.650846 #DIV/0!1 4.140247 0.216717 0 0 3.22715 #DIV/0!1 9.174826 0.559991 0 0 8.852146 #DIV/0!1 8.673545 0.24701 0 0 7.623383 #DIV/0!1 3.919709 0.302368 0 0 3.257164 #DIV/0!1 5.088474 0.81914 0 0 5.656199 #DIV/0!1 9.242231 0.44293 0 0 8.650731 #DIV/0!1 3.542828 0.175115 0 0 2.523663 #DIV/0!1 7.23745 0.979613 0 0 8.71966 #DIV/0!1 7.834814 0.601844 0 0 7.675743 #DIV/0!1 6.959128 0.993137 0 0 8.832513 #DIV/0!1 0.888824 0.314073 0 0 0.407806 #DIV/0!1 0.665213 0.150314 0 0 -0.301063 #DIV/0!1 0.12239 0.516526 0 0 0.15362 #DIV/0!1 2.128559 0.082328 0 0 0.769582 #DIV/0!1 0.046024 0.434281 0 0 -0.105443 #DIV/0!1 0.455373 0.716763 0 0 0.949327 #DIV/0!1 0.406002 0.775268 0 0 1.06743 #DIV/0!1 3.114159 0.586408 0 0 3.155237 #DIV/0!1 5.974476 0.489749 0 0 5.652589 #DIV/0!1 0.781212 0.95476 0 0 2.268082 #DIV/0!1 4.513591 0.098256 0 0 3.12372 #DIV/0!1 6.947489 0.790037 0 0 7.327129 #DIV/0!1 4.276356 0.488866 0 0 4.037377 #DIV/0!

Page 11: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 5.292195 0.070202 0 0 3.69868 #DIV/0!1 0.239731 0.249259 0 0 -0.382335 #DIV/0!1 0.820803 0.042331 0 0 -0.774455 #DIV/0!1 0.842334 0.396916 0 0 0.56465 #DIV/0!1 9.225031 0.484644 0 0 8.729075 #DIV/0!1 3.264119 0.693439 0 0 3.556675 #DIV/0!1 7.334365 0.75499 0 0 7.589854 #DIV/0!1 8.515562 0.596928 0 0 8.310987 #DIV/0!1 9.32931 0.937294 0 0 10.24417 #DIV/0!1 8.930307 0.93615 0 0 9.85682 #DIV/0!1 8.980793 0.883517 0 0 9.606885 #DIV/0!1 7.434942 0.686099 0 0 7.500207 #DIV/0!1 6.698585 0.085005 0 0 5.126795 #DIV/0!1 4.491109 0.173147 0 0 3.417624 #DIV/0!1 4.269786 0.763009 0 0 4.701706 #DIV/0!1 7.429119 0.089663 0 0 5.847249 #DIV/0!1 1.69119 0.202764 0 0 0.856868 #DIV/0!1 3.051611 0.670974 0 0 3.297989 #DIV/0!1 7.380989 0.552767 0 0 7.131514 #DIV/0!1 7.976183 0.205104 0 0 6.835055 #DIV/0!1 5.288756 0.961213 0 0 6.615218 #DIV/0!1 6.985037 0.428721 0 0 6.473867 #DIV/0!1 6.252648 0.079527 0 0 4.670628 #DIV/0!1 4.938193 0.453448 0 0 4.585863 #DIV/0!1 7.541195 0.405268 0 0 6.948041 #DIV/0!1 3.868255 0.01397 0 0 1.69347 #DIV/0!1 2.799437 0.052681 0 0 1.199757 #DIV/0!1 7.029475 0.301733 0 0 6.209799 #DIV/0!1 3.328948 0.672834 0 0 3.566099 #DIV/0!1 3.018661 0.832996 0 0 3.738534 #DIV/0!1 1.764444 0.971368 0 0 3.390015 #DIV/0!1 1.498114 0.320858 0 0 1.003791 #DIV/0!1 0.767385 0.882611 0 0 1.799991 #DIV/0!1 0.931989 0.809981 0 0 1.676653 #DIV/0!1 8.831446 0.352408 0 0 8.048403 #DIV/0!1 5.476173 0.546244 0 0 5.307086 #DIV/0!1 4.144622 0.914295 0 0 5.170208 #DIV/0!1 3.754648 0.334799 0 0 3.182292 #DIV/0!1 5.594928 0.7112 0 0 5.817159 #DIV/0!1 0.383045 0.180807 0 0 -0.458437 #DIV/0!1 2.488706 0.911834 0 0 3.583066 #DIV/0!1 3.649541 0.949974 0 0 4.949487 #DIV/0!1 5.684031 0.055582 0 0 3.963938 #DIV/0!1 2.710906 0.253457 0 0 1.977155 #DIV/0!1 0.231864 0.207224 0 0 -0.515345 #DIV/0!1 2.037435 0.925559 0 0 3.236707 #DIV/0!1 4.382568 0.968459 0 0 5.838773 #DIV/0!1 5.69705 0.454621 0 0 5.309444 #DIV/0!1 6.525895 0.665312 0 0 6.584497 #DIV/0!1 4.412876 0.027617 0 0 2.464244 #DIV/0!1 7.972851 0.37159 0 0 7.278875 #DIV/0!

Page 12: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 3.942393 0.625967 0 0 4.03479 #DIV/0!1 3.547853 0.785227 0 0 4.082529 #DIV/0!1 3.117985 0.975034 0 0 4.729295 #DIV/0!1 0.572383 0.738171 0 0 1.118595 #DIV/0!1 9.283932 0.575479 0 0 8.991307 #DIV/0!1 4.552141 0.705257 0 0 4.810905 #DIV/0!1 9.986497 0.045127 0 0 7.960166 #DIV/0!1 5.664897 0.695099 0 0 5.841681 #DIV/0!1 1.191782 0.597387 0 0 1.354465 #DIV/0!1 7.122439 0.481832 0 0 6.725253 #DIV/0!1 0.83748 0.565024 0 0 0.943181 #DIV/0!1 7.834656 0.767916 0 0 8.102739 #DIV/0!1 6.565718 0.19425 0 0 5.460128 #DIV/0!1 5.09698 0.564894 0 0 4.989407 #DIV/0!1 5.344548 0.003629 0 0 2.657275 #DIV/0!1 2.137809 0.350196 0 0 1.684073 #DIV/0!1 5.265059 0.849559 0 0 5.934331 #DIV/0!1 7.958612 0.472236 0 0 7.497899 #DIV/0!1 1.231101 0.476071 0 0 1.115448 #DIV/0!1 7.470307 0.250967 0 0 6.491555 #DIV/0!1 5.645826 0.507384 0 0 5.380218 #DIV/0!1 2.557134 0.086799 0 0 1.202727 #DIV/0!1 6.669646 0.009709 0 0 4.229266 #DIV/0!1 6.437319 0.716711 0 0 6.632037 #DIV/0!1 1.775156 0.37682 0 0 1.403503 #DIV/0!1 0.899766 0.485798 0 0 0.822683 #DIV/0!1 6.297459 0.659922 0 0 6.354183 #DIV/0!1 6.14496 0.93296 0 0 7.188177 #DIV/0!1 8.073391 0.356018 0 0 7.336999 #DIV/0!1 1.701056 0.987948 0 0 3.649045 #DIV/0!1 9.344711 0.070204 0 0 7.548582 #DIV/0!1 7.619671 0.866712 0 0 8.240114 #DIV/0!1 1.564316 0.507305 0 0 1.502607 #DIV/0!1 8.788421 0.569496 0 0 8.506825 #DIV/0!1 2.397166 0.632703 0 0 2.582897 #DIV/0!1 0.320788 0.528494 0 0 0.369183 #DIV/0!1 1.617291 0.36382 0 0 1.222504 #DIV/0!1 1.344191 0.41454 0 0 1.082387 #DIV/0!1 0.390687 0.112386 0 0 -0.723077 #DIV/0!1 1.924148 0.425465 0 0 1.658541 #DIV/0!1 0.347571 0.360349 0 0 0.007922 #DIV/0!1 8.534978 0.687864 0 0 8.549734 #DIV/0!1 8.319057 0.028136 0 0 6.18242 #DIV/0!1 6.028058 0.087269 0 0 4.502784 #DIV/0!1 6.631194 0.523787 0 0 6.353412 #DIV/0!1 2.306928 0.092531 0 0 0.996948 #DIV/0!1 9.621407 0.805375 0 0 9.916414 #DIV/0!1 9.721119 0.832723 0 0 10.10489 #DIV/0!1 7.959102 0.561367 0 0 7.700353 #DIV/0!1 6.326675 0.847105 0 0 6.933449 #DIV/0!1 9.345818 0.010107 0 0 6.785194 #DIV/0!

Page 13: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 0.176112 0.94676 0 0 1.62234 #DIV/0!1 7.006519 0.550665 0 0 6.770976 #DIV/0!1 7.256095 0.124477 0 0 5.854084 #DIV/0!1 5.462565 0.285806 0 0 4.679541 #DIV/0!1 3.581959 0.74974 0 0 4.010101 #DIV/0!1 8.335625 0.614423 0 0 8.181026 #DIV/0!1 6.675957 0.831357 0 0 7.207079 #DIV/0!1 9.001672 0.713784 0 0 9.060399 #DIV/0!1 7.117206 0.450797 0 0 6.649891 #DIV/0!1 0.133122 0.184638 0 0 -0.682828 #DIV/0!1 3.215802 0.707964 0 0 3.548473 #DIV/0!1 3.079089 0.231122 0 0 2.262474 #DIV/0!1 9.724046 0.262301 0 0 8.664321 #DIV/0!1 0.410655 0.88822 0 0 1.487215 #DIV/0!1 2.306309 0.243256 0 0 1.563748 #DIV/0!1 0.166252 0.114382 0 0 -0.926926 #DIV/0!1 6.89724 0.996717 0 0 9.002395 #DIV/0!1 9.476989 0.126343 0 0 7.972087 #DIV/0!1 2.601897 0.740138 0 0 3.052089 #DIV/0!1 7.966651 0.013385 0 0 5.571884 #DIV/0!1 2.798117 0.934242 0 0 4.017642 #DIV/0!1 5.570013 0.440495 0 0 5.156561 #DIV/0!1 5.06627 0.56433 0 0 4.958942 #DIV/0!1 5.648446 0.51182 0 0 5.392734 #DIV/0!1 5.445097 0.723 0 0 5.706262 #DIV/0!1 9.44081 0.101854 0 0 7.823053 #DIV/0!1 7.644941 0.564117 0 0 7.408192 #DIV/0!1 8.015199 0.380123 0 0 7.339374 #DIV/0!1 3.618938 0.484988 0 0 3.404063 #DIV/0!1 6.33593 0.293616 0 0 5.529813 #DIV/0!1 6.236051 0.131415 0 0 4.914939 #DIV/0!1 6.779292 0.881359 0 0 7.505597 #DIV/0!1 6.478263 0.778136 0 0 6.844734 #DIV/0!1 5.527189 0.739007 0 0 5.827976 #DIV/0!1 9.710528 0.029256 0 0 7.519716 #DIV/0!1 2.837761 0.013226 0 0 0.69523 #DIV/0!1 3.296166 0.707398 0 0 3.623334 #DIV/0!1 0.476192 0.106963 0 0 -0.667902 #DIV/0!1 9.587593 0.412064 0 0 8.90789 #DIV/0!1 3.526996 0.036285 0 0 1.732182 #DIV/0!1 4.026718 0.955594 0 0 5.359273 #DIV/0!1 7.252269 0.720363 0 0 7.415994 #DIV/0!1 5.053889 0.650104 0 0 5.148772 #DIV/0!1 9.464381 0.005592 0 0 6.70444 #DIV/0!1 5.09052 0.744909 0 0 5.429606 #DIV/0!1 7.799562 0.917786 0 0 8.66281 #DIV/0!1 6.367047 0.232635 0 0 5.390504 #DIV/0!1 7.227475 0.516078 0 0 6.902439 #DIV/0!1 1.691526 0.412062 0 0 1.406621 #DIV/0!1 9.814805 0.982143 0 0 11.21712 #DIV/0!1 0.759264 0.309886 0 0 0.274056 #DIV/0!

Page 14: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 9.65839 0.552984 0 0 9.295539 #DIV/0!1 4.007223 0.762919 0 0 4.452005 #DIV/0!1 1.173821 0.817643 0 0 1.932166 #DIV/0!1 0.16646 0.74564 0 0 0.753803 #DIV/0!1 2.979025 0.015902 0 0 0.894925 #DIV/0!1 4.398271 0.220548 0 0 3.483979 #DIV/0!1 5.322656 0.618683 0 0 5.328763 #DIV/0!1 9.22413 0.085079 0 0 7.526496 #DIV/0!1 7.539615 0.612102 0 0 7.419351 #DIV/0!1 3.948542 0.61566 0 0 4.016214 #DIV/0!1 8.046946 0.685731 0 0 8.080676 #DIV/0!1 6.898597 0.020031 0 0 4.703027 #DIV/0!1 5.103119 0.681835 0 0 5.274171 #DIV/0!1 6.520334 0.387132 0 0 5.935798 #DIV/0!1 9.601642 0.160189 0 0 8.225867 #DIV/0!1 2.783067 0.800332 0 0 3.40361 #DIV/0!1 2.362167 0.969234 0 0 3.929336 #DIV/0!1 7.131635 0.225292 0 0 6.095009 #DIV/0!1 4.226511 0.772129 0 0 4.687509 #DIV/0!1 9.428272 0.990902 0 0 11.0856 #DIV/0!1 1.553378 0.217198 0 0 0.771101 #DIV/0!1 0.975447 0.33207 0 0 0.535288 #DIV/0!1 6.358998 0.639344 0 0 6.362577 #DIV/0!1 1.687566 0.634632 0 0 1.913398 #DIV/0!1 4.228831 0.65707 0 0 4.381982 #DIV/0!1 1.839296 0.709965 0 0 2.246053 #DIV/0!1 2.181504 0.854677 0 0 3.02493 #DIV/0!1 1.36813 0.338256 0 0 0.923638 #DIV/0!1 1.147757 0.289829 0 0 0.591104 #DIV/0!1 3.39932 0.068422 0 0 1.888404 #DIV/0!1 4.145198 0.042701 0 0 2.3874 #DIV/0!1 7.446361 0.90201 0 0 8.239619 #DIV/0!1 8.277249 0.333257 0 0 7.474945 #DIV/0!1 4.660473 0.367818 0 0 4.123107 #DIV/0!1 8.71255 0.068067 0 0 6.933545 #DIV/0!1 3.068218 0.108845 0 0 1.803673 #DIV/0!1 9.27182 0.314801 0 0 8.373501 #DIV/0!1 4.357611 0.031065 0 0 2.458308 #DIV/0!1 0.981626 0.148155 0 0 -0.008846 #DIV/0!1 7.050312 0.633101 0 0 7.004338 #DIV/0!1 1.056874 0.49691 0 0 0.997049 #DIV/0!1 2.596062 0.365036 0 0 2.155254 #DIV/0!1 5.976955 0.463176 0 0 5.594787 #DIV/0!1 0.221712 0.8117 0 0 1.007612 #DIV/0!1 4.893586 0.673981 0 0 5.055372 #DIV/0!1 1.857273 0.810978 0 0 2.558988 #DIV/0!1 6.80034 0.702344 0 0 6.939098 #DIV/0!1 2.968576 0.984652 0 0 4.76804 #DIV/0!1 0.598933 0.840292 0 0 1.466461 #DIV/0!1 9.498083 0.798243 0 0 9.776164 #DIV/0!1 5.408345 0.758093 0 0 5.769064 #DIV/0!

Page 15: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 7.849772 0.708151 0 0 7.951235 #DIV/0!1 4.06388 0.133836 0 0 2.861553 #DIV/0!1 4.224368 0.074329 0 0 2.711285 #DIV/0!1 3.330929 0.977408 0 0 4.969801 #DIV/0!1 1.474082 0.959787 0 0 2.976197 #DIV/0!1 5.834582 0.384965 0 0 5.279226 #DIV/0!1 8.183394 0.774704 0 0 8.454258 #DIV/0!1 2.765825 0.407195 0 0 2.415918 #DIV/0!1 1.296092 0.709697 0 0 1.729305 #DIV/0!1 9.917636 0.095514 0 0 8.24315 #DIV/0!1 2.45442 0.458913 0 0 2.238701 #DIV/0!1 5.040022 0.409638 0 0 4.582076 #DIV/0!1 1.978393 0.84343 0 0 2.788662 #DIV/0!1 1.830675 0.880762 0 0 2.801702 #DIV/0!1 5.337051 0.663952 0 0 5.451733 #DIV/0!1 7.862517 0.017826 0 0 5.575681 #DIV/0!1 8.649624 0.217534 0 0 7.513566 #DIV/0!1 3.053975 0.907047 0 0 4.093622 #DIV/0!1 5.167826 0.091894 0 0 3.711329 #DIV/0!1 5.75693 0.912477 0 0 6.691514 #DIV/0!1 4.021446 0.093595 0 0 2.6315 #DIV/0!1 9.564042 0.772459 0 0 9.759149 #DIV/0!1 1.860729 0.310901 0 0 1.323041 #DIV/0!1 5.773395 0.195407 0 0 4.711204 #DIV/0!1 1.235544 0.264877 0 0 0.60735 #DIV/0!1 8.089029 0.442582 0 0 7.554394 #DIV/0!1 2.95396 0.410811 0 0 2.603035 #DIV/0!1 6.559981 0.214976 0 0 5.520539 #DIV/0!1 1.14789 0.989164 0 0 3.160148 #DIV/0!1 4.872031 0.702333 0 0 5.107177 #DIV/0!1 6.337358 0.837988 0 0 6.909457 #DIV/0!1 1.683476 0.827622 0 0 2.450941 #DIV/0!1 2.421897 0.891893 0 0 3.415512 #DIV/0!1 7.515795 0.390399 0 0 6.889167 #DIV/0!1 2.082725 0.06538 0 0 0.616494 #DIV/0!1 3.364822 0.56485 0 0 3.343757 #DIV/0!1 1.467391 0.913835 0 0 2.624193 #DIV/0!1 9.673377 0.545886 0 0 9.293615 #DIV/0!1 7.829371 0.216004 0 0 6.729629 #DIV/0!1 3.22949 0.780362 0 0 3.765164 #DIV/0!1 0.734275 0.422372 0 0 0.521045 #DIV/0!1 6.070179 0.019715 0 0 3.9101 #DIV/0!1 1.804157 0.395549 0 0 1.475184 #DIV/0!1 4.033492 0.024797 0 0 2.061986 #DIV/0!1 2.461651 0.938312 0 0 3.727391 #DIV/0!1 0.862153 0.239066 0 0 0.179681 #DIV/0!1 0.746366 0.636718 0 0 1.024263 #DIV/0!1 5.942751 0.824901 0 0 6.487695 #DIV/0!1 7.573569 0.158782 0 0 6.293975 #DIV/0!1 7.498973 0.929652 0 0 8.451953 #DIV/0!1 8.994063 0.610292 0 0 8.79682 #DIV/0!

Page 16: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 0.49272 0.853926 0 0 1.417624 #DIV/0!1 2.819309 0.24567 0 0 2.058028 #DIV/0!1 3.366023 0.650375 0 0 3.545958 #DIV/0!1 7.200484 0.27582 0 0 6.30386 #DIV/0!1 1.795484 0.42543 0 0 1.536231 #DIV/0!1 4.415351 0.511345 0 0 4.220219 #DIV/0!1 4.035086 0.199719 0 0 3.073798 #DIV/0!1 7.331412 0.724572 0 0 7.502498 #DIV/0!1 4.880381 0.034338 0 0 2.99535 #DIV/0!1 1.414412 0.411494 0 0 1.142048 #DIV/0!1 2.882776 0.140376 0 0 1.766372 #DIV/0!1 1.773735 0.206224 0 0 0.946276 #DIV/0!1 4.353286 0.520882 0 0 4.182824 #DIV/0!1 1.98577 0.884554 0 0 2.9664 #DIV/0!1 2.772596 0.557743 0 0 2.764893 #DIV/0!1 7.625793 0.188006 0 0 6.446533 #DIV/0!1 3.341714 0.30298 0 0 2.709648 #DIV/0!1 6.682075 0.51627 0 0 6.384743 #DIV/0!1 4.729531 0.552031 0 0 4.610951 #DIV/0!1 1.390896 0.092809 0 0 0.128225 #DIV/0!1 0.256541 0.247137 0 0 -0.372409 #DIV/0!1 2.119241 0.360607 0 0 1.691632 #DIV/0!1 0.167488 0.40485 0 0 -0.057952 #DIV/0!1 3.789943 0.158951 0 0 2.700159 #DIV/0!1 3.728563 0.369026 0 0 3.240681 #DIV/0!1 4.411116 0.298541 0 0 3.714085 #DIV/0!1 0.383189 0.937091 0 0 1.743878 #DIV/0!1 3.621776 0.579591 0 0 3.621728 #DIV/0!1 8.209353 0.724453 0 0 8.336222 #DIV/0!1 0.268692 0.160575 0 0 -0.639008 #DIV/0!1 1.02845 0.886838 0 0 2.067603 #DIV/0!1 1.689099 0.772707 0 0 2.278695 #DIV/0!1 6.915027 0.578039 0 0 6.746741 #DIV/0!1 7.155136 0.178498 0 0 5.967106 #DIV/0!1 4.87223 0.229966 0 0 3.96253 #DIV/0!1 7.39916 0.708792 0 0 7.524838 #DIV/0!1 6.14994 0.92895 0 0 7.165697 #DIV/0!1 5.142756 0.588295 0 0 5.086772 #DIV/0!1 4.920688 0.070642 0 0 3.348689 #DIV/0!1 1.134491 0.862323 0 0 2.061013 #DIV/0!1 1.846351 0.138986 0 0 0.776132 #DIV/0!1 3.339953 0.378084 0 0 2.893058 #DIV/0!1 7.376986 0.555688 0 0 7.134372 #DIV/0!1 6.718058 0.920761 0 0 7.653301 #DIV/0!1 9.67243 0.503484 0 0 9.196681 #DIV/0!1 0.07975 0.128046 0 0 -0.947923 #DIV/0!1 7.293327 0.704082 0 0 7.411964 #DIV/0!1 7.071136 0.667045 0 0 7.10677 #DIV/0!1 4.095774 0.638328 0 0 4.210071 #DIV/0!1 4.575262 0.333643 0 0 3.959014 #DIV/0!1 9.062729 0.83592 0 0 9.490994 #DIV/0!

Page 17: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 0.986905 0.969687 0 0 2.628762 #DIV/0!1 4.65009 0.941173 0 0 5.827982 #DIV/0!1 6.347238 0.402069 0 0 5.806336 #DIV/0!1 3.208357 0.388458 0 0 2.792541 #DIV/0!1 2.094329 0.335809 0 0 1.607489 #DIV/0!1 0.441781 0.187395 0 0 -0.380322 #DIV/0!1 8.007517 0.84553 0 0 8.524256 #DIV/0!1 5.422489 0.662297 0 0 5.528813 #DIV/0!1 2.992138 0.482682 0 0 2.80339 #DIV/0!1 3.977031 0.192168 0 0 2.994031 #DIV/0!1 6.066494 0.837801 0 0 6.65145 #DIV/0!1 7.827729 0.533297 0 0 7.511663 #DIV/0!1 2.05315 0.712048 0 0 2.45471 #DIV/0!1 2.940907 0.008727 0 0 0.651267 #DIV/0!1 7.313353 0.158519 0 0 6.045789 #DIV/0!1 2.778126 0.398785 0 0 2.40802 #DIV/0!1 1.403206 0.522936 0 0 1.384896 #DIV/0!1 9.698219 0.685703 0 0 9.649315 #DIV/0!1 1.197096 0.758382 0 0 1.76921 #DIV/0!1 2.508989 0.653751 0 0 2.74001 #DIV/0!1 5.505583 0.333699 0 0 4.842958 #DIV/0!1 8.64335 0.726486 0 0 8.754015 #DIV/0!1 3.751858 0.24814 0 0 2.951003 #DIV/0!1 1.041847 0.847485 0 0 1.914312 #DIV/0!1 2.871951 0.324919 0 0 2.319136 #DIV/0!1 4.053947 0.040834 0 0 2.281854 #DIV/0!1 4.395515 0.626777 0 0 4.467185 #DIV/0!1 9.880467 0.583775 0 0 9.577141 #DIV/0!1 9.077974 0.502882 0 0 8.630588 #DIV/0!1 8.088282 0.561816 0 0 7.824101 #DIV/0!1 1.866192 0.659252 0 0 2.142832 #DIV/0!1 1.276517 0.093524 0 0 0.023431 #DIV/0!1 0.927648 0.679052 0 0 1.300455 #DIV/0!1 7.625849 0.368992 0 0 6.94302 #DIV/0!1 8.136565 0.538217 0 0 7.816218 #DIV/0!1 8.199572 0.937396 0 0 9.171667 #DIV/0!1 6.881764 0.644923 0 0 6.872676 #DIV/0!1 2.244401 0.740452 0 0 2.713341 #DIV/0!1 4.649867 0.497637 0 0 4.412035 #DIV/0!1 6.972658 0.678128 0 0 7.040891 #DIV/0!1 9.730073 0.68612 0 0 9.680635 #DIV/0!1 9.070687 0.843636 0 0 9.527117 #DIV/0!1 9.041319 0.608177 0 0 8.836747 #DIV/0!1 3.086729 0.337696 0 0 2.554929 #DIV/0!1 6.580166 0.641405 0 0 6.577656 #DIV/0!1 2.974537 0.20481 0 0 2.08256 #DIV/0!1 2.504638 0.281099 0 0 1.856981 #DIV/0!1 8.636596 0.996781 0 0 10.66071 #DIV/0!1 2.509657 0.398054 0 0 2.151267 #DIV/0!1 2.000706 0.629199 0 0 2.197887 #DIV/0!1 3.345968 0.898375 0 0 4.32555 #DIV/0!

Page 18: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 7.787584 0.39803 0 0 7.165243 #DIV/0!1 5.814864 0.439115 0 0 5.386016 #DIV/0!1 6.473413 0.097805 0 0 4.983202 #DIV/0!1 0.005357 0.58337 0 0 0.194852 #DIV/0!1 2.621522 0.25218 0 0 1.888637 #DIV/0!1 4.103519 0.911515 0 0 5.115347 #DIV/0!1 3.799904 0.707524 0 0 4.102215 #DIV/0!1 2.743288 0.191586 0 0 1.820053 #DIV/0!1 2.964047 0.36654 0 0 2.508442 #DIV/0!1 5.136 0.497325 0 0 4.873157 #DIV/0!1 4.890091 0.463783 0 0 4.563643 #DIV/0!1 8.067458 0.90664 0 0 8.854228 #DIV/0!1 2.076377 0.245209 0 0 1.350921 #DIV/0!1 2.56079 0.356534 0 0 2.101274 #DIV/0!1 7.866795 0.592571 0 0 7.684526 #DIV/0!1 8.083242 0.63652 0 0 7.99382 #DIV/0!1 5.388799 0.222052 0 0 4.429542 #DIV/0!1 6.692882 0.771044 0 0 7.02733 #DIV/0!1 8.893142 0.718432 0 0 8.969658 #DIV/0!1 1.261951 0.135653 0 0 0.207271 #DIV/0!1 7.779793 0.282414 0 0 6.871887 #DIV/0!1 6.059013 0.713512 0 0 6.264152 #DIV/0!1 2.119702 0.030942 0 0 0.330711 #DIV/0!1 5.971246 0.542842 0 0 5.76967 #DIV/0!1 9.517505 0.102323 0 0 7.898286 #DIV/0!1 4.46517 0.304261 0 0 3.780234 #DIV/0!1 3.341785 0.129123 0 0 2.155635 #DIV/0!1 9.236209 0.950433 0 0 10.26085 #DIV/0!1 6.697925 0.282641 0 0 5.844718 #DIV/0!1 3.548205 0.378698 0 0 3.092354 #DIV/0!1 8.632514 0.939183 0 0 9.596192 #DIV/0!1 7.60966 0.179599 0 0 6.402699 #DIV/0!1 8.535382 0.493687 0 0 8.094349 #DIV/0!1 5.530214 0.600677 0 0 5.483648 #DIV/0!1 3.443894 0.407002 0 0 3.059634 #DIV/0!1 1.913059 0.941703 0 0 3.231894 #DIV/0!1 9.309979 0.059078 0 0 7.436006 #DIV/0!1 2.733706 0.430589 0 0 2.439391 #DIV/0!1 7.333118 0.956017 0 0 8.50443 #DIV/0!1 5.425787 0.148755 0 0 4.215441 #DIV/0!1 7.695631 0.347527 0 0 6.957499 #DIV/0!1 7.914246 0.940754 0 0 8.925719 #DIV/0!1 8.418412 0.82302 0 0 8.833021 #DIV/0!1 9.152004 0.877821 0 0 9.743764 #DIV/0!1 6.964762 0.749824 0 0 7.224003 #DIV/0!1 0.863374 0.572093 0 0 0.983993 #DIV/0!1 7.720289 0.194726 0 0 6.558531 #DIV/0!1 2.339294 0.109254 0 0 1.113166 #DIV/0!1 5.513618 0.796192 0 0 5.984373 #DIV/0!1 2.399525 0.803713 0 0 3.050196 #DIV/0!1 4.003976 0.632683 0 0 4.10932 #DIV/0!

Page 19: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 7.119827 0.619057 0 0 7.036962 #DIV/0!1 2.640515 0.435908 0 0 2.363048 #DIV/0!1 9.620808 0.126989 0 0 8.111517 #DIV/0!1 1.722674 0.540615 0 0 1.728467 #DIV/0!1 3.315376 0.028567 0 0 1.434914 #DIV/0!1 3.089573 0.399551 0 0 2.705683 #DIV/0!1 1.497622 0.579199 0 0 1.602878 #DIV/0!1 5.309011 0.454004 0 0 4.939405 #DIV/0!1 1.128566 0.443694 0 0 0.944492 #DIV/0!1 7.144119 0.283635 0 0 6.271249 #DIV/0!1 7.415332 0.84594 0 0 7.963237 #DIV/0!1 6.65037 0.291937 0 0 5.82413 #DIV/0!1 8.282695 0.371667 0 0 7.573408 #DIV/0!1 7.123127 0.779561 0 0 7.461679 #DIV/0!1 0.490964 0.521659 0 0 0.515378 #DIV/0!1 2.721746 0.518515 0 0 2.627506 #DIV/0!1 6.292987 0.714099 0 0 6.487981 #DIV/0!1 2.713026 0.829465 0 0 3.435545 #DIV/0!1 5.211009 0.238491 0 0 4.309422 #DIV/0!1 4.060157 0.453595 0 0 3.752062 #DIV/0!1 4.800287 0.123333 0 0 3.516027 #DIV/0!1 4.901521 0.975863 0 0 6.436646 #DIV/0!1 6.845702 0.163984 0 0 5.621667 #DIV/0!1 6.237095 0.503655 0 0 5.933498 #DIV/0!1 8.724843 0.301072 0 0 7.818689 #DIV/0!1 8.025547 0.318456 0 0 7.198796 #DIV/0!1 5.54176 0.331328 0 0 4.871442 #DIV/0!1 0.58805 0.453199 0 0 0.45266 #DIV/0!1 9.437586 0.54432 0 0 9.066053 #DIV/0!1 2.382815 0.210052 0 0 1.536939 #DIV/0!1 8.526402 0.18712 0 0 7.299147 #DIV/0!1 1.022342 0.884068 0 0 2.048898 #DIV/0!1 3.237666 0.455469 0 0 2.974957 #DIV/0!1 3.979754 0.820053 0 0 4.606049 #DIV/0!1 9.221682 0.361322 0 0 8.440671 #DIV/0!1 2.455221 0.833679 0 0 3.205731 #DIV/0!1 8.766683 0.811958 0 0 9.126198 #DIV/0!1 2.341102 0.050627 0 0 0.746849 #DIV/0!1 8.260251 0.393393 0 0 7.603426 #DIV/0!1 8.243336 0.81722 0 0 8.646766 #DIV/0!1 2.181901 0.545434 0 0 2.175685 #DIV/0!1 9.919588 0.763864 0 0 10.07152 #DIV/0!1 1.638455 0.107609 0 0 0.439401 #DIV/0!1 8.980466 0.126054 0 0 7.499131 #DIV/0!1 5.954626 0.007298 0 0 3.455471 #DIV/0!1 4.833152 0.285667 0 0 4.081228 #DIV/0!1 2.167989 0.383594 0 0 1.79273 #DIV/0!1 7.453297 0.866188 0 0 8.079868 #DIV/0!1 4.075156 0.406938 0 0 3.659186 #DIV/0!1 5.712853 0.873001 0 0 6.455415 #DIV/0!1 2.251568 0.170266 0 0 1.279864 #DIV/0!

Page 20: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 1.518402 0.206662 0 0 0.705093 #DIV/0!1 8.394371 0.237181 0 0 7.3298 #DIV/0!1 1.792588 0.818323 0 0 2.522315 #DIV/0!1 3.65387 0.171268 0 0 2.615611 #DIV/0!1 3.34881 0.65272 0 0 3.535321 #DIV/0!1 8.649684 0.567329 0 0 8.370056 #DIV/0!1 6.260853 0.598915 0 0 6.173644 #DIV/0!1 1.720931 0.960854 0 0 3.221946 #DIV/0!1 8.281806 0.242486 0 0 7.238251 #DIV/0!1 2.288229 0.889772 0 0 3.278303 #DIV/0!1 4.884584 0.57069 0 0 4.800919 #DIV/0!1 3.329045 0.119054 0 0 2.0992 #DIV/0!1 8.241271 0.240909 0 0 7.195189 #DIV/0!1 2.51539 0.811216 0 0 3.184993 #DIV/0!1 1.948349 0.147441 0 0 0.906752 #DIV/0!1 6.443023 0.108642 0 0 5.008756 #DIV/0!1 3.741197 0.538399 0 0 3.641032 #DIV/0!1 6.998541 0.524042 0 0 6.70297 #DIV/0!1 1.451977 0.329508 0 0 0.981621 #DIV/0!1 2.522285 0.66339 0 0 2.776317 #DIV/0!1 8.873622 0.831001 0 0 9.293585 #DIV/0!1 8.846515 0.729127 0 0 8.954194 #DIV/0!1 6.440166 0.638509 0 0 6.437679 #DIV/0!1 2.709084 0.453965 0 0 2.469384 #DIV/0!1 0.699598 0.758905 0 0 1.298101 #DIV/0!1 9.157194 0.533909 0 0 8.776043 #DIV/0!1 3.753997 0.105581 0 0 2.439225 #DIV/0!1 1.688008 0.546355 0 0 1.708581 #DIV/0!1 2.005764 0.878008 0 0 2.955669 #DIV/0!1 8.762405 0.870937 0 0 9.343601 #DIV/0!1 5.525821 0.484871 0 0 5.215339 #DIV/0!1 3.864721 0.97141 0 0 5.38586 #DIV/0!1 5.285237 0.969852 0 0 6.714343 #DIV/0!1 8.118517 0.595893 0 0 7.931386 #DIV/0!1 6.116741 0.098806 0 0 4.64957 #DIV/0!1 4.760875 0.048315 0 0 3.025254 #DIV/0!1 2.951954 0.192988 0 0 2.022908 #DIV/0!1 1.598307 0.646224 0 0 1.856543 #DIV/0!1 3.874671 0.960061 0 0 5.259624 #DIV/0!1 6.199598 0.894822 0 0 7.018687 #DIV/0!1 6.184449 0.347229 0 0 5.521149 #DIV/0!1 4.650803 0.098008 0 0 3.25278 #DIV/0!1 3.90693 0.805371 0 0 4.487646 #DIV/0!1 6.691476 0.179378 0 0 5.529664 #DIV/0!1 0.753779 0.767146 0 0 1.373634 #DIV/0!1 9.894335 0.263401 0 0 8.829135 #DIV/0!1 1.1196 0.189464 0 0 0.270513 #DIV/0!1 9.442365 0.652708 0 0 9.324169 #DIV/0!1 2.817764 0.822508 0 0 3.510626 #DIV/0!1 8.222027 0.022458 0 0 6.003245 #DIV/0!1 6.854998 0.300099 0 0 6.039817 #DIV/0!

Page 21: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 7.945356 0.644259 0 0 7.88148 #DIV/0!1 3.196455 0.050098 0 0 1.554834 #DIV/0!1 5.71531 0.962843 0 0 7.038225 #DIV/0!1 1.073431 0.355273 0 0 0.685234 #DIV/0!1 8.141952 0.887277 0 0 8.827495 #DIV/0!1 6.970113 0.393595 0 0 6.378268 #DIV/0!1 6.810496 0.636756 0 0 6.785277 #DIV/0!1 4.154555 0.937549 0 0 5.330026 #DIV/0!1 8.540993 0.327007 0 0 7.709948 #DIV/0!1 5.619236 0.584696 0 0 5.531101 #DIV/0!1 9.430738 0.035165 0 0 7.327883 #DIV/0!1 9.792598 0.430525 0 0 9.145191 #DIV/0!1 6.180007 0.607729 0 0 6.117451 #DIV/0!1 5.246598 0.066822 0 0 3.632289 #DIV/0!1 3.94291 0.784313 0 0 4.455013 #DIV/0!1 5.697946 0.058372 0 0 3.999146 #DIV/0!1 1.363348 0.626197 0 0 1.585244 #DIV/0!1 2.546438 0.378242 0 0 2.139594 #DIV/0!1 2.605508 0.814922 0 0 3.28304 #DIV/0!1 0.544102 0.145447 0 0 -0.435115 #DIV/0!1 1.687868 0.311323 0 0 1.159898 #DIV/0!1 2.135732 0.035106 0 0 0.396946 #DIV/0!1 5.241116 0.493602 0 0 4.964604 #DIV/0!1 5.016429 0.163156 0 0 3.880832 #DIV/0!1 7.953283 0.630922 0 0 7.85695 #DIV/0!1 0.098106 0.656215 0 0 0.455698 #DIV/0!1 5.956087 0.460894 0 0 5.569782 #DIV/0!1 1.630957 0.198507 0 0 0.785964 #DIV/0!1 9.013059 0.282213 0 0 8.042955 #DIV/0!1 1.229475 0.416799 0 0 0.978629 #DIV/0!1 4.923713 0.44625 0 0 4.555711 #DIV/0!1 8.649607 0.608602 0 0 8.465619 #DIV/0!1 8.498666 0.320668 0 0 7.653836 #DIV/0!1 1.097754 0.168284 0 0 0.176662 #DIV/0!1 0.528396 0.575746 0 0 0.674162 #DIV/0!1 1.739911 0.60996 0 0 1.904596 #DIV/0!1 9.155164 0.342232 0 0 8.331101 #DIV/0!1 4.598334 0.025574 0 0 2.610505 #DIV/0!1 7.357356 0.739965 0 0 7.569295 #DIV/0!1 4.560945 0.906779 0 0 5.523793 #DIV/0!1 7.569098 0.096189 0 0 6.015615 #DIV/0!1 0.590921 0.159259 0 0 -0.337767 #DIV/0!1 6.467542 0.953098 0 0 7.654585 #DIV/0!1 9.93794 0.608823 0 0 9.690053 #DIV/0!1 7.496225 0.806373 0 0 7.900761 #DIV/0!1 4.07791 0.874112 0 0 4.907047 #DIV/0!1 2.881383 0.327053 0 0 2.333432 #DIV/0!1 8.033775 0.521323 0 0 7.680286 #DIV/0!1 2.523867 0.203732 0 0 1.650996 #DIV/0!1 2.568806 0.723857 0 0 2.976095 #DIV/0!1 2.801095 0.321569 0 0 2.243414 #DIV/0!

Page 22: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

1 1.290488 0.011545 0 0 -0.821947 #DIV/0!1 8.338618 0.557394 0 0 8.051816 #DIV/0!1 2.996419 0.81918 0 0 3.668884 #DIV/0!1 8.745356 0.188033 0 0 7.51021 #DIV/0!1 1.723124 0.436154 0 0 1.492091 #DIV/0!1 8.869691 0.031414 0 0 6.749262 #DIV/0!1 0.123216 0.026012 0 0 -1.634282 #DIV/0!1 8.598693 0.030021 0 0 6.473717 #DIV/0!1 8.423359 0.574332 0 0 8.171125 #DIV/0!1 7.756638 0.689209 0 0 7.81374 #DIV/0!1 6.197116 0.526562 0 0 5.947319 #DIV/0!1 6.384892 0.961599 0 0 7.660702 #DIV/0!1 7.858065 0.56329 0 0 7.608767 #DIV/0!1 4.222285 0.6933 0 0 4.466576 #DIV/0!1 3.713805 0.450143 0 0 3.415171 #DIV/0!1 7.979475 0.919415 0 0 8.843479 #DIV/0!1 2.619293 0.753342 0 0 3.105819 #DIV/0!1 8.31465 0.601424 0 0 8.130606 #DIV/0!1 0.885256 0.025458 0 0 -0.918679 #DIV/0!1 8.958318 0.49232 0 0 8.493048 #DIV/0!1 7.950412 0.569593 0 0 7.710938 #DIV/0!1 4.630001 0.234057 0 0 3.744497 #DIV/0!1 9.086539 0.827234 0 0 9.482483 #DIV/0!1 5.756814 0.766109 0 0 6.123465 #DIV/0!1 0.984628 0.140371 0 0 -0.036888 #DIV/0!1 3.306483 0.314054 0 0 2.704534 #DIV/0!1 1.126333 0.742278 0 0 1.656265 #DIV/0!1 0.420417 0.585753 0 0 0.594666 #DIV/0!1 7.032 0.949042 0 0 8.154745 #DIV/0!1 7.529449 0.528013 0 0 7.216324 #DIV/0!1 2.357713 0.586174 0 0 2.436072 #DIV/0!1 3.14771 0.879419 0 0 4.046829 #DIV/0!1 0.810259 0.780012 0 0 1.465828 #DIV/0!1 1.264469 0.516291 0 0 1.238065 #DIV/0!1 5.586388 0.841947 0 0 6.210702 #DIV/0!1 7.938543 0.31359 0 0 7.103812 #DIV/0!1 1.196984 0.938521 0 0 2.527501 #DIV/0!1 0.362003 0.769597 0 0 1.008695 #DIV/0!1 3.869647 0.85078 0 0 4.613414 #DIV/0!1 7.559109 0.94695 0 0 8.637776 #DIV/0!1 5.573692 0.292873 0 0 4.80374 #DIV/0!1 2.352403 0.6554 0 0 2.595284 #DIV/0!1 8.971191 0.074841 0 0 7.224043 #DIV/0!1 8.898067 0.392733 0 0 8.207802 #DIV/0!1 9.01718 0.314968 0 0 8.132017 #DIV/0!1 0.351372 0.850535 0 0 1.270101 #DIV/0!1 7.248315 0.759523 0 0 7.521168 #DIV/0!1 3.939035 0.181711 0 0 2.922845 #DIV/0!1 0.962912 0.821787 0 0 1.746022 #DIV/0!

1000 4945.126

Page 23: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

4945.126 32706.77

0.003963 -0.000599-0.000599 0.000121

4700.74 0.04057631022.71 0.942375

Average x 4.945126 Av.SampY 5.37882Average y 4.70074 Av.SampX 5.920705

SumXY 7776.953 S samXY 58.47397SumX2 8252.5 SS samX 69.41043 SDx 2.777097SumY2 8148.227 SS samY 62.0609 SDy 2.625958

Compr2 0.899436 0.793747Comp r 0.948386 0.890925 1

Sy.x 1.264922SE slope 0.151828

Page 24: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

Lower Upper-1.305494 2.087483-0.223225 2.690090.849031 3.3027091.904441 3.932174

2.92995 4.5915413.901739 5.3046284.787341 6.1039025.571018 7.00516.273485 7.9875096.926848 9.0190227.552981 10.07776

SampleY 194.3345793.7714328.2491329.9113443.4320415.2493565.3468384.0643418.119438

1.3097#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 25: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 26: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 27: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 28: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 29: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 30: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 31: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 32: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 33: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 34: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 35: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 36: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 37: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 38: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 39: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 40: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 41: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 42: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Page 43: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

10 59.20705

Page 44: €¦ · XLS file · Web view · 2009-02-26SampleX SDx For X randomly distributed between 0 and 10. The error is X-5. variance of X is X2-5 ... 0.55 1.64 1.00 3.00 2.16 2.86 0.28

59.20705 419.9579 For X randomly distributed between 0 and 10.The error is X-5.

0.605036 -0.0853-0.0853 0.014407 Total variance over the interval is:

53.7882 0.390994376.938 0.842438

and the standard deviation of X is 2.886751

variance of X is X2-5

110 ∫0

10( X−5 )2

¿110∫0

10X2−10 X+25

¿110 [X 3

3−5 X2+25 X 10

0 ]¿1

10 [10003

−500+250]¿8 . 3333

√8 .333=