{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Información","Saldos","Ejemplo 1","Ejemplo 2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Información","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Para obtener la tabla de frecuencia y ciertos estadísticos:"]
[]
[]
[]
[null,null," 1. Ingrese los datos en una de las columnas A, B o C de una hoja."]
[null,null,"    Si desea inserte una nueva hoja e ingrese sus datos en ella."]
[null,null," 2. Haga clic en la niñita"]
[]
[null,null," 3. Debe ingresar el nombre de la hoja donde están los datos."]
[null,null,"    Si desea, cambie de nombre a la hoja o use el nombre que tiene"]

{"sheet":"Saldos","index":1,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Saldos","Zona A","Zona B",null,{"$f":"AVERAGE(Datos)","v":18584.420999999998}]
[21290.71,34,30]
[16049.04,26,29]
[13953.31,22,35]
[13690.46,21,34,null,"TABLA DE DISTRIBUCIÓN DE FRECUENCIAS"]
[12623.96,24,23,"Tamaño de muestra",50]
[13740.61,30,30,"Maximo",{"$f":"MAX(Datos)","v":24964.17}]
[13239.35,22,43,"Minimo",{"$f":"MIN(Datos)","v":12623.96}]
[24876.12,17,29,"Rango",{"$f":"MAX(Datos)-MIN(Datos)","v":12340.21}]
[22958.41,28,21,"Nro. intervalos",{"$f":"ROUND(1+3.322*LOG(E6),0)","v":7}]
[20086.77,20,28,"Amplitud",{"$f":"(MAX(Datos)-MIN(Datos)) / E10","v":1762.8871428571426}]
[19207.84,27,23]
[13814.31,20,19,"No de Int.","Lim. Inf.","Lim. Sup.","Pto. Medio","fi","Fi","hi","Hi"]
[13658.08,17,26,1,12623.96,14386.847142857141,13505.403571428571,{"$f":"FREQUENCY(Datos,Rango)","v":14},14,0.28000000000000003,0.28000000000000003]
[24963.82,23,32,2,14386.847142857141,16149.734285714283,15268.290714285711,2,16,0.04,0.32]
[13948.44,37,28,3,16149.734285714283,17912.621428571427,17031.177857142855,3,19,0.06,0.38]
[14330.13,15,26,4,17912.621428571427,19675.508571428571,18794.064999999999,9,28,0.18,0.56000000000000005]
[21324.99,21,27,5,19675.508571428571,21438.395714285714,20556.952142857142,9,37,0.18,0.74]
[24730.44,15,24,6,21438.395714285714,23201.282857142858,22319.839285714286,6,43,0.12,0.86]
[21301.58,39,21,7,23201.282857142858,24964.170000000002,24082.72642857143,7,50,0.14000000000000001,1]
[19606.169999999998,44,36]
[22962.68,17,34]
[22686.22,25,35,"ESTADISTICAS MAS FRECUENTES"]
[16488.55,23,27,"Cuando los datos de la muestra están:"]
[24964.17,33,29,null,"No agrupados","Agrupados"]
[17642.09,19,33,"Media = ",{"$f":"AVERAGE(Datos)","v":18584.420999999998},{"$f":"SUMPRODUCT(PMedio,FAbs)/SUM(FAbs)","v":18547.2608}]
[18067.28,null,null,"Mediana = ",{"$f":"MEDIAN(Datos)","v":19111.915000000001},19087.879523809523]
[16469.57,null,null,"Moda = ",{"$f":"MODE(Datos)","v":{"$error":"#N/A"}}]
[24018.46,null,null,"Quartil 1 = ",{"$f":"QUARTILE(Datos,1)","v":14047.514999999999},14197.96637755102]
[18227.52,null,null,"Quartil 3 = ",{"$f":"QUARTILE(Datos,3)","v":21662.025000000001},21585.302976190476]
[21774.37,null,null,"Rango Intercuartílico = ",7614.510000000002,7387.3365986394565]
[14547.88,null,null,"Varianza = ",{"$f":"VAR(Datos)","v":15527473.031201109},14715613.17596342]
[13382.21,null,null,"Desviación estándar = ",{"$f":"STDEV(Datos)","v":3940.4914707687299},{"$f":"SQRT(F32)","v":3836.0934785225736}]
[22361.73,null,null,"Coef. de Variación = ",{"$f":"STDEV(Datos)/AVERAGE(Datos)","v":0.21203197402645638}]
[18363.98,null,null,"Coef. Asimetría (Pearson) = ",{"$f":"(AVERAGE(Datos)-MODE(Datos))/STDEV(Datos)","v":{"$error":"#N/A"}}]
[13136.29,null,null,"Coef. Asimetría (Bowley) = ",{"$f":"(QUARTILE(Datos,3)+QUARTILE(Datos,1)-2*MEDIAN(Datos))/(QUARTILE(Datos,3)-QUARTILE(Datos,1))","v":-0.3301972155792034}]
[17943.259999999998,null,null,"Coef. Asimetría (Fisher) = ",{"$f":"SKEW(Datos)","v":-3.0326587692771103E-2}]
[13085.41]
[18881.71]
[19015.990000000002]
[22212.85]
[20027.28]
[23325.040000000001]
[19886.39]
[19927.759999999998]
[19340.75]
[20144.16]
[20280.38]
[13873.23]
[13030.2]
[23759.1]

{"sheet":"Ejemplo 1","index":2,"n_rows":2075,"n_cols":11,"rows_kept":2075,"cut":false,"hidden":false,"merged":[]}
["Saldo","Muestra 302",null,null,{"$f":"AVERAGE(Datos)","v":18584.420999999998}]
[1756,1756]
[748,748]
[1501,1501]
[1831,1831,null,null,"TABLA DE DISTRIBUCIÓN DE FRECUENCIAS"]
[1622,1622,null,"Tamaño de muestra",2074]
[1886,1886,null,"Maximo",{"$f":"MAX(Datos)","v":24964.17}]
[740,740,null,"Minimo",{"$f":"MIN(Datos)","v":12623.96}]
[1593,1593,null,"Rango",{"$f":"MAX(Datos)-MIN(Datos)","v":12340.21}]
[1169,1169,null,"Nro. intervalos",{"$f":"ROUND(1+3.322*LOG(E6),0)","v":12}]
[2125,2125,null,"Amplitud",{"$f":"(MAX(Datos)-MIN(Datos)) / E10","v":1028.3508333333332}]
[1554,1554]
[1474,1474,null,"No de Int.","Lim. Inf.","Lim. Sup.","Pto. Medio","fi","Fi","hi","Hi"]
[1913,1913,null,1,32,327.5,179.75,{"$f":"FREQUENCY(Datos,Rango)","v":14},87,4.1947926711668276E-2,4.1947926711668276E-2]
[1218,1218,null,2,327.5,623,475.25,2,186,4.7733847637415623E-2,8.9681774349083893E-2]
[1006,1006,null,3,623,918.5,770.75,3,286,4.8216007714561235E-2,0.13789778206364511]
[2215,2215,null,4,918.5,1214,1066.25,9,525,0.11523625843780134,0.25313404050144644]
[137,137,null,5,1214,1509.5,1361.75,9,828,0.14609450337512053,0.39922854387656698]
[167,167,null,6,1509.5,1805,1657.25,6,1111,0.1364513018322083,0.53567984570877525]
[343,343,null,7,1805,2100.5,1952.75,7,1399,0.13886210221793635,0.67454194792671163]
[2557,2557,null,8,2100.5,2396,2248.25,0,1653,0.12246865959498554,0.79701060752169717]
[2276,2276,null,9,2396,2691.5,2543.75,{"$error":"#N/A"},1770,5.6412729026036647E-2,0.85342333654773384]
[1494,1494,null,10,2691.5,2987,2839.25,{"$error":"#N/A"},1872,4.9180327868852458E-2,0.90260366441658624]
[2144,2144,null,11,2987,3282.5,3134.75,{"$error":"#N/A"},1961,4.29122468659595E-2,0.94551591128254575]
[1995,1995,null,12,3282.5,3578,3430.25,{"$error":"#N/A"},2074,5.4484088717454193E-2,1]
[1053,1053]
[1526,1526]
[1120,1120,null,"ESTADISTICAS MAS FRECUENTES"]
[1838,1838,null,"Cuando los datos de la muestra están:"]
[1746,1746,null,null,"No agrupados","Agrupados"]
[1616,1616,null,"Media = ",{"$f":"AVERAGE(Datos)","v":18584.420999999998},{"$f":"SUMPRODUCT(PMedio,FAbs)/SUM(FAbs)","v":18547.2608}]
[1958,1958,null,"Mediana = ",{"$f":"MEDIAN(Datos)","v":19111.915000000001},1727.7314487632509]
[634,634,null,"Moda = ",{"$f":"MODE(Datos)","v":{"$error":"#N/A"}},1439.1428571428571]
[580,580,null,"Quartil 1 = ",{"$f":"QUARTILE(Datos,1)","v":14047.514999999999},1205.9633891213389]
[1320,1320,null,"Quartil 3 = ",{"$f":"QUARTILE(Datos,3)","v":21662.025000000001},2282.5698818897636]
[1675,1675,null,"Rango Intercuartílico = ",1058.5,1076.6064927684247]
[789,789,null,"Varianza = ",{"$f":"VAR(Datos)","v":15527473.031201109},670469.97119390103]
[1735,1735,null,"Desviación estándar = ",{"$f":"STDEV(Datos)","v":3940.4914707687299},{"$f":"SQRT(F37)","v":818.82230745986703}]
[1784,1784,null,"Coef. de Variación = ",{"$f":"STDEV(Datos)/AVERAGE(Datos)","v":0.21203197402645638}]
[1326,1326]
[2051,2051]
[1044,1044]
[1885,1885]
[1790,1790]
[765,765]
[1645,1645]
[32,32]
[1266,1266]
[890,890]
[2204,2204]
[2409,2409]
[1338,1338]
[2076,2076]
[1708,1708]
[2138,2138]
[2375,2375]
[1455,1455]
[1487,1487]
[1125,1125]
[1989,1989]
[2156,2156]
[2172,2172]
[1515,1515]
[2028,2028]
[1565,1565]
[1658,1658]
[1393,1393]
[1964,1964]
[1186,1186]
[1047,1047]
[1647,1647]
[2158,2158]
[1973,1973]
[2124,2124]
[1376,1376]
[1762,1762]
[1798,1798]
[1957,1957]
[123,123]
[1419,1419]
[1326,1326]
[1922,1922]
[1253,1253]
[1574,1574]
[2077,2077]
[1889,1889]
[2206,2206]
[1147,1147]
[2317,2317]
[1073,1073]
[1668,1668]
[1490,1490]
[2234,2234]
[2055,2055]
[2142,2142]
[1538,1538]
[1408,1408]
[1737,1737]
[2089,2089]
[2030,2030]
[1501,1501]
[1017,1017]
[1032,1032]
[1550,1550]
[1690,1690]
[1690,1690]
[1903,1903]
[1480,1480]
[2148,2148]
[1979,1979]
[2108,2108]
[1413,1413]
[1751,1751]
[1203,1203]
[1000,1000]
[1380,1380]
[1026,1026]
[1611,1611]
[1088,1088]
[1635,1635]
[325,325]
[1612]
[1535]
[2085]
[1061]
[2040]
[1811]
[65]
[1481]
[2212]
[2058]
[1509]
[1682]
[1004]
[2050]
[1738]
[2273]
[1446]
[1136]
[2273]
[1644]
[1569]
[2161]
[2002]
[1317]
[2132]
[1075]
[2067]
[1427]
[2125]
[2187]
[1668]
[1339]
[68]
[1160]
[1680]
[2154]
[1396]
[1139]
[1211]
[2248]
[1950]
[1037]
[2114]
[65]
[1950]
[2015]
[1608]
[2285]
[1375]
[1295]
[1459]
[1261]
[1886]
[1966]
[1700]
[1423]
[1072]
[1954]
[2113]
[1659]
[1519]
[2012]
[1895]
[1645]
[2115]
[1032]
[1301]
[2300]
[1674]
[1160]
[1735]
[1280]
[2258]
[2168]
[1283]
[1874]
[1190]
[1213]
[1030]
[1221]
[1572]
[2159]
[2004]
[1200]
[1203]
[1948]
[1139]
[2320]
[80]
[2290]
[2300]
[1351]
[2088]
[1912]
[1646]
[1144]
[2251]
[1490]
[2227]
[1455]
[1257]
[1482]
[2114]
[1842]
[1655]
[1076]
[1501]
[1411]
[1866]
[1503]
[1959]
[1709]
[1868]
[1942]
[1573]
[1922]
[1654]
[2317]
[1255]
[1479]
[1196]
[1332]
[1985]
[1895]
[2122]
[1147]
[1862]
[1530]
[2216]
[2172]
[1565]
[1881]
[1659]
[2240]
[1303]
[1955]
[2296]
[1094]
[1973]
[1467]
[1803]
[1973]
[1360]
[1969]
[1910]
[1337]
[2194]
[1199]
[1328]
[2233]
[2236]
[54]
[1322]
[1036]
[2196]
[1301]
[1313]
[1447]
[1031]
[1777]
[1457]
[1517]
[2098]
[1799]
[1864]
[1509]
[1715]
[1325]
[1511]
[2233]
[1780]
[1121]
[2187]
[2311]
[1000]
[2112]
[1744]
[1651]
[1280]
[1395]
[1646]
[1252]
[1822]
[1789]
[1904]
[2055]
[1344]
[1963]
[1510]
[1751]
[1881]
[1819]
[1286]
[1696]
[2040]
[1558]
[1452]
[1494]
[1589]
[2278]
[1689]
[1811]
[1552]
[2165]
[2299]
[1595]
[1790]
[1356]
[1367]
[1630]
[1040]
[1401]
[1898]
[1458]
[78]
[1364]
[2025]
[1654]
[1192]
[1522]
[1406]
[2296]
[1072]
[2319]
[1849]
[2067]
[2057]
[2274]
[2140]
[1644]
[1107]
[1146]
[1425]
[1835]
[1026]
[1130]
[1430]
[1935]
[1341]
[1267]
[1615]
[1920]
[1089]
[2111]
[1158]
[1509]
[1851]
[1664]
[1149]
[1814]
[1412]
[2237]
[1538]
[2084]
[1811]
[1351]
[1581]
[1895]
[1349]
[1250]
[1842]
[1512]
[1263]
[1490]
[2296]
[1756]
[1592]
[1322]
[1623]
[1825]
[2104]
[2271]
[2275]
[1233]
[1188]
[1879]
[1239]
[65]
[1504]
[2180]
[1520]
[1718]
[2154]
[2289]
[1069]
[2111]
[1335]
[1095]
[2173]
[1241]
[1509]
[2010]
[1340]
[1411]
[1559]
[1104]
[2206]
[1574]
[2216]
[2309]
[1620]
[1816]
[1073]
[2305]
[1892]
[1489]
[2224]
[1395]
[1593]
[1031]
[2194]
[1482]
[1656]
[1613]
[1921]
[1644]
[1679]
[1662]
[1409]
[1075]
[1719]
[1972]
[2262]
[1745]
[1609]
[1493]
[1544]
[1212]
[1382]
[1004]
[2178]
[2134]
[1988]
[1046]
[1626]
[1404]
[2065]
[1083]
[1249]
[2205]
[70]
[1929]
[1162]
[2160]
[1895]
[1096]
[2147]
[1002]
[2183]
[2302]
[2041]
[1346]
[1359]
[2027]
[1391]
[1834]
[2233]
[1292]
[1040]
[1400]
[1362]
[2199]
[1877]
[1766]
[1961]
[1351]
[1940]
[1607]
[1956]
[1444]
[1584]
[1885]
[1142]
[2094]
[2156]
[1533]
[1465]
[1028]
[2274]
[1386]
[1132]
[1118]
[1103]
[1437]
[1003]
[1334]
[2040]
[1227]
[2000]
[1122]
[1383]
[2304]
[1532]
[1972]
[2309]
[1178]
[1425]
[1521]
[1890]
[1144]
[1116]
[1692]
[1814]
[2206]
[1975]
[2228]
[2229]
[2000]
[1493]
[2040]
[1983]
[2273]
[1809]
[1502]
[2082]
[1081]
[1519]
[1563]
[1064]
[1057]
[1834]
[1669]
[1743]
[1144]
[45]
[1000]
[2080]
[1086]
[2256]
[1928]
[1346]
[1110]
[1746]
[1848]
[1210]
[1589]
[1854]
[1146]
[1812]
[1891]
[1070]
[1620]
[1497]
[1634]
[2285]
[1890]
[2308]
[1042]
[1739]
[1942]
[1380]
[1454]
[1784]
[1542]
[1205]
[1304]
[2073]
[1666]
[1251]
[1621]
[1433]
[1405]
[1114]
[2120]
[1698]
[1570]
[2060]
[1186]
[1842]
[1794]
[1613]
[1677]
[2159]
[1159]
[1295]
[2244]
[2002]
[2113]
[1794]
[1797]
[1519]
[2114]
[1076]
[2009]
[1356]
[1192]
[1181]
[1944]
[1864]
[2297]
[1442]
[2246]
[2083]
[1025]
[1794]
[2066]
[1698]
[2037]
[2319]
[1383]
[1535]
[1690]
[1102]
[1689]
[1562]
[1591]
[2219]
[1374]
[1700]
[2004]
[1060]
[1235]
[2105]
[1131]
[2308]
[1997]
[1190]
[1718]
[1611]
[1288]
[1294]
[1808]
[1318]
[2005]
[1248]
[2185]
[1165]
[1488]
[2314]
[80]
[1175]
[1799]
[1906]
[2118]
[1751]
[1740]
[1319]
[2228]
[1729]
[1773]
[1265]
[1209]
[1557]
[1459]
[1127]
[1587]
[1870]
[1330]
[1793]
[2275]
[1684]
[2249]
[1260]
[2155]
[2125]
[1151]
[1412]
[2235]
[1215]
[2225]
[1190]
[1303]
[1301]
[1220]
[1299]
[1712]
[1723]
[2219]
[1352]
[1271]
[1404]
[1417]
[1913]
[1527]
[1305]
[2066]
[1370]
[1902]
[2070]
[1508]
[1406]
[1096]
[1468]
[2196]
[1494]
[2271]
[1650]
[1254]
[1869]
[1148]
[1523]
[1176]
[120]
[1252]
[1428]
[1119]
[1127]
[1000]
[1558]
[2018]
[2125]
[1194]
[1707]
[2236]
[1705]
[1346]
[1235]
[1613]
[1295]
[1680]
[1647]
[1345]
[1309]
[1266]
[1266]
[2264]
[1962]
[1495]
[2050]
[2090]
[1417]
[1707]
[1950]
[1711]
[2102]
[2005]
[1303]
[2015]
[2150]
[1092]
[1733]
[2181]
[1294]
[2036]
[130]
[2131]
[2231]
[1220]
[1662]
[2300]
[2320]
[2037]
[1699]
[1144]
[1959]
[1932]
[1014]
[1329]
[1541]
[2175]
[2206]
[1321]
[2099]
[1307]
[1284]
[1954]
[1781]
[2184]
[1997]
[1412]
[1502]
[2044]
[1919]
[1672]
[1520]
[2238]
[2103]
[1416]
[2014]
[1208]
[1147]
[1552]
[2150]
[1935]
[1565]
[1799]
[2312]
[1906]
[1359]
[2016]
[1593]
[1010]
[1208]
[1646]
[1131]
[2109]
[1240]
[1166]
[2308]
[2044]
[1136]
[1110]
[2184]
[1023]
[2102]
[1585]
[1108]
[2159]
[1666]
[1096]
[2115]
[1693]
[1258]
[1197]
[2033]
[1574]
[2094]
[1373]
[1407]
[1618]
[1321]
[2182]
[1200]
[1698]
[230]
[2222]
[1117]
[1061]
[1999]
[1352]
[712]
[3175]
[1376]
[1564]
[1297]
[293]
[1579]
[2646]
[447]
[3074]
[2054]
[1775]
[501]
[935]
[2323]
[2021]
[3348]
[3558]
[1454]
[2541]
[2153]
[2369]
[3419]
[1450]
[3034]
[3427]
[1998]
[2590]
[3522]
[3414]
[2706]
[168]
[2269]
[2430]
[2898]
[2161]
[3430]
[574]
[2593]
[2111]
[3567]
[2883]
[1584]
[2405]
[1982]
[300]
[1224]
[1594]
[1325]
[2786]
[1320]
[1507]
[2352]
[2392]
[2484]
[1783]
[320]
[1719]
[2795]
[2415]
[474]
[1817]
[3376]
[404]
[494]
[605]
[2830]
[739]
[1318]
[2876]
[1637]
[1262]
[1811]
[1601]
[1031]
[2140]
[155]
[1563]
[3210]
[2720]
[3179]
[2496]
[905]
[1086]
[389]
[2094]
[1083]
[1394]
[2469]
[2367]
[1474]
[256]
[1980]
[2964]
[1873]
[3253]
[1976]
[2987]
[1404]
[1175]
[2056]
[378]
[902]
[411]
[472]
[759]
[2173]
[699]
[794]
[2946]
[423]
[1615]
[399]
[3570]
[740]
[2678]
[2368]
[1667]
[1100]
[669]
[1920]
[941]
[2428]
[1963]
[2981]
[1911]
[2984]
[329]
[196]
[1220]
[711]
[2205]
[1499]
[2283]
[477]
[1775]
[2994]
[168]
[2608]
[2412]
[2702]
[2494]
[3380]
[220]
[2257]
[648]
[2302]
[889]
[218]
[2584]
[743]
[1784]
[2267]
[3263]
[2045]
[2742]
[1161]
[1133]
[1157]
[1500]
[494]
[2404]
[732]
[763]
[2770]
[943]
[2296]
[2431]
[954]
[2478]
[2486]
[2786]
[3503]
[1502]
[3043]
[2920]
[201]
[3068]
[1422]
[1732]
[2286]
[666]
[1386]
[2632]
[929]
[328]
[1437]
[1029]
[1361]
[3494]
[754]
[2051]
[739]
[3328]
[1936]
[336]
[3178]
[1715]
[3308]
[1769]
[864]
[2910]
[1583]
[3517]
[2512]
[2080]
[123]
[2376]
[1063]
[1405]
[3435]
[3569]
[2894]
[3186]
[932]
[2775]
[2678]
[664]
[1260]
[1582]
[2849]
[3522]
[3508]
[2132]
[2547]
[2237]
[2843]
[1000]
[1934]
[2009]
[526]
[2957]
[1951]
[1494]
[3526]
[1383]
[932]
[2000]
[1432]
[1996]
[696]
[3143]
[378]
[1325]
[2841]
[3334]
[2786]
[106]
[1292]
[1726]
[2939]
[2983]
[982]
[2540]
[2139]
[434]
[3178]
[3524]
[3013]
[1333]
[3144]
[551]
[1171]
[3088]
[2419]
[1935]
[2753]
[2217]
[2759]
[370]
[179]
[1960]
[3193]
[634]
[1116]
[3439]
[1525]
[2639]
[2348]
[2279]
[1710]
[1864]
[2438]
[2335]
[3355]
[3496]
[937]
[446]
[1907]
[1895]
[3089]
[787]
[1397]
[159]
[1894]
[1262]
[2673]
[1500]
[1924]
[1341]
[2604]
[1750]
[762]
[1996]
[3048]
[3184]
[2060]
[2171]
[867]
[786]
[343]
[1117]
[1452]
[994]
[2447]
[2002]
[1824]
[2223]
[2023]
[2185]
[927]
[258]
[1033]
[983]
[170]
[110]
[2942]
[2312]
[788]
[2332]
[2856]
[3538]
[2674]
[1024]
[350]
[395]
[792]
[365]
[837]
[3387]
[1448]
[2596]
[3495]
[2350]
[418]
[1010]
[3344]
[2323]
[430]
[1768]
[345]
[109]
[2979]
[3022]
[3092]
[2653]
[2256]
[3095]
[205]
[1271]
[1643]
[1221]
[2803]
[2351]
[903]
[2025]
[784]
[2512]
[3338]
[1219]
[2108]
[3336]
[1966]
[190]
[437]
[2214]
[3317]
[1229]
[3249]
[426]
[1495]
[3553]
[3475]
[1142]
[2037]
[2331]
[2005]
[1185]
[2479]
[604]
[2654]
[1883]
[1492]
[3168]
[626]
[2714]
[2137]
[1084]
[891]
[917]
[2584]
[577]
[3021]
[2350]
[2721]
[963]
[2768]
[2380]
[2087]
[1752]
[2914]
[2906]
[2039]
[3283]
[1502]
[1288]
[3271]
[2884]
[1566]
[3337]
[2546]
[2482]
[328]
[976]
[141]
[2462]
[549]
[1582]
[1609]
[751]
[2461]
[2979]
[1288]
[1017]
[3312]
[1526]
[494]
[1865]
[793]
[1669]
[542]
[1598]
[2202]
[2755]
[2161]
[3372]
[1256]
[2842]
[806]
[450]
[648]
[2325]
[3397]
[2335]
[2321]
[2845]
[1418]
[2072]
[1131]
[3240]
[2986]
[517]
[2493]
[1340]
[3536]
[1207]
[1288]
[1852]
[600]
[395]
[2016]
[2756]
[2098]
[2272]
[2767]
[112]
[3343]
[710]
[481]
[1790]
[1286]
[2933]
[1203]
[2481]
[607]
[2514]
[2615]
[1457]
[2493]
[2282]
[1751]
[1664]
[1212]
[2863]
[3200]
[1195]
[1347]
[2885]
[2822]
[2664]
[3093]
[1477]
[2154]
[3496]
[1230]
[3417]
[3132]
[901]
[1387]
[481]
[943]
[3357]
[2167]
[3135]
[1846]
[2554]
[2019]
[170]
[2962]
[3130]
[114]
[1158]
[1112]
[1448]
[845]
[3398]
[910]
[2316]
[1574]
[1189]
[1253]
[2521]
[1398]
[3108]
[1551]
[1173]
[145]
[3295]
[840]
[536]
[3321]
[153]
[539]
[3046]
[2007]
[3324]
[3070]
[2475]
[779]
[2822]
[1863]
[364]
[1254]
[887]
[2483]
[2243]
[1420]
[1082]
[2448]
[432]
[1310]
[3449]
[1740]
[3251]
[2590]
[422]
[2714]
[530]
[3290]
[167]
[3001]
[1783]
[3316]
[927]
[1227]
[1586]
[876]
[2609]
[644]
[2027]
[1893]
[2455]
[1640]
[1163]
[1548]
[1133]
[2894]
[778]
[272]
[842]
[679]
[3285]
[3481]
[1051]
[1940]
[2522]
[2278]
[2240]
[254]
[3421]
[3082]
[3148]
[720]
[1136]
[306]
[1651]
[2890]
[2871]
[3068]
[2520]
[2628]
[1417]
[1694]
[348]
[1710]
[3190]
[273]
[2611]
[1305]
[505]
[2062]
[1064]
[2364]
[451]
[3391]
[1080]
[463]
[883]
[3303]
[772]
[2077]
[992]
[877]
[1603]
[3563]
[3301]
[931]
[340]
[552]
[2073]
[146]
[586]
[3206]
[2721]
[2572]
[743]
[2396]
[993]
[2670]
[2001]
[3476]
[2385]
[591]
[2512]
[1586]
[833]
[3019]
[1210]
[3416]
[1059]
[1137]
[1251]
[2219]
[3149]
[780]
[3299]
[2544]
[168]
[3469]
[2823]
[1239]
[3148]
[1306]
[2279]
[3380]
[1181]
[1796]
[2904]
[1410]
[1369]
[935]
[1250]
[3237]
[1993]
[3439]
[1244]
[3578]
[463]
[2068]
[2862]
[1071]
[1922]
[3105]
[1768]
[2382]
[1127]
[2391]
[2875]
[3259]
[2676]
[2638]
[1953]
[1502]
[1542]
[2803]
[272]
[3230]
[1021]
[1178]
[706]
[3449]
[2846]
[2195]
[1686]
[1823]
[1611]
[3472]
[682]
[3114]
[1724]
[2057]
[2797]
[3153]
[1288]
[1023]
[1329]
[2944]
[2190]
[1058]
[999]
[1908]
[2942]
[394]
[1273]
[1256]
[1347]
[1183]
[1979]
[2315]
[1926]
[619]
[2283]
[1633]
[3127]
[3506]
[961]
[2454]
[2920]
[2020]
[3472]
[947]
[1139]
[2152]
[2972]
[1309]
[1604]
[352]
[1725]
[308]
[1763]
[1025]
[817]
[3575]
[1648]
[1837]
[1889]
[2428]
[195]
[1623]
[896]
[1125]
[880]
[718]
[3407]
[809]
[1520]
[635]
[2149]
[3304]
[699]
[741]
[526]
[1744]
[2066]
[3570]
[2942]
[2524]
[2500]
[1951]
[1630]
[978]
[2161]
[231]
[1475]
[3568]
[1590]
[1735]
[1891]
[3311]
[2037]
[291]
[1869]
[643]
[1930]
[1121]
[3300]
[417]
[2036]
[2965]
[2427]
[123]
[3207]
[1081]
[2878]
[2936]
[146]
[850]
[2802]
[1715]
[2279]
[1924]
[874]
[2483]
[176]
[1564]
[3132]
[1480]
[1861]
[1759]
[2363]
[2130]
[456]
[3189]
[346]
[1443]
[1268]
[2642]
[109]
[3281]
[2954]
[1687]
[3174]
[648]
[2248]
[555]
[1874]
[3459]
[2426]
[2700]
[2100]
[1225]
[1831]
[2171]
[1904]
[2913]
[1923]
[1903]
[1245]
[1357]
[1784]
[1417]
[2035]
[1956]
[2571]
[1444]
[1171]
[1628]
[1751]
[2604]
[3498]
[3073]
[2416]
[375]
[1679]
[3142]
[144]
[2321]
[3408]
[1904]
[1243]
[2198]
[3272]
[1822]
[994]
[1786]
[940]
[1939]
[2505]
[1742]
[908]
[2176]
[3189]
[1939]
[2955]
[2356]
[1173]
[3371]
[3340]
[1630]
[1837]
[3516]
[1868]
[2644]
[2596]
[252]
[2609]
[3043]
[1308]
[1738]
[502]
[336]
[3030]
[3381]
[2962]
[2934]
[646]
[786]
[3228]
[1334]
[2119]
[3381]
[2152]
[1361]
[2365]
[1477]
[167]
[2707]
[2291]
[1016]
[3087]
[1213]
[3356]
[1716]
[2627]
[2984]
[889]
[214]
[2422]
[2540]
[2883]
[894]
[2293]
[1563]
[1118]
[3381]
[2400]
[2189]
[1994]
[591]
[620]
[2765]
[3309]
[1791]
[414]
[567]
[2102]
[2352]
[231]
[3495]
[2250]
[3220]
[1726]
[824]
[1973]
[1591]
[265]
[1460]
[386]
[3339]
[3210]
[2665]
[1351]
[2912]
[1773]
[597]
[2219]
[1621]
[1823]
[497]
[2736]
[2820]
[162]
[1503]
[2707]
[2707]
[2624]
[3547]
[977]
[2506]
[276]
[1967]
[2617]
[1494]
[3348]
[1106]
[1979]
[1674]
[2979]
[2544]
[2320]
[2124]
[2477]
[2337]
[1810]
[2658]
[2455]
[1404]
[2283]
[814]
[2232]
[2540]
[2635]
[418]
[3508]
[1753]
[2544]
[1002]
[3099]
[2540]
[369]
[3278]
[2305]
[2676]
[1828]
[3523]
[2427]
[1544]
[3508]
[3526]
[3439]
[1633]
[1335]
[1962]
[3196]
[1883]
[1916]
[2657]
[1541]
[2219]
[372]
[3072]
[161]
[2316]
[1124]
[2151]
[420]
[2316]
[1572]
[3148]
[1519]
[2409]
[1131]
[2012]
[2694]
[3435]
[646]
[1967]
[1137]
[3174]
[1619]
[241]
[2642]
[614]
[261]
[2741]
[223]
[1427]
[119]
[1218]
[3380]
[285]
[2511]
[1134]
[462]
[2927]
[3506]
[3278]
[1723]
[2772]
[1521]
[962]
[630]
[1757]
[1360]
[1475]
[1945]
[2499]
[2570]
[899]
[859]
[3529]
[1377]
[3281]
[3024]
[781]
[560]
[1969]
[2838]
[1134]
[346]
[950]
[1980]
[327]
[918]
[1262]
[2479]
[2815]
[1372]
[895]
[178]
[1851]
[828]
[1435]
[1341]
[205]
[2653]
[3239]
[955]
[2552]
[1608]
[1811]
[218]
[2715]
[2517]
[727]
[2506]
[906]
[1088]
[2056]
[351]
[1423]
[1298]
[2064]
[1817]
[458]
[2912]
[1877]
[977]
[1235]
[463]
[177]
[2295]
[1578]
[437]
[1154]
[1161]
[1227]
[1262]
[871]
[3552]
[2008]
[3506]
[1879]
[3449]
[971]
[3014]
[2375]
[883]
[2514]
[2332]
[1926]
[223]
[3368]
[3047]
[3342]
[118]
[1414]
[1889]
[3098]
[2105]
[1313]
[443]
[2724]
[3384]
[3511]
[1206]
[1098]
[983]
[593]
[3217]
[2445]
[3557]
[3113]
[875]
[397]
[1852]
[1455]
[2572]
[903]
[3184]
[1655]
[268]
[2311]
[1746]
[2185]
[264]
[1403]
[3374]
[3051]
[2938]
[3314]
[1721]
[351]
[2688]
[1713]
[727]
[3272]
[810]
[1657]
[2764]
[1760]
[1186]
[113]
[1983]
[3073]
[3569]
[2339]
[2114]
[238]
[1859]
[927]
[225]
[986]
[358]
[2518]
[608]
[1961]
[3240]
[1373]
[3376]
[1058]
[1541]
[1584]
[2817]

{"sheet":"Ejemplo 2","index":3,"n_rows":121,"n_cols":13,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
["dd","Muestra 331",null,null,{"$f":"AVERAGE(Datos)","v":18584.420999999998}]
[2797,1479]
[1847,1196]
[1928,1332,null,null,null,null,"TABLA DE DISTRIBUCIÓN DE FRECUENCIAS"]
[2316,1985,null,null,null,"Tamaño de muestra",120]
[2039,1895,null,null,null,"Maximo",{"$f":"MAX(Datos)","v":24964.17}]
[2199,2122,null,null,null,"Minimo",{"$f":"MIN(Datos)","v":12623.96}]
[2544,1147,null,null,null,"Rango",{"$f":"MAX(Datos)-MIN(Datos)","v":12340.21}]
[2891,1862,null,null,null,"Nro. intervalos",8]
[2733,1530,null,null,null,"Amplitud",{"$f":"(MAX(Datos)-MIN(Datos)) / G9","v":1542.5262499999999}]
[2009,2216]
[2085,2172,null,null,null,"No de Int.","Lim. Inf.","Lim. Sup.","Pto. Medio","fi","Fi","hi","Hi"]
[2438,1565,null,null,null,1,980,1147.375,1063.6875,{"$f":"FREQUENCY(Datos,Rango)","v":14},13,0.10833333333333334,0.10833333333333334]
[1924,1881,null,null,null,2,1147.375,1314.75,1231.0625,2,23,8.3333333333333329E-2,0.19166666666666665]
[1936,1659,null,null,null,3,1314.75,1482.125,1398.4375,3,45,0.18333333333333332,0.375]
[2067,2240,null,null,null,4,1482.125,1649.5,1565.8125,9,60,0.125,0.5]
[2938,1303,null,null,null,5,1649.5,1816.875,1733.1875,9,75,0.125,0.625]
[2823,1955,null,null,null,6,1816.875,1984.25,1900.5625,6,93,0.15,0.77500000000000002]
[1928,2296,null,null,null,7,1984.25,2151.625,2067.9375,7,103,8.3333333333333329E-2,0.85833333333333339]
[2737,1094,null,null,null,8,2151.625,2319,2235.3125,0,120,0.14166666666666666,1]
[1928,1973]
[2890,1467]
[2823,1803,null,null,null,"ESTADISTICAS MAS FRECUENTES"]
[1827,1973,null,null,null,"Cuando los datos de la muestra estáns:"]
[1827,1360,null,null,null,null,"No agrupados","Agrupados"]
[2484,1969,null,null,null,"Media = ",{"$f":"AVERAGE(Datos)","v":18584.420999999998},{"$f":"SUMPRODUCT(PMedio,FAbs)/SUM(FAbs)","v":18547.2608}]
[2844,1910,null,null,null,"Mediana = ",{"$f":"MEDIAN(Datos)","v":19111.915000000001},1649.5]
[2028,1337,null,null,null,"Moda = ",{"$f":"MODE(Datos)","v":{"$error":"#N/A"}},1420.4605263157896]
[2837,2194,null,null,null,"Quartil 1 = ",{"$f":"QUARTILE(Datos,1)","v":14047.514999999999},1368.0056818181818]
[2753,1199,null,null,null,"Quartil 3 = ",{"$f":"QUARTILE(Datos,3)","v":21662.025000000001},1956.3541666666667]
[2273,1328,null,null,null,"Rango Intercuartílico = ",611.5,588.34848484848499]
[1898,2233,null,null,null,"Varianza = ",{"$f":"VAR(Datos)","v":15527473.031201109},138769.32319677877]
[2039,2236,null,null,null,"Desviación estándar = ",{"$f":"STDEV(Datos)","v":3940.4914707687299},{"$f":"SQRT(H32)","v":372.51754750183079}]
[2893,1240,null,null,null,"Coef. de Variación = ",{"$f":"STDEV(Datos)/AVERAGE(Datos)","v":0.21203197402645638}]
[2615,1322]
[2871,1036]
[2608,2196]
[2264,1301]
[2350,1313]
[2283,1447]
[2920,1031]
[null,1777]
[null,1457]
[null,1517]
[null,2098]
[null,1799]
[null,1864]
[null,1509]
[null,1715]
[null,1325]
[null,1511]
[null,2233]
[null,1780]
[null,1121]
[null,2187]
[null,2311]
[null,1000]
[null,2112]
[null,1744]
[null,1651]
[null,1280]
[null,1395]
[null,1646]
[null,1252]
[null,1822]
[null,1789]
[null,1904]
[null,2055]
[null,1344]
[null,1963]
[null,1510]
[null,1751]
[null,1881]
[null,1819]
[null,1286]
[null,1696]
[null,2040]
[null,1558]
[null,1452]
[null,1494]
[null,1589]
[null,2278]
[null,1689]
[null,1811]
[null,1552]
[null,2165]
[null,2299]
[null,1595]
[null,1790]
[null,1356]
[null,1367]
[null,1630]
[null,1040]
[null,1401]
[null,1898]
[null,1458]
[null,980]
[null,1364]
[null,2025]
[null,1654]
[null,1192]
[null,1522]
[null,1406]
[null,2296]
[null,1072]
[null,2319]
[null,1849]
[null,2067]
[null,2057]
[null,2274]
[null,2140]
[null,1644]
[null,1107]
[null,1146]
[null,1425]
[null,1835]
[null,1026]
[null,1130]
[null,1430]
[null,1935]
[null,1341]