{"id":15693,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/ttest\/"},"modified":"2021-02-25T16:38:18","modified_gmt":"2021-02-25T16:38:18","slug":"ttest","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/ttest\/","title":{"rendered":"TTEST"},"content":{"rendered":"

\u0130ki \u00d6rneklem T \u0130statisti\u011fi Testi<\/h2>\n

\u0130statistiksel analizlerde, \u00f6zellikle iki grup aras\u0131ndaki ortalama farklar\u0131n anlaml\u0131l\u0131\u011f\u0131n\u0131 test etmek i\u00e7in kullan\u0131lan T \u0130statisti\u011fi Testi (T-Test), hem Microsoft Excel hem de Google E-Tablolar’da s\u0131k kullan\u0131lan bir fonksiyondur. \u0130ki ayr\u0131 veri grubunun ortalamalar\u0131 aras\u0131nda istatistiksel olarak anlaml\u0131 bir fark olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in kullan\u0131l\u0131r. Bu yaz\u0131da bu i\u015flevin s\u00f6zdizimini, uygulanabilece\u011fi pratik g\u00f6revleri ve yorumlar\u0131 ile ele alaca\u011f\u0131z. <\/p>\n

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

Hem Excel hem de Google E-Tablolar i\u00e7in i\u015flevin genel s\u00f6zdizimi \u015f\u00f6yledir: <\/p>\n

 TTEST(array1, array2, tails, type)<\/code> <\/pre>\n
    \n
  • array1:<\/strong> \u0130lk veri grubunu temsil eder.<\/li>\n
  • array2:<\/strong> \u0130kinci veri grubunu temsil eder.<\/li>\n
  • tails:<\/strong> Testin tek kuyruklu mu yoksa \u00e7ift kuyruklu mu oldu\u011funu belirtir (1 veya 2).<\/li>\n
  • type:<\/strong> Test t\u00fcr\u00fcn\u00fc belirtir. Bu, e\u015fit varyansl\u0131 iki \u00f6rnekli t-test (1), farkl\u0131 varyansl\u0131 iki \u00f6rnekli t-test (2) veya ba\u011f\u0131ms\u0131z olmayan iki \u00f6rnekli t-test (3) olabilir.<\/li>\n<\/ul>\n
    Pratik G\u00f6revler ve \u00c7\u00f6z\u00fcmleri<\/h2>\n
    \u0130ki Grup Aras\u0131nda Ortalama Kar\u015f\u0131la\u015ft\u0131rmas\u0131<\/h3>\n
     Diyelim ki iki s\u0131n\u0131f\u0131n matematik s\u0131nav sonu\u00e7lar\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131rmak istiyorsunuz. S\u0131n\u0131f A’n\u0131n sonu\u00e7lar\u0131 [85, 90, 88, 93, 95], S\u0131n\u0131f B’nin sonu\u00e7lar\u0131 ise [80, 83, 85, 87, 90] olsun. <\/p>\n
     Excel’de:<\/strong> <\/p>\n
     =TTEST(A1:A5, B1:B5, 2, 2)<\/code> <\/pre>\n
     Google E-Tablolar’da:<\/strong> <\/p>\n
     =T.TEST(A1:A5, B1:B5, 2, 2)<\/code> <\/pre>\n
     Bu fonksiyon, iki s\u0131n\u0131f\u0131n sonu\u00e7lar\u0131 aras\u0131nda istatistiksel olarak anlaml\u0131 bir fark olup olmad\u0131\u011f\u0131n\u0131 de\u011ferlendirir. ‘2’ de\u011feri, testin \u00e7ift kuyruklu oldu\u011funu ve farkl\u0131 varyanslar kabul edildi\u011fini g\u00f6sterir. <\/p>\n
    M\u00fcdahale Grubu ile Kontrol Grubu Analizi<\/h3>\n
     Bir sa\u011fl\u0131k \u00e7al\u0131\u015fmas\u0131nda m\u00fcdahale grubu ve kontrol grubu \u00fczerinde yap\u0131lan tansiyon \u00f6l\u00e7\u00fcmlerini analiz edece\u011fiz. M\u00fcdahale grubunun de\u011ferleri [120, 122, 119, 123, 121], kontrol grubunun de\u011ferleri [130, 135, 138, 132, 131] olsun. <\/p>\n
     Excel’de:<\/strong> <\/p>\n
     =TTEST(A1:A5, B1:B5, 2, 3)<\/code> <\/pre>\n
     Google E-Tablolar’da:<\/strong> <\/p>\n
     =T.TEST(A1:A5, B1:B5, 2, 3)<\/code> <\/pre>\n
     Burada ‘3’ de\u011feri, ba\u011f\u0131ms\u0131z olmayan iki \u00f6rnekli t-test kullan\u0131ld\u0131\u011f\u0131n\u0131 belirtir. Bu test, m\u00fcdahale grubuna yap\u0131lan m\u00fcdahalenin etkinli\u011fini de\u011ferlendirirken yard\u0131mc\u0131 olur. <\/p>\n
    Genel Yorumlar<\/h2>\n
     T \u0130statisti\u011fi Testi, \u00f6zellikle bilimsel ara\u015ft\u0131rmalarda veya herhangi iki grubun performans\u0131 aras\u0131ndaki farkl\u0131l\u0131klar\u0131 \u00f6l\u00e7mek istendi\u011finde \u00f6nemli bir ara\u00e7t\u0131r. \u00c7ift kuyruklu testler, iki grup ortalamas\u0131 aras\u0131nda her iki y\u00f6nde de anlaml\u0131l\u0131\u011f\u0131 de\u011ferlendirirken, tek kuyruklu testler belirli bir y\u00f6nde fark arar. Test t\u00fcr\u00fcn\u00fcn do\u011fru se\u00e7ilmesi, ara\u015ft\u0131rma hedeflerine g\u00f6re farkl\u0131 olabilir ve sonu\u00e7lar\u0131n yorumlanmas\u0131nda kritik bir role sahiptir. <\/p>\n","protected":false},"excerpt":{"rendered":"
    Student t-test’le ili\u015fkilendirilmi\u015f olas\u0131l\u0131\u011f\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-15693","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de TTEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da TTEST 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\/ttest\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de TTEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da TTEST 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\/ttest\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:38:18+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 TTEST 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\/ttest\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/ttest\/\",\"name\":\"Excel'de TTEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:38:18+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da TTEST 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\/ttest\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/ttest\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/ttest\/#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\":\"TTEST\"}]},{\"@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 TTEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da TTEST 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\/ttest\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de TTEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da TTEST 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\/ttest\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:38:18+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de TTEST 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\/ttest\/","url":"https:\/\/functiontranslator.com\/tr\/ttest\/","name":"Excel'de TTEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:38:18+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da TTEST 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\/ttest\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/ttest\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/ttest\/#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":"TTEST"}]},{"@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\/15693","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=15693"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15693\/revisions"}],"predecessor-version":[{"id":26961,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15693\/revisions\/26961"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}