{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Hoja1","Hoja2","Hoja3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Hoja1","index":0,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"      PROPIEDADES DE LA MEDIA ARITMETICA Y LA DESVIACION TIPICA"]
[]
[]
[]
[null,null,"       INSTRUCCIONES"]
[]
[null,"Escribe datos en la columna B Valores de la tabla de abajo (no más de 10)"]
[]
[null,"Usa la barra de desplazamiento para alejar o acercar a la media el valor de K"]
[null,"Observarás que la suma de desviaciones (X-K) se acerca a cero"]
[null,"y la suma de (X-K)^2 se hace MINIMA."]
[]
[null,"Puedes alterar los datos hasta conseguir un valor determinado de la media."]
[null,"Verás que los valores extremos influyen bastante."]
[]
[]
["N° ORDEN"," VALORES"," (X-K)","(X-K)^2"]
[null,null,null,null,null,"    VALOR DE K"]
[1,1,{"$f":"B20-F$21","v":-1.9000000000000004},{"$f":"C20^2","v":3.6100000000000012}]
[2,2,{"$f":"B21-F$21","v":-0.90000000000000036},{"$f":"C21^2","v":0.81000000000000061},null,{"$f":"J24*0.1","v":2.9000000000000004},null,null,"Barra para fijar el valor de K"]
[3,9,6.1,37.209999999999994]
[4,2,-0.90000000000000036,0.81000000000000061,null,"  NUMERO DE DATOS"]
[5,2,-0.90000000000000036,0.81000000000000061,null,null,null,null,null,29]
[6,7,4.0999999999999996,16.809999999999999,null,10]
[7,3,9.9999999999999645E-2,9.9999999999999291E-3]
[8,2,-0.90000000000000036,0.81000000000000061,null,"VALOR DE LA MEDIA"]
[9,3,9.9999999999999645E-2,9.9999999999999291E-3]
[10,2,-0.90000000000000036,0.81000000000000061,null,{"$f":"AVERAGE(B20:B29)","v":3.3}]
["Sumas",10,{"$f":"SUM(C20:C29)","v":3.9999999999999964},{"$f":"SUM(D20:D29)","v":61.7}]
[]
[]
[null,"Suma desviaciones",null,{"$f":"C30","v":3.9999999999999964}]
[]
[null,"Suma de cuadrados",null,{"$f":"D30","v":61.7}]

{"sheet":"Hoja2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Hoja3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}