{"id":926,"date":"2023-07-28T07:20:31","date_gmt":"2023-07-28T07:20:31","guid":{"rendered":"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/"},"modified":"2023-07-28T07:20:31","modified_gmt":"2023-07-28T07:20:31","slug":"ki-kare-excel-istatistiginin-p-degeri","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/","title":{"rendered":"Excel&#39;de ki-kare istatisti\u011finin p de\u011feri nas\u0131l bulunur?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Her Ki-kare testi yapt\u0131\u011f\u0131n\u0131zda, bir Ki-kare testi istatisti\u011fi elde edersiniz. Daha sonra test sonu\u00e7lar\u0131n\u0131n istatistiksel olarak anlaml\u0131 olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in bu test istatisti\u011fine kar\u015f\u0131l\u0131k gelen p de\u011ferini bulabilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Excel&#8217;de Ki-kare testi istatisti\u011fine kar\u015f\u0131l\u0131k gelen p de\u011ferini bulmak i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanan CHISQ.DIST.RT() i\u015flevini kullanabilirsiniz:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>=K\u0130KARE.DA\u011e.RT(x, derece_serbestlik)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Alt\u0131n:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>x:<\/strong> ki-kare testi istatisti\u011fi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>deg_freedom:<\/strong> Serbestlik dereceleri<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnekler bu fonksiyonun pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>\u00d6rnek 1: Ki-kare uyum iyili\u011fi testi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Bir ma\u011faza sahibi, haftan\u0131n her g\u00fcn\u00fc ma\u011fazas\u0131na e\u015fit say\u0131da m\u00fc\u015fterinin geldi\u011fini s\u00f6yl\u00fcyor. Bu hipotezi test etmek i\u00e7in ba\u011f\u0131ms\u0131z bir ara\u015ft\u0131rmac\u0131, belirli bir haftada ma\u011fazaya gelen m\u00fc\u015fteri say\u0131s\u0131n\u0131 kaydeder ve a\u015fa\u011f\u0131dakileri bulur:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Pazartesi:<\/strong> 50 m\u00fc\u015fteri<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Sal\u0131:<\/strong> 60 m\u00fc\u015fteri<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>\u00c7ar\u015famba:<\/strong> 40 m\u00fc\u015fteri<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Per\u015fembe:<\/strong> 47 m\u00fc\u015fteri<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Cuma:<\/strong> 53 m\u00fc\u015fteri<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/tr\/ki-kare-uyum-iyiligi-testi\/\" target=\"_blank\" rel=\"noopener\">Ki-kare uyum iyili\u011fi testi<\/a> yapt\u0131ktan sonra ara\u015ft\u0131rmac\u0131 a\u015fa\u011f\u0131dakileri bulur:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ki-kare test istatisti\u011fi (X <sup>2<\/sup> ): <strong>4,36<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Serbestlik derecesi: (df): <strong>4<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu ki-kare testi istatisti\u011fi ve serbestlik dereceleriyle ili\u015fkili p de\u011ferini bulmak i\u00e7in Excel&#8217;de a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><span style=\"color: #000000;\"><b>=CHISQ.DIST.RT(4.36, 4)<\/b><\/span><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Excel&#8217;de \u015f\u00f6yle g\u00f6r\u00fcn\u00fcr:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9799 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chi_p_excel1.png\" alt=\"Excel'de ki-kare istatisti\u011finin p de\u011feri\" width=\"445\" height=\"386\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">P de\u011feri <strong>0,359472<\/strong> olarak \u00e7\u0131k\u0131yor. Bu p de\u011feri 0,05&#8217;ten k\u00fc\u00e7\u00fck olmad\u0131\u011f\u0131ndan s\u0131f\u0131r hipotezini reddedemiyoruz. Bu, m\u00fc\u015fterilerin ger\u00e7ek da\u011f\u0131l\u0131m\u0131n\u0131n ma\u011faza sahibinin bildirdi\u011finden farkl\u0131 oldu\u011funu s\u00f6yleyecek yeterli kan\u0131t\u0131m\u0131z olmad\u0131\u011f\u0131 anlam\u0131na geliyor.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>\u00d6rnek 2: Ki-kare ba\u011f\u0131ms\u0131zl\u0131k testi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Ara\u015ft\u0131rmac\u0131lar cinsiyetin siyasi parti tercihiyle ili\u015fkili olup olmad\u0131\u011f\u0131n\u0131 bilmek istiyor. 500 se\u00e7menden olu\u015fan basit rastgele bir \u00f6rneklem al\u0131yorlar ve onlara siyasi parti tercihlerini soruyorlar. <a href=\"https:\/\/statorials.org\/tr\/ki-kare-bagimsizlik-testi\/\" target=\"_blank\" rel=\"noopener\">Ki-kare ba\u011f\u0131ms\u0131zl\u0131k testi<\/a> yapt\u0131ktan sonra a\u015fa\u011f\u0131dakileri bulurlar:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ki-kare test istatisti\u011fi (X <sup>2<\/sup> ): <strong>0,8642<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Serbestlik derecesi: (df): <strong>2<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu Ki-kare testi istatisti\u011fi ve serbestlik dereceleriyle ili\u015fkili p de\u011ferini bulmak i\u00e7in Excel&#8217;de a\u015fa\u011f\u0131daki kodu kullanabiliriz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><b>=CHISQ.DIST.RT( <strong>0.8642<\/strong> , 2)<\/b><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Excel&#8217;de \u015f\u00f6yle g\u00f6r\u00fcn\u00fcr:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9800 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chi_p_excel2.png\" alt=\"Excel'de Ki-kare puan\u0131 i\u00e7in P de\u011feri\" width=\"452\" height=\"392\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">P de\u011feri <strong>0,649144<\/strong> olarak \u00e7\u0131k\u0131yor. Bu p de\u011feri 0,05&#8217;ten k\u00fc\u00e7\u00fck olmad\u0131\u011f\u0131ndan s\u0131f\u0131r hipotezini reddedemiyoruz. Bu, cinsiyet ile siyasi parti tercihleri aras\u0131nda bir ili\u015fki oldu\u011funu s\u00f6yleyecek yeterli kan\u0131ta sahip olmad\u0131\u011f\u0131m\u0131z anlam\u0131na geliyor.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\"><i>Daha fazla Excel e\u011fitimini burada bulabilirsiniz.<\/i><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Her Ki-kare testi yapt\u0131\u011f\u0131n\u0131zda, bir Ki-kare testi istatisti\u011fi elde edersiniz. Daha sonra test sonu\u00e7lar\u0131n\u0131n istatistiksel olarak anlaml\u0131 olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in bu test istatisti\u011fine kar\u015f\u0131l\u0131k gelen p de\u011ferini bulabilirsiniz. Excel&#8217;de Ki-kare testi istatisti\u011fine kar\u015f\u0131l\u0131k gelen p de\u011ferini bulmak i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanan CHISQ.DIST.RT() i\u015flevini kullanabilirsiniz: =K\u0130KARE.DA\u011e.RT(x, derece_serbestlik) Alt\u0131n: x: ki-kare testi istatisti\u011fi deg_freedom: Serbestlik dereceleri [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-926","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de ki-kare istatisti\u011finin P de\u011feri nas\u0131l bulunur?<\/title>\n<meta name=\"description\" content=\"Excel&#039;de ki-kare istatisti\u011fi i\u00e7in p de\u011ferinin nas\u0131l bulunaca\u011f\u0131na ili\u015fkin birka\u00e7 \u00f6rnek i\u00e7eren basit bir a\u00e7\u0131klama.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de ki-kare istatisti\u011finin P de\u011feri nas\u0131l bulunur?\" \/>\n<meta property=\"og:description\" content=\"Excel&#039;de ki-kare istatisti\u011fi i\u00e7in p de\u011ferinin nas\u0131l bulunaca\u011f\u0131na ili\u015fkin birka\u00e7 \u00f6rnek i\u00e7eren basit bir a\u00e7\u0131klama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T07:20:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chi_p_excel1.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/\",\"url\":\"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/\",\"name\":\"Excel&#39;de ki-kare istatisti\u011finin P de\u011feri nas\u0131l bulunur?\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-28T07:20:31+00:00\",\"dateModified\":\"2023-07-28T07:20:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Excel&#39;de ki-kare istatisti\u011fi i\u00e7in p de\u011ferinin nas\u0131l bulunaca\u011f\u0131na ili\u015fkin birka\u00e7 \u00f6rnek i\u00e7eren basit bir a\u00e7\u0131klama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de ki-kare istatisti\u011finin p de\u011feri nas\u0131l bulunur?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de ki-kare istatisti\u011finin P de\u011feri nas\u0131l bulunur?","description":"Excel&#39;de ki-kare istatisti\u011fi i\u00e7in p de\u011ferinin nas\u0131l bulunaca\u011f\u0131na ili\u015fkin birka\u00e7 \u00f6rnek i\u00e7eren basit bir a\u00e7\u0131klama.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de ki-kare istatisti\u011finin P de\u011feri nas\u0131l bulunur?","og_description":"Excel&#39;de ki-kare istatisti\u011fi i\u00e7in p de\u011ferinin nas\u0131l bulunaca\u011f\u0131na ili\u015fkin birka\u00e7 \u00f6rnek i\u00e7eren basit bir a\u00e7\u0131klama.","og_url":"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/","og_site_name":"Statorials","article_published_time":"2023-07-28T07:20:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chi_p_excel1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/","url":"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/","name":"Excel&#39;de ki-kare istatisti\u011finin P de\u011feri nas\u0131l bulunur?","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-28T07:20:31+00:00","dateModified":"2023-07-28T07:20:31+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Excel&#39;de ki-kare istatisti\u011fi i\u00e7in p de\u011ferinin nas\u0131l bulunaca\u011f\u0131na ili\u015fkin birka\u00e7 \u00f6rnek i\u00e7eren basit bir a\u00e7\u0131klama.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/ki-kare-excel-istatistiginin-p-degeri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de ki-kare istatisti\u011finin p de\u011feri nas\u0131l bulunur?"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=926"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/926\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}