Teneis vicios raros
Printable View
Teneis vicios raros
Sale el número pero no es posible copiarlo pero sí la fórmula, al tocar con el puntero sale algo así: =SUMA(B4:B6)/3.Quote:
Originally Posted by gixajo
Tened paciencia, esto es ir estrechando el cerco poco a poco hasta atinar, tengo dos samples muy buenos para hacer una media que tendría (creo) mejor distancia pero quería probar añadiéndole un poquito de gracia con algo de SSA.
https://i.imgur.com/a1nNPJH.png
Pero esa fórmula te sale en la ventana de fórmula de arriba? No debería verse la fórmula, no entiendo porque pasa eso...Quote:
Originally Posted by Defcon2
Yo estoy usando la tabla original que hice en el open office,no la de excel importada de la original, a mí no me pasa eso.:confused:
me pasan otras cosas diferentes, pero no esa.:picard1:
Es un asco, pero la verdad es que estoy disfrutando, es un asco muy rico.;)
Edit:todo esto nos lo ahorraríamos si alguno nos dijera a qué componente hace referencia cada coordenada, los cambiaríamos a mano hasta dar con samples güenos güenos.
:rolleyes:Quote:
Originally Posted by Defcon2
Mi primer Iberian_Average mezclado con el Basque_Spanish en el modelo que hice de Africa vs Asia vs Europa ,como únicos samples de la península, borrando los 3 que puse, me un daba resultado con una distancia de 1.3 en vez de la distancia de 1.5 del modelo con tres samples Ibéricos previos.Quote:
Originally Posted by Defcon2
Es más, me hizo desaparecer el porcentaje asiático y africano que me salía en el primer resultado, me daba 100% Europeo .;)
Yo creo que ese mismo modelo con tu Sample y alguno de los míos puede ser gracioso probarlo.:D
Lo gracioso es que ahora con la otra tabla tampoco puedo copiar, joder que cosa.Quote:
Originally Posted by gixajo
Probando como se comportan nuestros samples en el modelo de African vs Asian vs Europa.
Si dejo Basque, me acorta la distancia pero me hace aflorar lo no europeo, si lo quito, me hace 100% europeo. :rotfl:
Añadiendo los 4 nuevos samples y quitando todos los anteriores Ibéricos estos son mis resultados:
Target: gixajo_scaled
Distance: 1.6646% / 0.01664574
92.4 European:Iberian_Peninsula
4.2 European:SlavicA
3.4 European:English
Target: gixajo_scaled
Distance: 1.6646% / 0.01664574
100.0 European
Añadiendo los 4 nuevos samples y dejando el Basque_Spanish:
Target: gixajo_scaled
Distance: 1.4209% / 0.01420880
40.8 European:Basque
30.8 European:Iberian_Peninsula
10.8 European:Iberian_Average2
5.8 European:SlavicA
4.8 European:Italian
2.8 European:Croatian
2.0 Asian:Yemenite
1.2 European:Georgian
0.6 Asian:Levantine
0.4 African:Berber
Target: gixajo_scaled
Distance: 1.4209% / 0.01420910
97.0 European
2.6 Asian
0.4 African
Dejo el modelo con los nuevos samples ibéricos con el Basque_Spanish , si queréis quitarlo lo quitáis, si queréis dejarlo lo dejáis.:)Quote:
Distance to: gixajo_scaled
0.01793911 European:Iberian_Peninsula
0.02416049 European:Iberian_Average2
0.02594884 European:Popurri_Ibérico
0.02916098 European:Western_Iberia
0.03475637 European:Basque
0.04156026 European:French
0.04716326 European:Italian
0.06458197 European:German
0.06793278 European:English
0.07323389 European:Croatian
0.07427512 European:Hungarian
0.07433635 European:Irish
0.08279618 European:Greek
0.10386202 European:SlavicA
0.10929737 European:SlavicC
0.11597926 European:SlavicB
0.14702167 Asian:Turkish
0.16603887 Asian:Azeri
0.16945488 Asian:Levantine
0.17255404 Asian:Iranian
0.18385545 European:Georgian
0.21727948 Asian:Arab
0.21862150 Asian:Yemenite
0.23976090 Asian:Balochi
0.33806014 Asian:Hazara
Code:European:Western_Iberia,0.102441,0.145729,0.036392,-0.000002,0.037699,-0.000976,-0.004818,-0.004385,0.025770,0.032529,-0.001624,0.011090,-0.012562,-0.014726,0.011469,0.000862,0.000065,-0.000765,-0.007919,-0.002001,0.001622,-0.003524,-0.001910,-0.001325,0.001797
European:Iberian_Average2,0.108511,0.145898,0.035449,-0.002261,0.043598,-0.002138,-0.003368,-0.000385,0.021816,0.036083,-0.000487,0.010541,-0.012934,-0.015184,0.012577,0.000663,0.004477,-0.004814,-0.002514,-0.000917,-0.001040,-0.003709,-0.004149,-0.001124,-0.002754
European:Popurri_Ibérico,0.104646,0.1449668125,0.0369343125,-0.00218025,0.0422385,-0.0020219375,-0.0034663125,0.004225875,0.0239805,0.030103125,-0.0028215625,0.006154,-0.0118743125,-0.0129968125,0.0093731875,-0.0017236875,-0.0036915625,-0.0015203125,-0.003008875,-0.002211875,-0.0001403125,-0.0019243125,0.0003313125,-0.0025830625,-0.0009205
European:Iberian_Peninsula,0.114392,0.146490,0.040823,-0.000162,0.045311,-0.000697,-0.001765,0.000693,0.023623,0.0365338,-0.001908,0.010303,-0.013639,-0.014691,0.013809,0.001226,0.002282,-0.002534,0.000314,-0.000969,0.00121675,-0.003091,-0.005577,-0.002952,-0.003742
African:Yoruba,-0.6300625,0.0625011,0.022113,0.0167079,0.0005035,0 .0124741,-0.044417,0.0477673,-0.0488813,0.0327694,0.0046205,0.0007904,0.0230561, 0.0009509,0.0125232,-0.0096067,0.0070763,0.0004491,0.006022,-0.00299,0.0015542,0.0023156,-0.0017592,-0.0004711,-0.0004246
European:Italian,0.1213354,0.1473534,0.0208925,-0.0145996,0.0292668,-0.0058844,0.0028435,0.0001615,0.0074653,0.0241279,-0.0002273,0.0063544,-0.0098859,-0.0045141,-0.0015744,-0.0027048,0.0011213,0.0008997,0.0021747,-0.0038269,-0.0025705,0.0018548,-0.0024033,0.0038316,-0.0014967
African:Berber,-0.189857,0.0814452,-0.0242866,-0.085595,0.027636,-0.0552202,-0.0705968,0.0184146,0.155397,0.003499,0.0209156,-0.0318316,0.0747168,-0.0513334,0.0711988,-0.0363032,0.0052676,-0.066106,-0.1424162,0.0389938,-0.0376836,-0.1255322,0.0730118,-0.0137606,0.0164534
European:German,0.1302626,0.1373792,0.0579811,0.0387068,0.0400035,0.0156461,0.0040665,0.0057865,0.003526,0.00188,-0.0044133,0.0023732,-0.0053706,-0.0025417,0.0085125,0.0032913,-0.0032728,0.0016631,0.0033669,0.0017191,0.00314,0.002005,7.18e-05,0.0083052,0.0002774
European:Irish,0.1334042,0.134875,0.0610876,0.0482532,0.0383388,0.0188992,0.003,0.0047738,0.0031318,0.002725,-0.00714,0.005606,-0.0143759,-0.0139278,0.0253478,0.0048208,-0.0110725,0.0022052,0.0007502,0.0013385,0.0051745,0.0012249,-0.0003563,0.0147667,0.0010665
Asian:Levantine,0.0853674,0.1486734,-0.0573978,-0.0925072,-0.0096018,-0.0350286,-0.002209,-0.0081688,0.016321,0.008237,0.0091586,-0.0099212,0.0204854,0.0118632,-0.0055372,0.0021214,-0.011239,0.0010134,0.0021116,-0.003652,-0.0005242,0.003116,0.000567,-0.0029402,0.0046462
Asian:Arab,0.0448462,0.143799,-0.0612444,-0.1170562,-0.0092324,-0.0479134,-0.0110452,-0.0045692,0.053626,-0.007581,0.0147122,-0.0271256,0.0514366,0.0055874,0.0004886,0.0201534,-0.021383,0.00451,0.0025894,0.0183086,0.0114298,0.013132,-0.0067292,0.004651,-0.0054844
Asian:Amerindian,0.0529278,-0.328016,0.1120048,0.0774392,-0.1061738,-0.0184068,-0.1983488,-0.2347978,-0.0037325,-0.020137,0.0082817,-0.0034098,0.0063925,6.87e-05,-0.0151328,-0.004508,-0.0005215,0.0032622,0.0115015,0.0073472,0.0038682,-0.0107578,0.0027115,0.0062055,0.0092805
European:Greek,0.118376,0.1438667,0.0037713,-0.0325153,0.0159003,-0.010412,0.001645,-0.000923,-0.000409,0.018102,0.000108,0.0039467,-0.0058967,0.0037157,-0.016377,0.0023863,0.0134297,0.0003377,0.009176,-0.0007083,-0.0092753,0.003998,0.0013967,-0.0001203,-0.0033927
Asian:Chinese,0.0220816,-0.454551,-0.0059588,-0.067184,0.0749678,0.03224,0.000235,-0.0044306,-0.0137848,0.0022232,-0.0520616,-0.0056348,0.0087414,-0.0073766,-0.005293,0.000106,0.0019038,0.0009374,-0.004148,-0.0133564,0.0203392,0.0022008,0.0134092,-0.0006268,-0.005173
Asian:Iranian,0.0916275,0.1077846,-0.0632191,-0.0225219,-0.045365,0.0040439,0.0018586,-0.005318,-0.028373,-0.0168403,-0.0002509,0.000361,0.0043652,-0.0049418,0.0071253,0.0135542,-0.0035262,0.002885,0.0017313,-0.0087712,-0.0032216,-0.0037657,0.0006777,-0.003489,0.0053669
European:SlavicA,0.1318405,0.1292694,0.0698685,0.0577382,0.0406754,0.0217127,0.0086781,0.0108626,-0.0009329,-0.0185524,-0.0043488,-0.0064187,0.013093,0.0186295,-0.0070244,-0.0005595,0.0015455,-7.41e-05,0.0026948,0.0012872,-0.0031286,-0.0031185,0.0056063,-0.0033328,-8.76e-05
European:SlavicB,0.1308965,0.1216098,0.0735385,0.0608855,0.0360838,0.0225205,0.009694,0.011711,-0.0024542,-0.0240098,0.0008118,-0.0079052,0.017282,0.024359,-0.0136402,-0.0037125,0.0012385,0.0011085,0.0028285,0.0034392,-0.0023708,-0.0032148,0.0023725,-0.0050305,-0.0019758
European:SlavicC,0.1309273,0.1240867,0.0683506,0.0575551,0.0376867,0.0212936,0.0087651,0.0113072,-0.002891,-0.0210999,-0.0016327,-0.0076594,0.0153563,0.0216328,-0.0112354,-0.0010965,0.0046903,-0.0006985,0.0025989,0.0017002,-0.0044989,-0.003479,0.0067387,-0.0040578,0.0007217
Asian:Turkish,0.097275,0.0841327,-0.0305758,-0.0405241,-0.0228443,-0.0133439,0.0035069,-0.0019525,-0.021066,-0.0021728,-0.0002998,0.0027898,-0.0036708,0.0009528,-0.0056584,-0.0015502,0.0006519,0.0011109,0.0010635,-0.0017988,-0.0013438,0.0018834,-0.0018203,-0.0004636,0.0004421
Asian:Azeri,0.0921965,0.0891527,-0.0493829,-0.040613,-0.0361848,-0.0047412,0.0043166,-0.0038378,-0.0282782,-0.0097641,-0.0018205,-0.0002366,0.0007668,-0.0014849,0.0015502,0.0043266,-0.002594,0.0012203,0.0019714,-0.0048904,-0.0002365,-0.0010218,-0.0012131,-0.0022832,0.0008886
African:Bantu,-0.600986,0.062455,0.014708,0.0117895,0.002,0.00753,-0.012338,0.0265375,0.0029655,-0.0244195,-0.0023545,0.013338,-0.0320365,0.003303,-0.0352875,0.025921,-0.015255,-0.0043705,-0.0152725,0.006003,0.00287,-0.0051315,-0.0030195,0.0003615,0.0022155
Asian:Balochi,0.068863,0.0518768,-0.1006282,0.0307388,-0.0726032,0.0314913,0.0055812,0.0015768,-0.0227362,-0.0208053,-0.0038838,-0.002148,0.0039271,-0.0080164,0.0159583,0.0300978,-0.0101374,0.0029245,0.0072694,-0.0265127,-0.0010711,-0.0152092,0.0003698,-0.0160965,0.0137612
Asian:Dong,0.0161882,-0.4507823,-0.0269014,-0.0680812,0.1080886,0.0530821,-0.0002872,-0.0074869,-0.0150439,-0.0095774,-0.021363,-0.0045626,0.0053021,-0.0076609,-0.0034532,0.0017237,0.0043606,-0.0002814,-0.0030168,-0.0116584,0.0161243,0.0068557,0.0160086,-0.0019014,0.0010113
European:English,0.1318551,0.137043,0.0617883,0.044013,0.0392299,0.0167481,0.0049845,0.0057448,0.0052637,0.0056781,-0.0047691,0.0056161,-0.0125892,-0.0103507,0.0206153,0.0035521,-0.0103689,0.004094,0.003685,0.0029619,0.0059369,0.0034036,-0.0032693,0.0137938,3.16e-05
European:French,0.1271714,0.1414355,0.0504313,0.0239901,0.0409027,0.0093048,0.0027985,0.0054544,0.0116022,0.0181739,-0.0077061,0.0068121,-0.0129065,-0.0103844,0.0137695,0.0060631,-0.0018255,0.0046644,0.0027082,-0.0009778,0.0022007,0.0035747,-0.0012325,0.0111405,-0.0019051
European:Georgian,0.108132,0.1332374,-0.0619988,-0.0459952,-0.0383456,-0.0089246,0.0113746,-0.0056768,-0.0639748,-0.0175312,-0.0004546,0.0130384,-0.0251532,0.0072388,0.001873,-0.0238662,0.0070668,-0.0044088,-0.0095026,0.0153074,0.0115046,0.0013602,2.46e-05,-0.0070852,-0.0017964
Asian:Gujarati,0.0513912,-0.0577328,-0.1560525,0.1108222,-0.0805842,0.0621926,-0.0002232,0.0116072,0.033,0.0188524,-0.0064955,8.24e-05,-0.0021779,0.0017408,-0.0006786,0.0003778,0.0008801,-0.0001711,-0.0014267,-0.0039332,0.0014288,-0.0033139,0.0011093,0.0011266,-0.0029757
Asian:Han1,0.0254964,-0.4441926,0.0088248,-0.0643416,0.0505322,0.020415,0.0067212,0.0033692,-0.0136212,0.0037906,-0.076355,-0.01142,0.0121306,-0.0083674,-0.0050218,0,0.0025556,-0.0011656,-0.0014832,-0.004377,0.0109056,0.0073698,0.0085288,-0.001687,-0.001868
Asian:Han2,0.0220816,-0.454551,-0.0059588,-0.067184,0.0749678,0.03224,0.000235,-0.0044306,-0.0137848,0.0022232,-0.0520616,-0.0056348,0.0087414,-0.0073766,-0.005293,0.000106,0.0019038,0.0009374,-0.004148,-0.0133564,0.0203392,0.0022008,0.0134092,-0.0006268,-0.005173
Asian:Hazara,0.0660172,-0.1622816,-0.0037712,0.0005168,-0.0405612,0.0043506,0.007755,0.0059536,-0.0124348,-0.0049568,-0.022637,-0.0029374,0.0022002,-0.0036884,0.0035286,0.0036064,-0.005737,0.0021032,0.0043996,0.0007004,-0.007936,-0.0018052,-0.0059652,-0.0006268,0.0021794
European:Hungarian,0.1270753,0.1296252,0.0553559,0.0364298,0.0363804,0.0119326,0.0066138,0.0075326,0.0020597,-0.0046731,-0.0014731,-0.0027191,0.0038544,0.0087488,-0.0043722,0.0001231,-8.4e-05,-0.0003891,0.0026486,-0.0013221,-0.003378,0.0013865,0.0055286,0.0026939,0.0004789
Asian:Kazakh,0.0676109,-0.2193543,0.0449527,-0.0068153,-0.0360989,-0.0139445,0.0105284,0.0112148,-0.0065242,-0.0015306,-0.0223771,-0.0026377,0.0011002,-0.0012386,0.001425,0.0014985,0.000339,0.000418,0.0016591,0.0059152,-0.0139006,-0.0059476,-0.0084054,0.0005302,0.0011376
African:Kongo,-0.628304,0.064994,0.020365,0.017442,-0.000615,0.016176,-0.016451,0.020076,-0.033746,0.020228,0.008607,-0.003147,-0.001933,0.001514,-0.006786,0.00769,-0.009648,0.00114,0.001257,0.003502,-0.002496,-0.000989,0.001109,-0.001084,-0.006826
Asian:Korean,0.0227267,-0.4546526,0.0184538,-0.0641155,0.0393303,0.0116484,0.0054755,0.0033615,-0.0087399,0.0063599,-0.0745742,-0.008947,0.0103418,-0.0051105,-0.0085052,-0.002559,0.0012865,0.0022087,-0.0005237,-0.0077496,0.0169077,-0.0043938,0.0076947,0.0005381,-0.0173996
Asian:Yemenite,0.0492282,0.1414123,-0.0630735,-0.1155542,-0.0106942,-0.0473418,-0.0094002,-0.0071535,0.0581358,-0.0025965,0.0128692,-0.0314348,0.0573088,0.003888,0.0038,0.0195902,-0.0204703,0.0039908,0.0031738,0.0221358,0.0107002,0.0147148,-0.0130642,0.0085552,-0.008562
Asian:Gujarati,0.0513912,-0.0577328,-0.1560525,0.1108222,-0.0805842,0.0621926,-0.0002232,0.0116072,0.033,0.0188524,-0.0064955,8.24e-05,-0.0021779,0.0017408,-0.0006786,0.0003778,0.0008801,-0.0001711,-0.0014267,-0.0039332,0.0014288,-0.0033139,0.0011093,0.0011266,-0.0029757
African:Ethiopian,-0.4108256,0.0677019,-0.018479,-0.0372957,0.0001025,-0.0225345,0.024864,-0.0243837,0.1059571,-0.0875462,-0.0119303,-0.003367,-0.0153219,-0.0002385,0.0253525,-0.0231944,0.0240254,0.0186992,0.0048015,-0.0091294,-0.0014974,0.004501,-0.0029989,-0.0015904,0.0007504
European:Croatian,0.128051,0.1338467,0.0518917,0.0314925,0.035822,0.0125223,0.0060161,0.0067381,0.0018408,-0.0058862,-0.001153,-0.0023827,0.0047275,0.0127851,-0.0066365,-0.0022011,0.0027512,-0.0007223,0.0018101,-0.0007503,-0.005166,-0.0024236,0.0044246,-0.0010966,0.0001796
European:Basque,0.1319083,0.1504111,0.0582862,0.0090081,0.0575834,0.0001239,-0.0033162,0.0004102,0.0313603,0.0455997,-0.0045288,0.0116063,-0.0227781,-0.0187627,0.0179452,0.0037271,-0.0058094,0.0027731,-0.0018156,-6.96e-05,0.0087901,0.0024868,-0.0068883,-0.0090371,0.0022619
O que é um "popurri ibérico"?
Por cierto, lo que pasa con el Basque en este caso concreto es una de las formas que conocemos todos de cómo dirigir el resultado de un modelo, el efecto que hace en una source meter un sample muy puro o más mezclado en los resultados, hace que a cada "etnia" le salga más o menos "caquita" en sus resultados del "single".
Tenemos que hacer un decálogo de como "manipular" los resultados de un modelo para "dirigirlo" a lo que nos interese en cada momento.;)
Odio a la gente que usa comillas.