{"id":5451,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/binom-inv\/"},"modified":"2021-02-26T09:50:47","modified_gmt":"2021-02-26T09:50:47","slug":"binom-inv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/binom-inv\/","title":{"rendered":"BINOM.INV"},"content":{"rendered":"

Funkce BINOM.INV<\/strong> se \u0159ad\u00ed mezi statistick\u00e9 funkce v Excelu i Google Sheets. Jej\u00edm \u00fa\u010delem je naj\u00edt nejmen\u0161\u00ed cel\u00e9 \u010d\u00edslo k, pro kter\u00e9 kumulativn\u00ed binomick\u00e1 distribu\u010dn\u00ed funkce dosahuje nebo p\u0159ekra\u010duje zadanou hodnotu pravd\u011bpodobnosti. Tato funkce je \u0161iroce vyu\u017e\u00edv\u00e1na ve statistice pro \u00fa\u010dely jako je testov\u00e1n\u00ed hypot\u00e9z.<\/p>\n

Syntaxe a parametry<\/h2>\n

Syntaxe funkce je n\u00e1sleduj\u00edc\u00ed:<\/p>\n

BINOM.INV(pokusy; pravd\u011bpodobnost; alfa)<\/code><\/pre>\n
    \n
  • pokusy<\/strong> – Toto je celkov\u00fd po\u010det pokus\u016f, kter\u00e9 hodnot\u00edme. Hodnota mus\u00ed b\u00fdt nez\u00e1porn\u00e9 \u010d\u00edslo.<\/li>\n
  • pravd\u011bpodobnost<\/strong> – Pravd\u011bpodobnost \u00fasp\u011bchu v jednotliv\u00e9m pokusu. Hodnota by m\u011bla b\u00fdt v rozmez\u00ed 0 a\u017e 1.<\/li>\n
  • alfa<\/strong> – Toto je kritick\u00e1 hodnota pravd\u011bpodobnosti, kter\u00e1 ur\u010duje minim\u00e1ln\u00ed prahovou hodnotu. Hodnota by m\u011bla b\u00fdt tak\u00e9 mezi 0 a 1.<\/li>\n<\/ul>\n
    Nap\u0159\u00edklad, pokud m\u00e1me 10 pokus\u016f s pravd\u011bpodobnost\u00ed \u00fasp\u011bchu 0,5 a pot\u0159ebujeme zjistit minim\u00e1ln\u00ed k, pro kter\u00e9 je distribu\u010dn\u00ed funkce rovna nebo v\u011bt\u0161\u00ed ne\u017e 0,95, pou\u017eijeme tento p\u0159\u00edkaz:<\/p>\n
    BINOM.INV(10, 0.5, 0.95)<\/code><\/pre>\n
    Tento vstup vr\u00e1t\u00ed hodnotu 9, co\u017e znamen\u00e1, \u017ee pro dosa\u017een\u00ed kumulativn\u00ed pravd\u011bpodobnosti alespo\u0148 0,95 je zapot\u0159eb\u00ed minim\u00e1ln\u011b 9 \u00fasp\u011bch\u016f z 10 pokus\u016f.<\/p>\n
    Praktick\u00e9 p\u0159\u00edklady<\/h2>\n
    P\u0159\u00edklad 1: \u00dasp\u011b\u0161nost marketingov\u00e9 kampan\u011b<\/h2>\n
    P\u0159edstavte si spu\u0161t\u011bn\u00ed marketingov\u00e9 kampan\u011b, kde pot\u0159ebujeme zjistit, kolik lid\u00ed mus\u00edme kontaktovat, aby alespo\u0148 15 z nich reagovalo s pravd\u011bpodobnost\u00ed \u00fasp\u011bchu 0,1 a celkovou kumulativn\u00ed pravd\u011bpodobnost\u00ed \u00fasp\u011bchu 0,95.<\/p>\n
    =BINOM.INV(50, 0.1, 0.95)<\/code><\/pre>\n
    V\u00fdsledek \u0159\u00edk\u00e1, \u017ee je pot\u0159eba oslovit alespo\u0148 50 lid\u00ed, aby bylo dosa\u017eeno nejm\u00e9n\u011b 15 \u00fasp\u011bch\u016f v 95 % p\u0159\u00edpad\u016f.<\/p>\n
    P\u0159\u00edklad 2: Kontrola kvality produkce<\/h2>\n
    V\u00fdrobn\u00ed podnik chce zjistit, kolik v\u00fdrobk\u016f z \u0161ar\u017ee 200 kus\u016f pot\u0159ebuje zkontrolovat, aby s jistotou 90 % mohl tvrdit, \u017ee maxim\u00e1ln\u011b 5 v\u00fdrobk\u016f bude vadn\u00fdch, p\u0159i pravd\u011bpodobnosti vady 0,025.<\/p>\n
    =BINOM.INV(200, 0.025, 0.1)<\/code><\/pre>\n
    V tomto p\u0159\u00edpad\u011b funkce vr\u00e1t\u00ed hodnotu 140, co\u017e znamen\u00e1, \u017ee je t\u0159eba zkontrolovat minim\u00e1ln\u011b 140 v\u00fdrobk\u016f, abychom m\u011bli jistotu, \u017ee maxim\u00e1ln\u011b 5 kus\u016f bude vadn\u00fdch.<\/p>\n
    Funkce BINOM.INV<\/strong> se tedy ukazuje jako velmi cenn\u00fd n\u00e1stroj pro prov\u00e1d\u011bn\u00ed statistick\u00fdch anal\u00fdz a vyhodnocen\u00ed v r\u016fzn\u00fdch aplikac\u00edch, od marketingov\u00fdch kampan\u00ed p\u0159es v\u00fdrobn\u00ed kontroly a\u017e po projekty zam\u011b\u0159en\u00e9 na zaji\u0161t\u011bn\u00ed kvality.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Vr\u00e1t\u00ed nejmen\u0161\u00ed hodnotu, pro kterou m\u00e1 sou\u010dtov\u00e9 binomick\u00e9 rozd\u011blen\u00ed hodnotu v\u011bt\u0161\u00ed nebo rovnu hodnot\u011b krit\u00e9ria<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[287],"tags":[],"class_list":["post-5451","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nFunkce BINOM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije BINOM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\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\/cs\/binom-inv\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce BINOM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije BINOM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/binom-inv\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T09:50:47+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce BINOM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/binom-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/binom-inv\/\",\"name\":\"Funkce BINOM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:44+00:00\",\"dateModified\":\"2021-02-26T09:50:47+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije BINOM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/binom-inv\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/binom-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/binom-inv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistick\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/cs\/statisticke\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BINOM.INV\"}]},{\"@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\":\"cs\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@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\/cs\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkce BINOM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije BINOM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","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\/cs\/binom-inv\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce BINOM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije BINOM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/binom-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T09:50:47+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce BINOM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule","twitter_misc":{"Napsal(a)":"glavadmin","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/cs\/binom-inv\/","url":"https:\/\/functiontranslator.com\/cs\/binom-inv\/","name":"Funkce BINOM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:44+00:00","dateModified":"2021-02-26T09:50:47+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije BINOM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/binom-inv\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/binom-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/binom-inv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Statistick\u00e9","item":"https:\/\/functiontranslator.com\/cs\/statisticke\/"},{"@type":"ListItem","position":3,"name":"BINOM.INV"}]},{"@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":"cs"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"cs","@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\/cs\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/comments?post=5451"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5451\/revisions"}],"predecessor-version":[{"id":30590,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5451\/revisions\/30590"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}