{"id":15441,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/geoort\/"},"modified":"2021-02-25T16:27:44","modified_gmt":"2021-02-25T16:27:44","slug":"geomean","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/geomean\/","title":{"rendered":"GEOORT"},"content":{"rendered":"

\u00c7e\u015fitli Ortamlarda GEOMEAN Kullan\u0131m\u0131<\/h2>\n

GEOMEAN, yani geometrik ortalamay\u0131 hesaplama fonksiyonu, bir say\u0131 dizisinin \u00e7arp\u0131mlar\u0131n\u0131n n’inci k\u00f6k\u00fcn\u00fc alarak bu dizinin geometrik ortalamas\u0131n\u0131 bulur. Bu, finans, bilim, ekonomi gibi bir\u00e7ok alanda veri analizleri yaparken kullan\u0131lan \u00f6nemli bir istatistiksel ara\u00e7t\u0131r. <\/p>\n

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

MS Excel ve Google E-Tablolar’\u0131nda GEOMEAN fonksiyonunun genel s\u00f6zdizimi \u015fu \u015fekildedir: <\/p>\n

  GEOMEAN(numara1, [numara2], ...) <\/code> <\/pre>\n
 Burada numara1<\/code>, numara2<\/code>, …, fonksiyona girilen say\u0131lard\u0131r ve bu arg\u00fcmanlar aras\u0131nda en az bir tane say\u0131sal de\u011fer olmal\u0131d\u0131r. B\u00fct\u00fcn de\u011ferlerin pozitif olmas\u0131 gerekmektedir \u00e7\u00fcnk\u00fc negatif say\u0131lar\u0131n geometrik ortalamas\u0131 tan\u0131ml\u0131 de\u011fildir. <\/p>\n
Kullan\u0131m Alanlar\u0131 ve Pratik \u00c7\u00f6z\u00fcmler<\/h2>\n
Yat\u0131r\u0131m Getirisinin Hesaplanmas\u0131<\/h3>\n
 GEOMEAN, mali analizlerde \u00e7e\u015fitli zaman periyotlar\u0131ndaki yat\u0131r\u0131m getirilerinin ortalama b\u00fcy\u00fcme oran\u0131n\u0131 hesaplamak i\u00e7in s\u0131kl\u0131kla kullan\u0131l\u0131r. \u00d6rne\u011fin, bir yat\u0131r\u0131m\u0131n s\u0131ras\u0131yla %10, %20 ve %15’lik y\u0131ll\u0131k b\u00fcy\u00fcme oranlar\u0131 oldu\u011funu varsayal\u0131m. <\/p>\n
  Excel i\u00e7in: =GEOMEAN(1.10, 1.20, 1.15) - 1 Google E-Tablolar i\u00e7in: =GEOMEAN(1.10, 1.20, 1.15) - 1 <\/code> <\/pre>\n
 Bu form\u00fcl, y\u0131ll\u0131k ortalama bile\u015fik b\u00fcy\u00fcme oran\u0131n\u0131 verecektir. Burada 1 eklememizin nedeni, y\u00fczdesel b\u00fcy\u00fcme oranlar\u0131n\u0131 hesaplamakt\u0131r. <\/p>\n
Bilimsel Veri Setlerinde Ortalama Hesaplama<\/h3>\n
 \u00d6zellikle biyoloji ve \u00e7evre bilimleri dal\u0131nda, \u00e7ok \u00e7e\u015fitli veri setlerinde geometrik ortalaman\u0131n hesaplanmas\u0131, verilerin da\u011f\u0131l\u0131m\u0131 hakk\u0131nda daha realist bir g\u00f6r\u00fcn\u00fcm sunabilir. Diyelim ki bir laboratuvar testinde farkl\u0131 \u00f6rneklerde baz\u0131 protein konsantrasyonlar\u0131 \u00f6l\u00e7\u00fcmleri yap\u0131lm\u0131\u015f ve sonu\u00e7lar [18, 55, 120] gibi elde edilmi\u015f. Bu verilerin geometrik ortalamas\u0131n\u0131 hesaplayal\u0131m. <\/p>\n
  Excel i\u00e7in: =GEOMEAN(18, 55, 120) Google E-Tablolar i\u00e7in: =GEOMEAN(18, 55, 120) <\/code> <\/pre>\n
 Bu, farkl\u0131 \u00f6rnekler aras\u0131nda protein konsantrasyonlar\u0131n\u0131n ortalama d\u00fczeyini geometrik olarak yorumlamam\u0131z\u0131 sa\u011flar, bu da aritmetik ortalama kullan\u0131ld\u0131\u011f\u0131nda g\u00f6r\u00fclebilecek a\u015f\u0131r\u0131 de\u011ferlerden etkilenmez. <\/p>\n","protected":false},"excerpt":{"rendered":"
Geometrik ortay\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-15441","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de GEOMEAN (GEOORT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da GEOMEAN (GEOORT) 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\/geomean\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de GEOMEAN (GEOORT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da GEOMEAN (GEOORT) 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\/geomean\/\" \/>\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:44+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 GEOMEAN (GEOORT) 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\/geomean\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/geomean\/\",\"name\":\"Excel'de GEOMEAN (GEOORT) 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:44+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da GEOMEAN (GEOORT) 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\/geomean\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/geomean\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/geomean\/#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\":\"GEOORT\"}]},{\"@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 GEOMEAN (GEOORT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da GEOMEAN (GEOORT) 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\/geomean\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de GEOMEAN (GEOORT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da GEOMEAN (GEOORT) 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\/geomean\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:27:44+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de GEOMEAN (GEOORT) 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\/geomean\/","url":"https:\/\/functiontranslator.com\/tr\/geomean\/","name":"Excel'de GEOMEAN (GEOORT) 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:44+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da GEOMEAN (GEOORT) 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\/geomean\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/geomean\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/geomean\/#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":"GEOORT"}]},{"@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\/15441","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=15441"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15441\/revisions"}],"predecessor-version":[{"id":26709,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15441\/revisions\/26709"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}