{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Media","Proporción","Varianza","Razon var","Dif medias","Dif prop"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":1,"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":"Media","index":0,"n_rows":21,"n_cols":26,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,1,11,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelo de cola a la izquierda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelo de cola a la derecha"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelo de dos colas"]
[]
[]
[]
[null,null,null,"Modelo de cola a la izquierda",null,null,"Modelo de cola a la derecha",null,null,null,"Modelo de cola bilateral"]
[]
[]
[]
[]
[null,"Selecciona el modelo"]
[]
[]
[]
[]
[]
[null,"Nivel de significación: ",0.01,null,null,"Valor crítico: ",{"$f":"NORMSINV($C$18)","v":-2.3263478740408488}]
[null,"Grados de libertad: ",24,null,null,"Estadístico de la prueba: ",-1.3999999999999773,null,null,null,"p Valor: ",{"$f":"NORMDIST($G$19,0,1,1)","v":8.0756659233774508E-2}]
[]
[null,null,null,null,null,"Criterio de decisión: ","No rechazar la hipótesis nula"]

{"sheet":"Proporción","index":1,"n_rows":21,"n_cols":26,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,1,11,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelo de cola a la izquierda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelo de cola a la derecha"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelo de dos colas"]
[]
[]
[]
[null,null,null,"Modelo de cola a la izquierda",null,null,"Modelo de cola a la derecha",null,null,null,"Modelo de cola bilateral"]
[]
[]
[]
[]
[null,"Selecciona el modelo"]
[]
[]
[]
[]
[]
[null,"Nivel de significación: ",0.05,null,null,"Valor crítico: ",{"$f":"NORMSINV(1-$C$18)","v":1.6448536269514724},{"$f":"NORMSINV(1-$C$18/2)","v":1.959963984540054}]
[null,"tamaño de muestra: ",150,null,null,"Estadístico de la prueba: ",1.2247448713915883,null,null,null,"p Valor: ",{"$f":"1-NORMDIST($G$19,0,1,1)","v":0.11033568095992363}]
[]
[null,null,null,null,null,"Criterio de decisión: ","No rechazar la hipótesis nula"]

{"sheet":"Varianza","index":2,"n_rows":21,"n_cols":26,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,1,11,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelo de cola a la izquierda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelo de cola a la derecha"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelo de dos colas"]
[]
[]
[]
[null,null,null,"Modelo de cola a la izquierda",null,null,"Modelo de cola a la derecha",null,null,null,"Modelo de cola bilateral"]
[]
[]
[]
[]
[null,"Selecciona el modelo"]
[]
[]
[]
[]
[]
[null,"Nivel de significación: ",0.05,null,null,"Valor crítico: "]
[null,"tamaño de muestra: ",24,null,null,"Estadístico de la prueba: ",30.666666666666668,null,null,null,"p Valor: ",{"$f":"2*(CHIDIST($G$19,$C$19-1))","v":0.26240942761169994}]
[null,"Varianza de la muestra: ",400]
[null,null,null,null,null,"Criterio de decisión: ","No rechazar la hipótesis nula"]

{"sheet":"Razon var","index":3,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,1,11,2]]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Modelo de cola a la izquierda",null,null,"Modelo de cola a la derecha",null,null,null,"Modelo de cola bilateral"]
[]
[]
[]
[null,null,null,null,null,null,null,"Muestra 1","Muestra 2"]
[null,"Selecciona el modelo",null,null,null,null,"Tamaño de muestra: ",21,21]
[null,null,null,null,null,null,"Varianzas muestrales: ",10072.473099999999,3067.49775]
[null,null,null,null,null,null,"Nivel de significación: ",0.05]
[]
[]
[]
[null,null,null,null,null,"Valor crítico: ",{"$f":"FINV(1-$H$14/2,$H$12-1,$I$12-1)","v":0.40576440292567939}]
[null,null,null,null,null,"Estadístico de la prueba: ",3.2836122210684584,null,null,null,"p Valor: ",{"$f":"FDIST($G$19,$H$12-1,$I$12-1)","v":5.313339136544519E-3}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"FDIST($G$19,$H$12-1,$I$12-1)","v":5.313339136544519E-3}]
[null,null,null,null,null,"Criterio de decisión: ","Rechazar la Hipótesis nula"]

{"sheet":"Dif medias","index":4,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,1,11,2]]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Modelo de cola a la izquierda",null,null,"Modelo de cola a la derecha",null,null,null,"Modelo de cola bilateral"]
[]
[]
[null,null,null,null,null,null,"Varianzas poblacionales: ",null,1.5]
[]
[null,"Selecciona el modelo",null,null,null,null,null,"Muestra 1","Muestra 2",null,null,null,"Comparación de varianzas"]
[null,null,null,null,null,null,"Tamaño de muestra: ",21,21,null,null,null,"Fc = ",3.2836121893747783]
[null,null,null,null,null,null,"Varianza muestrales: ",100.361711,55.384995799999999,null,null,null,"pValor = ",{"$f":"FDIST($N$13,$H$13-1,$I$13-1)","v":5.3133394368097379E-3}]
[null,null,null,null,null,null,"Medias muestrales: ",8451.64,2062.8304800000001,null,null,null,"Varianzas diferentes.",3]
[null,null,null,null,null,null,"Nivel de significación: ",0.05,32.262569987027085]
[]
[null,null,null,null,null,"Valor crítico: ",{"$f":"(-1)*TINV($H$16,$I$16)","v":-2.0369333344070331},{"$f":"TINV($H$16,$I$16)","v":2.0369333344070331}]
[null,null,null,null,null,"Estadístico de la prueba: ",255.40675975533384,null,null,null,"p Valor = ",{"$f":"2*TDIST(ABS($G$19),$I$16,1)","v":1.5618104171722997E-54}]
[]
[null,null,null,null,null,"Criterio de decisión: ","Rechazar la Hipótesis nula"]

{"sheet":"Dif prop","index":5,"n_rows":21,"n_cols":26,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,1,11,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelo de cola a la izquierda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelo de cola a la derecha"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modelo de dos colas"]
[]
[]
[]
[null,null,null,"Modelo de cola a la izquierda",null,null,"Modelo de cola a la derecha",null,null,null,"Modelo de cola bilateral"]
[]
[]
[]
[]
[null,"Selecciona el modelo"]
[]
[]
[]
[]
[null,"Muestra 1","Muestra 2"]
["Tamaño: ",600,300,null,null,"Valor crítico: ",{"$f":"NORMSINV($B$20/2)","v":-1.9599639845400545},{"$f":"NORMSINV(1-$B$20/2)","v":1.959963984540054}]
["Proporción: ",0.25,0.18,null,null,"Estadístico de la prueba: ",2.4679423797583553,null,null,null,"p Valor: ",{"$f":"2*(1-NORMDIST($G$19,0,1,1))","v":1.3589219206120218E-2}]
["Nivel de significación: ",0.05]
[null,null,null,null,null,"Criterio de decisión: ","Rechazar la Hipótesis nula"]