{"id":15682,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/t-ters\/"},"modified":"2021-02-25T16:37:42","modified_gmt":"2021-02-25T16:37:42","slug":"t-inv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/t-inv\/","title":{"rendered":"T.TERS"},"content":{"rendered":"<h2>\u0130statistiksel Analizlerde T.INV Fonksiyonunun Kullan\u0131m\u0131<\/h2>\n<p>T.INV fonksiyonu, MS Excel ve Google E-Tablolar&#8217;da kullan\u0131lan ve istatistiksel analizlerde \u00f6nemli bir yere sahip olan bir i\u015flevdir. T.INV fonksiyonu, belirli bir olas\u0131l\u0131\u011fa kar\u015f\u0131l\u0131k gelen t-da\u011f\u0131l\u0131m\u0131n\u0131n de\u011ferini tersine \u00e7evirir. Bu fonksiyon, \u00f6zellikle \u00f6\u011frenci t da\u011f\u0131l\u0131m\u0131 alt\u0131nda belirli bir y\u00fczde d\u00fczeyindeki kritik de\u011ferleri bulmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n<h2>T.INV \u0130\u015flevinin S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n<p><code>T.INV(probability, degrees_freedom)<\/code><\/p>\n<ul>\n<li><strong>probability<\/strong>: T da\u011f\u0131l\u0131m\u0131n\u0131n alt\u0131nda kalan alan\u0131 temsil eden olas\u0131l\u0131k de\u011feri. Bu de\u011fer 0 ile 1 aras\u0131nda olmal\u0131d\u0131r.<\/li>\n<li><strong>degrees_freedom<\/strong>: Serbest derece say\u0131s\u0131n\u0131 tan\u0131mlar. Bu de\u011fer, \u00f6rneklemin b\u00fcy\u00fckl\u00fc\u011f\u00fcnden 1 eksik olacak \u015fekilde hesaplan\u0131r ve pozitif bir tam say\u0131 olmal\u0131d\u0131r.<\/li>\n<\/ul>\n<pre><code>\u00d6rne\u011fin, bir \u00f6\u011frenci t da\u011f\u0131l\u0131m\u0131 i\u00e7in %5 olas\u0131l\u0131k ve 10 serbest derece ile kritik de\u011feri bulmak istedi\u011finizde form\u00fcl \u015fu \u015fekilde kullan\u0131l\u0131r: Excel i\u00e7in: =T.INV(0.05, 10) Google E-Tablolar i\u00e7in: =T.INV(0.05, 10)<\/code><\/pre>\n<h2>Kritik De\u011fer Hesaplama<\/h2>\n<p>\u0130statistiksel testlerde, \u00f6zellikle hipotez testleri s\u0131ras\u0131nda kritik de\u011ferlerin belirlenmesi i\u00e7in T.INV i\u015flevi kullan\u0131l\u0131r. Kullan\u0131m \u00f6rne\u011fi olarak, 25 g\u00f6zlem i\u00e7eren bir veri setinde %10 hata pay\u0131yla kritik t de\u011ferini bulal\u0131m:<\/p>\n<pre><code>= T.INV(0.1, 24) Bu i\u015flem, serbestlik derecesi (n-1) 24 olan t-da\u011f\u0131l\u0131m\u0131 i\u00e7in %10 olas\u0131l\u0131kta kritik t de\u011ferini verir.<\/code><\/pre>\n<h2>\u0130ki \u00d6rnekli Testlerde De\u011ferlendirme<\/h2>\n<p>T.INV fonksiyonu ayn\u0131 zamanda ba\u011f\u0131ms\u0131z iki \u00f6rnekli t-testlerde ve e\u015fle\u015ftirilmi\u015f \u00f6rnekler t-testi gibi analizlerde kullan\u0131labilir. \u00d6rne\u011fin, iki grup aras\u0131ndaki ortalamalar\u0131n fark\u0131 i\u00e7in hata pay\u0131n\u0131 kontrol ederek analiz yapabilirsiniz. Diyelim ki iki grubun serbestlik dereceleri toplam\u0131 30 olsun ve %5 hata pay\u0131na g\u00f6re kritik t de\u011ferini bulmak istiyoruz:<\/p>\n<pre><code>= T.INV(0.05, 30) Bu form\u00fcl, iki grup aras\u0131ndaki fark\u0131n istatistiksel olarak anlaml\u0131 olup olmad\u0131\u011f\u0131n\u0131 de\u011ferlendirmek i\u00e7in kullan\u0131labilir.<\/code><\/pre>\n<p>Yukar\u0131daki \u00f6rnekler ve a\u00e7\u0131klamalar, T.INV fonksiyonunun ne \u015fekilde kullan\u0131labilece\u011fini g\u00f6stermekte olup, pratikte pek \u00e7ok farkl\u0131 senaryoda bu fonksiyon veri analistleri ve istatistik\u00e7iler taraf\u0131ndan kullan\u0131lmaktad\u0131r. Fonksiyonun do\u011fru kullan\u0131m\u0131, bilimsel ve ticari kararlarda daha sa\u011flam sonu\u00e7lara ula\u015f\u0131lmas\u0131na yard\u0131mc\u0131 olur.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Olas\u0131l\u0131k ve serbestlik derecelerinin i\u015flev olarak, Student t-da\u011f\u0131l\u0131m\u0131n\u0131n t-de\u011ferini 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-15682","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"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 T.INV (T.TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da T.INV (T.TERS) 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-inv\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de T.INV (T.TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da T.INV (T.TERS) 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-inv\/\" \/>\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:37:42+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 T.INV (T.TERS) 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\/t-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/t-inv\/\",\"name\":\"Excel'de T.INV (T.TERS) 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:37:42+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da T.INV (T.TERS) 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-inv\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/t-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/t-inv\/#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.TERS\"}]},{\"@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.INV (T.TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da T.INV (T.TERS) 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-inv\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de T.INV (T.TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da T.INV (T.TERS) 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-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:37:42+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de T.INV (T.TERS) 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\/t-inv\/","url":"https:\/\/functiontranslator.com\/tr\/t-inv\/","name":"Excel'de T.INV (T.TERS) 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:37:42+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da T.INV (T.TERS) 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-inv\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/t-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/t-inv\/#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.TERS"}]},{"@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\/15682","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=15682"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15682\/revisions"}],"predecessor-version":[{"id":26950,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15682\/revisions\/26950"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}