{"id":1282,"date":"2023-10-30T10:29:23","date_gmt":"2023-10-30T10:29:23","guid":{"rendered":"https:\/\/hlrnet.com\/sites\/bet\/?p=1282"},"modified":"2025-02-28T19:47:07","modified_gmt":"2025-02-28T19:47:07","slug":"calcular-el-valor-p-en-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/sites\/bet\/?p=1282","title":{"rendered":"Calcular el valor p en Excel"},"content":{"rendered":"<p>Hay varias maneras de calcular el valor p en Excel.<\/p>\n<p>Lo m\u00e1s evidente me parece ser el <em>Analysis toolpack <\/em>(en espa\u00f1ol: <em>Herramientas para an\u00e1lisis<\/em>)<em><br \/>\n<\/em><\/p>\n<ul>\n<li>En Excel: <em>Archivo, Opciones, Complementos, Administrar, Complementos de Exce<\/em>l. A\u00f1adir Herramientas para an\u00e1lisis (Analysis Toolpack).<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1283\" src=\"https:\/\/hlrnet.com\/sites\/bet\/files\/2023\/10\/xl-analysis-toolpack-246x300.png\" alt=\"\" width=\"246\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/sites\/bet\/files\/2023\/10\/xl-analysis-toolpack-246x300.png 246w, https:\/\/hlrnet.com\/sites\/bet\/files\/2023\/10\/xl-analysis-toolpack.png 505w\" sizes=\"auto, (max-width: 246px) 100vw, 246px\" \/><\/li>\n<li>Seleccionar los datos num\u00e9ricos (sin encabezados)<\/li>\n<li><em>Datos, An\u00e1lisis de datos<\/em><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1285\" src=\"https:\/\/hlrnet.com\/sites\/bet\/files\/2023\/10\/xl-analysis-toolpack1-300x115.png\" alt=\"\" width=\"300\" height=\"115\" srcset=\"https:\/\/hlrnet.com\/sites\/bet\/files\/2023\/10\/xl-analysis-toolpack1-300x115.png 300w, https:\/\/hlrnet.com\/sites\/bet\/files\/2023\/10\/xl-analysis-toolpack1-768x294.png 768w, https:\/\/hlrnet.com\/sites\/bet\/files\/2023\/10\/xl-analysis-toolpack1.png 853w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>Y en la tabla resultanto, el valor p es uno de los elementos<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1284\" src=\"https:\/\/hlrnet.com\/sites\/bet\/files\/2023\/10\/xl-analysis-toolpack2-300x171.png\" alt=\"\" width=\"300\" height=\"171\" srcset=\"https:\/\/hlrnet.com\/sites\/bet\/files\/2023\/10\/xl-analysis-toolpack2-300x171.png 300w, https:\/\/hlrnet.com\/sites\/bet\/files\/2023\/10\/xl-analysis-toolpack2-1024x585.png 1024w, https:\/\/hlrnet.com\/sites\/bet\/files\/2023\/10\/xl-analysis-toolpack2-768x438.png 768w, https:\/\/hlrnet.com\/sites\/bet\/files\/2023\/10\/xl-analysis-toolpack2.png 1149w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>M\u00e1s informaci\u00f3n:<br \/>\n<a href=\"https:\/\/support.microsoft.com\/es-es\/office\/usar-las-herramientas-para-an%C3%A1lisis-para-realizar-an%C3%A1lisis-de-datos-complejos-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6\">Usar las Herramientas para an\u00e1lisis para realizar an\u00e1lisis de datos complejos<\/a> &#8211; Soporte t\u00e9cnico de Microsoft<\/li>\n<\/ul>\n<p>Con analysis toolpack y con T.test<\/p>\n<ul>\n<li>How to Calculate P Value in Excel: Step-by-Step Guide (2023) | Spreadsheeto<br \/>\n<a href=\"https:\/\/spreadsheeto.com\/p-value-excel\/\" class=\"autohyperlink\">spreadsheeto.com\/p-value-excel\/<\/a><\/li>\n<li>How To Calculate P-Value in Excel Using Two Methods | <a href=\"http:\/\/Indeed.com\" class=\"autohyperlink\">Indeed.com<\/a><br \/>\n<a href=\"https:\/\/www.indeed.com\/career-advice\/career-development\/how-to-calculate-p-value-in-excel\" class=\"autohyperlink\">www.indeed.com\/career-advice\/career-development\/how-to-calculate-p-value-in-excel<\/a><\/li>\n<\/ul>\n<p>Con FORECAST:<\/p>\n<ul>\n<li>C\u00f3mo calcular el valor P en Excel | Techlandia<br \/>\n<a href=\"https:\/\/techlandia.com\/calcular-excel-como_8476\/\" class=\"autohyperlink\">techlandia.com\/calcular-excel-como_8476\/<\/a><\/li>\n<\/ul>\n<p>Con T.TEST:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.educba.com\/p-value-in-excel\/\">P-Value in Excel | How to Calculate P-Value in Excel?<\/a> &#8211; Educ BA<\/li>\n<\/ul>\n<p>Con F.DIST.RT:<\/p>\n<ul>\n<li><a href=\"https:\/\/statologos.com\/valor-p-de-la-estadistica-f-en-excel\/?utm_content=cmp-true\">C\u00f3mo calcular el valor P de una estad\u00edstica F en Excel en 2023<\/a> | STATOLOGOS\u00ae<\/li>\n<\/ul>\n<p>Unos v\u00eddeos:<\/p>\n<p>Pruebas de hip\u00f3tesis en Excel con el P-value &#8211; YouTube<br \/>\n<iframe loading=\"lazy\" title=\"Pruebas de hip\u00f3tesis en Excel con el P-value\" width=\"900\" height=\"506\" src=\"https:\/\/www.youtube.com\/embed\/5Hss-_tNaXg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>PRUEBA DE HIP\u00d3TESIS CON P-VALOR EN EXCEL &#8211; YouTube<br \/>\n<iframe loading=\"lazy\" title=\"PRUEBA DE HIP\u00d3TESIS CON P-VALOR EN EXCEL\" width=\"900\" height=\"506\" src=\"https:\/\/www.youtube.com\/embed\/gdGtlkUJs0U?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>Tambi\u00e9n quiero mencionar la ficha <a href=\"https:\/\/hlrnet.com\/sites\/bet\/?p=123\">Estad\u00edstica EXCELente<\/a> en esta misma web.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hay varias maneras de calcular el valor p en Excel. Lo m\u00e1s evidente me parece ser el Analysis toolpack (en espa\u00f1ol: Herramientas para an\u00e1lisis) En Excel: Archivo, Opciones, Complementos, Administrar, Complementos de Excel. A\u00f1adir Herramientas para an\u00e1lisis (Analysis Toolpack). Seleccionar los datos num\u00e9ricos (sin encabezados) Datos, An\u00e1lisis de datos Y<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[6],"tags":[34,12,10,31],"class_list":["post-1282","post","type-post","status-publish","format-standard","hentry","category-herramientas","tag-estadisticas","tag-excel","tag-tic","tag-ubu"],"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=\/wp\/v2\/posts\/1282","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1282"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=\/wp\/v2\/posts\/1282\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/sites\/bet\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}