WorkbookView::show_horizontal_scrollbar TRUE WorkbookView::show_vertical_scrollbar TRUE WorkbookView::show_notebook_tabs TRUE WorkbookView::do_auto_completion TRUE WorkbookView::is_protected FALSE 2024-07-08T16:14:19Z 2011-12-01T11:16:21Z Sheet1 Sheet2 Sheet3 odchylenie Sheet1!$E$2 A1 srednia Sheet1!$C$2 A1 width Sheet1!$K$18 A1 Sheet1 15 1000 1 Print_Area #REF! A1 Sheet_Title "Sheet1" A1 d_then_r portrait iso_a4 300.749550 504.630250 Default 7.086614 top-left fill 0 7.086614 1 7.086614 1 "histogram wzrostu studentów I roku" 1 Linear 1 155 197 7.086614 1 "wzrost studenta (cm)" Linear 1 7.086614 1 "liczba studentów" FALSE FALSE 1 1 FALSE 1 y-origin linear 1 "dane doświadczalne" Sheet1!$L$13:$L$32 Sheet1!$M$13:$M$32 Sheet1!$O$13:$O$32 Sheet1!$O$13:$O$32 y-origin linear 2 "gauss teoretyczny" Sheet1!$L$13:$L$32 Sheet1!$N$13:$N$32 wzrost średnia od.st.poj.p od.st.śred. całkowita niepewność u_x (cm): niepewność pomiaru stadiometrem Delta_x = 0.1 cm (jedna podziałka) =randnorm(175,5) =sum(A2:A1001)/1000 =(A2-srednia)^2 =sqrt(sum(D2:D1001)/(1000-1)) =E2/sqrt(1000) =sqrt(F2*F2+0.10000000000000001*0.10000000000000001/3) <- uwzględniając Delta_x niepewność eksperymentatora Delta_x_E = min. 0.05 cm (minimum pół podziałki) =sqrt(F2*F2+0.10000000000000001*0.10000000000000001/3+0.050000000000000003*0.050000000000000003/3) <- uwzgl. Delta_x oraz Delta_x_E (Gnum) od.st.poj.pom (Gnumeric) - Miara szerokości rozkładu =average(A2:A1001) =stdev(A2:A1001) średni wzrost studenta = C2(G3) cm to co produkuje gnumeric: Histogram górne zakresy binów -1.7976931348623157e+308 Column 1 konwertujemy na liczby: szerokość binu środek binu kopia częstości Gauss teoret. u_y chi^2 (składowe) -1.7976931348623157e+308 159.54610208146266 0 (Ctrl+C, Edit->Paste Special->As Value) (kilka wybranych) 159.54610208146266 161.26325396899671 4 161.26325396899671 =J13-width/2 =I13 =normdist(Sheet1!L13,srednia,odchylenie,0)*999*width =sqrt(M13) =(N13-M13)^2/N13 161.26325396899671 162.98040585653078 5 162.98040585653078 162.98040585653078 164.69755774406482 16 164.69755774406482 164.69755774406482 166.4147096315989 23 166.4147096315989 166.4147096315989 168.13186151913294 31 168.13186151913294 168.13186151913294 169.84901340666698 67 169.84901340666698 =J19-J18 169.84901340666698 171.56616529420106 77 171.56616529420106 171.56616529420106 173.2833171817351 122 173.2833171817351 173.2833171817351 175.00046906926917 135 175.00046906926917 175.00046906926917 176.71762095680322 129 176.71762095680322 176.71762095680322 178.43477284433726 127 178.43477284433726 178.43477284433726 180.15192473187133 91 180.15192473187133 180.15192473187133 181.86907661940538 78 181.86907661940538 181.86907661940538 183.58622850693945 54 183.58622850693945 183.58622850693945 185.30338039447349 19 185.30338039447349 185.30338039447349 187.02053228200754 11 187.02053228200754 187.02053228200754 188.73768416954161 6 188.73768416954161 188.73768416954161 190.45483605707565 4 190.45483605707565 190.45483605707565 192.17198794460973 0 192.17198794460973 192.17198794460973 193.88913983214377 0 193.88913983214377 193.88913983214377 1.7976931348623157e+308 1 liczba stud. =sum(M13:M32) chi^2 = (w histogramie) chi^2/ndf = =P34/17 poz. Ufności =chidist(Sheet1!P34,17) Sheet2 0 0 1 Print_Area #REF! A1 Sheet_Title "Sheet2" A1 d_then_r portrait iso_a4 Sheet3 0 0 1 Print_Area #REF! A1 Sheet_Title "Sheet3" A1 d_then_r portrait iso_a4