{"id":15308,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kikare-test\/"},"modified":"2021-02-25T16:23:38","modified_gmt":"2021-02-25T16:23:38","slug":"chisq-test","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/chisq-test\/","title":{"rendered":"K\u0130KARE.TEST"},"content":{"rendered":"

CHISQ.TEST Fonksiyonunun Kullan\u0131m\u0131<\/h1>\n

CHISQ.TEST, yani Ki Kare Test i\u015flevi, Excel ve Google E-Tablolar’da iki kategorik de\u011fi\u015fken aras\u0131ndaki ba\u011f\u0131ms\u0131zl\u0131\u011f\u0131 test etme amac\u0131yla kullan\u0131l\u0131r. \u0130statistiksel anlamda, bu i\u015flev g\u00f6zlemlenen verilerin ve teorik da\u011f\u0131l\u0131m aras\u0131ndaki uyumu de\u011ferlendirir. \u00d6zellikle anket sonu\u00e7lar\u0131, t\u0131bbi ara\u015ft\u0131rmalar ve pazar ara\u015ft\u0131rmas\u0131 gibi alanlarda s\u0131k\u00e7a tercih edilir.<\/p>\n

\u0130\u015flevin S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

CHISQ.TEST i\u015flevinin genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

  =CHISQ.TEST(g\u00f6zlem_dizisi, beklenen_dizisi) <\/code> <\/pre>\n
    \n
  • g\u00f6zlem_dizisi:<\/strong> G\u00f6zlemlenen frekanslar\u0131 i\u00e7eren dizi ya da aral\u0131k.<\/li>\n
  • beklenen_dizisi:<\/strong> Beklenen (teorik) frekanslar\u0131 i\u00e7eren dizi ya da aral\u0131k.<\/li>\n<\/ul>\n
    \u0130\u015flev, iki dizideki veri say\u0131s\u0131n\u0131n ayn\u0131 olmas\u0131n\u0131 gerektirir ve her iki dizinin de pozitif olmas\u0131 \u015fartt\u0131r.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    Senaryo 1: E\u011fitim S\u00fcrecindeki \u00d6\u011frenci Ba\u015far\u0131lar\u0131<\/h3>\n
    \u00d6\u011fretmenler, \u00f6\u011frencilerin \u00e7e\u015fitli \u00f6\u011frenme y\u00f6ntemlerine cevap verme d\u00fczeylerini belirlemek i\u00e7in CHISQ.TEST i\u015flevini kullanabilirler.<\/p>\n
    \u00d6rne\u011fin, bir \u00f6\u011fretmen iki farkl\u0131 \u00f6\u011fretim metodunu denemi\u015f ve sonu\u00e7lar\u0131 kar\u015f\u0131la\u015ft\u0131rmak istiyor. G\u00f6zlem dizisi \u00f6\u011frencilerin bu metodlarla elde etti\u011fi notlar\u0131n frekans\u0131n\u0131, beklenen dizisi ise her iki metodun e\u015fit ba\u015far\u0131 sa\u011flayaca\u011f\u0131 varsay\u0131m\u0131 ile hesaplanan notlar\u0131n frekans\u0131n\u0131 i\u00e7erir.<\/p>\n
      =CHISQ.TEST(A2:A10, B2:B10) <\/code> <\/pre>\n
    Form\u00fclde A2:A10 aral\u0131\u011f\u0131 ilk metoda ait \u00f6\u011frenci notlar\u0131n\u0131n frekanslar\u0131n\u0131, B2:B10 aral\u0131\u011f\u0131 ise ikinci metoda ait beklentilerin frekanslar\u0131n\u0131 i\u00e7erir. Sonucunda elde edilen p de\u011feri, iki \u00f6\u011fretim metodunun ba\u015far\u0131 d\u00fczeyleri aras\u0131nda anlaml\u0131 bir fark olup olmad\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/p>\n
    Senaryo 2: \u00dcr\u00fcn Tercihleri De\u011ferlendirmesi<\/h3>\n
    Pazar ara\u015ft\u0131rmac\u0131lar\u0131, farkl\u0131 demografik gruplar\u0131n \u00fcr\u00fcn tercihlerini analiz etmek i\u00e7in bu i\u015flevi kullanabilir.<\/p>\n
    \u00d6rne\u011fin, bir \u015firket iki \u00fcr\u00fcn\u00fc piyasaya s\u00fcrm\u00fc\u015f ve hangi ya\u015f grubunun hangi \u00fcr\u00fcn\u00fc tercih etti\u011fini \u00f6\u011frenmek istiyor. G\u00f6zlem dizisi m\u00fc\u015fteri yan\u0131tlar\u0131n\u0131 i\u00e7erirken, beklenen dizisi ise \u00fcr\u00fcnlerin e\u015fit olarak tercih edilece\u011fi varsay\u0131m\u0131na dayan\u0131r.<\/p>\n
      =CHISQ.TEST(C2:C20, D2:D20) <\/code> <\/pre>\n
    Form\u00fclde C2:C20 aral\u0131\u011f\u0131 ya\u015f gruplar\u0131na g\u00f6re ger\u00e7ek m\u00fc\u015fteri tercihlerini, D2:D20 aral\u0131\u011f\u0131 ise beklenen tercihleri ifade eder. \u00c7\u0131kan sonu\u00e7, e\u011fer \u00e7ok d\u00fc\u015f\u00fck bir p de\u011feri ise, demografik gruplar aras\u0131nda anlaml\u0131 bir fark oldu\u011funu belirtir.<\/p>\n
    CHISQ.TEST i\u015flevi, veriler aras\u0131ndaki ili\u015fkilerin ve farklar\u0131n istatistiksel \u00f6neminin de\u011ferlendirilmesi a\u00e7\u0131s\u0131ndan \u00f6nemli bir ara\u00e7t\u0131r. Excel ve Google E-Tablolar’da veri analizi yapan herkes taraf\u0131ndan kolayl\u0131kla kullan\u0131labilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    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":[582],"tags":[],"class_list":["post-15308","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de CHISQ.TEST (K\u0130KARE.TEST) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da CHISQ.TEST (K\u0130KARE.TEST) 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\/chisq-test\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de CHISQ.TEST (K\u0130KARE.TEST) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da CHISQ.TEST (K\u0130KARE.TEST) 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\/chisq-test\/\" \/>\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:38+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de CHISQ.TEST (K\u0130KARE.TEST) 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\/chisq-test\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/chisq-test\/\",\"name\":\"Excel'de CHISQ.TEST (K\u0130KARE.TEST) 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:38+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da CHISQ.TEST (K\u0130KARE.TEST) 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\/chisq-test\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/chisq-test\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/chisq-test\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0130statistik\",\"item\":\"https:\/\/functiontranslator.com\/tr\/istatistik\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"K\u0130KARE.TEST\"}]},{\"@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 CHISQ.TEST (K\u0130KARE.TEST) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da CHISQ.TEST (K\u0130KARE.TEST) 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\/chisq-test\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de CHISQ.TEST (K\u0130KARE.TEST) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da CHISQ.TEST (K\u0130KARE.TEST) 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\/chisq-test\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:23:38+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de CHISQ.TEST (K\u0130KARE.TEST) 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\/chisq-test\/","url":"https:\/\/functiontranslator.com\/tr\/chisq-test\/","name":"Excel'de CHISQ.TEST (K\u0130KARE.TEST) 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:38+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da CHISQ.TEST (K\u0130KARE.TEST) 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\/chisq-test\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/chisq-test\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/chisq-test\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"\u0130statistik","item":"https:\/\/functiontranslator.com\/tr\/istatistik\/"},{"@type":"ListItem","position":3,"name":"K\u0130KARE.TEST"}]},{"@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\/15308","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=15308"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15308\/revisions"}],"predecessor-version":[{"id":26576,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15308\/revisions\/26576"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}