{"id":5754,"date":"2025-07-15T13:34:45","date_gmt":"2025-07-15T13:34:45","guid":{"rendered":"https:\/\/functiontranslator.com\/poisson\/"},"modified":"2021-02-26T10:01:43","modified_gmt":"2021-02-26T10:01:43","slug":"poisson","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/poisson\/","title":{"rendered":"POISSON"},"content":{"rendered":"<h2>\u00davod do distribu\u010dn\u00ed funkce Poisson<\/h2>\n<p>Distribuce Poisson je u\u017eite\u010dn\u00fd matematick\u00fd n\u00e1stroj pro modelov\u00e1n\u00ed po\u010dtu ud\u00e1lost\u00ed v dan\u00e9m \u010dasov\u00e9m intervalu, kde tyto ud\u00e1losti nast\u00e1vaj\u00ed s konstantn\u00ed pravd\u011bpodobnost\u00ed nez\u00e1visle na \u010dase od posledn\u00ed ud\u00e1losti. Tato distribuce je velmi vhodn\u00e1 pro anal\u00fdzu d\u011bj\u016f, kde je pravd\u011bpodobnost v\u00fdskytu konkr\u00e9tn\u00ed ud\u00e1losti relativn\u011b mal\u00e1, ale potenci\u00e1ln\u00ed celkov\u00fd po\u010det ud\u00e1lost\u00ed je velk\u00fd, nap\u0159\u00edklad po\u010det e-mail\u016f p\u0159ijat\u00fdch za den nebo po\u010det nehod v tov\u00e1rn\u011b za rok.<\/p>\n<p>Funkce rozd\u011blen\u00ed Poissona v <strong>MS Excel<\/strong> i <strong>Google Tabulk\u00e1ch<\/strong> poskytuje dv\u011b varianty:<\/p>\n<ul>\n<li><strong>Cumulativn\u00ed distribu\u010dn\u00ed funkce<\/strong> (CDF), kter\u00e1 vypo\u010d\u00edt\u00e1 pravd\u011bpodobnost, \u017ee prom\u011bnn\u00e1 X nab\u00fdv\u00e1 hodnoty men\u0161\u00ed nebo rovn\u00e9 k ur\u010dit\u00e9mu \u010d\u00edslu.<\/li>\n<li><strong>Pravd\u011bpodobnostn\u00ed hmotnostn\u00ed funkce<\/strong> (PMF), kter\u00e1 vypo\u010d\u00edt\u00e1 pravd\u011bpodobnost, \u017ee prom\u011bnn\u00e1 X nab\u00fdv\u00e1 p\u0159esn\u011b ur\u010den\u00e9 hodnoty.<\/li>\n<\/ul>\n<h2>Syntaxe a pou\u017eit\u00ed v praxi<\/h2>\n<p>Ve funkci pou\u017e\u00edv\u00e1me n\u00e1sleduj\u00edc\u00ed syntaxi:<\/p>\n<pre><code>=POISSON(x, st\u0159edn\u00ed_hodnota, kumulativn\u00ed)<\/code><\/pre>\n<p>kde:<\/p>\n<ul>\n<li><code>x<\/code> &#8211; Hodnota, pro kterou funkce vypo\u010d\u00edt\u00e1v\u00e1 pravd\u011bpodobnost.<\/li>\n<li><code>st\u0159edn\u00ed_hodnota<\/code> &#8211; St\u0159edn\u00ed hodnota ud\u00e1lost\u00ed (\u03bb, lambda), kter\u00e1 je rovna o\u010dek\u00e1van\u00e9mu po\u010dtu ud\u00e1lost\u00ed.<\/li>\n<li><code>kumulativn\u00ed<\/code> &#8211; Logick\u00e1 hodnota (PRAVDA nebo NEPRAVDA); PRAVDA pro v\u00fdpo\u010det CDF, NEPRAVDA pro v\u00fdpo\u010det PMF.<\/li>\n<\/ul>\n<h2>P\u0159\u00edklad \u010d. 1: Po\u010det e-mail\u016f<\/h2>\n<p>P\u0159edstavte si, \u017ee pr\u016fm\u011brn\u00fd po\u010det e-mail\u016f p\u0159ijat\u00fdch denn\u011b ve va\u0161\u00ed firm\u011b je 15. Jak\u00e1 je pravd\u011bpodobnost, \u017ee dnes p\u0159ijmete pr\u00e1v\u011b 20 e-mail\u016f?<\/p>\n<p>Ve va\u0161em tabulkov\u00e9m procesoru byste pou\u017eili p\u0159\u00edkaz:<\/p>\n<pre><code>=POISSON(20, 15, NEPRAVDA)<\/code><\/pre>\n<p>Tento p\u0159\u00edkaz vr\u00e1t\u00ed pravd\u011bpodobnost, \u017ee p\u0159esn\u011b 20 e-mail\u016f bude p\u0159ijato dnes.<\/p>\n<h2>P\u0159\u00edklad \u010d. 2: Po\u010det nehod<\/h2>\n<p>V tov\u00e1rn\u011b je pr\u016fm\u011brn\u00fd po\u010det nehod za rok 5. Jak\u00e1 je pravd\u011bpodobnost, \u017ee dojde k 5 nebo m\u00e9n\u011b nehod\u00e1m v dan\u00e9m roce?<\/p>\n<p>Pro z\u00edsk\u00e1n\u00ed t\u00e9to informace byste zapsali:<\/p>\n<pre><code>=POISSON(5, 5, PRAVDA)<\/code><\/pre>\n<p>V\u00fdsledek uk\u00e1zal by kumulativn\u00ed pravd\u011bpodobnost, \u017ee po\u010det nehod nebude p\u0159es\u00e1hnout 5.<\/p>\n<p>Tyto dv\u011b ilustrace demonstruj\u00ed, jak lze pomoc\u00ed funkce Poisson analyzovat r\u016fzn\u00e9 druhy situac\u00ed ve va\u0161em ka\u017edodenn\u00edm \u017eivot\u011b \u010di podnik\u00e1n\u00ed, zaji\u0161\u0165uj\u00edc p\u0159itom pe\u010dliv\u00e9 pl\u00e1nov\u00e1n\u00ed a p\u0159edv\u00edd\u00e1n\u00ed. Pomoc\u00ed funkc\u00ed pro distribuci Poisson m\u016f\u017eete nejen posoudit pravd\u011bpodobnosti konkr\u00e9tn\u00edch v\u00fdsledk\u016f, ale tak\u00e9 spr\u00e1vn\u011b p\u0159ipravit a reagovat na mo\u017en\u00e9 v\u00fdzvy.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vr\u00e1t\u00ed hodnotu distribu\u010dn\u00ed funkce Poissonova rozd\u011blen\u00ed<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[289],"tags":[],"class_list":["post-5754","post","type-post","status-publish","format-standard","hentry","category-kompatibilita"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Funkce POISSON v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije POISSON 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\/poisson\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce POISSON v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije POISSON u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/poisson\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T10:01:43+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce POISSON 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\/poisson\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/poisson\/\",\"name\":\"Funkce POISSON v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:45+00:00\",\"dateModified\":\"2021-02-26T10:01:43+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije POISSON u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/poisson\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/poisson\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/poisson\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kompatibilita\",\"item\":\"https:\/\/functiontranslator.com\/cs\/kompatibilita\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"POISSON\"}]},{\"@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 POISSON v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije POISSON 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\/poisson\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce POISSON v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije POISSON u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/poisson\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T10:01:43+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce POISSON 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\/poisson\/","url":"https:\/\/functiontranslator.com\/cs\/poisson\/","name":"Funkce POISSON v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:45+00:00","dateModified":"2021-02-26T10:01:43+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije POISSON u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/poisson\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/poisson\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/poisson\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Kompatibilita","item":"https:\/\/functiontranslator.com\/cs\/kompatibilita\/"},{"@type":"ListItem","position":3,"name":"POISSON"}]},{"@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\/5754","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=5754"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5754\/revisions"}],"predecessor-version":[{"id":30892,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5754\/revisions\/30892"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}