{"id":15689,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kirportalama\/"},"modified":"2021-02-25T16:38:08","modified_gmt":"2021-02-25T16:38:08","slug":"trimmean","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/trimmean\/","title":{"rendered":"KIRPORTALAMA"},"content":{"rendered":"

Veri \u0130\u015flemede Kullan\u0131lan K\u0131r\u0131kortalama<\/h2>\n

Hem Microsoft Excel hem de Google E-Tablolar, istatistiksel analizlerde s\u0131kl\u0131kla kullan\u0131lan bir\u00e7ok faydal\u0131 i\u015flev sunar. Bu i\u015flevlerden biri de ‘TRIMMEAN’, T\u00fcrk\u00e7e ad\u0131yla ‘KIRPORTALAMA’d\u0131r. K\u0131r\u0131kortalama i\u015flevi, veri setinizden belirli bir y\u00fczdeyi hari\u00e7 tutarak hesaplanan ortalamay\u0131 verir. Bu i\u015flev, \u00f6zellikle ayk\u0131r\u0131 de\u011ferlerin etkisini azaltarak veri k\u00fcmesinin merkezini daha iyi temsil eden bir ortalama sa\u011flar. <\/p>\n

K\u0131r\u0131kortalama Nas\u0131l \u00c7al\u0131\u015f\u0131r?<\/h2>\n

K\u0131r\u0131kortalama i\u015flevinin genel s\u00f6zdizimi \u015fu \u015fekildedir: <\/p>\n

=TRIMMEAN(dizi, y\u00fczde)<\/code><\/pre>\n
    \n
  • dizi<\/code>: Ortalama hesaplanacak olan veri k\u00fcmesi.<\/li>\n
  • y\u00fczde<\/code>: Toplam veri say\u0131s\u0131n\u0131n hangi y\u00fczdesinin hem ba\u015ftan hem de sondan kesilece\u011fini belirten orand\u0131r. De\u011fer 0 ile 1 aras\u0131nda olmal\u0131d\u0131r.<\/li>\n<\/ul>\n
     \u00d6rnek: Bir s\u0131n\u0131f\u0131n s\u0131nav sonu\u00e7lar\u0131n\u0131n bulundu\u011fu A1:A30 aral\u0131\u011f\u0131n\u0131n %10’unu k\u0131rp\u0131p ortalama almak i\u00e7in: <\/p>\n
    =TRIMMEAN(A1:A30, 0.1)<\/code><\/pre>\n
    K\u0131r\u0131kortalama \u0130\u015flevinin Uygulamalar\u0131<\/h2>\n
     K\u0131r\u0131kortalama i\u015flevi, \u00e7e\u015fitli pratik durumlarda kullan\u0131labilir. \u0130\u015fte iki \u00f6zg\u00fcn \u00f6rnek: <\/p>\n
    \u00d6rnek Uygulama: S\u0131nav Sonu\u00e7lar\u0131<\/h2>\n
     Bir \u00f6\u011fretmen, s\u0131n\u0131f\u0131ndaki \u00f6\u011frencilerin s\u0131nav sonu\u00e7lar\u0131n\u0131 de\u011ferlendirirken ayk\u0131r\u0131 y\u00fcksek ve d\u00fc\u015f\u00fck sonu\u00e7lar\u0131n genel performansa etkisini azaltmak isteyebilir. \u00d6rne\u011fin, 30 \u00f6\u011frencinin sonu\u00e7lar\u0131 A1:A30 h\u00fccrelerinde yer al\u0131yorsa ve sonu\u00e7lar\u0131n %10’unu hari\u00e7 tutarak ortalama hesaplamak istiyorsa, kullan\u0131lacak form\u00fcl: <\/p>\n
    =TRIMMEAN(A1:A30, 0.1)<\/code><\/pre>\n
     Bu, en y\u00fcksek ve en d\u00fc\u015f\u00fck %10’luk dilimi \u00e7\u0131kararak ortalama hesaplar. <\/p>\n
    \u00d6rnek Uygulama: \u015eirket Gelirleri<\/h2>\n
     Bir i\u015f analisti, \u015firketin ayl\u0131k gelirlerindeki ola\u011fand\u0131\u015f\u0131 dalgalanmalar\u0131 dikkate almaks\u0131z\u0131n, daha istikrarl\u0131 bir gelir trendi analizi yapmak isteyebilir. Gelir verileri B1:B12 h\u00fccrelerinde varsay\u0131larak ve %5’lik bir k\u0131r\u0131lma uygulanarak: <\/p>\n
    =TRIMMEAN(B1:B12, 0.05)<\/code><\/pre>\n
     Bu form\u00fcl, en y\u00fcksek ve en d\u00fc\u015f\u00fck %5’lik k\u0131sm\u0131 hari\u00e7 tutar ve geri kalan verilerin ortalamas\u0131n\u0131 hesaplar. <\/p>\n
     K\u0131r\u0131kortalama i\u015flevi, \u00f6zellikle b\u00fcy\u00fck ve \u00e7e\u015fitlilik g\u00f6steren veri k\u00fcmelerinde ayk\u0131r\u0131 de\u011ferlerin ortalama \u00fczerindeki etkisini azaltmak i\u00e7in etkili bir y\u00f6ntem sunar. \u0130\u015flev, finans, e\u011fitim, sa\u011fl\u0131k ve daha pek \u00e7ok alanda veri analizi yaparken kullan\u0131labilir. <\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir veri k\u00fcmesinin i\u00e7inin ortalamas\u0131n\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-15689","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de TRIMMEAN (KIRPORTALAMA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da TRIMMEAN (KIRPORTALAMA) 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\/trimmean\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de TRIMMEAN (KIRPORTALAMA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da TRIMMEAN (KIRPORTALAMA) 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\/trimmean\/\" \/>\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:38:08+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 TRIMMEAN (KIRPORTALAMA) 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\/trimmean\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/trimmean\/\",\"name\":\"Excel'de TRIMMEAN (KIRPORTALAMA) 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:38:08+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da TRIMMEAN (KIRPORTALAMA) 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\/trimmean\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/trimmean\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/trimmean\/#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\":\"KIRPORTALAMA\"}]},{\"@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 TRIMMEAN (KIRPORTALAMA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da TRIMMEAN (KIRPORTALAMA) 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\/trimmean\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de TRIMMEAN (KIRPORTALAMA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da TRIMMEAN (KIRPORTALAMA) 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\/trimmean\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:38:08+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de TRIMMEAN (KIRPORTALAMA) 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\/trimmean\/","url":"https:\/\/functiontranslator.com\/tr\/trimmean\/","name":"Excel'de TRIMMEAN (KIRPORTALAMA) 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:38:08+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da TRIMMEAN (KIRPORTALAMA) 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\/trimmean\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/trimmean\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/trimmean\/#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":"KIRPORTALAMA"}]},{"@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\/15689","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=15689"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15689\/revisions"}],"predecessor-version":[{"id":26957,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15689\/revisions\/26957"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}