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

Funkce STDEVA<\/strong> je cenn\u00fdm n\u00e1strojem v Microsoft Excel a Google Sheets pro v\u00fdpo\u010det standardn\u00ed odchylky sady dat, p\u0159i\u010dem\u017e v\u0161echny hodnoty ve v\u00fdpo\u010dtu jsou zahrnuty jako vzorek. Tato funkce je kl\u00ed\u010dov\u00e1 pro statistickou anal\u00fdzu, obzvl\u00e1\u0161t\u011b kdy\u017e se anal\u00fdza zam\u011b\u0159uje na vzorky dat a nikoli na celou populaci.<\/p>\n

Popis a syntaxe funkce<\/h2>\n

Syntaxe funkce STDEVA<\/strong> v Excelu i Google Sheets je:<\/p>\n

=STDEVA(hodnota1, [hodnota2], ...)<\/code><\/pre>\n
Argumenty hodnota1, hodnota2, …<\/strong> reprezentuj\u00ed soubor hodnot, pro kter\u00e9 se vypo\u010d\u00edt\u00e1v\u00e1 standardn\u00ed odchylka. V Excelu a Google Sheets se textov\u00e9 hodnoty v sad\u011b dat interpretuj\u00ed jako nuly, zat\u00edmco logick\u00e9 hodnoty TRUE a FALSE se p\u0159ev\u00e1d\u011bj\u00ed na 1 a 0.<\/p>\n
P\u0159\u00edklady vyu\u017eit\u00ed<\/h2>\n
    \n
  • V\u00fdpo\u010det variability pro soubor testovac\u00edch sk\u00f3re.<\/li>\n
  • Anal\u00fdza rozptylu prodejn\u00edch \u010d\u00edsel r\u016fzn\u00fdch produkt\u016f.<\/li>\n<\/ul>\n
    Praktick\u00e9 p\u0159\u00edklady a \u0159e\u0161en\u00ed<\/h2>\n
    Zde uv\u00e1d\u00edme dva praktick\u00e9 p\u0159\u00edklady pou\u017eit\u00ed funkce STDEVA<\/strong>.<\/p>\n
    P\u0159\u00edklad 1: Anal\u00fdza testovac\u00edch sk\u00f3re<\/h2>\n
    P\u0159edstavte si v\u00fdsledky test\u016f skupiny student\u016f:<\/p>\n
    78, 85, 90, 95, 60, \"nehodnoceno\", TRUE<\/code><\/pre>\n
    Pro v\u00fdpo\u010det standardn\u00ed odchylky jejich sk\u00f3re pou\u017eijeme funkci STDEVA<\/strong> takto:<\/p>\n
    =STDEVA(78, 85, 90, 95, 60, \"nehodnoceno\", TRUE)<\/code><\/pre>\n
    V tomto p\u0159\u00edkladu je „nehodnoceno“ pova\u017eov\u00e1no za 0 a TRUE za 1. V\u00fdsledek funkce odr\u00e1\u017e\u00ed m\u00edru rozptylu dat.<\/p>\n
    P\u0159\u00edklad 2: Rozptyl prodej\u016f produkt\u016f<\/h2>\n
    M\u00e1me prodejn\u00ed \u010d\u00edsla za r\u016fzn\u00e9 produkty b\u011bhem jednoho m\u011bs\u00edce:<\/p>\n
    120, 150, 130, 160, 180, \"nezn\u00e1m\u00e9\", FALSE<\/code><\/pre>\n
    Pro anal\u00fdzu variability prodej\u016f pou\u017eijeme funkci STDEVA<\/strong> n\u00e1sledovn\u011b:<\/p>\n
    =STDEVA(120, 150, 130, 160, 180, \"nezn\u00e1m\u00e9\", FALSE)<\/code><\/pre>\n
    Op\u011bt „nezn\u00e1m\u00e9“ se p\u0159epo\u010d\u00edt\u00e1v\u00e1 na 0 a FALSE tak\u00e9 na 0. V\u00fdsledek poskytne p\u0159ehled o rozptylu prodejn\u00edch \u010d\u00edsel, co\u017e pom\u00e1h\u00e1 identifikovat produkty s v\u00fdrazn\u011b odli\u0161n\u00fdm prodejn\u00edm v\u00fdkonem.<\/p>\n
    Tyto p\u0159\u00edklady ukazuj\u00ed, jak m\u016f\u017ee b\u00fdt funkce STDEVA<\/strong> efektivn\u011b vyu\u017eita pro analyzov\u00e1n\u00ed dat obsahuj\u00edc\u00edch r\u016fzn\u00e9 typy hodnot, v\u010detn\u011b textov\u00fdch a logick\u00fdch.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Vypo\u010dte sm\u011brodatnou odchylku v\u00fdb\u011bru v\u010detn\u011b \u010d\u00edsel, textu a\u00a0logick\u00fdch hodnot<\/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-5816","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nFunkce STDEVA v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije STDEVA 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\/stdeva\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce STDEVA v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije STDEVA u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/stdeva\/\" \/>\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:03:48+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce STDEVA 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\/stdeva\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/stdeva\/\",\"name\":\"Funkce STDEVA 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:03:48+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije STDEVA u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/stdeva\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/stdeva\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/stdeva\/#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\":\"STDEVA\"}]},{\"@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 STDEVA v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije STDEVA 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\/stdeva\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce STDEVA v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije STDEVA u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/stdeva\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T10:03:48+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce STDEVA 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\/stdeva\/","url":"https:\/\/functiontranslator.com\/cs\/stdeva\/","name":"Funkce STDEVA 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:03:48+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije STDEVA u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/stdeva\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/stdeva\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/stdeva\/#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":"STDEVA"}]},{"@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\/5816","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=5816"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5816\/revisions"}],"predecessor-version":[{"id":30950,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5816\/revisions\/30950"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}