{"id":5865,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/var-vyber\/"},"modified":"2021-02-26T10:05:32","modified_gmt":"2021-02-26T10:05:32","slug":"var-2","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/var-2\/","title":{"rendered":"VAR.V\u00ddB\u011aR"},"content":{"rendered":"

\u00davod<\/h2>\n

Funkce VAR, zn\u00e1m\u00e1 v nov\u011bj\u0161\u00edch verz\u00edch program\u016f MS Excel a Google Sheets jako VAR.V\u00ddB\u011aR, je statistick\u00e1 funkce pro v\u00fdpo\u010det variance z\u00e1kladn\u00edho souboru. Variance m\u011b\u0159\u00ed rozpt\u00fdlen\u00ed datov\u00fdch bod\u016f vzhledem k pr\u016fm\u011brn\u00e9 (st\u0159edn\u00ed) hodnot\u011b souboru.<\/p>\n

Syntaxe<\/h2>\n

Syntaxe pro funkci VAR je n\u00e1sleduj\u00edc\u00ed:<\/p>\n

=VAR(\u010d\u00edslo1, [\u010d\u00edslo2], ...)<\/code><\/pre>\n
Pro funkci VAR.V\u00ddB\u011aR v Excelu plat\u00ed velmi podobn\u00e1 syntaxe:<\/p>\n
=VAR.V\u00ddB\u011aR(\u010d\u00edslo1, [\u010d\u00edslo2], ...)<\/code><\/pre>\n
Kde \u010d\u00edslo1, \u010d\u00edslo2, ...<\/code> jsou argumenty reprezentuj\u00edc\u00ed vzorek datov\u00fdch bod\u016f. Funkce m\u016f\u017ee p\u0159ij\u00edmat a\u017e 255 argument\u016f. Datov\u00e9 body mohou b\u00fdt zad\u00e1ny p\u0159\u00edmo, nebo mohou b\u00fdt odkazy na jednotliv\u00e9 bu\u0148ky \u010di rozsahy bun\u011bk obsahuj\u00edc\u00ed relevantn\u00ed data.<\/p>\n
P\u0159\u00edklady u\u017eit\u00ed<\/h2>\n
N\u00ed\u017ee jsou uvedeny dva praktick\u00e9 p\u0159\u00edklady, jak efektivn\u011b vyu\u017e\u00edt funkci VAR.V\u00ddB\u011aR:<\/p>\n
P\u0159\u00edklad 1: V\u00fdpo\u010det variability prodeje<\/h2>\n
P\u0159edstavte si, \u017ee analyzujete m\u011bs\u00ed\u010dn\u00ed prodejn\u00ed data z trojice obchod\u016f za cel\u00fd rok a chcete zjistit rozptyl mezi jednotliv\u00fdmi prodeji.<\/p>\n
Data prodeje pro ka\u017ed\u00fd obchod jsou n\u00e1sleduj\u00edc\u00ed:<\/p>\n
    \n
  • Obchod A: 250, 300, 400<\/li>\n
  • Obchod B: 450, 500, 550<\/li>\n
  • Obchod C: 400, 600, 650<\/li>\n<\/ul>\n
    Pro ka\u017ed\u00fd obchod pou\u017eijeme funkci VAR.V\u00ddB\u011aR:<\/p>\n
    =VAR.V\u00ddB\u011aR(250, 300, 400) \/\/ V\u00fdsledek pro Obchod A<\/code><\/pre>\n
    =VAR.V\u00ddB\u011aR(450, 500, 550) \/\/ V\u00fdsledek pro Obchod B<\/code><\/pre>\n
    =VAR.V\u00ddB\u011aR(400, 600, 650) \/\/ V\u00fdsledek pro Obchod C<\/code><\/pre>\n
    Tyto v\u00fdpo\u010dty ukazuj\u00ed zm\u011bny prodej\u016f ve zvolen\u00fdch obchodech a mohou pomoci identifikovat obchod s nejstabiln\u011bj\u0161\u00edmi prodeji.<\/p>\n
    P\u0159\u00edklad 2: Anal\u00fdza distribuce student\u016f podle \u00fasp\u011b\u0161nosti<\/h2>\n
    M\u00e1me testov\u00e9 v\u00fdsledky 30 student\u016f. Informace jsou ulo\u017eeny v bu\u0148k\u00e1ch A1:A30.<\/p>\n
    Pro anal\u00fdzu rozptylu jejich v\u00fdsledk\u016f pou\u017eijeme:<\/p>\n
    =VAR.V\u00ddB\u011aR(A1:A30)<\/code><\/pre>\n
    Tento v\u00fdpo\u010det poskytne insight do variability v\u00fdkonu student\u016f, co\u017e n\u00e1m umo\u017en\u00ed l\u00e9pe pochopit, zda jsou jejich v\u00fdsledky velmi rozd\u00edln\u00e9 nebo relativn\u011b konzistentn\u00ed.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Vypo\u010dte rozptyl v\u00fdb\u011bru<\/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-5865","post","type-post","status-publish","format-standard","hentry","category-kompatibilita"],"acf":[],"yoast_head":"\nFunkce VAR (VAR.V\u00ddB\u011aR) v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije VAR (VAR.V\u00ddB\u011aR) 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\/var-2\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce VAR (VAR.V\u00ddB\u011aR) v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije VAR (VAR.V\u00ddB\u011aR) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/var-2\/\" \/>\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-26T10:05:32+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce VAR (VAR.V\u00ddB\u011aR) 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\/var-2\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/var-2\/\",\"name\":\"Funkce VAR (VAR.V\u00ddB\u011aR) 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-26T10:05:32+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije VAR (VAR.V\u00ddB\u011aR) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/var-2\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/var-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/var-2\/#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\":\"VAR.V\u00ddB\u011aR\"}]},{\"@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 VAR (VAR.V\u00ddB\u011aR) v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije VAR (VAR.V\u00ddB\u011aR) 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\/var-2\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce VAR (VAR.V\u00ddB\u011aR) v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije VAR (VAR.V\u00ddB\u011aR) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/var-2\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T10:05:32+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce VAR (VAR.V\u00ddB\u011aR) 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\/var-2\/","url":"https:\/\/functiontranslator.com\/cs\/var-2\/","name":"Funkce VAR (VAR.V\u00ddB\u011aR) 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-26T10:05:32+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije VAR (VAR.V\u00ddB\u011aR) u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/var-2\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/var-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/var-2\/#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":"VAR.V\u00ddB\u011aR"}]},{"@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\/5865","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=5865"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5865\/revisions"}],"predecessor-version":[{"id":30999,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5865\/revisions\/30999"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}