Overview
GAUSSBieżący
Sheet 1: GAUSS
| n= | 37 | {ilosc kulek we wszystkich przedzialach} | |||||||||||||||||||||||||||||||||||||||
| PRZEGRODA | |||||||||||||||||||||||||||||||||||||||||
| Numer serii | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | Suma | |||
| 1 | 1 | 1 | 1 | 1 | 1 | 3 | 2 | 4 | 5 | 5 | 9 | 5 | 5 | 6 | 7 | 9 | 6 | 4 | 1 | 9 | 2 | 1 | 1 | 2 | 1 | 1 | 93 | ||||||||||||||
| 2 | 2 | 1 | 1 | 3 | 5 | 3 | 5 | 6 | 4 | 3 | 6 | 6 | 6 | 9 | 8 | 4 | 4 | 5 | 4 | 1 | 4 | 1 | 1 | 92 | |||||||||||||||||
| 3 | 1 | 1 | 1 | 3 | 1 | 2 | 6 | 1 | 6 | 10 | 7 | 7 | 9 | 8 | 5 | 5 | 6 | 6 | 1 | 1 | 1 | 2 | 1 | 1 | 92 | ||||||||||||||||
| 4 | 1 | 3 | 4 | 2 | 2 | 8 | 5 | 7 | 3 | 3 | 4 | 5 | 11 | 9 | 5 | 2 | 4 | 3 | 4 | 3 | 1 | 1 | 1 | 1 | 1 | 93 | |||||||||||||||
| 5 | 2 | 2 | 1 | 5 | 5 | 2 | 4 | 3 | 6 | 2 | 7 | 7 | 5 | 5 | 5 | 5 | 4 | 3 | 4 | 2 | 4 | 2 | 1 | 1 | 3 | 2 | 92 | ||||||||||||||
| 6 | 2 | 2 | 2 | 2 | 5 | 3 | 4 | 8 | 7 | 3 | 12 | 7 | 5 | 7 | 2 | 3 | 1 | 5 | 3 | 3 | 3 | 2 | 1 | 92 | |||||||||||||||||
| 7 | 2 | 2 | 3 | 4 | 2 | 3 | 2 | 5 | 8 | 3 | 6 | 8 | 7 | 5 | 4 | 4 | 8 | 4 | 3 | 2 | 1 | 3 | 3 | 1 | 93 | ||||||||||||||||
| 8 | 1 | 1 | 2 | 2 | 4 | 2 | 2 | 5 | 6 | 8 | 3 | 4 | 10 | 5 | 6 | 8 | 4 | 4 | 2 | 6 | 1 | 2 | 1 | 1 | 1 | 1 | 92 | ||||||||||||||
| 9 | 1 | 3 | 1 | 3 | 4 | 1 | 1 | 5 | 1 | 4 | 8 | 4 | 6 | 4 | 7 | 11 | 3 | 5 | 6 | 1 | 3 | 2 | 1 | 2 | 3 | 1 | 1 | 92 | |||||||||||||
| 10 | 1 | 1 | 1 | 1 | 3 | 1 | 3 | 6 | 3 | 2 | 8 | 6 | 12 | 7 | 6 | 7 | 1 | 3 | 3 | 5 | 1 | 3 | 3 | 2 | 1 | 1 | 1 | 92 | |||||||||||||
| 11 | 1 | 1 | 2 | 2 | 2 | 3 | 1 | 1 | 6 | 5 | 7 | 8 | 4 | 3 | 9 | 8 | 5 | 4 | 3 | 2 | 4 | 3 | 1 | 3 | 2 | 2 | |||||||||||||||
| 12 | 1 | 2 | 1 | 2 | 3 | 4 | 3 | 3 | 8 | 8 | 6 | 7 | 12 | 5 | 8 | 5 | 1 | 2 | 4 | 3 | 1 | 1 | 1 | 1 | |||||||||||||||||
| Ws= | 886,302020530236 | Ni=f(n) | 7 | 5 | 3 | 6 | 10 | 5 | 19 | 20 | 22 | 32 | 38 | 39 | 54 | 78 | 62 | 75 | 76 | 82 | 90 | 68 | 55 | 45 | 47 | 30 | 35 | 21 | 24 | 17 | 11 | 10 | 9 | 5 | 2 | 4 | 1 | 0 | 0 | 1107 | |
| Ys= | 1,24533770307041 | X_Simp | 4,75 | 5 | 4,25 | 6,25 | 7,75 | 9,75 | 15,75 | 20,25 | 24 | 31 | 36,75 | 42,5 | 56,25 | 68 | 69,25 | 72 | 77,25 | 82,5 | 82,5 | 70,25 | 55,75 | 48 | 42,25 | 35,5 | 30,25 | 25,25 | 21,5 | 17,25 | 12,25 | 10 | 8,25 | 5,25 | 3,25 | 2,75 | 1,5 | 0,25 | 0 | ||
| a= | 0,0002428 | (Ni-Nsr_12)^2 | 126,587907779108 | 175,592424490942 | 232,596941202775 | 150,090166135025 | 68,0811327113572 | 175,592424490942 | 0,560807508105192 | 3,0585491521883 | 14,0540324403545 | 189,031448881186 | 390,017898745684 | 430,515640389767 | 1277,98176505101 | 3569,92756450901 | 1913,96369820368 | 3220,43433957676 | 3334,93208122084 | 4063,91853108534 | 5147,90046423801 | 2474,95014806818 | 1350,4795066951 | 715,502090254266 | 826,497573542432 | 138,035965593019 | 280,524673813435 | 7,5562907962714 | 33,0495157285207 | 1,56532421993898 | 52,5788743554403 | 68,0811327113572 | 85,5833910672741 | 175,592424490942 | 264,099199558692 | 203,094682846859 | 297,601457914609 | 333,103716270526 | 333,103716270526 | 32125,8375020095 | |
| b= | 1,03017500761269 | Ni*n | 7 | 10 | 9 | 24 | 50 | 30 | 133 | 160 | 198 | 320 | 418 | 468 | 702 | 1092 | 930 | 1200 | 1292 | 1476 | 1710 | 1360 | 1155 | 990 | 1081 | 720 | 875 | 546 | 648 | 476 | 319 | 300 | 279 | 160 | 66 | 136 | 35 | 0 | 0 | 19375 | |
| Wn=(N-Ns)^2 | 110,297430574426 | 156,306463998094 | 210,315497421761 | 132,30194728626 | 56,2838804389249 | 156,306463998094 | 2,24323003242077 | 6,23871332058698 | 20,2296798969194 | 210,184512778582 | 420,157412507579 | 462,152895795745 | 1332,08514511824 | 3659,97674403423 | 1980,04901142357 | 3305,99029416973 | 3421,98577745789 | 4159,95867718689 | 5255,92254349222 | 2550,02191115257 | 1406,0806284064 | 756,125795524742 | 870,116762101075 | 156,193546202249 | 306,17096264308 | 12,2341966087532 | 42,2206464732518 | 0,252263456088341 | 42,2793637270911 | 56,2838804389249 | 72,2883971507586 | 156,306463998094 | 240,320014133595 | 182,310980709928 | 272,324530845429 | 306,329047557263 | 306,329047557263 | 32793,1747596187 | |||
| Yn=log(Ni+1) | 0,903089986991943 | 0,778151250383644 | 0,602059991327962 | 0,845098040014257 | 1,04139268515823 | 0,778151250383644 | 1,30102999566398 | 1,32221929473392 | 1,36172783601759 | 1,51851393987789 | 1,5910646070265 | 1,60205999132796 | 1,74036268949424 | 1,89762709129044 | 1,79934054945358 | 1,88081359228079 | 1,88649072517248 | 1,91907809237607 | 1,95904139232109 | 1,83884909073726 | 1,7481880270062 | 1,66275783168157 | 1,68124123737559 | 1,49136169383427 | 1,55630250076729 | 1,34242268082221 | 1,39794000867204 | 1,25527250510331 | 1,07918124604762 | 1,04139268515823 | 1 | 0,778151250383644 | 0,477121254719662 | 0,698970004336019 | 0,301029995663981 | 0 | 0 | 46,0774950136051 | |||
| (Wn-Ws)Yn | -700,80197504888 | -568,04695508999 | -406,984440240507 | -637,20398406909 | -864,374819639726 | -568,04695508999 | -1150,18700436808 | -1163,63668537994 | -1179,3548142453 | -1026,69386051638 | -741,66618758109 | -679,512343093901 | 775,824317639124 | 5263,4002977487 | 1968,02331155721 | 4550,9825941436 | 4783,54388941454 | 6282,40277175089 | 8560,26747321827 | 3059,32980811236 | 908,670738983069 | -216,451537626626 | -27,2113239086859 | -1088,85581095654 | -902,859416162552 | -1173,36847140911 | -1179,97512336913 | -1112,23389820864 | -910,853422461244 | -864,374819639726 | -814,013623379477 | -568,04695508999 | -308,21174541829 | -492,068620155719 | -184,825641057599 | 0 | 0 | 16622,5847693616 | |||
| (Wn-Ws)^2 | 602183,123632484 | 532893,512556671 | 456957,779424284 | 568516,11045192 | 688930,112880639 | 532893,512556671 | 781559,945056459 | 774511,424696784 | 750081,299210071 | 457134,884288308 | 217290,795588596 | 179902,480013034 | 198722,594167443 | 7693271,47180495 | 1196282,48008822 | 5854891,34158847 | 6429692,11514677 | 10716827,9056724 | 19093583,5146906 | 2767963,87445238 | 270169,801205688 | 16945,8495566808 | 261,962590418719 | 533058,38428554 | 336552,04432527 | 763994,560814835 | 712473,366029926 | 785084,172011155 | 712374,245197039 | 688930,112880639 | 662618,179047385 | 532893,512556671 | 417292,752588229 | 495603,384147278 | 376968,357839657 | 336368,649379109 | 336368,649379109 | 68472048,2618018 | |||
| Nsr_1= | 17,5022583559169 | {ze wzoru} | ;numer przedzialu dla którego krzywa przyjmuje wartosc najwieksza | ||||||||||||||||||||||||||||||||||||||
| Nsr_2= | 19 | {odczytane z wykresu} | |||||||||||||||||||||||||||||||||||||||
| Nsr_12= | 18,2511291779584 | ||||||||||||||||||||||||||||||||||||||||
| sigma= | 5,38707992173089 | {ze wzoru} | |||||||||||||||||||||||||||||||||||||||
| sigma_2= | 7 | ||||||||||||||||||||||||||||||||||||||||
| sigma_3= | 29,8976634243751 |
Sheet 2: Bieżący
|
||||||||||
Wyszukiwarka
Podobne podstrony:
1 GAUSSid 9255
więcej podobnych podstron