{"id":5719,"date":"2025-07-15T13:34:45","date_gmt":"2025-07-15T13:34:45","guid":{"rendered":"https:\/\/functiontranslator.com\/norm-inv\/"},"modified":"2021-02-26T10:00:15","modified_gmt":"2021-02-26T10:00:15","slug":"norm-inv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/norm-inv\/","title":{"rendered":"NORM.INV"},"content":{"rendered":"

Syntaxe a pou\u017eit\u00ed statistick\u00e9 funkce<\/h2>\n

Statistick\u00e1 funkce, kterou zde budeme rozeb\u00edrat, se pou\u017e\u00edv\u00e1 k nalezen\u00ed inverzn\u00ed hodnoty norm\u00e1ln\u00edho rozd\u011blen\u00ed pravd\u011bpodobnosti. V MS Excelu i v Google Tabulk\u00e1ch m\u00e1 tato funkce syntaxi, kter\u00e1 se skl\u00e1d\u00e1 ze t\u0159\u00ed parametr\u016f:<\/p>\n

=JM\u00c9NO_FUNKCE(pravd\u011bpodobnost; st\u0159edn\u00ed hodnota; sm\u011brodatn\u00e1 odchylka)<\/code><\/pre>\n
    \n
  • pravd\u011bpodobnost<\/code>: Hodnota pravd\u011bpodobnosti odpov\u00eddaj\u00edc\u00ed norm\u00e1ln\u00edmu rozd\u011blen\u00ed. Mus\u00ed b\u00fdt mezi 0 a 1.<\/li>\n
  • st\u0159edn\u00ed hodnota<\/code>: Arimetick\u00fd pr\u016fm\u011br distribuce.<\/li>\n
  • sm\u011brodatn\u00e1 odchylka<\/code>: Sm\u011brodatn\u00e1 odchylka distribuce, nesm\u00ed b\u00fdt z\u00e1porn\u00e1.<\/li>\n<\/ul>\n
    Tato funkce je u\u017eite\u010dn\u00e1 nap\u0159\u00edklad p\u0159i anal\u00fdze v\u00fdsledk\u016f, kter\u00e9 maj\u00ed norm\u00e1ln\u00ed rozd\u011blen\u00ed a pot\u0159ebujeme zjistit teoretickou hodnotu odpov\u00eddaj\u00edc\u00ed zadan\u00e9 pravd\u011bpodobnosti.<\/p>\n
    P\u0159\u00edklad 1: Vypo\u010d\u00edt\u00e1n\u00ed teoretick\u00e9 prahov\u00e9 hodnoty<\/h2>\n
    P\u0159edpokl\u00e1dejme, \u017ee chceme zjistit, jak\u00e1 hodnota odpov\u00edd\u00e1 95% prahov\u00e9 hodnot\u011b v norm\u00e1ln\u011b rozd\u011blen\u00e9m souboru \u00fadaj\u016f s pr\u016fm\u011brem 50 a sm\u011brodatnou odchylkou 10. Pou\u017eijeme n\u00e1sleduj\u00edc\u00ed formuli ve sv\u00e9m tabulkov\u00e9m procesoru:<\/p>\n
    =JM\u00c9NO_FUNKCE(0.95; 50; 10)<\/code><\/pre>\n
    Po zad\u00e1n\u00ed tohoto vzorce do bu\u0148ky tabulky by v\u00fdsledkem m\u011bla b\u00fdt hodnota, kter\u00e1 p\u0159edstavuje 95. percentil pro tento datov\u00fd soubor. Tento v\u00fdsledek m\u016f\u017ee b\u00fdt u\u017eite\u010dn\u00fd nap\u0159\u00edklad p\u0159i nastavov\u00e1n\u00ed limit\u016f pro kontroln\u00ed grafy v kvalit\u011b v\u00fdroby.<\/p>\n
    P\u0159\u00edklad 2: Anal\u00fdza rizik<\/h2>\n
    P\u0159edstavte si, \u017ee jako analytik rizik mus\u00edte ur\u010dit minimum v\u00fdnosnosti, kter\u00e9 spad\u00e1 do 5% nejni\u017e\u0161\u00edch v\u00fdnosnost\u00ed (riziko ztr\u00e1ty) investi\u010dn\u00edho portfolia, kter\u00e9 m\u00e1 pr\u016fm\u011br 8% ro\u010dn\u00ed n\u00e1vrat a sm\u011brodatnou odchylku 15%. Zad\u00e1me:<\/p>\n
    =JM\u00c9NO_FUNKCE(0.05; 8; 15)<\/code><\/pre>\n
    V\u00fdsledek, kter\u00fd dostaneme, n\u00e1m uk\u00e1\u017ee, p\u0159i jak\u00e9 v\u00fdnosnosti se nach\u00e1z\u00ed spodn\u00edch 5% portfolia, co\u017e pom\u00e1h\u00e1 p\u0159i posuzov\u00e1n\u00ed investi\u010dn\u00edch rizik. Tento \u00fadaj lze vyu\u017e\u00edt pro strategick\u00e9 rozhodov\u00e1n\u00ed o rozlo\u017een\u00ed investic nebo nastaven\u00ed rezerv pro kryt\u00ed mo\u017en\u00fdch ztr\u00e1t.<\/p>\n
    V obou p\u0159\u00edkladech vid\u00edme, jak m\u016f\u017ee b\u00fdt tato funkce u\u017eite\u010dn\u00e1 v praktick\u00fdch aplikac\u00edch, zejm\u00e9na ve financ\u00edch a anal\u00fdze dat. P\u0159i spr\u00e1vn\u00e9m pou\u017eit\u00ed m\u016f\u017ee p\u0159in\u00e9st cenn\u00e9 vhledy do chov\u00e1n\u00ed datov\u00e9 sady a pomoci v rozhodovac\u00edch procesech.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Vr\u00e1t\u00ed inverzn\u00ed funkci k funkci norm\u00e1ln\u00edho sou\u010dtov\u00e9ho 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-5719","post","type-post","status-publish","format-standard","hentry","category-kompatibilita"],"acf":[],"yoast_head":"\nFunkce NORM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije NORM.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\/norm-inv\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce NORM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije NORM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/norm-inv\/\" \/>\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:00:15+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce NORM.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\/norm-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/norm-inv\/\",\"name\":\"Funkce NORM.INV 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:00:15+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije NORM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/norm-inv\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/norm-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/norm-inv\/#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\":\"NORM.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 NORM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije NORM.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\/norm-inv\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce NORM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije NORM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/norm-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T10:00:15+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce NORM.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\/norm-inv\/","url":"https:\/\/functiontranslator.com\/cs\/norm-inv\/","name":"Funkce NORM.INV 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:00:15+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije NORM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/norm-inv\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/norm-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/norm-inv\/#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":"NORM.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\/5719","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=5719"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5719\/revisions"}],"predecessor-version":[{"id":30857,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5719\/revisions\/30857"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}