{"id":15561,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/normsters\/"},"modified":"2021-02-25T16:32:55","modified_gmt":"2021-02-25T16:32:55","slug":"normsinv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/normsinv\/","title":{"rendered":"NORMSTERS"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, finansal analiz, m\u00fchendislik, istatistik ve genel veri analizi gibi \u00e7e\u015fitli alanlarda yayg\u0131n olarak kullan\u0131lan iki g\u00fc\u00e7l\u00fc elektronik tablo uygulamas\u0131d\u0131r. Her iki platform da geni\u015f bir i\u015flev seti sunar, bu i\u015flevler i\u00e7erisinde istatistiksel fonksiyonlar \u00f6nemli bir yer tutmaktad\u0131r. Bu makalede, istatistiksel bir fonksiyon olan Excel’deki NORMSINV ve Google Sheets’teki NORM.TERS’in kullan\u0131m\u0131n\u0131 detayl\u0131 bir \u015fekilde ele alaca\u011f\u0131z.<\/p>\n

Fonksiyonun Tan\u0131m\u0131 ve Kullan\u0131m\u0131<\/h2>\n

NORMSINV (Excel) ve NORM.TERS (Google Sheets), belirli bir olas\u0131l\u0131k de\u011feri i\u00e7in standart normal da\u011f\u0131l\u0131m\u0131n k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonunun tersini hesaplayarak ilgili z-skorunu veya standart sapma birimlerindeki de\u011ferini d\u00f6nd\u00fcren fonksiyonlard\u0131r. Bu fonksiyonlar, finans, m\u00fchendislik ve risk analizi gibi alanlarda kritik \u00f6neme sahiptir.<\/p>\n

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

Microsoft Excel i\u00e7in s\u00f6zdizimi:<\/strong><\/p>\n

=NORMSINV(probability)<\/code><\/pre>\n
Google Sheets i\u00e7in s\u00f6zdizimi:<\/strong><\/p>\n
=NORM.TERS(probability; mean; standard_deviation)<\/code><\/pre>\n
Burada:<\/p>\n
    \n
  • probability<\/strong> – Hesaplanacak k\u00fcm\u00fclatif olas\u0131l\u0131k de\u011feri; bu de\u011fer 0 ile 1 aras\u0131nda olmal\u0131d\u0131r (dahil de\u011fil).<\/li>\n
  • mean<\/strong> – (Sadece Google Sheets) Da\u011f\u0131l\u0131m\u0131n ortalamas\u0131, varsay\u0131lan olarak 0.<\/li>\n
  • standard_deviation<\/strong> – (Sadece Google Sheets) Da\u011f\u0131l\u0131m\u0131n standart sapmas\u0131, varsay\u0131lan olarak 1.<\/li>\n<\/ul>\n
    \u00d6rne\u011fin, 0.8413 olas\u0131l\u0131k de\u011feri i\u00e7in Excel’de z-skorunu bulmak i\u00e7in:<\/p>\n
    =NORMSINV(0.8413)<\/code><\/pre>\n
    Google Sheets’te ise:<\/p>\n
    =NORM.TERS(0.8413)<\/code><\/pre>\n
    Bu i\u015flemler sonucunda yakla\u015f\u0131k olarak 1 de\u011feri elde edilir \u00e7\u00fcnk\u00fc 0.8413 olas\u0131l\u0131k de\u011feri z-tablosunda yakla\u015f\u0131k olarak 1 z-skoru ile korelasyona sahiptir.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    \u0130\u015fte bu fonksiyonun kullan\u0131ld\u0131\u011f\u0131 baz\u0131 pratik senaryolar ve a\u00e7\u0131klamalar\u0131:<\/p>\n
    Senaryo 1: Risk Analizi<\/h2>\n
    Bir finansal analist, bir yat\u0131r\u0131m\u0131n %5’lik zarar olas\u0131l\u0131\u011f\u0131n\u0131 de\u011ferlendirmek i\u00e7in NORMSINV fonksiyonunu kullanabilir:<\/p>\n
    =NORMSINV(0.05)<\/code><\/pre>\n
    Bu de\u011fer yakla\u015f\u0131k -1.645 olarak hesaplan\u0131r, bu da yat\u0131r\u0131m\u0131n ortalaman\u0131n 1.645 standart sapma alt\u0131nda beklenen bir getiriye sahip oldu\u011funu g\u00f6sterir.<\/p>\n
    Senaryo 2: Kalite Kontrol<\/h2>\n
    Bir \u00fcretim s\u00fcrecinde, \u00fcretilen par\u00e7alar\u0131n uzunluklar\u0131n\u0131n normal da\u011f\u0131l\u0131m g\u00f6sterdi\u011fi durumda, bir kalite kontrol m\u00fchendisi, \u00fcretilen par\u00e7alar\u0131n %90’\u0131n\u0131n kabul edilebilir uzunluk aral\u0131\u011f\u0131nda oldu\u011funu do\u011frulamak i\u00e7in \u00fcst s\u0131n\u0131r\u0131 bulmak amac\u0131yla NORMSINV fonksiyonunu kullanabilir:<\/p>\n
    =NORMSINV(0.95)<\/code><\/pre>\n
    Bu hesaplama, par\u00e7alar\u0131n %90’\u0131n\u0131n bulundu\u011fu maksimum uzunlu\u011fu belirlemede kullan\u0131lan z-skorunu verir ve yakla\u015f\u0131k 1.645 de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p>\n
    Yukar\u0131da verilen \u00f6rnekler, NORMSINV (veya NORM.TERS) fonksiyonunun finansal risk de\u011ferlendirmeleri ile \u00fcretim s\u00fcre\u00e7lerinin optimizasyonu gibi \u00e7e\u015fitli alanlarda geni\u015f bir kullan\u0131m yelpazesine sahip oldu\u011funu g\u00f6stermektedir. Fonksiyonun kullan\u0131lmas\u0131, verilere daha derinlemesine analizler yapma ve daha bilin\u00e7li kararlar alma imkan\u0131 sunar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Standart normal k\u00fcm\u00fclatif da\u011f\u0131l\u0131m\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":[584],"tags":[],"class_list":["post-15561","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de NORMSINV (NORMSTERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da NORMSINV (NORMSTERS) 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\/normsinv\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de NORMSINV (NORMSTERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da NORMSINV (NORMSTERS) 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\/normsinv\/\" \/>\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:32:55+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 NORMSINV (NORMSTERS) 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\/normsinv\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/normsinv\/\",\"name\":\"Excel'de NORMSINV (NORMSTERS) 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:32:55+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da NORMSINV (NORMSTERS) 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\/normsinv\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/normsinv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/normsinv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uyumluluk\",\"item\":\"https:\/\/functiontranslator.com\/tr\/uyumluluk\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"NORMSTERS\"}]},{\"@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 NORMSINV (NORMSTERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da NORMSINV (NORMSTERS) 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\/normsinv\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de NORMSINV (NORMSTERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da NORMSINV (NORMSTERS) 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\/normsinv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:32:55+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de NORMSINV (NORMSTERS) 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\/normsinv\/","url":"https:\/\/functiontranslator.com\/tr\/normsinv\/","name":"Excel'de NORMSINV (NORMSTERS) 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:32:55+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da NORMSINV (NORMSTERS) 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\/normsinv\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/normsinv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/normsinv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Uyumluluk","item":"https:\/\/functiontranslator.com\/tr\/uyumluluk\/"},{"@type":"ListItem","position":3,"name":"NORMSTERS"}]},{"@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\/15561","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=15561"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15561\/revisions"}],"predecessor-version":[{"id":26829,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15561\/revisions\/26829"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}