{"id":15453,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/hipergeomdag\/"},"modified":"2021-02-25T16:28:36","modified_gmt":"2021-02-25T16:28:36","slug":"hypgeomdist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/hypgeomdist\/","title":{"rendered":"H\u0130PERGEOMDA\u011e"},"content":{"rendered":"

H\u0130PERGEOMDA\u011e<\/strong> fonksiyonu, Excel ve Google Sheets’de kullan\u0131lan, belirli bir \u00f6rneklem boyutu i\u00e7inde belirli bir ba\u015far\u0131 say\u0131s\u0131n\u0131n elde edilme olas\u0131l\u0131\u011f\u0131n\u0131 hesaplayan bir istatistiksel fonksiyondur. Hipergeometrik da\u011f\u0131l\u0131m, nesnelerin iki farkl\u0131 kategoriye ayr\u0131ld\u0131\u011f\u0131 ve \u00f6rnekleme s\u0131ras\u0131nda yerine koyma yap\u0131lmayan bir pop\u00fclasyondan rastgele \u00f6rnekler \u00e7ekildi\u011finde kullan\u0131lan bir y\u00f6ntemdir.<\/p>\n

H\u0130PERGEOMDA\u011e Fonksiyonunun S\u00f6zdizimi ve \u00d6rnekleri<\/h2>\n

Fonksiyonun genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=H\u0130PERGEOMDA\u011e(ba\u015far\u0131_say\u0131s\u0131, \u00f6rnek_boyut, ba\u015far\u0131lar, n)<\/code><\/pre>\n
    \n
  • ba\u015far\u0131_say\u0131s\u0131<\/strong>: \u00d6rneklemede elde edilmesi hedeflenen ba\u015far\u0131 say\u0131s\u0131.<\/li>\n
  • \u00f6rnek_boyut<\/strong>: Al\u0131nacak \u00f6rne\u011fin toplam boyutu.<\/li>\n
  • ba\u015far\u0131lar<\/strong>: Pop\u00fclasyonda ba\u015far\u0131l\u0131 olarak kabul edilen \u00f6\u011felerin toplam say\u0131s\u0131.<\/li>\n
  • n<\/strong>: Pop\u00fclasyonun toplam b\u00fcy\u00fckl\u00fc\u011f\u00fc.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m:<\/p>\n
    =H\u0130PERGEOMDA\u011e(5, 10, 20, 100)<\/code><\/pre>\n
    Bu \u00f6rnekte, pop\u00fclasyon boyutu 100, ba\u015far\u0131l\u0131 \u00f6gelerin say\u0131s\u0131 20 olan bir grup i\u00e7inden 10 \u00f6geler se\u00e7ildi\u011finde tam olarak 5 ba\u015far\u0131l\u0131 \u00f6\u011fenin bulunma olas\u0131l\u0131\u011f\u0131 hesaplanmaktad\u0131r.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    H\u0130PERGEOMDA\u011e fonksiyonu \u00e7e\u015fitli alanlarda kullan\u0131labilir. \u0130\u015fte birka\u00e7 pratik uygulama:<\/p>\n
    Kalite Kontrol Testleri<\/h2>\n
    Bir \u00fcretici, \u00fcr\u00fcnler aras\u0131nda hatal\u0131 olanlar\u0131n oran\u0131n\u0131 belirlemek i\u00e7in rastgele \u00f6rnekler al\u0131r. Diyelim ki, 1000 \u00fcr\u00fcn i\u00e7inde 100 tanesi hatal\u0131 olarak tahmin ediliyor. \u00dcretici, 30 \u00fcr\u00fcn \u00f6rne\u011fi al\u0131r ve bu \u00f6rneklerden ka\u00e7 tanesinin hatal\u0131 \u00e7\u0131kabilece\u011fini hesaplamak ister. Beklenen hatal\u0131 \u00fcr\u00fcn say\u0131s\u0131 3 ise:<\/p>\n
    =H\u0130PERGEOMDA\u011e(3, 30, 100, 1000)<\/code><\/pre>\n
    Bu form\u00fcl, 1000 \u00fcr\u00fcn i\u00e7indeki 100 hatal\u0131 \u00fcr\u00fcnden 30 tanesi se\u00e7ildi\u011finde tam olarak 3 tanesinin hatal\u0131 olma ihtimalini belirler.<\/p>\n
    Pazarlama ve Anket \u00c7al\u0131\u015fmalar\u0131<\/h2>\n
    Bir firma, yeni bir \u00fcr\u00fcn\u00fcn m\u00fc\u015fteri memnuniyet seviyesini \u00f6l\u00e7mek amac\u0131yla anket yapmay\u0131 planlar. Firman\u0131n 5000 m\u00fc\u015fterisi vard\u0131r ve bu m\u00fc\u015fterilerden 500’\u00fc \u00fcr\u00fcn\u00fc denemi\u015ftir. Firma, 200 m\u00fc\u015fteri \u00fczerinden anket yapmay\u0131 d\u00fc\u015f\u00fcn\u00fcr ve 50 m\u00fc\u015fterinin \u00fcr\u00fcn\u00fc be\u011fendi\u011fini tahmin eder:<\/p>\n
    =H\u0130PERGEOMDA\u011e(50, 200, 500, 5000)<\/code><\/pre>\n
    Bu \u00f6rnekte, 5000 m\u00fc\u015fteri aras\u0131ndan se\u00e7ilen 200 m\u00fc\u015fteri \u00fczerinden yap\u0131lan de\u011ferlendirmede 50 m\u00fc\u015fterinin \u00fcr\u00fcn\u00fc be\u011fenme olas\u0131l\u0131\u011f\u0131 hesaplanmaktad\u0131r.<\/p>\n
    Bu fonksiyon, \u00f6zellikle k\u00fc\u00e7\u00fck \u00f6rneklemler kullan\u0131ld\u0131\u011f\u0131nda istatistiksel analizler ve veri bilimi uygulamalar\u0131 i\u00e7in olduk\u00e7a yararl\u0131d\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Hipergeometrik da\u011f\u0131l\u0131m\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":[584],"tags":[],"class_list":["post-15453","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de HYPGEOMDIST (H\u0130PERGEOMDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da HYPGEOMDIST (H\u0130PERGEOMDA\u011e) 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\/hypgeomdist\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de HYPGEOMDIST (H\u0130PERGEOMDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da HYPGEOMDIST (H\u0130PERGEOMDA\u011e) 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\/hypgeomdist\/\" \/>\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:28:36+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 HYPGEOMDIST (H\u0130PERGEOMDA\u011e) 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\/hypgeomdist\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/hypgeomdist\/\",\"name\":\"Excel'de HYPGEOMDIST (H\u0130PERGEOMDA\u011e) 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:28:36+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da HYPGEOMDIST (H\u0130PERGEOMDA\u011e) 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\/hypgeomdist\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/hypgeomdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/hypgeomdist\/#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\":\"H\u0130PERGEOMDA\u011e\"}]},{\"@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 HYPGEOMDIST (H\u0130PERGEOMDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da HYPGEOMDIST (H\u0130PERGEOMDA\u011e) 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\/hypgeomdist\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de HYPGEOMDIST (H\u0130PERGEOMDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da HYPGEOMDIST (H\u0130PERGEOMDA\u011e) 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\/hypgeomdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:28:36+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de HYPGEOMDIST (H\u0130PERGEOMDA\u011e) 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\/hypgeomdist\/","url":"https:\/\/functiontranslator.com\/tr\/hypgeomdist\/","name":"Excel'de HYPGEOMDIST (H\u0130PERGEOMDA\u011e) 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:28:36+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da HYPGEOMDIST (H\u0130PERGEOMDA\u011e) 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\/hypgeomdist\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/hypgeomdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/hypgeomdist\/#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":"H\u0130PERGEOMDA\u011e"}]},{"@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\/15453","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=15453"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15453\/revisions"}],"predecessor-version":[{"id":26721,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15453\/revisions\/26721"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}