{"id":15692,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/t-test\/"},"modified":"2021-02-25T16:38:14","modified_gmt":"2021-02-25T16:38:14","slug":"t-test","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/t-test\/","title":{"rendered":"T.TEST"},"content":{"rendered":"

Farkl\u0131 veri gruplar\u0131 aras\u0131nda istatistiksel bir k\u0131yaslama yapmak i\u00e7in kullan\u0131lan fonksiyonlardan biri T.TEST fonksiyonudur. Microsoft Excel ve Google E-Tablolar ortamlar\u0131nda bu fonksiyon, iki \u00f6rneklemin ortalamalar\u0131 aras\u0131ndaki fark\u0131n istatistiksel olarak anlaml\u0131 olup olmad\u0131\u011f\u0131n\u0131 test etmek i\u00e7in kullan\u0131l\u0131r. Bu makalede, T.TEST fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011freneceksiniz. Makalemiz, g\u00f6rsel olmadan ad\u0131m ad\u0131m a\u00e7\u0131klamalar ve pratik \u00f6rnekler i\u00e7erecektir.<\/p>\n

Fonksiyon S\u00f6zdizimi ve Kullan\u0131m \u015eekli<\/h2>\n

T.TEST fonksiyonunun genel kullan\u0131m\u0131 a\u015fa\u011f\u0131daki gibidir:<\/p>\n

  T.TEST(array1, array2, tails, type) <\/code> <\/pre>\n
    \n
  • array1, array2:<\/strong> \u0130statistiksel testin yap\u0131laca\u011f\u0131 iki veri grubudur.<\/li>\n
  • tails:<\/strong> Testin bir tarafl\u0131 m\u0131 yoksa iki tarafl\u0131 m\u0131 oldu\u011funu belirten parametredir. 1 ve 2 de\u011ferlerini alabilir.<\/li>\n
  • type:<\/strong> Hangi t\u00fcr t testinin uygulanaca\u011f\u0131n\u0131 belirleyen parametredir (1: e\u015fle\u015fmemi\u015f ve varyanslar e\u015fit varsay\u0131lmaz, 2: e\u015fle\u015fmemi\u015f ve varyanslar e\u015fit varsay\u0131l\u0131r, 3: e\u015fle\u015ftirilmi\u015f).<\/li>\n<\/ul>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    \u0130\u015f d\u00fcnyas\u0131 ve e\u011fitim alan\u0131nda T.TEST fonksiyonunun kullanabilece\u011fi pratik senaryolara \u00f6rnek verebiliriz.<\/p>\n
    \u00d6rnek 1: Pazarlama Kampanyas\u0131n\u0131n Etkilili\u011fi<\/h2>\n
    Bir \u015firket, iki farkl\u0131 pazarlama stratejisini test etmekte ve hangi stratejinin daha etkili oldu\u011funu anlamak istemektedir. \u0130ki farkl\u0131 m\u00fc\u015fteri grubundan elde etti\u011fi sat\u0131\u015f verileri \u00fczerinden, T.TEST fonksiyonu ile anlaml\u0131l\u0131k testi yap\u0131labilir.<\/p>\n
      = T.TEST(B2:B101, C2:C101, 2, 2) <\/code> <\/pre>\n
    Bu form\u00fcl, B2:B101 h\u00fccre aral\u0131\u011f\u0131nda yer alan 1. grup verileri ve C2:C101 h\u00fccre aral\u0131\u011f\u0131nda yer alan 2. grup verilerini kullanarak, iki tarafl\u0131 bir test (tails = 2) ve varyanslar e\u015fit varsay\u0131larak (type=2) yap\u0131lmaktad\u0131r.<\/p>\n
    \u00d6rnek 2: E\u011fitim Programlar\u0131n\u0131n Kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131<\/h2>\n
    Bir e\u011fitim kurumu, farkl\u0131 e\u011fitim programlar\u0131n\u0131n \u00f6\u011frenci ba\u015far\u0131lar\u0131 \u00fczerindeki etkisini \u00f6l\u00e7mek istiyor olabilir. \u0130ki grup \u00f6\u011frencinin s\u0131nav sonu\u00e7lar\u0131 \u00fczerinden, bir t-testi yaparak iki program\u0131n da \u00f6\u011frenci performanslar\u0131 \u00fczerindeki etkisini anlamak m\u00fcmk\u00fcn olabilir.<\/p>\n
      = T.TEST(D2:D51, E2:E51, 1, 1) <\/code> <\/pre>\n
    Bu form\u00fclde, D2:D51 h\u00fccre aral\u0131\u011f\u0131nda yer alan birinci e\u011fitim program\u0131n\u0131n verileri ve E2:E51 h\u00fccre aral\u0131\u011f\u0131nda yer alan ikinci e\u011fitim program\u0131n\u0131n verileri kullan\u0131lm\u0131\u015ft\u0131r. Burada, test bir tarafl\u0131 olarak (tails = 1) ve varyanslar e\u015fit kabul edilmezken (type = 1) yap\u0131lm\u0131\u015ft\u0131r.<\/p>\n
    Sonu\u00e7lar\u0131n De\u011ferlendirilmesi<\/h2>\n
    T.TEST fonksiyonu kullan\u0131larak elde edilen sonu\u00e7lar, genellikle bir p-de\u011feri (anlaml\u0131l\u0131k de\u011feri) formunda verilir. Bu de\u011fer, genellikle \u00f6nceden belirlenen bir anlaml\u0131l\u0131k d\u00fczeyi (\u00f6rne\u011fin, 0.05) ile kar\u015f\u0131la\u015ft\u0131r\u0131l\u0131r. elde edilen p-de\u011feri, belirlenen anlaml\u0131l\u0131k d\u00fczeyinden d\u00fc\u015f\u00fckse, hipoteziniz istatistiksel olarak anlaml\u0131d\u0131r ve iki veri grubu aras\u0131nda \u00f6nemli bir fark oldu\u011fu sonucuna var\u0131labilir. E\u011fer p-de\u011feri y\u00fcksekse bu, iki grup aras\u0131nda istatistiksel olarak \u00f6nemli bir fark olmad\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/p>\n
    Bu fonksiyon, verileriniz \u00fczerinde derinlemesine analiz yapman\u0131za ve \u00f6nemli kararlar alman\u0131za yard\u0131mc\u0131 olabilir. Fonksiyonun d\u00fczg\u00fcn kullan\u0131m\u0131 ve veri setlerinin do\u011fru se\u00e7imi, sonu\u00e7lar\u0131n g\u00fcvenilirli\u011fini art\u0131r\u0131r.<\/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":[582],"tags":[],"class_list":["post-15692","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de T.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da T.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\/t-test\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de T.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da T.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\/t-test\/\" \/>\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:14+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 T.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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/t-test\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/t-test\/\",\"name\":\"Excel'de T.TEST 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:14+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da T.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\/t-test\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/t-test\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/t-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\":\"T.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 T.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da T.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\/t-test\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de T.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da T.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\/t-test\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:38:14+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de T.TEST Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/t-test\/","url":"https:\/\/functiontranslator.com\/tr\/t-test\/","name":"Excel'de T.TEST 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:14+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da T.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\/t-test\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/t-test\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/t-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":"T.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\/15692","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=15692"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15692\/revisions"}],"predecessor-version":[{"id":26960,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15692\/revisions\/26960"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}