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

Finansal analizler ve istatistiksel hesaplamalarda s\u0131k\u00e7a kullan\u0131lan bir i\u015flev olan F.INV, verilen bir olas\u0131l\u0131k de\u011feriyle serbestlik derecesine sahip F-da\u011f\u0131l\u0131m\u0131n\u0131n tersini hesaplar. Bu i\u015flev, hem Microsoft Excel’de hem de Google E-Tablolar’da kullan\u0131labilir ve \u00e7o\u011funlukla hipotez testleri veya varyans analizleri gibi istatistiksel testlerde kullan\u0131l\u0131r. Bu rehber, F.INV i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131na dair temel bilgileri ve pratik uygulama \u00f6rneklerini sunacakt\u0131r.<\/p>\n

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

F.INV i\u015flevinin genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

F.INV(p, derece1, derece2)<\/code><\/pre>\n
    \n
  • p:<\/b> \u0130\u015flevin hesaplanmas\u0131nda kullan\u0131lacak olas\u0131l\u0131k de\u011feri. Bu de\u011fer, 0 ile 1 aras\u0131nda olmal\u0131d\u0131r.<\/li>\n
  • derece1:<\/b> F-da\u011f\u0131l\u0131m\u0131n\u0131n numerat\u00f6r serbestlik derecesi.<\/li>\n
  • derece2:<\/b> F-da\u011f\u0131l\u0131m\u0131n\u0131n denominat\u00f6r serbestlik derecesi.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m\u0131:<\/p>\n
    =F.INV(0.05, 10, 20)<\/code><\/pre>\n
    Bu form\u00fcl, p de\u011feri olarak 0.05, numerat\u00f6r serbestlik derecesi olarak 10 ve denominat\u00f6r serbestlik derecesi olarak 20 kullanarak F-da\u011f\u0131l\u0131m\u0131n\u0131n tersini hesaplar.<\/p>\n
    Pratik G\u00f6revler ve \u00c7\u00f6z\u00fcmleri<\/h2>\n
    G\u00f6rev 1: \u0130ki Grup Aras\u0131ndaki Varyanslar\u0131 Kar\u015f\u0131la\u015ft\u0131rma<\/b><\/p>\n
    Bir ara\u015ft\u0131rmac\u0131, iki farkl\u0131 tedavi y\u00f6nteminin etkinli\u011fini \u00f6l\u00e7mek i\u00e7in iki farkl\u0131 grup \u00fczerinde deney yapm\u0131\u015f olsun. Her iki grup i\u00e7in de varyanslar hesapland\u0131\u011f\u0131nda, grup A’n\u0131n varyans\u0131 22 ve grup B’nin varyans\u0131 35 \u00e7\u0131km\u0131\u015ft\u0131r. Ara\u015ft\u0131rmac\u0131, bu fark\u0131n istatistiksel olarak anlaml\u0131 olup olmad\u0131\u011f\u0131n\u0131 test etmek istiyor.<\/p>\n
    =F.INV(0.05, 10, 10) <\/code><\/pre>\n
    Bu form\u00fcl, gruplar aras\u0131 varyans fark\u0131n\u0131n %95 g\u00fcvenilirlikle anlaml\u0131 olup olmad\u0131\u011f\u0131n\u0131 test etmek i\u00e7in kullan\u0131l\u0131r. E\u011fer hesaplanan F istatisti\u011fi bu de\u011ferden b\u00fcy\u00fckse, varyanslar aras\u0131nda anlaml\u0131 bir fark oldu\u011fu sonucuna var\u0131labilir.<\/p>\n
    G\u00f6rev 2: Hipotez Testi<\/b><\/p>\n
    Bir \u015firket, iki farkl\u0131 b\u00f6l\u00fcm aras\u0131nda \u00e7al\u0131\u015fma saatlerinin varyans\u0131n\u0131n benzer olup olmad\u0131\u011f\u0131n\u0131 test etmek istiyor. \u0130lk b\u00f6l\u00fcm\u00fcn 15 \u00e7al\u0131\u015fan\u0131, ikinci b\u00f6l\u00fcm\u00fcn ise 20 \u00e7al\u0131\u015fan\u0131 var. \u0130lk b\u00f6l\u00fcm i\u00e7in hesaplanan varyans 8, ikinci b\u00f6l\u00fcm i\u00e7in ise 10.<\/p>\n
    =F.INV(0.1, 14, 19)<\/code><\/pre>\n
    F.INV fonksiyonu kullan\u0131larak, serbestlik dereceleri ve alpha de\u011feri (hata marj\u0131) belirtilerek elde edilen de\u011fer, F da\u011f\u0131l\u0131m tablosundan kar\u015f\u0131la\u015ft\u0131rma yapmak i\u00e7in kullan\u0131l\u0131r. Hesaplanan F de\u011feri bu kritik de\u011ferden b\u00fcy\u00fckse iki b\u00f6l\u00fcm aras\u0131nda anlaml\u0131 bir fark oldu\u011fu sonucu \u00e7\u0131kar\u0131labilir.<\/p>\n
    Yukar\u0131daki \u00f6rneklerde g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi, F.INV i\u015flevi, iki \u00f6rnek grubun varyanslar\u0131n\u0131n kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131 gibi istatistiksel testlerde \u00f6nemli bir rol oynamaktad\u0131r. Farkl\u0131 senaryolar ve veri setlerine uygulanabilir olmas\u0131, bu i\u015flevi finansal ve bilimsel analizlerde vazge\u00e7ilmez k\u0131lar.<\/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-15411","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de F.INV (F.TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da F.INV (F.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\/f-inv\/\" \/>\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 (F.TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da F.INV (F.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\/f-inv\/\" \/>\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:00+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 (F.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\/f-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/f-inv\/\",\"name\":\"Excel'de F.INV (F.TERS) 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:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da F.INV (F.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\/f-inv\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/f-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/f-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\":\"F.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 F.INV (F.TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da F.INV (F.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\/f-inv\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de F.INV (F.TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da F.INV (F.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\/f-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:27:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de F.INV (F.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\/f-inv\/","url":"https:\/\/functiontranslator.com\/tr\/f-inv\/","name":"Excel'de F.INV (F.TERS) 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:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da F.INV (F.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\/f-inv\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/f-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/f-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":"F.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\/15411","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=15411"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15411\/revisions"}],"predecessor-version":[{"id":26679,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15411\/revisions\/26679"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}