{"id":5683,"date":"2025-07-15T13:34:45","date_gmt":"2025-07-15T13:34:45","guid":{"rendered":"https:\/\/functiontranslator.com\/lognorm-inv\/"},"modified":"2021-02-26T09:59:05","modified_gmt":"2021-02-26T09:59:05","slug":"lognorm-inv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/lognorm-inv\/","title":{"rendered":"LOGNORM.INV"},"content":{"rendered":"

\u00davod do funkce<\/h2>\n

Funkce LOGNORM.INV je u\u017eite\u010dn\u00fd n\u00e1stroj v Excelu a Google Sheets, kter\u00fd se pou\u017e\u00edv\u00e1 ke zji\u0161t\u011bn\u00ed inverzn\u00ed hodnoty lognorm\u00e1ln\u00ed distribuce. Tato funkce umo\u017e\u0148uje ur\u010dit hodnotu X, p\u0159i kter\u00e9 je pravd\u011bpodobnost, \u017ee lognorm\u00e1ln\u011b rozd\u011blen\u00e1 n\u00e1hodn\u00e1 veli\u010dina nep\u0159ekro\u010d\u00ed hodnotu X, rovna zadan\u00e9 pravd\u011bpodobnosti P. D\u00edky tomu najde uplatn\u011bn\u00ed ve financ\u00edch, in\u017een\u00fdrstv\u00ed a ve v\u00fdzkumu kvality.<\/p>\n

Syntaxe a p\u0159\u00edklady<\/h2>\n

Syntaxe funkce LOGNORM.INV v Excelu a Google Sheets je n\u00e1sleduj\u00edc\u00ed:<\/p>\n

=LOGNORM.INV(pravd\u011bpodobnost, pr\u016fm\u011br, sm\u011brodatn\u00e1 odchylka)<\/code><\/pre>\n
    \n
  • pravd\u011bpodobnost<\/strong> – Pravd\u011bpodobnost, kter\u00e1 odpov\u00edd\u00e1 po\u017eadovan\u00e9 hodnot\u011b. Hodnota mus\u00ed b\u00fdt mezi 0 a 1.<\/li>\n
  • pr\u016fm\u011br<\/strong> – St\u0159edn\u00ed hodnota logaritmu X, kde log(X) n\u00e1sleduje norm\u00e1ln\u00ed distribuci.<\/li>\n
  • sm\u011brodatn\u00e1 odchylka<\/strong> – Sm\u011brodatn\u00e1 odchylka logaritmu X.<\/li>\n<\/ul>\n
    P\u0159\u00edklad pou\u017eit\u00ed:<\/p>\n
    =LOGNORM.INV(0.9, 2, 1)<\/code><\/pre>\n
    Tento p\u0159\u00edklad vr\u00e1t\u00ed hodnotu X, kde pravd\u011bpodobnost, \u017ee lognorm\u00e1ln\u011b rozd\u011blen\u00e1 n\u00e1hodn\u00e1 veli\u010dina nep\u0159ekro\u010d\u00ed X, je 90%, s pr\u016fm\u011brem logaritmu 2 a sm\u011brodatnou odchylkou 1.<\/p>\n
    Praktick\u00e9 aplikace<\/h2>\n
    P\u0159\u00edklad 1: V\u00fdpo\u010det minim\u00e1ln\u00ed \u017eivotnosti komponentu<\/h2>\n
    P\u0159edpokl\u00e1dejme, \u017ee \u017eivotnost ur\u010dit\u00e9ho typu pr\u016fmyslov\u00fdch filtr\u016f sleduje lognorm\u00e1ln\u00ed distribuci. Za zn\u00e1m\u00fdch pr\u016fm\u011br\u016f logaritmu \u017eivotnosti 3,5 a sm\u011brodatn\u00e9 odchylky 0,5 chceme vypo\u010d\u00edtat minim\u00e1ln\u00ed \u017eivotnost, kterou vykazuje 95% t\u011bchto filtr\u016f.<\/p>\n
    =LOGNORM.INV(0.95, 3.5, 0.5)<\/code><\/pre>\n
    Tento p\u0159\u00edkaz ur\u010d\u00ed minim\u00e1ln\u00ed \u017eivotnost X tak, \u017ee 95% filtr\u016f m\u00e1 del\u0161\u00ed \u017eivotnost ne\u017e tato hodnota X. Tento \u00fadaj je kl\u00ed\u010dov\u00fd pro napl\u00e1nov\u00e1n\u00ed preventivn\u00ed \u00fadr\u017eby.<\/p>\n
    P\u0159\u00edklad 2: Finan\u010dn\u00ed rozhodov\u00e1n\u00ed zalo\u017een\u00e9 na o\u010dek\u00e1van\u00fdch vratech<\/h2>\n
    P\u0159edpokl\u00e1dejme, \u017ee o\u010dek\u00e1van\u00e9 v\u00fdnosy z investice jsou lognorm\u00e1ln\u011b rozd\u011bleny. Pr\u016fm\u011br logaritmu v\u00fdnosu \u010din\u00ed 0,04 a sm\u011brodatn\u00e1 odchylka 0,2. Chceme ur\u010dit hodnotu v\u00fdnosu, kter\u00e1 je ni\u017e\u0161\u00ed ne\u017e v 10% nejhor\u0161\u00edch p\u0159\u00edpad\u016f.<\/p>\n
    =LOGNORM.INV(0.1, 0.04, 0.2)<\/code><\/pre>\n
    Tato funkce umo\u017en\u00ed vypo\u010d\u00edtat hodnotu v\u00fdnosu, kter\u00e9 10% investic nedosahuje, co\u017e je u\u017eite\u010dn\u00e9 pro hodnocen\u00ed rizik a stanoven\u00ed minim\u00e1ln\u00edch o\u010dek\u00e1van\u00fdch v\u00fdnos\u016f p\u0159i pl\u00e1nov\u00e1n\u00ed investi\u010dn\u00edho portfolia.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Vr\u00e1t\u00ed inverzn\u00ed funkci ke kumulativn\u00edmu logaritmicko-norm\u00e1ln\u00edmu 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":[287],"tags":[],"class_list":["post-5683","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nFunkce LOGNORM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije LOGNORM.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\/lognorm-inv\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce LOGNORM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije LOGNORM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/lognorm-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-26T09:59:05+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce LOGNORM.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\/lognorm-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/lognorm-inv\/\",\"name\":\"Funkce LOGNORM.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-26T09:59:05+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije LOGNORM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/lognorm-inv\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/lognorm-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/lognorm-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\":\"LOGNORM.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 LOGNORM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije LOGNORM.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\/lognorm-inv\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce LOGNORM.INV v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije LOGNORM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/lognorm-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T09:59:05+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce LOGNORM.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\/lognorm-inv\/","url":"https:\/\/functiontranslator.com\/cs\/lognorm-inv\/","name":"Funkce LOGNORM.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-26T09:59:05+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije LOGNORM.INV u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/lognorm-inv\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/lognorm-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/lognorm-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":"LOGNORM.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\/5683","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=5683"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5683\/revisions"}],"predecessor-version":[{"id":30821,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5683\/revisions\/30821"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}