{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["1. Leíró statisztika","2. Leíró statisztika","3. Leíró statisztika","Rangkorrel.","1. LNM","2. LNM","1. Konf. int","2. Konf. int","Hibaterjedés","1. teszt","2. Teszt","1. Eloszlásos ","2. Eloszlásos"],"not_rendered":{"charts":9,"images":1,"macros":1,"external_links":1,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Leíró statisztika","index":0,"n_rows":93,"n_cols":25,"rows_kept":93,"cut":false,"hidden":false,"merged":[[13,23,13,24]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"darabszám",null,{"$f":"COUNT(data)","v":82}]
[null,"Oktán szám",null,"a)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f)","intervallumok száma",null,{"$f":"ROUND(SQRT(COUNT(data)),0)","v":9}]
[null,88.5,null,"átlag",{"$f":"AVERAGE(data)","v":90.525609756097538},null,null,"e)"]
[null,94.7,null,"tap szór",{"$f":"_xlfn.STDEV.P(data)","v":2.8874332840190289},null,null,"Kvartilisek",null,null,"IQR",{"$f":"I17-I15","v":3.6000000000000085}]
[null,84.3,null,"kor tap sz",{"$f":"_xlfn.STDEV.S(data)","v":2.9052022719410253},null,null,0,{"$f":"QUARTILE(data,H14)","v":83.4},null,null,null,null,null,null,null,null,null,"sorszám","alsó","felső","darab","interval","tap. Sfv."]
[null,90.1,null,null,null,null,null,1,{"$f":"QUARTILE(data,H15)","v":88.6},null,"felfelé","Q3+1,5 IQR",{"$f":"I17+1.5*L13","v":97.600000000000023},"darab",{"$f":"COUNTIF(data,\">\"&M15)","v":2},null,null,null,1,{"$f":"PERCENTILE(data,(S15-1)/$V$11)","v":83.4},{"$f":"PERCENTILE(data,S15/$V$11)","v":87.6},{"$f":"COUNTIF(data,\"<\"&U15)-COUNTIF(data,\"<\"&T15)","v":9},{"$f":"V15/$V$25/(U15-T15)","v":2.6132404181184739E-2},{"$f":"T15","v":83.4},0]
[null,89,null,"b)",null,null,null,2,{"$f":"QUARTILE(data,H16)","v":90.4},null,"extrém felelé","Q3+3 IQR",{"$f":"I17+3*L13","v":103.00000000000003},"darab",{"$f":"COUNTIF(data,\">\"&M16)","v":0},null,null,null,2,87.6,88.5,9,{"$f":"V16/$V$25/(U16-T16)","v":0.12195121951219436},{"$f":"T15","v":83.4},{"$f":"W15","v":2.6132404181184739E-2}]
[null,89.8,null,"medián",{"$f":"MEDIAN(data)","v":90.4},null,null,3,{"$f":"QUARTILE(data,H17)","v":92.2},null,"lefelé","Q1-1,5 IQR",{"$f":"I15-1.5*L13","v":83.199999999999989},"darab",{"$f":"COUNTIF(data,\"<\"&M17)","v":0},null,null,null,3,88.5,89.3,8,0.12195121951219556,{"$f":"U15","v":87.6},{"$f":"W15","v":2.6132404181184739E-2}]
[null,91.6,null,"1. kvartilis",{"$f":"_xlfn.QUARTILE.INC(data,1)","v":88.6},null,null,4,{"$f":"QUARTILE(data,H18)","v":100.3},null,"extrém lefelé","Q1-3 IQR",{"$f":"I15-3*L13","v":77.799999999999969},"darab",{"$f":"COUNTIF(data,\"<\"&M18)","v":0},null,null,null,4,89.3,90.1,9,0.13719512195121999,{"$f":"U15","v":87.6},0]
[null,90.3,null,"3. kvartilis",{"$f":"_xlfn.QUARTILE.INC(data,3)","v":92.2},null,null,null,null,null,null,null,null,null,null,null,null,null,5,90.1,90.8,10,0.17421602787456375,{"$f":"T16","v":87.6},{"$f":"W16","v":0.12195121951219436}]
[null,90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,90.8,91.2,8,0.2439024390243868,{"$f":"U16","v":88.5},{"$f":"W16","v":0.12195121951219436}]
[null,91.5,null,"c)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,91.2,92.3,10,0.11086474501108705,{"$f":"U16","v":88.5},0]
[null,89.9,null,"Átlag ~ medián, tehát szimmetrikus eloszlás",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,92.3,93.4,9,9.9778270509977049E-2,{"$f":"T17","v":88.5},{"$f":"W17","v":0.12195121951219556}]
[null,98.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,93.4,100.3,{"$f":"COUNTIF(data,\"<=\"&U23)-COUNTIF(data,\"<\"&T23)","v":10},1.7674089784376127E-2,{"$f":"U17","v":89.3},{"$f":"W17","v":0.12195121951219556}]
[null,88.3,null,"d)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U17","v":89.3},0]
[null,90.4,null,"x_min",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"szum",{"$f":"SUM(V15:V23)","v":82},null,{"$f":"T18","v":89.3},{"$f":"W18","v":0.13719512195121999}]
[null,91.2,null,"x_max",{"$f":"COUNT(data)","v":82},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U18","v":90.1},{"$f":"W18","v":0.13719512195121999}]
[null,90.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U18","v":90.1},0]
[null,92.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T19","v":90.1},{"$f":"W19","v":0.17421602787456375}]
[null,87.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U19","v":90.8},{"$f":"W19","v":0.17421602787456375}]
[null,91.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U19","v":90.8},0]
[null,86.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T20","v":90.8},{"$f":"W20","v":0.2439024390243868}]
[null,93.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U20","v":91.2},{"$f":"W20","v":0.2439024390243868}]
[null,96.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U20","v":91.2},0]
[null,89.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T21","v":91.2},{"$f":"W21","v":0.11086474501108705}]
[null,90.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U21","v":92.3},{"$f":"W21","v":0.11086474501108705}]
[null,91.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U21","v":92.3},0]
[null,90.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T22","v":92.3},{"$f":"W22","v":9.9778270509977049E-2}]
[null,88.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U22","v":93.4},{"$f":"W22","v":9.9778270509977049E-2}]
[null,88.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U22","v":93.4},0]
[null,94.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T23","v":93.4},{"$f":"W23","v":1.7674089784376127E-2}]
[null,85.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U23","v":100.3},{"$f":"W23","v":1.7674089784376127E-2}]
[null,90.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U23","v":100.3},0]
[null,89.3]
[null,91.1,null,null,null,null,null,null,null,null,null,null,null,null,null,"g)","Szempontok:"]
[null,92.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"intervallumok száma"]
[null,83.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"intervallumok szélessége területe"]
[null,91,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"átlag vs medián"]
[null,88.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kiugró értékek látszana e"]
[null,88.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"stb stb"]
[null,93.3]
[null,87.4]
[null,91.1]
[null,90.5]
[null,100.3]
[null,87.6]
[null,92.7]
[null,87.9]
[null,93]
[null,94.4]
[null,90.4]
[null,91.2]
[null,86.7]
[null,94.2]
[null,90.8]
[null,90.1]
[null,91.8]
[null,88.4]
[null,92.6]
[null,93.7]
[null,96.5]
[null,84.3]
[null,93.2]
[null,88.6]
[null,88.7]
[null,92.7]
[null,89.3]
[null,91]
[null,87.5]
[null,87.8]
[null,88.3]
[null,89.2]
[null,92.3]
[null,88.9]
[null,89.8]
[null,92.7]
[null,93.3]
[null,86.7]
[null,91]
[null,90.9]
[null,89.9]
[null,91.8]
[null,89.7]
[null,92.2]

{"sheet":"2. Leíró statisztika","index":1,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"c)","Adatsorok a kiugró adatok nélkül"]
[null,"Nem permetezett felhők","Permetezett felhők",null,null,null,null,null,null,null,null,null,null,"Nem permetezett felhők","Permetezett felhők"]
[null,81.2,274.7,null,null,"a)","1. adatsor","2. adatsor",null,null,null,null,null,81.2,274.7]
[null,26.1,302.8,null,null,"átlag",{"$f":"AVERAGE(data1)","v":164.58846153846159},{"$f":"AVERAGE(data2)","v":441.98461538461549},null,null,null,null,null,26.1,302.8]
[null,95,242.5,null,null,"kor tap szórás",{"$f":"STDEV(data1)","v":278.4264043899903},{"$f":"STDEV(data2)","v":650.78717116569385},null,null,null,null,null,95,242.5]
[null,41.1,255,null,null,"medián",{"$f":"MEDIAN(data1)","v":44.2},{"$f":"MEDIAN(data2)","v":221.6},null,null,null,null,null,41.1,255]
[null,28.6,17.5,null,null,null,null,null,null,null,null,null,null,28.6,17.5]
[null,21.7,115.3,null,null,"b)","nem permetezett",null,null,"permetezett",null,null,null,21.7,115.3]
[null,11.5,31.4,null,null,null,"sorszám","kvartilis",null,"sorszám","kvartilis",null,null,11.5,31.4]
[null,68.5,703.4,null,null,null,0,{"$f":"QUARTILE(data1,G22)","v":1},null,0,{"$f":"QUARTILE(data2,J22)","v":4.0999999999999996},null,null,68.5,703.4]
[null,345.5,334.1,null,null,null,1,{"$f":"QUARTILE(data1,G23)","v":24.824999999999999},null,1,{"$f":"QUARTILE(data2,J23)","v":98.125},null,null,345.5,334.1]
[null,321.2,1697.8,null,null,null,2,{"$f":"QUARTILE(data1,G24)","v":44.2},null,2,{"$f":"QUARTILE(data2,J24)","v":221.6},null,null,321.2,118.3]
[null,1202.5999999999999,118.3,null,null,null,3,{"$f":"QUARTILE(data1,G25)","v":159.19999999999999},null,3,{"$f":"QUARTILE(data2,J25)","v":406.02499999999998},null,null,1,198.6]
[null,1,198.6,null,null,null,4,{"$f":"QUARTILE(data1,G26)","v":1202.5999999999999},null,4,{"$f":"QUARTILE(data2,J26)","v":2745.6},null,null,4.9000000000000004,129.6]
[null,4.9000000000000004,129.6,null,null,null,null,null,null,null,null,null,null,163,274.7]
[null,163,274.7,null,null,null,"IQR",{"$f":"H25-H23","v":134.375},null,null,{"$f":"K25-K23","v":307.89999999999998},null,null,244.3,119,null,null,"nem permetezett",null,null,"permetezett"]
[null,372.4,119,null,null,"lefelé kiugró nincs az ábra alapján",null,null,null,null,null,null,null,47.3,7.7,null,null,"sorszám","kvartilis",null,"sorszám","kvartilis"]
[null,244.3,1656,null,null,"felfelé kiugró határ",null,{"$f":"H25+1.5*H28","v":360.76249999999999},null,null,{"$f":"K25+1.5*K28","v":867.875},null,null,87,430,null,null,0,{"$f":"QUARTILE(data4,R30)","v":1},null,0,{"$f":"QUARTILE(data5,U30)","v":4.0999999999999996}]
[null,47.3,7.7,null,null,null,"db",{"$f":"COUNTIF(data1,\">\"&H30)","v":3},null,null,{"$f":"COUNTIF(data2,\">\"&K30)","v":4},null,null,26.3,40.6,null,null,1,{"$f":"QUARTILE(data4,R31)","v":23.049999999999997},null,1,{"$f":"QUARTILE(data5,U31)","v":53.550000000000004}]
[null,87,430,null,null,"extrém felfelé határ",null,{"$f":"H25+3*H28","v":562.32500000000005},null,null,{"$f":"K25+3*K28","v":1329.7249999999999},null,null,24.4,92.4,null,null,2,{"$f":"QUARTILE(data4,R32)","v":36.6},null,2,{"$f":"QUARTILE(data5,U32)","v":164.1}]
[null,26.3,40.6,null,null,null,null,{"$f":"COUNTIF(data1,\">\"&H32)","v":2},null,null,{"$f":"COUNTIF(data2,\">\"&K32)","v":3},null,null,4.9000000000000004,200.7,null,null,3,{"$f":"QUARTILE(data4,R33)","v":91},null,3,{"$f":"QUARTILE(data5,U33)","v":274.7}]
[null,24.4,92.4,null,null,null,null,null,null,null,null,null,null,36.6,32.700000000000003,null,null,4,{"$f":"QUARTILE(data4,R34)","v":345.5},null,4,{"$f":"QUARTILE(data5,U34)","v":703.4}]
[null,830.1,200.7,null,null,null,null,null,null,null,null,null,null,147.80000000000001,4.0999999999999996]
[null,4.9000000000000004,32.700000000000003,null,null,null,null,null,null,null,null,null,null,17.3,489.1,null,null,"IQR",{"$f":"S33-S31","v":67.95},null,null,{"$f":"V33-V31","v":221.14999999999998}]
[null,36.6,4.0999999999999996,null,null,null,null,null,null,null,null,null,null,29,null,null,"lefelé kiugró nincs az ábra alapján"]
[null,147.80000000000001,978,null,null,null,null,null,null,null,null,null,null,null,null,null,"felfelé kiugró határ",null,{"$f":"S33+1.5*S36","v":192.92500000000001},null,null,{"$f":"V33+1.5*V36","v":606.42499999999995}]
[null,17.3,489.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"db",{"$f":"COUNTIF(data4,\">\"&S38)","v":3},null,null,{"$f":"COUNTIF(data5,\">\"&V38)","v":1}]
[null,29,2745.6,null,null,null,null,null,null,null,null,null,null,null,null,null,"extrém felfelé határ",null,{"$f":"S33+3*S36","v":294.85000000000002},null,null,{"$f":"V33+3*V36","v":938.14999999999986}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(data4,\">\"&S40)","v":2},null,null,{"$f":"COUNTIF(data5,\">\"&V40)","v":0}]

{"sheet":"3. Leíró statisztika","index":2,"n_rows":69,"n_cols":21,"rows_kept":69,"cut":false,"hidden":false,"merged":[[10,16,10,17],[9,12,9,15],[9,16,9,17],[8,12,8,15],[10,12,10,15],[8,16,8,17],[1,17,1,19],[2,12,2,14],[6,12,6,15],[6,16,6,17],[7,12,7,15],[7,16,7,17],[3,12,3,15],[3,16,3,17],[5,12,5,15],[5,16,5,17],[4,12,4,15],[4,16,4,17]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pontozás (a javító tölti ki):",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"A számításai alapján töltse ki!"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Átlag (1p)",null,null,null,{"$f":"AVERAGE(C13:C69)","v":815.41961403508742}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Korrigált tapasztalati szórás (1p)",null,null,null,{"$f":"_xlfn.STDEV.S(C13:C69)","v":199.77382366403535}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Medián (1p)",null,null,null,{"$f":"MEDIAN(C13:C69)","v":793.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hisztogram segítségével (3p)",null,null,null,{"$f":"Q13","v":0.25256785125206183},null,{"$f":"Q7*COUNT($C$13:$C$69)","v":14.396367521367525}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pontosan (3p)",null,null,null,{"$f":"Q14","v":0.24561403508771928},null,{"$f":"Q8*COUNT($C$13:$C$69)","v":14}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mivel vizsgálja a kapcsolatot? (2p)",null,null,null,"korrelációs eh."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mekkora kiszámolt érték? (2p)",null,null,null,{"$f":"CORREL(C13:C69,D13:D69)","v":-0.32418837552045315}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Van-e lineáris kapcsolat? (2p)",null,null,null,"nincs"]
[null,"Év sorszáma","Levélpostai küldemény millió db.","Gazdaságilag aktív népesség száma \nezer fő",null,"Intervallum sorszáma","alsó határ","felső határ","gyakoriság","hisztogram magasság"]
[null,1,552.1,4735,null,1,495.4,616,7,1.0191453738079639E-3,null,null,"alsó",850,null,"hisztogramból",{"$f":"((H17-N13)*J17+(H18-G18)*J18+(N14-G19)*J19)","v":0.25256785125206183}]
[null,2,558.70000000000005,4626,null,2,616,693,7,1.5990497076023376E-3,null,null,"felső",1000,null,"pontosan",{"$f":"(COUNTIF(C13:C69,\"<\"&N14)-COUNTIF(C13:C69,\"<\"&N13))/COUNT(C13:C69)","v":0.24561403508771928}]
[null,3,495.4,4544,null,3,693,745,7,2.3662238447757166E-3]
[null,4,529,4569,null,4,745,794,7,2.5062656641604009E-3]
[null,5,505.4,4653,null,5,794,857,7,1.9493177387914229E-3]
[null,6,559.5,4649,null,6,857,882,7,4.9122807017543853E-3]
[null,7,586.1,4666,null,7,882,1006,7,9.8403058929374758E-4]
[null,8,615.9,4710,null,8,1006,1302,8,4.7479999050400014E-4]
[null,9,632.79999999999995,4802]
[null,10,638.20000000000005,4979]
[null,11,664.2,5127]
[null,12,709,5440]
[null,13,744.3,5491]
[null,14,756.1,5531]
[null,15,772.2,5563]
[null,16,793.6,5634]
[null,17,823.5,5679]
[null,18,875.1,5777]
[null,19,875.6,5742]
[null,20,768.3,5736]
[null,21,743.7,5470]
[null,22,735.7,5447]
[null,23,751,5437]
[null,24,798.2,5413]
[null,25,831,5392]
[null,26,872.3,5373]
[null,27,870.4,5361]
[null,28,744.6,5371]
[null,29,729.1,5284]
[null,30,781.4,5216]
[null,31,885.1,5108]
[null,32,901.3,5022]
[null,33,945.9,4510.2]
[null,34,869.1,4435.8999999999996]
[null,35,847.1,4250.6000000000004]
[null,36,777.4,4132.05]
[null,37,692.7,4063.65]
[null,38,847,4028.25]
[null,39,1006.4,4008.1499999999996]
[null,40,1074,4076.65]
[null,41,1183.0999999999999,4115.6499999999996]
[null,42,1234.5999999999999,4145.8500000000004]
[null,43,1252.4000000000001,4096.45]
[null,44,1291.2,4138.7000000000007]
[null,45,1295.5999999999999,4173.95]
[null,46,1302,4170.25]
[null,47,961.1,4222.6614499999996]
[null,48,906.5,4234.9183749999993]
[null,49,889.1,4174.9414350000006]
[null,50,881.6,4159.9493899999998]
[null,51,868,4176.5496350000003]
[null,52,856.6,4191.5902850000002]
[null,53,797.81799999999998,4244.9195849999996]
[null,54,693.7,4295.9990049999997]
[null,55,653.4,4385.00353]
[null,56,621.6,4464.4799999999996]
[null,57,632.20000000000005,4537.5048333333343]

{"sheet":"Rangkorrel.","index":3,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[5,4,5,6],[5,8,5,9]]}
[]
[]
[]
[]
[]
[null,null,null,null,"Rang korreláció páronként",null,null,null,"Kendall"]
[null,"1. pontozó","2. pontozó","3. pontozó","d^2_(1-2)","d^2_(1-3)","d^2_(2-3)",null,null,"R_i"]
["Nagymihály Balázs & Szalai Ágnes",1,1,3,{"$f":"($B8-C8)^2","v":0},{"$f":"($B8-D8)^2","v":4},{"$f":"($C8-D8)^2","v":4},null,null,{"$f":"SUM(B8:D8)","v":5}]
["Zilahy Szabolcs György & Mikes Anna",3,4,2,{"$f":"($B9-C9)^2","v":1},1,{"$f":"($C9-D9)^2","v":4},null,null,9]
["Süttő Roland & Tombácz Anikó",6,3,1,9,25,4,null,null,10]
["Kovács László & Kelemen Erika",4,2,6,4,4,16,null,null,12]
["Lehoczky György & Czina Boglárka",2,5,4,9,4,1,null,null,11]
["Vas Zsolt & Kiss-Nemes Veronika",5,6,5,1,0,1,null,null,16]
[null,null,null,null,null,null,null,null,"átlag",{"$f":"AVERAGE(J8:J13)","v":10.5}]
[null,null,null,"rang-korr:",{"$f":"1-6*SUM(E8:E13)/COUNT(B8:B13)/(COUNT(B8:B13)^2-1)","v":0.31428571428571428},{"$f":"1-6*SUM(F8:F13)/COUNT(C8:C13)/(COUNT(C8:C13)^2-1)","v":-8.5714285714285632E-2},{"$f":"1-6*SUM(G8:G13)/COUNT(D8:D13)/(COUNT(D8:D13)^2-1)","v":0.1428571428571429},null,"szum(R_i-R_átl)",{"$f":"DEVSQ(J8:J13)","v":65.5}]
[]
[null,null,null,null,null,null,null,null,"kendall W",{"$f":"12*J15/COUNT(B8:D8)^2/COUNT(B8:B13)/(COUNT(B8:B13)^2-1)","v":0.41587301587301589}]
[]
[null,null,null,"Minden megvilágításból az a következtetés vonható le, hogy a zsűri véleménye nem igazán egybehangzó."]

{"sheet":"1. LNM","index":4,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Karát","Eladási ár"]
[0.3,1302,null,"a)"]
[0.3,1510,null,"korreláció",{"$f":"CORREL(A11:A50,B11:B50)","v":0.88580040691618001}]
[0.3,1510]
[0.3,1260]
[0.31,1641,null,"A megoldás le kell vezetni! A trendvonal illesztés ellenőrzésre szolgál."]
[0.31,1555]
[0.31,1427]
[0.31,1427]
[0.31,1126]
[0.31,1126]
[0.32,1468]
[0.32,1202]
[0.36,1635]
[0.36,1485]
[0.37,1420]
[0.37,1420]
[0.4,1911]
[0.4,1525]
[0.41,1956]
[0.43,1747]
[0.33,1367]
[0.33,1098]
[0.34,1693]
[0.34,1551]
[0.34,1410]
[0.34,1269]
[0.34,1316]
[0.34,1222]
[0.35,1738]
[0.35,1593]
[0.35,1447]
[0.35,1255]
[0.45,1572]
[0.46,2942]
[0.48,2532]
[0.5,3501]
[0.5,3501]
[0.5,3501]
[0.5,3293]
[0.5,3016]

{"sheet":"2. LNM","index":5,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"x","y","a)","yi/(xi+1)","1/(xi+1)^2","f(xi)","(f(xi)-yi))^2",null,"b)","e^(-xi)","e^(-xi)*e^(-xi)","yi*e^(-xi)","g(xi)","(g(xi)-yi))^2"]
[null,5.0000000000000001E-3,12.873895965448,null,{"$f":"C8/(B8+1)","v":12.809846731789056},{"$f":"1/(B8+1)^2","v":0.99007450310635903},{"$f":"$E$31/(B8+1)","v":12.303196397770074},{"$f":"(G8-C8)^2","v":0.32569799654777093},null,null,{"$f":"EXP(-B8)","v":0.99501247919268232},{"$f":"K8*K8","v":0.99004983374916811},{"$f":"C8*K8","v":12.809687141449086},{"$f":"$L$31*EXP(-B8)","v":12.70813287830263},{"$f":"(N8-C8)^2","v":2.7477401059963574E-2}]
[null,{"$f":"B8*1.5","v":7.4999999999999997E-3},12.9179793231601,null,12.821815705369826,0.98516707817916471,12.272667374450544,0.41642751114732546,null,null,0.99252805481913842,0.98511193960306265,12.821456889809944,12.676402225948696,5.8359493897088444E-2]
[null,1.125E-2,11.925755156084399,null,11.793082972642175,0.97787407121062342,12.227156865027366,9.084299015374088E-2,null,null,0.98881304461123309,0.97775123719333645,11.792342265175925,12.62895473724522,0.49448965094475333]
[null,1.6875000000000001E-2,12.568737730162001,null,12.360160029661463,0.96708547260069311,12.159520471797343,0.16745876454348693,null,null,0.98326658527661903,0.96681317772154274,12.358419829173794,12.558116286771146,1.1281505970514022E-4]
[null,2.5312500000000002E-2,11.9957167485278,null,11.699571348762253,0.95123428686829425,12.059457365202242,4.0628662140381926E-3,null,null,0.97500517529841779,0.95063509185869843,11.695885911228514,12.452602940998538,0.20874499287040899]
[null,3.7968750000000002E-2,12.250155023563,null,11.802046086226584,0.92817836905237561,11.912412950542993,0.11406970788785138,null,null,0.96274302614068197,0.92687413438251787,11.79375131807752,12.295992823910854,2.1011039407297554E-3]
[null,5.6953125000000007E-2,12.2933766826874,null,11.630957316756504,0.895135014950596,11.698449143389329,0.35393877701525817,null,null,0.94463834825130311,0.89234160898695025,11.61279504396491,12.064762907554659,5.2264258180443599E-2]
[null,8.5429687500000018E-2,11.566638874843401,null,10.656276503256597,0.84878287461501201,11.391536938922101,3.0660687963386807E-2,null,null,0.91811769593519055,0.84294010358934301,10.619535833485628,11.726045574154101,2.5410495785132121E-2]
[null,0.12814453125000003,10.801651791143801,null,9.5747056267475035,0.7857248976427974,10.960220111210971,2.5143912128924441E-2,null,null,0.87972622202524942,0.77391822571881841,9.5024963218552045,11.235716093827108,0.18841181886394565]
[null,0.19221679687500004,10.697122931600401,null,8.9724645380264327,0.70354118766273943,10.371194578174798,0.10622929156672463,null,null,0.82512796393535237,0.68083615686810017,8.8264952645176056,10.538396278006074,2.5194150561253417E-2]
[null,0.28832519531250006,9.7878114206136502,null,7.5973142931816131,0.60248882994843767,9.5975087848528027,3.6215093177525789E-2,null,null,0.74951781292384623,0.56177695189014576,7.3361390092893872,9.5727160819321924,4.6266004722491039E-2]
[null,0.43248779296875006,8.2257081112071209,null,5.7422535476967695,0.48732438167492576,8.6316354250626848,0.1647769841339935,null,null,0.64889277414047908,0.42106183233172678,5.3376025555510287,8.28754992524145,3.8244099630565425E-3]
[null,0.64873168945312509,7.23003183034018,null,4.3852082643831158,0.36787479173946463,7.4995297651252333,7.2629136853408813E-2,null,null,0.52270831298766185,0.27322398046640745,3.7791977408842126,6.6759431031761673,0.30701431757023567]
[null,0.9730975341796877,5.4350618205979897,null,2.7545834539079732,0.2568637936061926,6.2666503634852164,0.69153950466130087,null,null,0.37791063215708781,0.14281644589736972,2.0539676484350387,4.8266113541331936,0.37021197014122792]
[null,1.4596463012695315,3.65435582873309,null,1.4857241168565238,0.16529308314716812,5.0270286314650008,1.8842306233598793,null,null,0.23231843093371549,5.3971853351503535E-2,0.848974212204749,2.9671321235888888,0.47227642091212396]
[null,2.1894694519042974,2.4048146339083698,null,0.75398578671840122,9.8302170284920748E-2,3.876730147823324,2.166535280103524,null,null,0.11197614158920592,1.2538656285205892E-2,0.26928186394231801,1.4301405422270042,0.94998958499489516]
[null,3.2842041778564459,1.4222396745530199,null,0.33197289753464126,5.4482832658446223E-2,2.8861165029593594,2.1429353687450035,null,null,3.747039299941491E-2,1.4040303515306018E-3,5.3291879544861614E-2,0.47856558907194791,0.89052077960853759]
[null,4.9263062667846693,0.90139311338661698,null,0.15210032570180848,2.8472907456809169E-2,2.0864113029493203,1.4042681095944669,null,null,7.2532454153267341E-3,5.260956905495829E-5,6.5380254670785705E-3,9.2637236682397359E-2,0.65408606810361092]
[null,7.389459400177004,0.621044210909795,null,7.4026725833692228E-2,1.4207970498304121E-2,1.4738389912820902,0.72725893743023118,null,null,6.1772980788544715E-4,3.8159011555019143E-7,3.8363752109367677E-4,7.8895417350604343E-3,0.37595864833077824]
[null,11.084189100265506,0.42469172526264398,null,3.514441240027541E-2,6.8480192820174618E-3,1.0232140756128398,0.35822900386872258,null,null,1.5353162174933381E-5,2.3571958876980513E-10,6.5203609323096249E-6,1.9608801809148016E-4,0.18019654603965873]
[null,null,null,null,{"$f":"SUM(E8:E27)","v":137.43324068345325},{"$f":"SUM(F8:F27)","v":11.114956536185341},null,null,null,null,null,{"$f":"SUM(L8:L27)","v":10.454118251640319},{"$f":"SUM(M8:M27)","v":133.51824891193885}]
[null,"tap szór^2",{"$f":"_xlfn.STDEV.P(C8:C27)^2","v":21.531736065165298}]
[null,"darab",{"$f":"COUNT(C8:C27)","v":20}]
[null,null,null,"a",{"$f":"E28/F28","v":12.364712379758924},null,"R2",{"$f":"1-SUM(H8:H27)/C30/C29","v":0.97379879050869755},null,null,"b",{"$f":"M28/L28","v":12.771832659439163},null,"R2",{"$f":"1-SUM(O8:O27)/C30/C29","v":0.98761616128999052}]

{"sheet":"1. Konf. int","index":6,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,4,16,5]]}
[]
[]
[]
[]
[]
[]
[]
[null,"n",20]
[null,"átlag",1014,"óra"]
[null,"σ",25,"óra"]
[]
[null,"p",0.95]
[null,"(p+1)/2",{"$f":"(C12+1)/2","v":0.97499999999999998}]
[]
[null,"lambda",{"$f":"_xlfn.NORM.S.INV(C13)","v":1.9599639845400536}]
[]
[null,"a",{"$f":"C15*C10/SQRT(C8)","v":10.956531757207268},null,"mérés eredménye:",null,"1014+-10,96 óra, p = 95% esetén"]

{"sheet":"2. Konf. int","index":7,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Nyomó-szilárdság\n[MPa]"]
[null,22.16,null,"átlag",{"$f":"AVERAGE(adat)","v":22.599166666666665}]
[null,22.25,null,"kor t sz",{"$f":"STDEV(adat)","v":0.35569287909996777}]
[null,23.18,null,"n",{"$f":"COUNT(adat)","v":12}]
[null,22.37,null,"p",0.95]
[null,23.01]
[null,22.55,null,"lambda_st",{"$f":"_xlfn.T.INV.2T(1-E14,E13-1)","v":2.2009851600916384}]
[null,22.49,null,"a",{"$f":"E16*E12/SQRT(E13)","v":0.22599647337948151}]
[null,22.81]
[null,22.75,null,"eredmény","22,599 +- 0,226 Mpa, p = 95% esetén"]
[null,22.04]
[null,22.63]
[null,22.95]

{"sheet":"Hibaterjedés","index":8,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,12,3,13],[4,12,4,13],[5,12,5,13]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"σ_η",{"$f":"M16","v":4.1954994219744968E-2}]
[null,null,null,null,null,null,null,null,null,null,null,"η",{"$f":"M13","v":1.3230276828132461}]
[null,null,null,null,null,null,null,null,null,null,null,"h_η",{"$f":"M15","v":1.0056097337006427E-3}]
[]
[]
[]
[]
[]
[]
[null,"C",{"$f":"PI()/3/10000","v":1.0471975511965977E-4},null,null,null,null,null,null,null,null,"éta",{"$f":"C13*C15*C23^(C26)/E19/C27","v":1.3230276828132461}]
[]
[null,"P",500,"W",null,null,null,{"$f":"C18*C17/C15","v":0.03},{"$f":"H15^2","v":8.9999999999999998E-4},null,null,"h",{"$f":"SUM(I15:I30)","v":1.0056097337006427E-3}]
[null,"2*sigma",30,null,null,null,null,null,{"$f":"H16^2","v":0},null,null,"szigma",{"$f":"SQRT(M15)*M13","v":4.1954994219744968E-2}]
[null,"sigma",{"$f":"C16/2","v":15},null,null,null,null,null,0]
[null,"k",1,null,null,null,null,null,0]
[null,"Q",110,"l/perc",{"$f":"C19/10^3/60","v":1.8333333333333333E-3},"m^3/s",null,{"$f":"C22*C21/C19","v":-2.2727272727272726E-3},5.1652892561983466E-6]
[null,"2*sigma",0.5,null,{"$f":"C20/10^3/60","v":8.3333333333333337E-6},null,null,null,0]
[null,"sigma",{"$f":"C20/2","v":0.25},null,4.1666666666666669E-6,null,null,null,0]
[null,"k",-1,null,null,null,null,null,0]
[null,"n",1500,"1/min",null,null,null,{"$f":"C26*C25/C23","v":-6.6666666666666664E-4},4.4444444444444444E-7]
[null,"2*sigma",10,null,null,null,null,null,0]
[null,"sigma",{"$f":"10/2","v":5},null,null,null,null,null,0]
[null,"k",{"$f":"-1/5","v":-0.2},null,null,null,null,null,0]
[null,"p",5,"bar",null,null,null,{"$f":"C30*C29/C27","v":-0.01},1E-4]
[null,"2*sigma",0.1,null,null,null,null,null,0]
[null,"sigma",{"$f":"C28/2","v":0.05},null,null,null,null,null,0]
[null,"k",-1,null,null,null,null,null,0]

{"sheet":"1. teszt","index":9,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Relatív gyakoriság"]
[null,null,"a) a kedvező és kedvezőtlen esetek számának hányadosa;"]
[null,"x","b) a kedvező és az összes esetek számának hányadosa;"]
[null,null,"c) értéke lehet pozitív és negatív is.;"]
[null,null,"d) értéke mindig független a megfigyelések számától;"]
[]
[null,null,"Tapasztalati sűrűségfüggvény"]
[null,null,"a) olyan lépcsősfüggvény, amelynek értéke a legnagyobb mintaelem felett egységnyi;"]
[null,null,"b) olyan lépcsősfüggvény, amely értéke minden mintaelemnél növekszik;"]
[null,null,"c) értéke lehet pozitív és negatív is;"]
[null,"x","d) alatt lévő terület egységnyi."]
[]
[null,null,"Mérés és mérési hibák"]
[null,null,"a) a rendszeres hiba nulla várható értékű, egységnyi szórású valószínűségi változó;"]
[null,"x","b) a véletlen hiba nulla várható értékű, normális eloszlású valószínűségi változó;"]
[null,null,"c) közvetlen mérés eredményét vagy csak rendszeres vagy csak véletlen mérési hiba terhelheti;"]
[null,null,"d) a nullponthiba véletlen hiba."]
[]
[null,null,"Rangkorreláció"]
[null,"x","a) a zsűritagok által készített rangsorok közötti korrelációs együttható;"]
[null,null,"b) értéke csak 0 és 1 között változhat;"]
[null,null,"c) csak akkor számolható, ha a zsűritagok és a versenyzők száma megegyezik;"]
[null,null,"d) értéke egyhez tart, ha a versenyzők száma minden határon túl növekszik."]
[]
[null,null,"5. Kendall féle konkordancia együttható"]
[null,null,"a) értéke kiszámítható a rangkorreláció értékéből;"]
[null,null,"b) értéke 0 és -1 között is lehet;"]
[null,null,"c) csak akkor számolható, ha a zsűritagok és a versenyzők száma megegyezik;"]
[null,"x","d) értéke egységnyi, ha a zsűri minden tagja ugyan olyan rangsort állít fel."]

{"sheet":"2. Teszt","index":10,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"A konfidencia intervallum"]
[null,null,"a)    sugara egyenlő a várható érték és az átlag különbségével;"]
[null,null,"b)    sugara egyenlő a valószínűségi változó szórásával;"]
[null,null,"c)    közepe a várható érték, és p<1 valószínűséggel tartalmazza az átlagot;"]
[null,"x","d)    közepe az átlag, és p<1 valószínűséggel tartalmazza a várható értéket."]
[]
[null,null,"Wald módszere"]
[null,"x","a) két hibával terhelt változó közötti lineáris kapcsolat együtthatóinak becslésére szolgál;"]
[null,null,"b) egy megfigyelés-sorozat átlagának becslésére szolgál;"]
[null,null,"c) alkalmas a megfigyelésekhez illeszkedő másodfokú polinom együtthatóinak meghatározására;"]
[null,null,"d) csak akkor alkalmazható, ha az egyik változó konstans;"]
[]
[null,null,"A hiba terjedés összefüggése megmutatja"]
[null,null,null,"a) hogy hogyan terjed a hiba az egyik mérésről a másikra;"]
[null,null,null,"b) a rendszeres hiba terjedését;"]
[null,"x",null,"c) a véletlen hiba terjedését;"]
[null,null,null,"d) hogy a véletlen hibából rendszeres hiba lesz."]
[]
[null,null,"Rendszeres és véletlen hiba"]
[null,"x",null,"a) rendszeres hiba minden mérési eredményt terhel;"]
[null,null,null,"b) véletlen hiba miden mérési eredményt terhel;"]
[null,null,null,"c) a véletlen hiba értéke pontosan meghatározható;"]
[null,null,null,"d) a rendszeres hiba értéke nem függhet a mért értéktől;"]
[]
[null,null,"Az F(x) eloszlásfüggvény tulajdonságai"]
[null,null,null,"a) az eloszlásfüggvény lépcsős függvény;"]
[null,null,null,"b) F(x) → 0, ha x→¥"]
[null,null,null,"c) F(x) → ¥, ha x→0"]
[null,"x",null,"d) F(x) → 1, ha x→¥"]

{"sheet":"1. Eloszlásos ","index":11,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[9,5,9,7],[10,1,12,4],[10,5,12,6],[13,1,15,4],[13,5,15,6],[108,2,108,3],[108,4,108,5],[108,6,108,7],[16,1,18,4],[16,5,18,6],[19,1,22,4],[19,5,22,6],[23,1,24,4],[23,5,24,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"lambda",{"$f":"1/1200","v":8.3333333333333339E-4}]
[]
[]
[]
[null,null,null,null,null,"A számításai alapján töltse ki!"]
[null,"Mekkora annak a valószínűsége, hogy egy kiválasztott égő  3000 órán belül megy tönkre?",null,null,null,{"$f":"_xlfn.EXPON.DIST(3000,J6,TRUE)","v":0.91791500137610116}]
[]
[null,null,null,null,null,null,null,0.9]
[null,"Mekkora annak a valószínűsége, hogy egy kiválasztott égő 3000 órán belül még nem megy tönkre?",null,null,null,{"$f":"1-_xlfn.EXPON.DIST(3000,J6,TRUE)","v":8.2084998623898842E-2}]
[]
[null,null,null,null,null,null,null,0.08]
[null,"Mekkora annak a valószínűsége, hogy egy kiválasztott égő 1500 és 3000 órán belül megy tönkre?",null,null,null,{"$f":"_xlfn.EXPON.DIST(3000,J6,TRUE)-_xlfn.EXPON.DIST(1500,J6,TRUE)","v":0.20441979823629131}]
[]
[null,null,null,null,null,null,null,0.2]
[null,"Válasszunk ki véletlen szerűen 5 égőt. Mennyi annak a valószínűsége, hogy ennek az 5 égőnek az átlagos tönkremeneteli ideje kisebb, mint 2500 óra?",null,null,null,{"$f":"_xlfn.EXPON.DIST(2500,J6,TRUE)","v":0.87548552855587702}]
[]
[]
[null,null,null,null,null,null,null,0.88]
[null,"Mekkora a tönkremenetli idő szórása?",null,null,null,"1200 óra"]
[null,null,null,null,null,null,null,"uaz, mint a vé."]

{"sheet":"2. Eloszlásos","index":12,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[5,5,5,7],[6,1,7,4],[6,5,7,6],[8,1,10,4],[8,5,10,6],[11,1,13,4],[11,5,13,6],[14,1,17,4],[14,5,17,6],[18,1,19,4],[18,5,19,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"A számításai alapján töltse ki!"]
[null,"Mekkora annak a valószínűsége, hogy 5 lehetséges színből az emberek a kedvencüknek jelölnek 1 színt, ha a színek közötti megoszlás bizonyítottan egyenletes eloszlású?",null,null,null,{"$f":"1/5","v":0.2}]
[]
[null,"Mekkora annak a valószínűsége, hogy egy N(0,1) eloszlásból származó valószínűségi változó értéke kisebb, mint 0,8?",null,null,null,{"$f":"_xlfn.NORM.S.DIST(0.8,1)","v":0.78814460141660336}]
[]
[]
[null,"Mekkora annak a valószínűsége, hogy egy N(0,1) eloszlásból származó valószínűségi változó értéke nagyobb, mint 0,8?",null,null,null,"1-I10"]
[]
[]
[null,"Az x= 1;2;3 és y=-3;-5;-7 pontsorra LNM segítségével egyenest illesztünk. \nMekkora lesz a determinációs együttható?",null,null,null,1,null,null,1,-3]
[null,null,null,null,null,null,null,null,2,-5]
[null,null,null,null,null,null,null,null,3,-7]
[null,null,null,null,null,null,null,null,"R2 = 1"]
[null,"Az η valószínűségi változó szórásnégyzete 12. \nMekkora lesz a ξ=a*η valószínűségi változó szórásnégyzete D2(ξ), ha a=3?",null,null,null,{"$f":"9*12","v":108}]