{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Teste T e Tamanho do efeito"],"not_rendered":{"charts":1,"images":2,"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":"Teste T e Tamanho do efeito","index":0,"n_rows":149,"n_cols":16,"rows_kept":149,"cut":false,"hidden":false,"merged":[[8,4,12,13],[47,6,47,7],[25,8,25,15],[26,8,26,15]]}
[]
[]
[]
[null,null,null,null,null,null,null,"Prof. Luis Anunciação, PhD"]
[null,null,null,null,null,null,null,"Psicometria"]
[null,null,null,null,null,null,null,"www.anovabr.com"]
[]
[]
[null,null,null,null,"Este conteúdo foi desenvolvido para calcular o resultado de um teste T, bem como o tamanho do efeito. Esta é uma medida utilizada após obter significância estatística e que auxilia a entender o efeito de determinado tratamento. Sabe-se que valores p < 0,05 podem ocorrer por tamanho amostral e flutuações estatísticas. Portanto, é importante sempre reportar o tamanho do efeito para reduzir erros do tipo I. Caso não saiba  o N, o g de Hedges não será calculado. Atenção, os valores estão em módulo."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Grupo 1",null,null,"Grupo 2"]
[null,null,null,null,null,null,"Média",2.2999999999999998,null,"Média",3]
[null,null,null,null,null,null,"Desvio-Padrão",1.2,null,"Desvio-Padrão",2.1]
[null,null,null,null,null,null,"N",50,null,"N",100]
[]
[null,null,null,"Padronizadas",null,null,null,null,null,"Brutas",null,null,null,null,"Intervalo de confiança"]
[null,null,null,"P valor","d  de cohen","g de hedges","Correlação","R2",null,"|Δmédias|","Spooled","df","T crítico","Teste T","Inferior","Superior"]
[null,null,null,{"$f":"_xlfn.T.DIST.2T(J23/(K23*SQRT(1/H19+1/K19)),L23)","v":3.0594387385501451E-2},{"$f":"J23/SQRT((H18^2+K18^2)/2)","v":0.40929374234328042},{"$f":"J23/K23","v":0.37814702045914056},{"$f":"E23/SQRT(E23^2+4)","v":0.2004916025441717},{"$f":"G23^2","v":4.0196882690730115E-2},null,{"$f":"ABS(H17-K17)","v":0.70000000000000018},{"$f":"SQRT(((H19-1)*H18^2+(K19-1)*K18^2)/(H19+K19-2))","v":1.8511318670449139},{"$f":"H19+K19-2","v":148},{"$f":"_xlfn.T.INV.2T(0.05,L23)","v":1.9761224936137434},{"$f":"J23/(K23*SQRT(1/H19+1/K19))","v":2.1832328405533974},{"$f":"J23-(M23*(K23/(SQRT(H19*K19/(H19+K19)))))","v":6.6404847052873084E-2},{"$f":"J23+(M23*(K23/(SQRT(H19*K19/(H19+K19)))))","v":1.3335951529471273}]
[null,null,null,{"$f":"IF(D23<0.05,\"*\",\"\")","v":"*"}]
[null,null,null,"Pontos de corte"]
[null,null,null,0.2,"Pequeno",null,null,null,{"$f":"\"O Teste T (amostras independentes) chegou ao p valor de \"&ROUND(D23,1)","v":"O Teste T (amostras independentes) chegou ao p valor de 0"}]
[null,null,null,0.5,"Médio",null,null,null,{"$f":"\"O tamanho do efeito foi de \"&ROUND(E23,1)","v":"O tamanho do efeito foi de 0.4"}]
[null,null,null,0.8,"Grande"]
[null,null,null,">= 1.20","Muito grande"]
[null,null,null,"THRESHOLDS FOR INTERPRETING EFFECT SIZES"]
[null,null,null,"Paul D. Ellis, Hong Kong Polytechnic University"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Data simulation"]
[null,null,null,null,null,null,"Grupo 1","Grupo 2"]
[null,null,null,null,null,null,{"$f":"NORMINV(RAND(), 2.3,12)","v":19.773209336615736},{"$f":"NORMINV(RAND(), 3,2.1)","v":5.3189504152238616}]
[null,null,null,null,null,null,-0.75995685862376661,0.26448055131539494]
[null,null,null,null,null,null,-15.728511152477015,2.3308393895938879]
[null,null,null,null,null,null,7.3242581189997749,1.9080464152582246]
[null,null,null,null,null,null,9.7464301344004696,3.6050575968571938]
[null,null,null,"Mínimo",{"$f":"MIN(G50:G500)","v":-24.938918843178655},{"$f":"MIN(H50:H500)","v":-1.8356297074947552},-5.7609947156443253,2.8311939507702162]
[null,null,null,"Q1",{"$f":"_xlfn.QUARTILE.INC(G50:G500,1)","v":-3.7065093315449191},{"$f":"_xlfn.QUARTILE.INC(H50:H500,1)","v":1.6836573020578549},10.067604338466296,4.1951527122534191]
[null,null,null,"Mediana",{"$f":"MEDIAN(G50:G500)","v":1.0024913300356406},{"$f":"MEDIAN(H50:H500)","v":3.5587015316489241},3.1353269832091675,5.1447001913073898]
[null,null,null,"Q3",{"$f":"_xlfn.QUARTILE.INC(G50:G500,3)","v":9.6692938836208668},{"$f":"_xlfn.QUARTILE.INC(H50:H500,3)","v":4.8890903050898888},-7.1103105214796054,4.0574317721250637]
[null,null,null,"Máximo",{"$f":"MAX(G50:G500)","v":23.14677109666367},{"$f":"MAX(H50:H500)","v":9.0575067636272522},-2.113110575056222,4.3237320354807682]
[null,null,null,null,null,null,-1.4991127811714913,4.9920139453083525]
[null,null,null,"Diferença","Grupo1","Grupo 2",2.6227504162507542,1.9243788177894907]
[null,null,null,"mínimo",{"$f":"E55","v":-24.938918843178655},{"$f":"F55","v":-1.8356297074947552},-0.40950387177356218,3.8846211916691402]
[null,null,null,"q1-min",{"$f":"E56-E55","v":21.232409511633737},3.5192870095526101,14.628994620885127,3.9150180787322006]
[null,null,null,"mediana-q1",4.7090006615805597,1.8750442295910692,-15.677763761045711,6.3783540244672672]
[null,null,null,"q3-med",8.6668025535852262,1.3303887734409647,4.5974234660218141,7.6310719656827688]
[null,null,null,"max-q3",13.477477213042803,4.1684164585373633,10.62299279203047,0.40133558712195283]
[null,null,null,null,null,null,1.6029917599603456,1.1610961534977495]
[null,null,null,null,null,null,-3.8618413028280241,1.1511247314775439]
[null,null,null,null,null,null,0.73933462615598877,3.1632180950454045]
[null,null,null,null,null,null,18.643267317974431,1.5871555719251313]
[null,null,null,null,null,null,11.273658622260829,2.4709001439003164]
[null,null,null,null,null,null,13.505823907132836,4.3142973387935104]
[null,null,null,null,null,null,11.590893561269286,3.2974869509926483]
[null,null,null,null,null,null,-2.1371739780466852,-0.38185937080977483]
[null,null,null,null,null,null,13.31063365696065,4.5304185743275376]
[null,null,null,null,null,null,-6.7299395624231524,5.6364267636657841]
[null,null,null,null,null,null,-0.47534229651297322,1.4389385143187574]
[null,null,null,null,null,null,5.5810759501704315,1.2315062671535388]
[null,null,null,null,null,null,-4.1194461381699021E-2,6.155835575565713]
[null,null,null,null,null,null,-5.8442962250079793,-1.4896056021896849]
[null,null,null,null,null,null,-3.2405134176956034,0.8840256293830171]
[null,null,null,null,null,null,{"$f":"NORMINV(RAND(), 2.3,12)","v":0.99550467124381026},{"$f":"NORMINV(RAND(), 3,2.1)","v":3.5123454664406544}]
[null,null,null,null,null,null,-3.9953260984053314,2.6737252714853468]
[null,null,null,null,null,null,-0.62516412621964568,4.1225700638092517]
[null,null,null,null,null,null,13.553525579510183,2.4696914060546149]
[null,null,null,null,null,null,1.0094779888274708,3.0907689052071001]
[null,null,null,null,null,null,2.6994425469446686,5.5666446535178853]
[null,null,null,null,null,null,-10.9027434325683,4.1912000580178672]
[null,null,null,null,null,null,-2.9229857655019975,4.5844697558835215]
[null,null,null,null,null,null,14.360004792843348,-1.8296946575343593]
[null,null,null,null,null,null,-9.9175650555174641,1.7934090266520852]
[null,null,null,null,null,null,6.7369413090868164,-0.11639807368284671]
[null,null,null,null,null,null,2.0449489890981525,1.1316622309614557]
[null,null,null,null,null,null,23.14677109666367,-0.5967260153073477]
[null,null,null,null,null,null,4.6080992467044233,6.1889530337966789]
[null,null,null,null,null,null,-24.938918843178655,1.8355956911967495]
[null,null,null,null,null,null,-5.3824225323676513,3.8094741361406985]
[null,null,null,null,null,null,9.4378851312820622,-0.32409794248415791]
[null,null,null,null,null,null,-16.470620579667944,3.8403128358284828]
[null,null,null,null,null,null,null,9.0575067636272522]
[null,null,null,null,null,null,null,6.7714278971706285]
[null,null,null,null,null,null,null,1.6513756301478031]
[null,null,null,null,null,null,null,3.2236790441321164]
[null,null,null,null,null,null,null,0.4206177741345809]
[null,null,null,null,null,null,null,3.7877064989616605]
[null,null,null,null,null,null,null,1.4468552975230347]
[null,null,null,null,null,null,null,3.1891914076302066]
[null,null,null,null,null,null,null,-1.8356297074947552]
[null,null,null,null,null,null,null,6.6496071969729122]
[null,null,null,null,null,null,null,6.0873939813081357]
[null,null,null,null,null,null,null,3.7094179044212718]
[null,null,null,null,null,null,null,3.6934014300316926]
[null,null,null,null,null,null,null,5.9616638772099044]
[null,null,null,null,null,null,null,{"$f":"NORMINV(RAND(), 3,2.1)","v":1.1678279230024322}]
[null,null,null,null,null,null,null,0.25494554710078754]
[null,null,null,null,null,null,null,1.8955391453999135]
[null,null,null,null,null,null,null,1.0645221604797972]
[null,null,null,null,null,null,null,1.6144438587873513]
[null,null,null,null,null,null,null,3.9659757683486472]
[null,null,null,null,null,null,null,5.2423223182555088]
[null,null,null,null,null,null,null,2.8279245996171793]
[null,null,null,null,null,null,null,4.0463058567577157]
[null,null,null,null,null,null,null,5.8187229171788513]
[null,null,null,null,null,null,null,0.60076071034819778]
[null,null,null,null,null,null,null,3.8314000852178967]
[null,null,null,null,null,null,null,6.6786343063055007]
[null,null,null,null,null,null,null,6.1941494010539895]
[null,null,null,null,null,null,null,5.8773547164112365]
[null,null,null,null,null,null,null,1.6944178593612056]
[null,null,null,null,null,null,null,4.0892886532782011]
[null,null,null,null,null,null,null,5.7926727944550338]
[null,null,null,null,null,null,null,4.8689489036553759]
[null,null,null,null,null,null,null,2.9285260779097557]
[null,null,null,null,null,null,null,3.4148371364816712]
[null,null,null,null,null,null,null,3.1937056137559274]
[null,null,null,null,null,null,null,4.9495145093934276]
[null,null,null,null,null,null,null,6.1387570295908596]
[null,null,null,null,null,null,null,2.9146692896781992]
[null,null,null,null,null,null,null,3.2045763875429598]
[null,null,null,null,null,null,null,5.1660950107148036]
[null,null,null,null,null,null,null,4.0992735518295387]
[null,null,null,null,null,null,null,4.1528068351969196]
[null,null,null,null,null,null,null,3.0437891377525963]
[null,null,null,null,null,null,null,2.7713014287760669]
[null,null,null,null,null,null,null,4.0698321143664575]
[null,null,null,null,null,null,null,5.3809936315395754]
[null,null,null,null,null,null,null,3.6551346838963856]
[null,null,null,null,null,null,null,1.3422266961012552]
[null,null,null,null,null,null,null,5.143388134943903]