{"id":15439,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/gauss\/"},"modified":"2021-02-25T16:27:40","modified_gmt":"2021-02-25T16:27:40","slug":"gauss","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/gauss\/","title":{"rendered":"GAUSS"},"content":{"rendered":"

GAUSS Fonksiyonunun Kullan\u0131m Alanlar\u0131 ve \u00d6rnekleri<\/h2>\n

GAUSS fonksiyonu, bir veri k\u00fcmesinin normal da\u011f\u0131l\u0131m\u0131n alt\u0131nda kalan alan\u0131n y\u00fczdesini belirlemek i\u00e7in kullan\u0131l\u0131r. Hem Microsoft Excel hem de Google E-Tablolar’da bulunan bu fonksiyon, belirli bir de\u011ferin standart normal da\u011f\u0131l\u0131mdaki y\u00fczdelik konumunu hesaplar. GAUSS fonksiyonu, istatistiksel analizlerde ve veri i\u015fleme konular\u0131nda olduk\u00e7a yararl\u0131d\u0131r. A\u015fa\u011f\u0131da GAUSS i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131na dair detayl\u0131 bir a\u00e7\u0131klama ve pratik \u00f6rnekler sunulmu\u015ftur.<\/p>\n

Fonksiyon S\u00f6zdizimi ve \u00d6rnekler<\/h2>\n

GAUSS fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

  GAUSS(z) <\/code> <\/pre>\n
Burada z<\/code> arg\u00fcman\u0131, hesaplanacak z-skoru (standart skor) de\u011feridir. Z-skoru, bir g\u00f6zlemin ortalamadan ne kadar standart sapma fark\u0131yla ayr\u0131ld\u0131\u011f\u0131n\u0131 belirten bir \u00f6l\u00e7\u00fctt\u00fcr.<\/p>\n
Pratik G\u00f6rev 1: Test Sonu\u00e7lar\u0131n\u0131n Normal Da\u011f\u0131l\u0131m Analizi<\/h2>\n
Bir s\u0131navdan al\u0131nan puanlar\u0131n bir grup \u00f6\u011frenci aras\u0131nda nas\u0131l da\u011f\u0131ld\u0131\u011f\u0131n\u0131 analiz etmek istiyoruz. Diyelim ki, s\u0131nav\u0131n ortalama puan\u0131 70 ve standart sapmas\u0131 10 olsun. Bir \u00f6\u011frencinin ald\u0131\u011f\u0131 85 puan\u0131n\u0131n normal da\u011f\u0131l\u0131mdaki y\u00fczdelik konumunu bulmak i\u00e7in GAUSS i\u015flevini kullanabiliriz.<\/p>\n
    \n
  • \u00d6ncelikle z-skoru hesaplanmal\u0131d\u0131r: (85-70)\/10 = 1.5<\/code>.<\/li>\n
  • Excel veya Google E-Tablolar’da, =GAUSS(1.5)<\/code> form\u00fcl\u00fc girilerek \u00f6\u011frencinin s\u0131nav puan\u0131n\u0131n y\u00fczdelik de\u011feri bulunur.<\/li>\n
  • Bu form\u00fcl, \u00f6\u011frencinin s\u0131nav sonucunun yakla\u015f\u0131k olarak y\u00fczde 93.32’sinde oldu\u011funu g\u00f6sterir.<\/li>\n<\/ul>\n
    Bu sonu\u00e7, \u00f6\u011frencinin s\u0131navdaki performans\u0131n\u0131n genel pop\u00fclasyon i\u00e7inde \u00fcst d\u00fczey oldu\u011funu g\u00f6stermektedir.<\/p>\n
    Pratik G\u00f6rev 2: Finansal Verilerin De\u011ferlendirilmesi<\/h2>\n
    Bir yat\u0131r\u0131mc\u0131, hisse senedi getirilerinin performans\u0131n\u0131 de\u011ferlendirmek istiyor. Diyelim ki, hisse senedi getirilerininortalama getirisi 0.5% (yani 0.005) ve standart sapmas\u0131 0.1 (yani 0.1%) olmak \u00fczere, bir g\u00fcn i\u00e7inde %0.8 y\u00fckselen bir hissenin performans\u0131n\u0131 de\u011ferlendirmek istiyoruz.<\/p>\n
      \n
    • \u00d6ncelikle, hissenin z-skoru hesaplan\u0131r: (0.008 - 0.005) \/ 0.1 = 0.03<\/code>.<\/li>\n
    • Excel veya Google E-Tablolar’da, =GAUSS(0.03)<\/code> form\u00fcl\u00fc kullan\u0131larak bu hissenin performans\u0131n\u0131n normal da\u011f\u0131l\u0131m \u00e7er\u00e7evesindeki y\u00fczdelik konumu belirlenir.<\/li>\n
    • Bu form\u00fcl, hissenin g\u00fcn i\u00e7i performans\u0131n\u0131n normal da\u011f\u0131l\u0131mda yakla\u015f\u0131k olarak y\u00fczde 51.2’de oldu\u011funu g\u00f6sterir.<\/li>\n<\/ul>\n
      Bu bilgi, yat\u0131r\u0131mc\u0131n\u0131n hisse senedi getirilerini piyasa ortalamas\u0131yla kar\u015f\u0131la\u015ft\u0131rarak de\u011ferlendirme yapmas\u0131na olanak tan\u0131r.<\/p>\n
      GAUSS fonksiyonu, verileri normal da\u011f\u0131l\u0131ma g\u00f6re analiz ederek hem e\u011fitim hem de finansal analiz gibi alanlarda \u00f6nemli i\u00e7g\u00f6r\u00fcler sa\u011flar. Fonksiyonun uygulamas\u0131 basit olmakla birlikte, elde edilen sonu\u00e7lar do\u011frultusunda yap\u0131lacak de\u011ferlendirmeler olduk\u00e7a de\u011ferlidir.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Standart normal k\u00fcm\u00fclatif da\u011f\u0131l\u0131mdan 0,5 az\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-15439","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de GAUSS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da GAUSS 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\/gauss\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de GAUSS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da GAUSS 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\/gauss\/\" \/>\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:27:40+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 GAUSS 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\/gauss\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/gauss\/\",\"name\":\"Excel'de GAUSS 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:27:40+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da GAUSS 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\/gauss\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/gauss\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/gauss\/#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\":\"GAUSS\"}]},{\"@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 GAUSS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da GAUSS 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\/gauss\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de GAUSS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da GAUSS 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\/gauss\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:27:40+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de GAUSS 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\/gauss\/","url":"https:\/\/functiontranslator.com\/tr\/gauss\/","name":"Excel'de GAUSS 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:27:40+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da GAUSS 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\/gauss\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/gauss\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/gauss\/#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":"GAUSS"}]},{"@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\/15439","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=15439"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15439\/revisions"}],"predecessor-version":[{"id":26707,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15439\/revisions\/26707"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}