{"id":54085,"date":"2019-04-04T18:33:45","date_gmt":"2019-04-04T17:33:45","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=54085"},"modified":"2019-04-04T18:33:45","modified_gmt":"2019-04-04T17:33:45","slug":"p-waarde-berekenen-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/p-waarde-berekenen-in-excel\/","title":{"rendered":"p waarde berekenen in Excel"},"content":{"rendered":"<p>V. Hoe kan ik de p-waarde berekenen in Excel, om te weten of een correlatie significant is?<\/p>\n<p>A. Je kan dat doen met het ingebouwde Analysis Toolpak.<\/p>\n<ul>\n<li>Activeer Analysis Toolpak bij de invoegtoepassingen.<\/li>\n<li>Voer de gegevensin: de eerste reeks (x waarden) en de tweede reekls (y waarden)<\/li>\n<li>Data, Data Analysis, Analysis Toolpak. Kies Regression.<\/li>\n<li>Kies invoerbereik 2 (de y waarden) en invoerbereik 1 (de X waarden). Zeg aan Excel dat je de labels mee hebt genomen &#8211; dat vergemakkelijkt het lezen van het resultaat.<\/li>\n<li>In het blad van de uitvoer zal je de p-waarde zien staan.<\/li>\n<\/ul>\n<p>Meer info?<\/p>\n<ul>\n<li>Een video<br \/>\n<a href=\"https:\/\/www.youtube.com\/watch?v=vFcxExzLfZI\" rel=\"nofollow\">https:\/\/www.youtube.com\/watch?v=vFcxExzLfZI<\/a><\/li>\n<li>Een pagina over de regressie-analyse in Excel<br \/>\n<a href=\"https:\/\/www.excel-easy.com\/examples\/regression.html\" rel=\"nofollow\">https:\/\/www.excel-easy.com\/examples\/regression.html<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>V. Hoe kan ik de p-waarde berekenen in Excel, om te weten of een correlatie significant is? A. Je kan dat doen met het ingebouwde Analysis Toolpak. Activeer Analysis Toolpak bij de invoegtoepassingen. Voer de gegevensin: de eerste reeks (x waarden) en de tweede reekls (y waarden) Data, Data Analysis,<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":1142,"footnotes":""},"categories":[539,464,54,79,10],"tags":[],"class_list":["post-54085","post","type-post","status-publish","format-standard","hentry","category-berekeningen","category-ebp","category-excel","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-01 23:13:36","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/54085","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=54085"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/54085\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=54085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=54085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=54085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}