{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["PrbaSigno01","PrbaSigno02","PrbaSigno03","DatosPareados","RangWil01","RangWil02","ManWitWil01","ManWitWil02","KruskWallis01","KruskWallis02","CxRSpearman01"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"PrbaSigno01","index":0,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Te agradó el queso?"]
[null,null,"Nro de \"+\"",{"$f":"COUNTIF(A3:A22,E2)","v":10},"+","Les agradó"]
["+",null,"Nro de \"-\"",{"$f":"COUNTIF(A3:A22,E3)","v":8},"-","No les agradó"]
[null,null,"Nro de nulos"]
["-"]
["+",null,"n = ",{"$f":"SUM(D2:D3)","v":18}]
["-",null,"k = ",{"$f":"MIN(D2:D3)","v":8}]
["+"]
["-",null,"P(X ≤ k) = ",{"$f":"BINOMDIST(D7,D6,0.5,1)","v":0.40726470947265636}]
["+",null,null,{"$f":"IF(D9<0.05,\"Se rechaza la hipótesis nula\",\"No se rechaza la hipótesis nula\")","v":"No se rechaza la hipótesis nula"}]
["+",null,null,{"$f":"IF(D2>D3,\"A más presentes les agradó el producto\",\"A menos presentes les agradó el producto\")","v":"A más presentes les agradó el producto"}]
["-"]
["-"]
["+"]
["+"]
["-"]
["-"]
[]
["+"]
["+"]
["-"]
["+"]

{"sheet":"PrbaSigno02","index":1,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Nuevo","Antiguo","Difer"]
[2.2999999999999998,2.2000000000000002,{"$f":"A2-B2","v":9.9999999999999645E-2}]
[2.6,2.5,{"$f":"A3-B3","v":0.10000000000000009},null,"<0","Negativos",{"$f":"COUNTIF(C2:C18,E3)","v":3},null,null,"Nota:"]
[3.5,3.4,0.10000000000000009,null,">0","Positivos",{"$f":"COUNTIF(C2:C18,E4)","v":11},null,null,"Si la diferencia (Nuevo - Antiguo) es positiva, no reduce"]
[2.9,2.9,0,null,null,"Nulos",{"$f":"COUNT(A2:A18)-G3-G4","v":3}]
[2.5,2.4,0.10000000000000009,null,null,"n = ",{"$f":"G4+G3","v":14}]
[3.3,3.1,0.19999999999999973,null,null,"k = ",{"$f":"MIN(G3:G4)","v":3}]
[1.7,1.8,-0.10000000000000009,null,null,"P( X ≤ k ) =  ",{"$f":"BINOMDIST(G7,G6,0.5,1)","v":2.8686523437500003E-2}]
[2.8,2.8,0]
[2.9,2.9,0,null,null,null,{"$f":"IF(AND(G8<0.05,G4>G3),\"No reduce el tiempo\",\"Sí logra reducir el tiempo\")","v":"No reduce el tiempo"}]
[3.1,3.2,-0.10000000000000009]
[2.4,2.2999999999999998,0.10000000000000009]
[3.2,3.3,-9.9999999999999645E-2]
[2.5,2.4,0.10000000000000009]
[2.6,2.5,0.10000000000000009]
[3.3,3.2,9.9999999999999645E-2]
[2.9,2.8,0.10000000000000009]
[2.2000000000000002,2.1,0.10000000000000009]

{"sheet":"PrbaSigno03","index":2,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Antes","Después","Difer"]
[12,13,{"$f":"B2-A2","v":1},null,"Nro de ",">0",{"$f":"COUNTIF(C2:C11,F2)","v":8},"El comercial es efectivo"]
[8,12,{"$f":"B3-A3","v":4},null,"Nro de ","<0",{"$f":"COUNTIF(C2:C11,F3)","v":2},"El comercial no es efectivo"]
[9,15,6,null,"Nro de ",{"$f":"0","v":0},{"$f":"COUNTIF(C2:C11,F4)","v":0}]
[11,12,1,null,"n = ",null,{"$f":"SUM(G2:G3)","v":10}]
[13,10,-3,null,"Sea ","X= ",{"$f":"MIN(G2:G3)","v":2}]
[15,11,-4]
[10,12,2]
[6,8,2,null,"Probab",null,{"$f":"BINOMDIST(G6,G5,0.5,1)","v":5.4687500000000007E-2}]
[7,14,7,null,null,null,{"$f":"IF(G9<0.05,\"Se rechaza la hipótesis nula\",\"No se rechaza la hipótesis nula\")","v":"No se rechaza la hipótesis nula"}]
[8,16,8,null,null,null,{"$f":"IF(G2>G3,\"Más calificaciones fueron positivas\",\"Menos calficaciones fueron positivas\")","v":"Más calificaciones fueron positivas"}]
[]
[]
["Un grupo de 10 consumidores, elegidos al azar, fueron requeridos para manifestar su grado de satisfacción respecto a un tipo de jabón,"]
["en una puntuación de 0 a 20. Después de solicitarles que vean un video sobre el mismo producto, se les pidió que volvieran a calificarlo."]
["Los resultados se muestran en la siguiente tabla:"]
["El comercial tuvo algún efecto significativo sobre la satisfacción por el producto?. Use nivel de significación del 5%."]

{"sheet":"DatosPareados","index":3,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Antes","Después","Diferencia"]
[217,209,{"$f":"A2-B2","v":8}]
[252,241,{"$f":"A3-B3","v":11},null,"Nro de ",">0",{"$f":"COUNTIF(C2:C7,F3)","v":4}]
[229,230,-1,null,"Nro de ","<0",{"$f":"COUNTIF(C2:C7,F4)","v":2}]
[200,208,-8,null,"Nro de ",{"$f":"0","v":0},{"$f":"COUNTIF(C2:C7,F5)","v":0}]
[209,206,3,null,"n = ",null,{"$f":"SUM(G3:G4)","v":6}]
[213,211,2,null,"Sea ","X= ",{"$f":"MIN(G3:G4)","v":2}]
[]
[null,null,null,null,"Probab X < ",{"$f":"G7","v":2},{"$f":"BINOMDIST(F9,G6,0.5,1)","v":0.34375}]
[null,"Reduce si >0"]
[null,"No reduce si <=0",null,null,null,null,{"$f":"IF(G9<0.05,\"Sí logra reducir el nivel de colesterol\",\"No reduce el nivel de colesterol\")","v":"No reduce el nivel de colesterol"}]
[]
[null,"Ho: No reduce"]
[]
[]
["A un conjunto de 6 pacientes se les evaluó en nivel de colesterol que tenían en la sangre."]
["Después de aplicarles un nuevo medicamento se les volvió a medir el nivel de colesterol."]
["Los datos se meustran en las columnas A y B de esta hoja. A un nivel de significación del 5%,"]
["se puede afirmar que el medicamento reduce el colesterol en la sangre?"]

{"sheet":"RangWil01","index":4,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Paciente","Método A","Método B","Diff","Rango","Rango con signo",null,"Paciente","Diff","Asignar rango"]
[1,87,76,{"$f":"B2-C2","v":11},{"$f":"VLOOKUP(A2,$H$2:$J$9,3,0)","v":5},{"$f":"IF(D2>0,E2,-1*E2)","v":5},null,3,{"$f":"ABS(D2)","v":11},8]
[2,66,56,{"$f":"B3-C3","v":10},{"$f":"VLOOKUP(A3,$H$2:$J$9,3,0)","v":4},{"$f":"IF(D3>0,E3,-1*E3)","v":4},null,6,10,7]
[3,75,76,-1,8,-8,null,5,1,1]
[4,95,86,9,2,2,null,7,9,6]
[5,73,76,-3,1,-1,null,8,3,3]
[6,88,86,2,7,7,null,4,2,2]
[7,69,64,5,6,6,null,2,5,4]
[8,77,70,7,3,3,null,1,7,5]
[]
[null,null,null,null,null,{"$f":"SUMIF(F2:F9,G11)","v":27},">0"]
[null,null,null,null,null,{"$f":"SUMIF(F2:F9,G12)","v":-9},"<0"]
[null,null,null,null,"Estadístico  T =",{"$f":"MIN(ABS(F11),ABS(F12))","v":9}]
[null,null,null,null,"Tamaño de muestra = ",{"$f":"COUNTIF(F2:F9,\"<>0\")","v":8}]
[null,null,null,null,"Media de T = ",{"$f":"1/4*F14*(F14+1)","v":18}]
[null,null,null,null,"Desviación de T = ",{"$f":"SQRT(1/24*F14*(F14+1)*(2*F14+1))","v":7.1414284285428504}]
[null,null,null,null,"Estadístico calculado = Tc = ",{"$f":"(F13-F15)/F16","v":-1.2602520756252087}]
[null,null,null,null,"Valor crítico = ",1.96]
[null,null,null,null,null,{"$f":"IF(ABS(F17)>F18,\"Se rechaza Ho\",\"No se rechaza Ho\")","v":"No se rechaza Ho"}]

{"sheet":"RangWil02","index":5,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[17,6,17,7]]}
["Identif","Método 1","Método 2","Difer",null,"Rango","Rango con signo",null,null,null,"Identif","DifAbs","Asingar rango"]
[1,10.199999999999999,9.5,{"$f":"B2-C2","v":0.69999999999999929},null,{"$f":"VLOOKUP(A2,$K$2:$M$12,3,0)","v":8},{"$f":"IF(D2>0,F2,-1*F2)","v":8},null,null,null,8,0]
[2,9.6,9.8000000000000007,-0.20000000000000107,null,2,-2,null,null,null,7,9.9999999999999645E-2,1]
[3,9.1999999999999993,8.8000000000000007,0.39999999999999858,null,3.5,3.5,null,null,null,2,0.20000000000000107,2]
[4,10.6,10.1,0.5,null,5.5,5.5,null,null,null,3,0.39999999999999858,3.5]
[5,9.9,10.3,-0.40000000000000036,null,3.5,-3.5,null,null,null,5,0.40000000000000036,3.5]
[6,10.199999999999999,9.3000000000000007,0.89999999999999858,null,10,10,null,null,null,4,0.5,5.5]
[7,10.6,10.5,9.9999999999999645E-2,null,1,1,null,null,null,10,0.5,5.5]
[8,10,10,0,null,0,0,null,null,null,9,0.59999999999999964,7]
[9,11.2,10.6,0.59999999999999964,null,7,7,null,null,null,1,0.69999999999999929,8]
[10,10.7,10.199999999999999,0.5,null,5.5,5.5,null,null,null,11,0.79999999999999893,9]
[11,10.6,9.8000000000000007,0.79999999999999893,null,9,9,null,null,null,6,0.89999999999999858,10]
[]
[null,null,null,null,null,null,"Suma de +",{"$f":"SUMIF(D2:D12,I14,G2:G12)*(1)","v":49.5},">0"]
[null,null,null,null,null,null,"Suma de -",{"$f":"SUMIF(D2:D12,I15,F2:F12)*(-1)","v":-5.5},"<0"]
[null,null,null,null,null,null,"Estadístico T = ",{"$f":"MIN(ABS(H14),ABS(H15))","v":5.5}]
[]
[null,null,null,null,null,null,"Prueba T"]
[null,null,null,null,null,null,"Tamaño de la muestra = ",{"$f":"COUNTIF(G2:G12,\"<>0\")","v":10}]
[null,null,null,null,null,null,"Media de T = ",{"$f":"1/4*H19*(H19+1)","v":27.5}]
[null,null,null,null,null,null,"Desviación de T = ",{"$f":"SQRT(1/24*H19*(H19+1)*(2*H19+1))","v":9.8107084351742913}]
[null,null,null,null,null,null,"Estadístico de la prueba: ",{"$f":"(H16-H20)/H21","v":-2.2424476423255526}]
[null,null,null,null,null,null,"Valor crítico = ",1.96]
[null,null,null,null,null,null,null,{"$f":"IF(ABS(H22)>H23,\"Se rechaza la hipótesis nula\",\"No se rechaza la hipótesis nula\")","v":"Se rechaza la hipótesis nula"}]

{"sheet":"ManWitWil01","index":6,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Diurno","Nocturno",null,"NroComp","Turno","Rango"]
[80,50,1,30,"N",1]
[40,60,2,35,"N",2,null,null,null,null,"Turno","Suma Rango"]
[40,48,3,40,"D",4.5,null,null,null,null,"D",{"$f":"SUMIF(E2:E39,K4,F2:F39)","v":500.5}]
[60,60,4,40,"D",4.5,null,null,null,null,"N",{"$f":"SUMIF(E2:E39,K5,F2:F39)","v":240.5}]
[55,65,5,40,"N",4.5]
[65,78,6,40,"N",4.5,null,null,null,"Tamaño:","D",{"$f":"COUNTIF(E2:E39,K7)","v":22}]
[75,85,7,48,"N",7,null,null,null,null,"N",{"$f":"COUNTIF(E2:E39,K8)","v":16}]
[85,83,8,50,"N",8]
[84,40,9,55,"D",9]
[78,35,10,58,"D",10,null,null,null,"Cálculo de U(N) = ",null,{"$f":"L7*L8+L8/2*(L8+1)-L5","v":247.5}]
[95,70,11,60,"D",12,null,null,null,"Cálculo de U(D) = ",null,{"$f":"L7*L8+L7/2*(L7+1)-L4","v":104.5}]
[92,78,12,60,"N",12]
[85,80,13,60,"N",12,null,null,null,"Determinación del estadístico U = ",null,{"$f":"MIN(L11:L12)","v":104.5}]
[90,30,14,65,"D",15]
[79,40,15,65,"D",15]
[95,90,16,65,"N",15,null,null,null,"Media de U = ",null,{"$f":"L7*L8/2","v":176}]
[58,null,17,70,"D",17.5,null,null,null,"Varianza de U = ",null,{"$f":"1/12*L7*L8*(L7+L8+1)","v":1144}]
[65,null,18,70,"N",17.5,null,null,null,"Desviación de U = ",null,{"$f":"SQRT(L18)","v":33.823069050575526}]
[90,null,19,75,"D",19]
[95,null,20,78,"D",21,null,null,null,"Cálculo del estadistico de la prueba = ",null,{"$f":"(L14-L17)/L19","v":-2.1139418156609704}]
[70,null,21,78,"N",21]
[80,null,22,78,"N",21,null,null,null,"Valor crítico Z = ",null,1.96]
[null,null,23,79,"D",23,null,null,null,null,null,{"$f":"IF(ABS(L21)>L23,\"Rechazar Ho\",\"No rechazar Ho\")","v":"Rechazar Ho"}]
[null,null,24,80,"D",25,null,null,null,null,null,"El rendimiento del turno diurno es mejor que los del turno nocturno"]
[null,null,25,80,"D",25]
[null,null,26,80,"N",25]
[null,null,27,83,"N",27]
[null,null,28,84,"D",28]
[null,null,29,85,"D",30]
[null,null,30,85,"D",30]
[null,null,31,85,"N",30]
[null,null,32,90,"D",33]
[null,null,33,90,"D",33]
[null,null,34,90,"N",33]
[null,null,35,92,"D",35]
[null,null,36,95,"D",37]
[null,null,37,95,"D",37]
[null,null,38,95,"D",37]

{"sheet":"ManWitWil02","index":7,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Gas 97","Gas 98",null,"Nro","Rendim","Gas","Rango"]
[20.2,21.1,null,1,16.899999999999999,"G98",1,null,null,"Estadísticas"]
[21,19.7,null,2,17.3,"G98",2,null,null,null,"Suma Rango"]
[20.5,18.5,null,3,17.399999999999999,"G98",3,null,null,"G97",{"$f":"SUMIF(F2:F25,J4,G2:G25)","v":185.5}]
[19.8,17.399999999999999,null,4,17.600000000000001,"G98",4,null,null,"G98",{"$f":"SUMIF(F3:F26,J5,G3:G26)","v":113.5}]
[19.8,17.600000000000001,null,5,17.8,"G98",5]
[19.2,21.3,null,6,18,"G98",6,null,null,"Tamaño de muestra:"]
[20.5,20.100000000000001,null,7,18.5,"G98",7,null,null,"G97",{"$f":"COUNTIF(F2:F25,J8)","v":12}]
[20.6,18,null,8,18.600000000000001,"G97",8,null,null,"G98",{"$f":"COUNTIF(F2:F25,J9)","v":12}]
[19.899999999999999,16.899999999999999,null,9,18.8,"G97",9.5]
[18.600000000000001,17.8,null,10,18.8,"G98",9.5,null,null,"Cálculo de los estadísticos por muestra:"]
[18.899999999999999,18.8,null,11,18.899999999999999,"G97",11,null,null,"Gas 97: U1 ",{"$f":"K8*K9+K8/2*(K8+1)-K4","v":36.5}]
[18.8,17.3,null,12,19.2,"G97",12,null,null,"Gas 98: U2 ",{"$f":"K8*K9+K9/2*(K9+1)-K5","v":108.5}]
[null,null,null,13,19.7,"G98",13]
[null,null,null,14,19.8,"G97",14.5,null,null,"Estadístico T = ",{"$f":"MIN(K12:K13)","v":36.5}]
[null,null,null,15,19.8,"G97",14.5]
[null,null,null,16,19.899999999999999,"G97",16,null,null,"Media de T = ",{"$f":"K8*K9/2","v":72}]
[null,null,null,17,20.100000000000001,"G98",17,null,null,"Varianza de T = ",{"$f":"1/12*K8*K9*(K8+K9+1)","v":300}]
[null,null,null,18,20.2,"G97",18]
[null,null,null,19,20.5,"G97",19.5,null,null,"Estadístico de la prueba = Tc = ",{"$f":"(K15-K17)/SQRT(K18)","v":-2.0495934556231714}]
[null,null,null,20,20.5,"G97",19.5]
[null,null,null,21,20.6,"G97",21,null,null,"Valor Crítico = Zα= ",1.96]
[null,null,null,22,21,"G97",22,null,null,null,{"$f":"IF(ABS(K20)>K22,\"Rechazar la hipótesis nula\", \"No rechazar la hipótesis nula\")","v":"Rechazar la hipótesis nula"}]
[null,null,null,23,21.1,"G98",23]
[null,null,null,24,21.3,"G98",24]

{"sheet":"KruskWallis01","index":8,"n_rows":21,"n_cols":21,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["A","B","C",null,"Valor","Método","Rango"]
[25,60,50,null,15,"B",1]
[70,20,70,null,20,"B",2,null,null,null,null,null,"Tamaño de las muestras",null,null,"Suma de los rangos:",null,null,null,"R²i","R²i / ni"]
[60,30,60,null,25,"A",3,null,null,null,null,"n1 = ",{"$f":"COUNTIF($F$2:$F$21,Q4)","v":7},null,null,"Método","A",{"$f":"SUMIF(F2:F21,Q4,G2:G21)","v":95},null,{"$f":"R4^2","v":9025},{"$f":"T4/M4","v":1289.2857142857142}]
[85,15,80,null,30,"B",4,null,null,null,null,"n2 = ",{"$f":"COUNTIF($F$2:$F$21,Q5)","v":6},null,null,"Método","B",{"$f":"SUMIF(F3:F22,Q5,G3:G22)","v":26},null,{"$f":"R5^2","v":676},{"$f":"T5/M5","v":112.66666666666667}]
[95,40,90,null,35,"B",5,null,null,null,null,"n3 = ",{"$f":"COUNTIF($F$2:$F$21,Q6)","v":7},null,null,"Método","C",{"$f":"SUMIF(F4:F23,Q6,G4:G23)","v":88},null,7744,1106.2857142857142]
[90,35,70,null,40,"B",6,null,null,null,null,"n = ",{"$f":"SUM(M4:M6)","v":20}]
[80,null,75,null,50,"C",7]
[null,null,null,null,60,"A",9,null,null,null,null,null,"Cálculo del estadísitco H:",{"$f":"12/(M7*(M7+1))*SUM(U4:U6)-3*(M7+1)","v":8.6639455782312922}]
[null,null,null,null,60,"B",9]
[null,null,null,null,60,"C",9,null,null,null,null,null,"Valor crítico c² (2) = ",5.99146]
[null,null,null,null,70,"A",12]
[null,null,null,null,70,"C",12,null,null,null,null,null,"Criterio de decisión: ",{"$f":"IF(N9>N11,\"Se rechaza Ho\",\"No se rechaza Ho\")","v":"Se rechaza Ho"}]
[null,null,null,null,70,"C",12]
[null,null,null,null,75,"C",14]
[null,null,null,null,80,"A",15.5]
[null,null,null,null,80,"C",15.5]
[null,null,null,null,85,"A",17]
[null,null,null,null,90,"A",18.5]
[null,null,null,null,90,"C",18.5]
[null,null,null,null,95,"A",20]

{"sheet":"KruskWallis02","index":9,"n_rows":19,"n_cols":20,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Método 1","Método 2","Método 3",null,"Valor","Método","Rangos"]
[9.4,8.5,8.9,null,6.1,2,1]
[8.6999999999999993,8.1999999999999993,6.7,null,6.7,3,2,null,null,null,null,"Tamaño de las muestras",null,null,"Suma de los rangos:",null,null,null,"R²i","R²i / ni"]
[9.1,7.9,7.2,null,6.9,3,3,null,null,null,"n1 = ",{"$f":"COUNTIF($F$2:$F$19,P4)","v":6},null,null,"Método",1,{"$f":"SUMIF($F$2:$F$19,P4,$G$2:$G$19)","v":84},null,{"$f":"Q4^2","v":7056},{"$f":"S4/L4","v":1176}]
[7.4,8.4,7.6,null,7.2,2,4.5,null,null,null,"n2 = ",{"$f":"COUNTIF($F$2:$F$19,P5)","v":7},null,null,"Método",2,{"$f":"SUMIF($F$2:$F$19,P5,$G$2:$G$19)","v":55.5},null,{"$f":"Q5^2","v":3080.25},{"$f":"S5/L5","v":440.03571428571428}]
[8.6,6.1,6.9,null,7.2,3,4.5,null,null,null,"n3 = ",{"$f":"COUNTIF($F$2:$F$19,P6)","v":5},null,null,"Método",3,{"$f":"SUMIF($F$2:$F$19,P6,$G$2:$G$19)","v":31.5},null,992.25,198.45]
[9.6999999999999993,7.2,null,null,7.4,1,6,null,null,null,"n = ",{"$f":"SUM(L4:L6)","v":18}]
[null,8,null,null,7.6,3,7]
[null,null,null,null,7.9,2,8,null,null,null,null,"Cálculo del estadísitco H:",{"$f":"12/(L7*(L7+1))*SUM(T4:T6)-3*(L7+1)","v":6.6661654135338324}]
[null,null,null,null,8,2,9]
[null,null,null,null,8.1999999999999993,2,10,null,null,null,null,"Valor crítico c² (2) = ",5.99146]
[null,null,null,null,8.4,2,11]
[null,null,null,null,8.5,2,12,null,null,null,null,"Criterio de decisión: ",{"$f":"IF(M9>M11,\"Se rechaza Ho\",\"No se rechaza Ho\")","v":"Se rechaza Ho"}]
[null,null,null,null,8.6,1,13]
[null,null,null,null,8.6999999999999993,1,14]
[null,null,null,null,8.9,3,15]
[null,null,null,null,9.1,1,16]
[null,null,null,null,9.4,1,17]
[null,null,null,null,9.6999999999999993,1,18]

{"sheet":"CxRSpearman01","index":10,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Frec Spot","Nro bebidas",null,null,"X","Rx","Y","Ry","Rx - Ry","(Rx - Ry)²"]
[4,12,null,null,4,5,12,7,{"$f":"F2-H2","v":-2},{"$f":"I2^2","v":4}]
[9,14,null,null,9,8,14,8,{"$f":"F3-H3","v":0},{"$f":"I3^2","v":0}]
[3,7,null,null,3,4,7,5,-1,1]
[0,6,null,null,0,1,6,3.5,-2.5,6.25]
[1,3,null,null,1,2,3,1,1,1]
[6,5,null,null,6,7,5,2,5,25]
[2,6,null,null,2,3,6,3.5,-0.5,0.25]
[5,10,null,null,5,6,10,6,0,0]
[]
[null,null,null,null,null,null,null,null,"Tamaño de la muestra = ",{"$f":"COUNT(E2:E9)","v":8}]
[]
[null,null,null,null,null,null,null,null,"Valor de Rs = ",{"$f":"1-6*SUM(J2:J9)/(J11*(J11^2-1))","v":0.5535714285714286}]
[]
[null,null,null,null,null,null,null,null,"Estadístico de la prueba = Tc = ",{"$f":"J13*SQRT(J11-2)/SQRT(1-J13^2)","v":1.6281997674605597}]
[]
[null,null,null,null,null,null,null,null,"Valor crítico  t (n-2) = ",{"$f":"TINV(0.05,J11-2)","v":2.4469118464326822}]
[]
[null,null,null,null,null,null,null,null,"Decisión: ",{"$f":"IF(J15>J17,\"Se rechaza la hipótesis nula\",\"No se rechaza la hipótesis nula\")","v":"No se rechaza la hipótesis nula"}]