{"id":725,"date":"2023-07-28T23:32:04","date_gmt":"2023-07-28T23:32:04","guid":{"rendered":"https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/"},"modified":"2023-07-28T23:32:04","modified_gmt":"2023-07-28T23:32:04","slug":"ki-kare-uyum-kalitesi-testi-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/","title":{"rendered":"Excel'de ki kare uyum testi nas\u0131l yap\u0131l\u0131r?"},"content":{"rendered":"

<\/p>\n

\n

Kategorik bir de\u011fi\u015fkenin varsay\u0131msal bir da\u011f\u0131l\u0131ma uyup uymad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in ki-kare uyum iyili\u011fi testi<\/a><\/strong> kullan\u0131l\u0131r.<\/span><\/p>\n

Bu e\u011fitimde Excel’de ki-kare uyum iyili\u011fi testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.<\/span><\/p>\n

\u00d6rnek: Excel’de ki-kare uyum iyili\u011fi testi<\/strong><\/span><\/h3>\n

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

    \n
  • Pazartesi:<\/strong> 50 m\u00fc\u015fteri<\/span><\/li>\n
  • Sal\u0131:<\/strong> 60 m\u00fc\u015fteri<\/span><\/li>\n
  • \u00c7ar\u015famba:<\/strong> 40 m\u00fc\u015fteri<\/span><\/li>\n
  • Per\u015fembe:<\/strong> 47 m\u00fc\u015fteri<\/span><\/li>\n
  • Cuma:<\/strong> 53 m\u00fc\u015fteri<\/span><\/li>\n<\/ul>\n

    Verilerin ma\u011faza sahibinin iddias\u0131yla tutarl\u0131 olup olmad\u0131\u011f\u0131n\u0131 belirlemek amac\u0131yla ki-kare uyum iyili\u011fi testi ger\u00e7ekle\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullanaca\u011f\u0131z.<\/span><\/p>\n

    Ad\u0131m 1: Verileri girin.<\/strong><\/span><\/p>\n

    \u00d6ncelikle her g\u00fcn beklenen m\u00fc\u015fteri say\u0131s\u0131 i\u00e7in veri de\u011ferlerini bir s\u00fctuna, her g\u00fcn g\u00f6zlemlenen m\u00fc\u015fteri say\u0131s\u0131n\u0131 ba\u015fka bir s\u00fctuna girece\u011fiz:<\/span> <\/p>\n

    \"Excel'de<\/p>\n

    Not:<\/strong> Toplamda 250 m\u00fc\u015fteri vard\u0131. Yani ma\u011faza sahibi her g\u00fcn ma\u011fazaya e\u015fit say\u0131da m\u00fc\u015fterinin girmesini bekliyorsa, g\u00fcnde 50 m\u00fc\u015fterisinin olmas\u0131n\u0131 bekleyecektir.<\/em><\/span><\/p>\n

    Ad\u0131m 2: G\u00f6zlemlenen ve beklenen de\u011ferler aras\u0131ndaki fark\u0131 bulun.<\/strong><\/span><\/p>\n

    Uyum iyili\u011fi testi i\u00e7in Ki-kare testi istatisti\u011fi X 2<\/sup> = \u03a3(OE) 2<\/sup> \/ E’dir.<\/strong><\/span><\/p>\n

    Alt\u0131n:<\/span><\/p>\n

      \n
    • \u03a3:<\/strong> \u201ctoplam\u201d anlam\u0131na gelen s\u00fcsl\u00fc bir sembold\u00fcr<\/span><\/li>\n
    • O:<\/strong> g\u00f6zlemlenen de\u011fer<\/span><\/li>\n
    • E:<\/strong> beklenen de\u011fer<\/span><\/li>\n<\/ul>\n

      A\u015fa\u011f\u0131daki form\u00fcl, her sat\u0131r i\u00e7in (OE) 2<\/sup> \/E’nin<\/strong> nas\u0131l hesaplanaca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n

      \"Excel'de<\/p>\n

      Ad\u0131m 3: Ki-kare testi istatisti\u011fini ve kar\u015f\u0131l\u0131k gelen p de\u011ferini hesaplay\u0131n.<\/strong><\/span><\/p>\n

      Son olarak, a\u015fa\u011f\u0131daki form\u00fclleri kullanarak Ki-kare test istatisti\u011fini ve kar\u015f\u0131l\u0131k gelen p-de\u011ferini hesaplayaca\u011f\u0131z:<\/span> <\/p>\n

      \"Excel'de<\/p>\n

      Not:<\/strong> Excel i\u015flevi CHISQ.DIST.RT(x, deg_freedom),<\/strong> x<\/strong> test istatisti\u011fi ve belirli bir serbestlik derecesi ile ili\u015fkili Ki-kare da\u011f\u0131l\u0131m\u0131n\u0131n do\u011fru olas\u0131l\u0131\u011f\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Serbestlik dereceleri n-1 olarak hesaplan\u0131r. Bu durumda, serbestlik derecesi = 5 \u2013 1 = 4.<\/span><\/p>\n

      Ad\u0131m 4: Sonu\u00e7lar\u0131 yorumlay\u0131n.<\/strong><\/span><\/p>\n

      Testin X2<\/sup> test istatisti\u011fi 4,36<\/strong> ve buna kar\u015f\u0131l\u0131k gelen p de\u011feri 0,3595’tir<\/strong> . Bu p de\u011feri 0,05’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","protected":false},"excerpt":{"rendered":"

      Kategorik bir de\u011fi\u015fkenin varsay\u0131msal bir da\u011f\u0131l\u0131ma uyup uymad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in ki-kare uyum iyili\u011fi testi kullan\u0131l\u0131r. Bu e\u011fitimde Excel’de ki-kare uyum iyili\u011fi testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r. \u00d6rnek: Excel’de ki-kare uyum iyili\u011fi testi 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 […]<\/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-725","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel'de Ki Kare Uyum Testi Nas\u0131l Yap\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de ki-kare uyum iyili\u011fi testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin 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-uyum-kalitesi-testi-excel\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de Ki Kare Uyum Testi Nas\u0131l Yap\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de ki-kare uyum iyili\u011fi testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin basit bir a\u00e7\u0131klama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T23:32:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gofexcel1.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-uyum-kalitesi-testi-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/\",\"name\":\"Excel'de Ki Kare Uyum Testi Nas\u0131l Yap\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-28T23:32:04+00:00\",\"dateModified\":\"2023-07-28T23:32:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de ki-kare uyum iyili\u011fi testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin basit bir a\u00e7\u0131klama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel'de ki kare uyum testi nas\u0131l yap\u0131l\u0131r?\"}]},{\"@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'de Ki Kare Uyum Testi Nas\u0131l Yap\u0131l\u0131r?","description":"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de ki-kare uyum iyili\u011fi testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin 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-uyum-kalitesi-testi-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de Ki Kare Uyum Testi Nas\u0131l Yap\u0131l\u0131r?","og_description":"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de ki-kare uyum iyili\u011fi testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin basit bir a\u00e7\u0131klama.","og_url":"https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T23:32:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gofexcel1.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-uyum-kalitesi-testi-excel\/","url":"https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/","name":"Excel'de Ki Kare Uyum Testi Nas\u0131l Yap\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-28T23:32:04+00:00","dateModified":"2023-07-28T23:32:04+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de ki-kare uyum iyili\u011fi testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin basit bir a\u00e7\u0131klama.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/ki-kare-uyum-kalitesi-testi-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel'de ki kare uyum testi nas\u0131l yap\u0131l\u0131r?"}]},{"@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\/725","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=725"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/725\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=725"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}