{"id":15303,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kikaretest\/"},"modified":"2021-02-25T16:23:27","modified_gmt":"2021-02-25T16:23:27","slug":"chitest","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/chitest\/","title":{"rendered":"K\u0130KARETEST"},"content":{"rendered":"<p>Microsoft Excel ve Google Sheets, verileri analiz etmek ve hesaplamalar yapmak i\u00e7in son derece etkili ara\u00e7lard\u0131r. Bu programlarda yer alan <strong>CHITEST<\/strong> veya di\u011fer ad\u0131yla <strong>K\u0130KARETEST<\/strong> fonksiyonu, iki veri seti aras\u0131ndaki ba\u011f\u0131ms\u0131zl\u0131k derecesini de\u011ferlendirmek amac\u0131yla kullan\u0131l\u0131r. Bu fonksiyon, kategorik veriler \u00fczerinde ki-kare testi uygulayarak, iki kategorik de\u011fi\u015fken aras\u0131nda istatistiksel bir ili\u015fkinin olup olmad\u0131\u011f\u0131n\u0131 test eder.<\/p>\n<h2>Fonksiyonun Tan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n<p><strong>K\u0130KARETEST<\/strong> fonksiyonu, iki veri dizisi veya matris aras\u0131nda beklenen frekanslarla olan uyumlulu\u011fu de\u011ferlendirir. Fonksiyonun s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n<pre><code>=CHITEST(aktual_aral\u0131k, beklenen_aral\u0131k)<\/code><\/pre>\n<ul>\n<li><strong>aktual_aral\u0131k:<\/strong> G\u00f6zlemlenen frekanslar\u0131n bulundu\u011fu h\u00fccre aral\u0131\u011f\u0131.<\/li>\n<li><strong>beklenen_aral\u0131k:<\/strong> Teorik, beklenen frekanslar\u0131n bulundu\u011fu h\u00fccre aral\u0131\u011f\u0131.<\/li>\n<\/ul>\n<p>Elde edilen sonu\u00e7 bir p-de\u011feri olarak tan\u0131mlan\u0131r ve bu de\u011fer 0 ile 1 aras\u0131nda bir de\u011fer al\u0131r. P-de\u011feri, null hipotezin (iki grup aras\u0131nda ili\u015fki yoktur) reddedilip reddedilmedi\u011fini belirlemek i\u00e7in kullan\u0131l\u0131r. Genelde, p-de\u011feri 0.05&#8217;ten k\u00fc\u00e7\u00fckse, null hipotezi reddedilir ve b\u00f6ylece gruplar aras\u0131nda istatistiksel olarak anlaml\u0131 bir ili\u015fki var oldu\u011fu sonucuna var\u0131l\u0131r.<\/p>\n<h2>Kullan\u0131m Senaryolar\u0131<\/h2>\n<p>Ki-kare test fonksiyonunun Excel ve Google Sheets&#8217;te pratik uygulamalar\u0131ndan iki \u00f6rnek a\u015fa\u011f\u0131da verilmi\u015ftir:<\/p>\n<h2>\u00d6rnek 1: Reklam Kampanyas\u0131n\u0131n Etkilili\u011finin De\u011ferlendirilmesi<\/h2>\n<p>Diyelim ki, bir \u015firket iki farkl\u0131 reklam kampanyas\u0131n\u0131n etkilili\u011fini \u00f6l\u00e7mek istiyor. M\u00fc\u015fteriler iki gruba ayr\u0131l\u0131r, bir gruba A kampanyas\u0131, di\u011ferine B kampanyas\u0131 uygulan\u0131r. M\u00fc\u015fteri tepkileri \u015fu \u015fekilde toplan\u0131r:<\/p>\n<pre><code><table> <tr> <th>Kampanya \/ Tepki<\/th> <th>Olumlu<\/th> <th>Olumsuz<\/th> <\/tr> <tr> <td>A Kampanyas\u0131<\/td> <td>300<\/td> <td>200<\/td> <\/tr> <tr> <td>B Kampanyas\u0131<\/td> <td>250<\/td> <td>250<\/td> <\/tr> <\/table><\/code><\/pre>\n<p>Bu verilere dayanarak, CHITEST fonksiyonunu kullanarak iki kampanyan\u0131n etkilili\u011finin fark\u0131n\u0131 de\u011ferlendirebiliriz:<\/p>\n<pre><code>=CHITEST(A2:B3, D2:E3)<\/code><\/pre>\n<p>Bu form\u00fclde A2:B3 aral\u0131\u011f\u0131 g\u00f6zlemlenen frekanslar\u0131, D2:E3 aral\u0131\u011f\u0131 ise e\u015fit etkililik varsay\u0131m\u0131na g\u00f6re beklenen frekanslar\u0131 temsil eder. E\u011fer hesaplanan p-de\u011feri 0.05&#8217;ten k\u00fc\u00e7\u00fck \u00e7\u0131karsa, kampanyalar aras\u0131nda anlaml\u0131 bir etkililik fark\u0131 oldu\u011funu s\u00f6yleyebiliriz.<\/p>\n<h2>\u00d6rnek 2: E\u011fitim Seviyesi ve \u00dcr\u00fcn Tercihi \u0130li\u015fkisinin Analizi<\/h2>\n<p>\u0130kinci \u00f6rnekte, farkl\u0131 e\u011fitim seviyelerine sahip bireylerin belirli bir \u00fcr\u00fcn\u00fc tercih edip etmediklerini inceleyelim. \u00dc\u00e7 farkl\u0131 e\u011fitim d\u00fczeyi (Lise, \u00dcniversite, Y\u00fcksek Lisans) ve bunlar\u0131n \u00fcr\u00fcn tercihleri (Tercih Edildi, Tercih Edilmedi) toplanm\u0131\u015ft\u0131r:<\/p>\n<pre><code><table> <tr> <th>E\u011fitim \/ Tercih<\/th> <th>Tercih Edildi<\/th> <th>Tercih Edilmedi<\/th> <\/tr> <tr> <td>Lise<\/td> <td>85<\/td> <td>215<\/td> <\/tr> <tr> <td>\u00dcniversite<\/td> <td>125<\/td> <td>75<\/td> <\/tr> <tr> <td>Y\u00fcksek Lisans<\/td> <td>70<\/td> <td>30<\/td> <\/tr> <\/table><\/code><\/pre>\n<p>Bu verilere dayanarak, e\u011fitim seviyesinin \u00fcr\u00fcn tercihi \u00fczerinde istatistiksel olarak anlaml\u0131 bir etkiye sahip olup olmad\u0131\u011f\u0131n\u0131 analiz etmek i\u00e7in a\u015fa\u011f\u0131daki CHITEST form\u00fcl\u00fcn\u00fc kullan\u0131r\u0131z:<\/p>\n<pre><code>=CHITEST(A2:B4, D2:E4)<\/code><\/pre>\n<p>Burada A2:B4 aral\u0131\u011f\u0131 g\u00f6zlemlenen frekanslar\u0131, D2:E4 aral\u0131\u011f\u0131 ise her e\u011fitim d\u00fczeyinde e\u015fit \u00fcr\u00fcn tercihi olmas\u0131n\u0131n beklenen frekanslar\u0131n\u0131 i\u00e7erir. E\u011fer p-de\u011feri 0.05&#8217;ten k\u00fc\u00e7\u00fckse, e\u011fitim seviyesinin \u00fcr\u00fcn tercihlerine anlaml\u0131 bir etkisi oldu\u011funu s\u00f6yleyebiliriz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ba\u011f\u0131ms\u0131zl\u0131k s\u0131namas\u0131n\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[584],"tags":[],"class_list":["post-15303","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de CHITEST (K\u0130KARETEST) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da CHITEST (K\u0130KARETEST) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/chitest\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de CHITEST (K\u0130KARETEST) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da CHITEST (K\u0130KARETEST) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/chitest\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:23:27+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de CHITEST (K\u0130KARETEST) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\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:\/\/functiontranslator.com\/tr\/chitest\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/chitest\/\",\"name\":\"Excel'de CHITEST (K\u0130KARETEST) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:23:27+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da CHITEST (K\u0130KARETEST) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/chitest\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/chitest\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/chitest\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uyumluluk\",\"item\":\"https:\/\/functiontranslator.com\/tr\/uyumluluk\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"K\u0130KARETEST\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de CHITEST (K\u0130KARETEST) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da CHITEST (K\u0130KARETEST) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/chitest\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de CHITEST (K\u0130KARETEST) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da CHITEST (K\u0130KARETEST) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/chitest\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:23:27+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de CHITEST (K\u0130KARETEST) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/chitest\/","url":"https:\/\/functiontranslator.com\/tr\/chitest\/","name":"Excel'de CHITEST (K\u0130KARETEST) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:23:27+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da CHITEST (K\u0130KARETEST) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/chitest\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/chitest\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/chitest\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Uyumluluk","item":"https:\/\/functiontranslator.com\/tr\/uyumluluk\/"},{"@type":"ListItem","position":3,"name":"K\u0130KARETEST"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15303"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15303\/revisions"}],"predecessor-version":[{"id":26571,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15303\/revisions\/26571"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}