{"id":5749,"date":"2025-07-15T13:34:45","date_gmt":"2025-07-15T13:34:45","guid":{"rendered":"https:\/\/functiontranslator.com\/phi\/"},"modified":"2021-02-26T10:01:34","modified_gmt":"2021-02-26T10:01:34","slug":"phi","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/phi\/","title":{"rendered":"PHI"},"content":{"rendered":"

\u00davod do funkce PHI<\/h2>\n

Funkce PHI<\/code> je matematick\u00fd n\u00e1stroj pou\u017e\u00edvan\u00fd v Microsoft Excel a Google Tabulk\u00e1ch pro v\u00fdpo\u010det hodnoty hustoty pravd\u011bpodobnosti norm\u00e1ln\u00edho rozd\u011blen\u00ed pro dan\u00fd argument. Tato funkce je velmi u\u017eite\u010dn\u00e1 p\u0159i anal\u00fdze dat, kter\u00e1 sleduj\u00ed norm\u00e1ln\u00ed distribuci, \u010dasto ozna\u010dovanou jako Gauss\u016fv nebo zvonov\u00fd tvar.<\/p>\n

Syntaxe a parametry<\/h2>\n

Syntaxe funkce PHI<\/code> v obou aplikac\u00edch je n\u00e1sleduj\u00edc\u00ed:<\/p>\n

PHI(x)<\/code><\/pre>\n
    \n
  • x<\/strong> – Hodnota, pro kterou chcete spo\u010d\u00edtat hustotu pravd\u011bpodobnosti. Toto m\u016f\u017ee b\u00fdt \u010d\u00edslo nebo odkaz na bu\u0148ku obsahuj\u00edc\u00ed \u010d\u00edselnou hodnotu.<\/li>\n<\/ul>\n
    Je d\u016fle\u017eit\u00e9 poznamenat, \u017ee funkce vrac\u00ed hodnotu hustoty pravd\u011bpodobnosti standardn\u00edho norm\u00e1ln\u00edho rozd\u011blen\u00ed s pr\u016fm\u011brem 0 a sm\u011brodatnou odchylkou 1 na z\u00e1klad\u011b zadan\u00e9ho vstupu x<\/code>.<\/p>\n
    P\u0159\u00edklady vyu\u017eit\u00ed<\/h2>\n
    Uvedeme dva praktick\u00e9 p\u0159\u00edklady, jak m\u016f\u017ee b\u00fdt funkce PHI<\/code> vyu\u017eita v tabulkov\u00fdch aplikac\u00edch:<\/p>\n
    Anal\u00fdza \u0161k\u00e1lov\u00e1n\u00ed testov\u00fdch sk\u00f3re<\/h2>\n
    P\u0159edpokl\u00e1dejme, \u017ee m\u00e1me skupinu testov\u00fdch v\u00fdsledk\u016f a chceme ur\u010dit, jakou maj\u00ed hustotu pravd\u011bpodobnosti v norm\u00e1ln\u00edm rozd\u011blen\u00ed. Zde je postup:<\/p>\n
      \n
    1. Zadejte hodnotu testov\u00e9ho sk\u00f3re do bu\u0148ky A1.<\/li>\n
    2. Do bu\u0148ky B1 vlo\u017ete v\u00fdpo\u010det hustoty pravd\u011bpodobnosti pomoc\u00ed =PHI(A1)<\/code>.<\/li>\n
    3. Vizualizujte data pomoc\u00ed grafu pro lep\u0161\u00ed p\u0159ehlednost.<\/li>\n<\/ol>\n
      Ve v\u00fdsledku zobraz\u00ed bu\u0148ka B1 hustotu pravd\u011bpodobnosti pro zadan\u00fd sk\u00f3re testu. M\u016f\u017eete takto postupn\u011b analyzovat v\u00edce sk\u00f3re a z\u00edskat tak p\u0159edstavu o pravd\u011bpodobnostn\u00ed distribuci t\u011bchto v\u00fdsledk\u016f.<\/p>\n
      P\u0159edpov\u011b\u010f po\u010dtu z\u00e1kazn\u00edk\u016f<\/h2>\n
      Jestli\u017ee m\u00e1te data o n\u00e1v\u0161t\u011bvnosti obchodu a p\u0159edpokl\u00e1d\u00e1te, \u017ee se jedn\u00e1 o norm\u00e1ln\u00ed rozd\u011blen\u00ed, m\u016f\u017eete pomoc\u00ed funkce PHI<\/code> odhadnout pravd\u011bpodobnosti pro r\u016fzn\u00e9 po\u010dty n\u00e1v\u0161t\u011bvn\u00edk\u016f. Postup je podobn\u00fd:<\/p>\n
        \n
      1. Zapsat po\u010det n\u00e1v\u0161t\u011bvn\u00edk\u016f jednoho dne do bu\u0148ky A2.<\/li>\n
      2. Vypo\u010d\u00edtat pravd\u011bpodobnostn\u00ed hustotu do B2 s formul\u00ed =PHI(A2)<\/code>.<\/li>\n
      3. Opakovat pro r\u016fzn\u00e9 dny a porovnat hodnoty v B sloupci.<\/li>\n<\/ol>\n
        V\u00fdsledky v\u00e1m umo\u017en\u00ed porozum\u011bt, jak se n\u00e1v\u0161t\u011bvnost obchodu vzta\u017eena ke standardn\u00edmu norm\u00e1ln\u00edmu rozd\u011blen\u00ed chov\u00e1 a m\u016f\u017eete l\u00e9pe pl\u00e1novat nap\u0159\u00edklad z\u00e1soby nebo person\u00e1ln\u00ed pot\u0159eby.<\/p>\n
        Tyto p\u0159\u00edklady ilustruj\u00ed, jak m\u016f\u017ee b\u00fdt funkce PHI<\/code> prakticky vyu\u017eita pro anal\u00fdzu a predikci ve finan\u010dn\u00edm pl\u00e1nov\u00e1n\u00ed, marketingu i dal\u0161\u00edch oblastech.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Vr\u00e1t\u00ed hodnotu funkce hustoty pro standardn\u00ed sm\u011brodatnou odchylku<\/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-5749","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nFunkce PHI v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije PHI 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\/phi\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce PHI v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije PHI u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/phi\/\" \/>\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:34+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce PHI 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\/phi\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/phi\/\",\"name\":\"Funkce PHI 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:34+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije PHI u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/phi\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/phi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/phi\/#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\":\"PHI\"}]},{\"@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 PHI v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije PHI 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\/phi\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce PHI v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije PHI u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/phi\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T10:01:34+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce PHI 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\/phi\/","url":"https:\/\/functiontranslator.com\/cs\/phi\/","name":"Funkce PHI 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:34+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije PHI u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/phi\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/phi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/phi\/#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":"PHI"}]},{"@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\/5749","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=5749"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5749\/revisions"}],"predecessor-version":[{"id":30887,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5749\/revisions\/30887"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}