WorkbookView::show_horizontal_scrollbar TRUE WorkbookView::show_vertical_scrollbar TRUE WorkbookView::show_notebook_tabs TRUE WorkbookView::do_auto_completion TRUE WorkbookView::is_protected FALSE 2019-11-25T15:18:03Z 2011-12-06T12:21:26Z Sheet1 zal. niepewn. od l. pomiarów Sheet3 width1 Sheet1!$O$5 A1 width2 Sheet1!$O$30 A1 width3 Sheet1!$O$55 A1 Sheet1 29 4999 1 Print_Area #REF! A1 Sheet_Title "Sheet1" A1 d_then_r portrait na_letter 227.245500 333.734400 Default 7.086614 top-left fill 0 7.086614 1 7.086614 1 "Rozkład płaski" 1 Linear 1 7.086614 1 "wygenerowana liczba" Linear 1 100 400 7.086614 1 "częstość" FALSE FALSE 1 1 FALSE 1 y-origin linear 1 Sheet1!$P$4:$P$23 Sheet1!$M$4:$M$23 227.245500 332.260800 Default 7.086614 top-left fill 0 7.086614 1 7.086614 1 "Rozkład Gaussa" 1 Linear 1 7.086614 1 "wygenerowana liczba" Linear 1 7.086614 1 "częstość" FALSE FALSE 1 1 FALSE 1 y-origin linear 1 Sheet1!$P$29:$P$48 Sheet1!$M$29:$M$48 233.239500 332.246400 Default 7.086614 top-left fill 0 7.086614 1 7.086614 1 "Rozkład eksponencjalny exp(-x/b)" 1 Linear 1 7.086614 1 "wygenerowana liczba" Linear 1 7.086614 1 "częstość" FALSE FALSE 1 1 FALSE 1 y-origin linear 1 Sheet1!$P$54:$P$73 Sheet1!$M$54:$M$73 240.760500 472.497750 Default 7.086614 top-left fill 0 7.086614 1 7.086614 1 "Rozkład Poissona (lambda - wart. średnia)" 1 Linear 1 -1 7.086614 1 "wygenerowana liczba" Linear 1 7.086614 1 "częstość" FALSE FALSE 1 1 FALSE 1 y-origin linear 1 Sheet1!$K$85:$K$100 Sheet1!$L$85:$L$100 =rand() =randnorm(175,5) =randpoisson(5) =randuniform(5,10) =randexp(5) Rozkład płaski (kolumna A) -1.7976931348623157e+308 Column 1 górna granica binu (liczba) szerokość binu środek binu -1.7976931348623157e+308 0.00012937255338820965 0 (Ctrl+C, Edit->Paste Special->As Value) 0.00012937255338820965 0.050052293725967305 269 0.050052293725967305 =N4-width1/2 0.050052293725967305 0.099975214898546397 275 0.099975214898546397 =K5-K4 0.099975214898546397 0.14989813607112548 239 0.14989813607112548 0.14989813607112548 0.19982105724370458 264 0.19982105724370458 0.19982105724370458 0.24974397841628368 233 0.24974397841628368 0.24974397841628368 0.29966689958886272 242 0.29966689958886272 0.29966689958886272 0.34958982076144185 265 0.34958982076144185 0.34958982076144185 0.39951274193402092 250 0.39951274193402092 0.39951274193402092 0.44943566310659999 265 0.44943566310659999 0.44943566310659999 0.49935858427917912 218 0.49935858427917912 0.49935858427917912 0.54928150545175825 263 0.54928150545175825 0.54928150545175825 0.59920442662433726 237 0.59920442662433726 0.59920442662433726 0.64912734779691639 249 0.64912734779691639 0.64912734779691639 0.69905026896949551 238 0.69905026896949551 0.69905026896949551 0.74897319014207453 256 0.74897319014207453 0.74897319014207453 0.79889611131465366 250 0.79889611131465366 0.79889611131465366 0.84881903248723278 246 0.84881903248723278 0.84881903248723278 0.8987419536598118 258 0.8987419536598118 0.8987419536598118 0.94866487483239093 258 0.94866487483239093 0.94866487483239093 0.99858779600497005 224 0.99858779600497005 0.99858779600497005 1.7976931348623157e+308 1 Rozkład Gaussa (kolumna C) -1.7976931348623157e+308 Column 1 górna granica binu (liczba) szerokość binu środek binu -1.7976931348623157e+308 157.77547481596292 0 (Ctrl+C, Edit->Paste Special->As Value) 157.77547481596292 159.46017869227811 4 159.46017869227811 =N29-width2/2 159.46017869227811 161.14488256859329 12 161.14488256859329 161.14488256859329 162.82958644490844 17 162.82958644490844 162.82958644490844 164.51429032122363 47 164.51429032122363 164.51429032122363 166.19899419753881 118 166.19899419753881 166.19899419753881 167.88369807385399 178 167.88369807385399 167.88369807385399 169.56840195016918 269 169.56840195016918 169.56840195016918 171.25310582648433 460 171.25310582648433 171.25310582648433 172.93780970279951 575 172.93780970279951 172.93780970279951 174.6225135791147 651 174.6225135791147 174.6225135791147 176.30721745542988 685 176.30721745542988 176.30721745542988 177.99192133174506 585 177.99192133174506 177.99192133174506 179.67662520806022 503 179.67662520806022 179.67662520806022 181.3613290843754 364 181.3613290843754 181.3613290843754 183.04603296069058 253 183.04603296069058 183.04603296069058 184.73073683700576 140 184.73073683700576 184.73073683700576 186.41544071332095 77 186.41544071332095 186.41544071332095 188.1001445896361 39 188.1001445896361 188.1001445896361 189.78484846595128 15 189.78484846595128 189.78484846595128 191.46955234226647 7 191.46955234226647 191.46955234226647 1.7976931348623157e+308 1 Rozkład eksponencjalny (kolumna I) -1.7976931348623157e+308 Column 1 górna granica binu (liczba) szerokość binu środek binu -1.7976931348623157e+308 0.0005401884943912283 0 (Ctrl+C, Edit->Paste Special->As Value) 0.0005401884943912283 2.2181323963527726 1816 2.2181323963527726 =N54-width3/2 2.2181323963527726 4.4357246042111544 1137 4.4357246042111544 4.4357246042111544 6.6533168120695363 718 6.6533168120695363 6.6533168120695363 8.8709090199279164 478 8.8709090199279164 8.8709090199279164 11.088501227786297 304 11.088501227786297 11.088501227786297 13.30609343564468 185 13.30609343564468 13.30609343564468 15.523685643503061 123 15.523685643503061 15.523685643503061 17.741277851361442 83 17.741277851361442 17.741277851361442 19.958870059219823 59 19.958870059219823 19.958870059219823 22.176462267078204 31 22.176462267078204 22.176462267078204 24.394054474936585 20 24.394054474936585 24.394054474936585 26.611646682794969 19 26.611646682794969 26.611646682794969 28.82923889065335 14 28.82923889065335 28.82923889065335 31.046831098511731 4 31.046831098511731 31.046831098511731 33.264423306370112 4 33.264423306370112 33.264423306370112 35.482015514228493 1 35.482015514228493 35.482015514228493 37.699607722086874 2 37.699607722086874 37.699607722086874 39.917199929945255 1 39.917199929945255 39.917199929945255 42.134792137803636 0 42.134792137803636 42.134792137803636 44.352384345662017 0 44.352384345662017 44.352384345662017 1.7976931348623157e+308 1 Rozkład Poissona (kolumna E) min. wygen. liczba =min(E1:E5000) maks. wygen. liczba =max(E1:E5000) (w trakcie robienia histogramu wyszło 15) 0 =frequency(E1:E5000,K85:K100) =K85+1 zal. niepewn. od l. pomiarów 13 9999 1 Print_Area #REF! A1 Sheet_Title "zal. niepewn. od l. pomiarów" A1 d_then_r portrait na_letter 224.999250 315.686800 Default 7.086614 top-left fill 0 7.086614 1 1 Log 1 20000 7.086614 1 "liczba pomiarów" Linear 1 170 180 7.086614 1 "średnia wraz z niepewnością" FALSE FALSE 1 1 FALSE 1 y-origin linear 1 'zal. niepewn. od l. pomiarów'!$L$4:$L$12 'zal. niepewn. od l. pomiarów'!$M$4:$M$12 'zal. niepewn. od l. pomiarów'!$N$4:$N$12 'zal. niepewn. od l. pomiarów'!$N$4:$N$12 Jak niepewność średniej (met. A) zależy od liczby pomiarów: liczba pomiarów: średnia: niepewność średniej: 5 =average(A1:A5) =stdev(A1:A5)/sqrt(5) 10 =average(B1:B10) =stdev(B1:B10)/sqrt(10) 20 =average(C1:C20) =stdev(C1:C20)/sqrt(20) 100 =average(D1:D100) =stdev(D1:D100)/sqrt(100) 500 =average(E1:E500) =stdev(E1:E500)/sqrt(500) 1000 =average(F1:F1000) =stdev(F1:F1000)/sqrt(1000) 2000 =average(G1:G2000) =stdev(G1:G2000)/sqrt(2000) 5000 =average(H1:H5000) =stdev(H1:H5000)/sqrt(5000) 10000 =average(I1:I10000) =stdev(I1:I10000)/sqrt(10000) Sheet3 0 0 1 Print_Area #REF! A1 Sheet_Title "Sheet3" A1 d_then_r portrait na_letter