{"id":15412,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/f-ters-sagk\/"},"modified":"2021-02-25T16:27:01","modified_gmt":"2021-02-25T16:27:01","slug":"f-inv-rt","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/f-inv-rt\/","title":{"rendered":"F.TERS.SA\u011eK"},"content":{"rendered":"

Fonksiyon F.TERS.SA\u011eK (F.INV.RT) belirli bir olas\u0131l\u0131k de\u011feri i\u00e7in F da\u011f\u0131l\u0131m\u0131n\u0131n tersini hesaplamak amac\u0131yla kullan\u0131l\u0131r. Bu fonksiyon, hipotez testleri ve varyans analizi gibi istatistiksel analizlerde olduk\u00e7a \u00f6nemlidir. Tanto en MS Excel como en Google Sheets, esta funci\u00f3n se utiliza para determinar el valor cr\u00edtico de F utilizando los grados de libertad especificados y el valor de probabilidad proporcionado.<\/p>\n

Syntax ve Kullan\u0131m<\/h2>\n

F.TERS.SA\u011eK fonksiyonunun s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

 F.TERS.SA\u011eK(olas\u0131l\u0131k, serbestlik_derecesi1, serbestlik_derecesi2)<\/code> <\/pre>\n
    \n
  • olas\u0131l\u0131k<\/strong>: F da\u011f\u0131l\u0131m\u0131n\u0131n sa\u011f kuyru\u011fundaki alan\u0131 tan\u0131mlayan 0 ile 1 aras\u0131nda bir de\u011fer.<\/li>\n
  • serbestlik_derecesi1<\/strong>: Paydaki serbestlik derecesi, pozitif bir tamsay\u0131 olmal\u0131d\u0131r.<\/li>\n
  • serbestlik_derecesi2<\/strong>: Paydadaki serbestlik derecesi, bu da pozitif bir tamsay\u0131 olmal\u0131d\u0131r.<\/li>\n<\/ul>\n
    \u00d6rne\u011fin, olas\u0131l\u0131k de\u011feri 0.05 ve serbestlik dereceleri s\u0131ras\u0131yla 10 ve 20 olan bir F da\u011f\u0131l\u0131m\u0131 i\u00e7in kritik F de\u011feri a\u015fa\u011f\u0131daki gibi hesaplan\u0131r:<\/p>\n
     =F.TERS.SA\u011eK(0.05, 10, 20)<\/code> <\/pre>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    Varyans Analizinde Kritik De\u011fer Hesaplama<\/h2>\n
    Bir ara\u015ft\u0131rmac\u0131, \u00fc\u00e7 farkl\u0131 diyetin a\u011f\u0131rl\u0131k kayb\u0131 \u00fczerindeki etkilerini kar\u015f\u0131la\u015ft\u0131rmak \u00fczere ANOVA (tek y\u00f6nl\u00fc varyans analizi) kullanmay\u0131 planl\u0131yor. Grup say\u0131s\u0131 n=3, her grup i\u00e7in 15 \u00f6l\u00e7\u00fcm yap\u0131lm\u0131\u015ft\u0131r (toplamda 45 \u00f6l\u00e7\u00fcm).<\/p>\n
     =F.TERS.SA\u011eK(0.05, 2, 42) \/\/ 2 serbestlik derecesi (grup say\u0131s\u0131-1), 42 serbestlik derecesi (toplam \u00f6l\u00e7\u00fcm - grup say\u0131s\u0131)<\/code> <\/pre>\n
    Bu kritik de\u011fer, F da\u011f\u0131l\u0131m tablosunda referans al\u0131narak herhangi bir ANOVA tablosundaki hesaplanan F de\u011feri ile kar\u015f\u0131la\u015ft\u0131r\u0131l\u0131r. E\u011fer hesaplanan F de\u011feri kritik de\u011ferden b\u00fcy\u00fckse, grup ortalamalar\u0131 aras\u0131nda istatistiksel olarak anlaml\u0131 bir fark oldu\u011fu sonucuna var\u0131l\u0131r.<\/p>\n
    \u0130ki Varyans\u0131 Kar\u015f\u0131la\u015ft\u0131rmak \u0130\u00e7in Kritik F De\u011feri Hesaplama<\/h2>\n
    \u0130ki farkl\u0131 makina taraf\u0131ndan \u00fcretilen par\u00e7alar\u0131n \u00e7aplar\u0131 \u00f6l\u00e7\u00fcl\u00fcyor ve her iki makina i\u00e7in 20’\u015fer \u00f6l\u00e7\u00fcm yap\u0131lm\u0131\u015ft\u0131r. Bu \u00f6l\u00e7\u00fcmlerin varyanslar\u0131 kar\u015f\u0131la\u015ft\u0131r\u0131l\u0131yor.<\/p>\n\n\n\n
    Makina A<\/th>\nMakina B<\/th>\n<\/tr>\n
    Varyans = 2.5<\/td>\nVaryans = 1.7<\/td>\n<\/tr>\n<\/table>\n
    \u0130\u015fte bu kar\u015f\u0131la\u015ft\u0131rma i\u00e7in kullan\u0131lacak kritik F de\u011feri:<\/p>\n
     =F.TERS.SA\u011eK(0.05, 19, 19)<\/code> <\/pre>\n
    E\u011fer hesaplanan F de\u011feri bu kritik de\u011ferden b\u00fcy\u00fck ise, iki makina aras\u0131nda varyans a\u00e7\u0131s\u0131ndan istatistiksel olarak anlaml\u0131 bir fark oldu\u011fu kabul edilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    F olas\u0131l\u0131k da\u011f\u0131l\u0131m\u0131n\u0131n tersini 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-15412","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de F.INV.RT (F.TERS.SA\u011eK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da F.INV.RT (F.TERS.SA\u011eK) 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\/f-inv-rt\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de F.INV.RT (F.TERS.SA\u011eK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da F.INV.RT (F.TERS.SA\u011eK) 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\/f-inv-rt\/\" \/>\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:27:01+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 F.INV.RT (F.TERS.SA\u011eK) 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\/f-inv-rt\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/f-inv-rt\/\",\"name\":\"Excel'de F.INV.RT (F.TERS.SA\u011eK) 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:27:01+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da F.INV.RT (F.TERS.SA\u011eK) 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\/f-inv-rt\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/f-inv-rt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/f-inv-rt\/#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\":\"F.TERS.SA\u011eK\"}]},{\"@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 F.INV.RT (F.TERS.SA\u011eK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da F.INV.RT (F.TERS.SA\u011eK) 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\/f-inv-rt\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de F.INV.RT (F.TERS.SA\u011eK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da F.INV.RT (F.TERS.SA\u011eK) 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\/f-inv-rt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:27:01+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de F.INV.RT (F.TERS.SA\u011eK) 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\/f-inv-rt\/","url":"https:\/\/functiontranslator.com\/tr\/f-inv-rt\/","name":"Excel'de F.INV.RT (F.TERS.SA\u011eK) 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:27:01+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da F.INV.RT (F.TERS.SA\u011eK) 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\/f-inv-rt\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/f-inv-rt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/f-inv-rt\/#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":"F.TERS.SA\u011eK"}]},{"@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\/15412","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=15412"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15412\/revisions"}],"predecessor-version":[{"id":26680,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15412\/revisions\/26680"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}