{"id":5482,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/confidence-norm\/"},"modified":"2021-02-26T09:51:56","modified_gmt":"2021-02-26T09:51:56","slug":"confidence-norm","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/confidence-norm\/","title":{"rendered":"CONFIDENCE.NORM"},"content":{"rendered":"

\u00davod do statistick\u00e9 funkce pro odhad intervalu spolehlivosti<\/h2>\n

Funkce pro v\u00fdpo\u010det norm\u00e1ln\u00edho intervalu spolehlivosti je u\u017eite\u010dn\u00fdm n\u00e1strojem p\u0159i anal\u00fdze dat, kter\u00fd poskytuje odhad spolehlivostn\u00edho intervalu pro st\u0159edn\u00ed hodnotu populace na z\u00e1klad\u011b zadan\u00e9ho vzorku. Tato funkce je k dispozici jak v MS Excelu, tak v Google Tabulk\u00e1ch a je \u0161iroce vyu\u017e\u00edv\u00e1na ve statistice, v\u00fdzkumu, a dal\u0161\u00edch oborech kde je pot\u0159eba ur\u010dit m\u00edru uncertainty odhad\u016f. <\/p>\n

Syntaxe a pou\u017eit\u00ed<\/h2>\n

V MS Excelu i Google Tabulk\u00e1ch m\u00e1 tato funkce n\u00e1sleduj\u00edc\u00ed syntaxi: <\/p>\n

=CONFIDENCE.NORM(alpha, standard_dev, size)<\/code><\/pre>\n
 Kde: <\/p>\n
    \n
  • alpha<\/code> – \u00farove\u0148 v\u00fdznamnosti, 1 – (d\u016fv\u011bra\/100). Nap\u0159\u00edklad pro 95% interval spolehlivosti, alpha bude 0.05.<\/li>\n
  • standard_dev<\/code> – sm\u011brodatn\u00e1 odchylka vzorku.<\/li>\n
  • size<\/code> – velikost vzorku (po\u010det pozorov\u00e1n\u00ed).<\/li>\n<\/ul>\n
     Funkce vrac\u00ed \u0161\u00ed\u0159ku poloviny intervalu spolehlivosti. To znamen\u00e1, \u017ee k definov\u00e1n\u00ed cel\u00e9ho intervalu by m\u011bla b\u00fdt tato hodnota p\u0159i\u010dtena a ode\u010dtena od vypo\u010d\u00edtan\u00e9ho pr\u016fm\u011bru vzorku. <\/p>\n
    Praktick\u00e9 p\u0159\u00edklady pou\u017eit\u00ed<\/h2>\n
    P\u0159\u00edklad 1: Odhad intervalu spolehlivosti pro pr\u016fm\u011brnou hmotnost<\/h3>\n
     P\u0159edstavme si, \u017ee prov\u00e1d\u00edme v\u00fdzkum na vzorku 40 lid\u00ed, abychom zjistili pr\u016fm\u011brnou hmotnost s 95% intervalu spolehlivosti. Sm\u011brodatn\u00e1 odchylka hmotnosti ve vzorku je 12 kg. <\/p>\n
    =CONFIDENCE.NORM(0.05, 12, 40)<\/code><\/pre>\n
     Hodnota, kterou dostaneme z t\u00e9to funkce, \u0159ekn\u011bme, \u017ee je 3.6. To znamen\u00e1, \u017ee 95% interval spolehlivosti kolem vypo\u010d\u00edtan\u00e9ho pr\u016fm\u011bru je do \u00b13.6 kg. Pokud je pr\u016fm\u011brn\u00e1 hmotnost vzorku 70 kg, interval spolehlivosti bude 70 kg \u00b1 3.6 kg, co\u017e odpov\u00edd\u00e1 66.4 kg do 73.6 kg. <\/p>\n
    P\u0159\u00edklad 2: Aplikace ve \u0161koln\u00edm testov\u00e1n\u00ed<\/h3>\n
     U\u010ditel chce ur\u010dit 95% interval spolehlivosti pr\u016fm\u011brn\u00e9ho sk\u00f3re testu ve t\u0159\u00edd\u011b, kde studenti m\u011bli sm\u011brodatnou odchylku sk\u00f3re 15 bod\u016f a celkem 30 student\u016f napsalo test. <\/p>\n
    =CONFIDENCE.NORM(0.05, 15, 30)<\/code><\/pre>\n
     Pokud tato funkce vrac\u00ed hodnotu 5.5, a pr\u016fm\u011brn\u00e9 sk\u00f3re ve t\u0159\u00edd\u011b bylo 75 bod\u016f, pak 95% interval spolehlivosti by byl od 69.5 bod\u016f do 80.5 bod\u016f. U\u010ditel m\u016f\u017ee s t\u00edmto intervalem confidentn\u011b tvrdit, \u017ee skute\u010dn\u00fd pr\u016fm\u011br sk\u00f3re cel\u00e9 populace student\u016f, kdyby v\u0161ichni absolvovali test, by le\u017eel n\u011bkde v tomto intervalu. <\/p>\n
    Z\u00e1v\u011br<\/h2>\n
     Pou\u017eit\u00ed funkce pro norm\u00e1ln\u00ed interval spolehlivosti je velmi cenn\u00fdm n\u00e1strojem pro posouzen\u00ed nejistoty ve v\u00fdsledc\u00edch z\u00edskan\u00fdch z datov\u00fdch vzork\u016f. Permite analyz\u00e1tory pochopit rozsah, ve kter\u00e9m by skute\u010dn\u00e9 st\u0159edn\u00ed hodnoty mohly varirovat, co\u017e pom\u00e1h\u00e1 p\u0159i rozhodov\u00e1n\u00ed a dal\u0161\u00edch statistick\u00fdch anal\u00fdz\u00e1ch. <\/p>\n","protected":false},"excerpt":{"rendered":"
    Vr\u00e1t\u00ed interval spolehlivosti pro st\u0159edn\u00ed hodnotu z\u00e1kladn\u00edho souboru<\/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-5482","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nFunkce CONFIDENCE.NORM v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije CONFIDENCE.NORM 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\/confidence-norm\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce CONFIDENCE.NORM v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije CONFIDENCE.NORM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/confidence-norm\/\" \/>\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:51:56+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce CONFIDENCE.NORM 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\/confidence-norm\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/confidence-norm\/\",\"name\":\"Funkce CONFIDENCE.NORM 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:51:56+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije CONFIDENCE.NORM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/confidence-norm\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/confidence-norm\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/confidence-norm\/#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\":\"CONFIDENCE.NORM\"}]},{\"@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 CONFIDENCE.NORM v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije CONFIDENCE.NORM 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\/confidence-norm\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce CONFIDENCE.NORM v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije CONFIDENCE.NORM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/confidence-norm\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T09:51:56+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce CONFIDENCE.NORM 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\/confidence-norm\/","url":"https:\/\/functiontranslator.com\/cs\/confidence-norm\/","name":"Funkce CONFIDENCE.NORM 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:51:56+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije CONFIDENCE.NORM u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/confidence-norm\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/confidence-norm\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/confidence-norm\/#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":"CONFIDENCE.NORM"}]},{"@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\/5482","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=5482"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5482\/revisions"}],"predecessor-version":[{"id":30621,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5482\/revisions\/30621"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}