{"id":783779,"date":"2023-11-11T03:27:39","date_gmt":"2023-11-11T09:27:39","guid":{"rendered":"https:\/\/blogging-techies.com\/sw\/hur-man-beraknar-p-varde-i-excel\/"},"modified":"2023-11-11T03:27:39","modified_gmt":"2023-11-11T09:27:39","slug":"hur-man-beraknar-p-varde-i-excel","status":"publish","type":"post","link":"https:\/\/blogging-techies.com\/sw\/hur-man-beraknar-p-varde-i-excel\/","title":{"rendered":"Hur man ber\u00e4knar p-v\u00e4rde i Excel"},"content":{"rendered":"<p>Om du beh\u00f6ver ber\u00e4kna P-v\u00e4rde i Excel f\u00f6r hypotespr\u00f6vning kan du enkelt ber\u00e4kna P-v\u00e4rde genom att f\u00f6lja vissa instruktioner.  Detta kommer att visa dig om nollhypotesen har starkt eller svagt st\u00f6d.  S\u00e5 l\u00e5t oss l\u00e4ra oss hur man hittar P-v\u00e4rdet i Excel.<\/p>\n<figure class=\"wp-block-embed-youtube aligncenter wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><\/figure>\n<p>Ett p-v\u00e4rde \u00e4r en del av statistiken och \u00e4r den sannolikhet som nollhypotesen ger f\u00f6r att ett visst experimentresultat ska intr\u00e4ffa.  En nollhypotes \u00e4r att teorin som testas \u00e4r falsk, medan en alternativ hypotes s\u00e4ger att de tv\u00e5 variablerna \u00e4r statistiskt signifikanta.  &#8220;P&#8221; i &#8220;P-Value&#8221; st\u00e5r f\u00f6r Probability.  Det str\u00e4cker sig fr\u00e5n 0 till 1. Om ett P-v\u00e4rde \u00e4r mindre \u00e4n 0,05 (\u2264 0,05), finns det statistisk signifikans.  Men om ett p-v\u00e4rde \u00e4r st\u00f6rre \u00e4n 0,05 (>0,05) finns det ingen statistisk signifikans.<\/p>\n<p>\u00c4ven om f\u00e4lten som kr\u00e4ver en ber\u00e4kning av P-v\u00e4rde expanderar f\u00f6r varje dag, \u00e4r ber\u00e4kning av P-v\u00e4rde en operation man vanligtvis st\u00f6ter p\u00e5 n\u00e4r man skriver en akademisk avhandling.  Det anv\u00e4nds i princip f\u00f6r att testa hypoteser. <\/p>\n<figure class=\"aligncenter size-full\"><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Beraknar_korrelationen\"><\/span>Ber\u00e4knar korrelationen<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>F\u00f6rst m\u00e5ste du ber\u00e4kna skillnaden mellan dina variabler.  Som du vet har kalkylblad kolumner och rader.  Anta till exempel att dina variabler \u00e4r listade under kolumnerna A och B och att deras intervall str\u00e4cker sig fr\u00e5n den f\u00f6rsta raden till den tionde. <\/p>\n<ul>\n<li>Titta p\u00e5 linjerna.  Du kommer att se dina variabler. <\/li>\n<li>Subtrahera en variabel fr\u00e5n den andra. <\/li>\n<li>Sedan m\u00e5ste du utf\u00f6ra denna ber\u00e4kning f\u00f6r varje rad. <\/li>\n<li>F\u00f6r att g\u00f6ra denna ber\u00e4kning automatiskt, st\u00e4ll in &#8220;Formel&#8221; till &#8220;A1-B1&#8221; och du kommer att se resultatet.<\/li>\n<li>Siffran som visas betyder att subtraktionen \u00e4r klar och det du ser \u00e4r skillnaden. <\/li>\n<li>F\u00f6r att till\u00e4mpa den p\u00e5 resten av data, dra &#8220;Formeln&#8221; till resten av cellerna. <\/li>\n<\/ul>\n<figure class=\"aligncenter size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"640\" height=\"640\" http:=\"\" alt=\"hitta p-v\u00e4rdet\" class=\"wp-image-17213\" src=\"https:\/\/blogging-techies.com\/wp-content\/uploads\/2021\/10\/Como-calcular-el-valor-p-en-Excel.png\"><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Hitta_p-vardet\"><\/span>Hitta p-v\u00e4rdet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nu n\u00e4r du har ber\u00e4knat skillnaden mellan dina variabler \u00e4r det dags att ber\u00e4kna p-v\u00e4rdet.<\/p>\n<ul>\n<li>G\u00e5 till fliken &#8220;Data&#8221;.  Den finns l\u00e4ngst upp p\u00e5 sk\u00e4rmen.<\/li>\n<li>Genom att klicka p\u00e5 fliken &#8220;Data&#8221; \u00f6ppnas ett band.<\/li>\n<li>Klicka p\u00e5 &#8220;Dataanalys&#8221; l\u00e4ngst upp till h\u00f6ger. <\/li>\n<li>Ett f\u00f6nster \u00f6ppnas.  Scrolla ner och hitta &#8220;t-Test: Paired Two Sample for Means&#8221;, klicka p\u00e5 det och v\u00e4lj &#8220;OK&#8221;.  Ett annat f\u00f6nster \u00f6ppnas.<\/li>\n<li>V\u00e4lj &#8220;Variabelomr\u00e5de 1&#8221; som kolumn A (minen).<\/li>\n<li>V\u00e4lj &#8220;Variable Range 2&#8221; som din kolumn B (subtrahenden).<\/li>\n<li>&#8220;Alpha&#8221; betyder Alpha-v\u00e4rde.  Den finns under och kommer att vara 0,05 som standard, eftersom de vanligaste signifikansniv\u00e5erna \u00e4r 0,05 och 0,01.  Du kan beh\u00e5lla det som 0,05<\/li>\n<li>Du kommer att se att &#8220;Output Range&#8221; \u00e4r listad under &#8220;Output Options&#8221;.  V\u00e4lj &#8220;Output Range&#8221; och skriv i vilken cell du vill visa analysresultaten.<\/li>\n<li>Klicka p\u00e5 knappen &#8220;OK&#8221;.  Du kommer att se analysresultaten i cellen du precis skrev. <\/li>\n<li>J\u00e4mf\u00f6r &#8220;P(T <= t) ensidig\" och \"P(T <= t) tv\u00e5sidig.\" <\/li>\n<li>Fokusera p\u00e5 den &#8220;ensidiga P(T <= t).  Om P-v\u00e4rdet \u00e4r st\u00f6rre \u00e4n \"Alpha\"-v\u00e4rdet, som h\u00e4r \u00e4r 0,05, \u00e4r nollhypotesen sann. <\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Vanliga_fragor_om_hur_man_beraknar_p-varde_i_Excel\"><\/span>Vanliga fr\u00e5gor om hur man ber\u00e4knar p-v\u00e4rde i Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong class=\"schema-faq-question\">Vilket omr\u00e5de ska P-v\u00e4rdet vara?<\/strong><\/p>\n<p class=\"schema-faq-answer\">0,05 anses vara gr\u00e4nsen f\u00f6r statistisk signifikans.<\/p>\n<p><strong class=\"schema-faq-question\">Vad \u00e4r nollhypotesen?<\/strong><\/p>\n<p class=\"schema-faq-answer\">Det indikerar att teorin du testar \u00e4r falsk;  d\u00e4rf\u00f6r felaktigt.<\/p>\n<p><strong class=\"schema-faq-question\">Vad betyder den alternativa hypotesen?<\/strong><\/p>\n<p class=\"schema-faq-answer\">Det betyder att det finns statistisk signifikans mellan de tv\u00e5 variablerna.<\/p>\n<p><strong class=\"schema-faq-question\">Vad ska vara &#8220;Alfa&#8221;-v\u00e4rdet?<\/strong><\/p>\n<p class=\"schema-faq-answer\">Standardv\u00e4rdet \u00e4r 0,05, men du kan \u00e4ndra det till 0,01.  Det beror p\u00e5 vilken betydelse du vill ha.<\/p>\n<p><strong class=\"schema-faq-question\">Hur kan jag f\u00f6rst\u00e5 att nollhypotesen \u00e4r sann?<\/strong><\/p>\n<p class=\"schema-faq-answer\">Observera &#8220;P(T <= t) f\u00f6r en svans\".  Om det \u00e4r st\u00f6rre \u00e4n \"Alpha\"-v\u00e4rdet \u00e4r nollhypotesen sann.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Slutsats_om_hur_man_beraknar_p-varde_i_Excel\"><\/span>Slutsats om hur man ber\u00e4knar p-v\u00e4rde i Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>I den h\u00e4r artikeln f\u00f6rklarar vi hur du hittar P-v\u00e4rdet i Excel.  Kort sagt, The P-Value betygs\u00e4tter bevisen.  N\u00e4r man testar en hypotes kan denna P-v\u00e4rde funktion hj\u00e4lpa till att utv\u00e4rdera st\u00f6d f\u00f6r eller emot argumentet.  Observera att ju l\u00e4gre P-v\u00e4rde du har, desto st\u00f6rre \u00e4r sannolikheten f\u00f6r att hypotesen \u00e4r sann.  Om detta var tillr\u00e4ckligt f\u00f6r att v\u00e4cka ditt intresse kanske du vill kolla in en annan popul\u00e4r och anv\u00e4ndbar formel, n\u00e4mligen standardavvikelsen.<\/p>\n<figure class=\"wp-block-embed-youtube aligncenter wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><\/figure>\n  <div id=\"ez-toc-container\" class=\"ez-toc-v2_0_88 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blogging-techies.com\/sw\/hur-man-beraknar-p-varde-i-excel\/#Beraknar_korrelationen\" >Ber\u00e4knar korrelationen<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blogging-techies.com\/sw\/hur-man-beraknar-p-varde-i-excel\/#Hitta_p-vardet\" >Hitta p-v\u00e4rdet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blogging-techies.com\/sw\/hur-man-beraknar-p-varde-i-excel\/#Vanliga_fragor_om_hur_man_beraknar_p-varde_i_Excel\" >Vanliga fr\u00e5gor om hur man ber\u00e4knar p-v\u00e4rde i Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blogging-techies.com\/sw\/hur-man-beraknar-p-varde-i-excel\/#Slutsats_om_hur_man_beraknar_p-varde_i_Excel\" >Slutsats om hur man ber\u00e4knar p-v\u00e4rde i Excel<\/a><\/li><\/ul><\/nav><\/div>\n ","protected":false},"excerpt":{"rendered":"<p>Om du beh\u00f6ver ber\u00e4kna P-v\u00e4rde i Excel f\u00f6r hypotespr\u00f6vning kan du enkelt ber\u00e4kna P-v\u00e4rde genom att f\u00f6lja vissa instruktioner. Detta kommer att visa dig om nollhypotesen har starkt eller svagt st\u00f6d. S\u00e5 l\u00e5t oss l\u00e4ra oss hur man hittar P-v\u00e4rdet i Excel. Ett p-v\u00e4rde \u00e4r en del av statistiken och \u00e4r den sannolikhet som nollhypotesen [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":783780,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/blogging-techies.com\/wp-content\/uploads\/2023\/06\/1309-768x389-1.webp","fifu_image_alt":"","footnotes":""},"categories":[5],"tags":[],"class_list":["post-783779","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bloggar"],"_links":{"self":[{"href":"https:\/\/blogging-techies.com\/sw\/wp-json\/wp\/v2\/posts\/783779","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogging-techies.com\/sw\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogging-techies.com\/sw\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogging-techies.com\/sw\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blogging-techies.com\/sw\/wp-json\/wp\/v2\/comments?post=783779"}],"version-history":[{"count":0,"href":"https:\/\/blogging-techies.com\/sw\/wp-json\/wp\/v2\/posts\/783779\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogging-techies.com\/sw\/wp-json\/wp\/v2\/media\/783780"}],"wp:attachment":[{"href":"https:\/\/blogging-techies.com\/sw\/wp-json\/wp\/v2\/media?parent=783779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogging-techies.com\/sw\/wp-json\/wp\/v2\/categories?post=783779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogging-techies.com\/sw\/wp-json\/wp\/v2\/tags?post=783779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}