{"id":5804,"date":"2025-07-15T13:34:45","date_gmt":"2025-07-15T13:34:45","guid":{"rendered":"https:\/\/functiontranslator.com\/skew-p\/"},"modified":"2021-02-26T10:03:17","modified_gmt":"2021-02-26T10:03:17","slug":"skew-p","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/skew-p\/","title":{"rendered":"SKEW.P"},"content":{"rendered":"

Popis a syntaxe funkce pro v\u00fdpo\u010det zkosen\u00ed distribuce<\/h2>\n

Funkce SKEW.P je n\u00e1strojem v Excelu a Google Sheets pou\u017e\u00edvan\u00fdm pro v\u00fdpo\u010det zkosen\u00ed distribuce s opravn\u00fdm koeficientem ur\u010den\u00fdm pro men\u0161\u00ed vzorky dat. Tato funkce je kl\u00ed\u010dov\u00e1 pro anal\u00fdzu dat, jeliko\u017e umo\u017e\u0148uje zjistit asymetrii distribuce hodnot. Zkosen\u00ed m\u016f\u017ee b\u00fdt jak kladn\u00e9, tak z\u00e1porn\u00e9, co\u017e indikuje, zda jsou hodnoty distribuov\u00e1ny v\u00edce na prav\u00e9 \u010di lev\u00e9 stran\u011b spektra.<\/p>\n

Syntaxe t\u00e9to funkce je n\u00e1sleduj\u00edc\u00ed:<\/p>\n

SKEW.P(hodnota1, [hodnota2], ...)<\/code><\/pre>\n
Kde hodnota1, hodnota2, … jsou argumenty funkce p\u0159edstavuj\u00edc\u00ed hodnoty, pro kter\u00e9 chceme zkosen\u00ed vyhodnotit. Tyto argumenty mohou b\u00fdt zad\u00e1ny p\u0159\u00edmo nebo mohou odkazovat na bu\u0148ky, kter\u00e9 obsahuj\u00ed relevantn\u00ed data.<\/p>\n
P\u0159\u00edklady pou\u017eit\u00ed funkce<\/h2>\n
    \n
  • \n
    P\u0159\u00edklad 1:<\/strong> Vyhodnocen\u00ed zkosen\u00ed sady \u010d\u00edsel.<\/p>\n
    Uva\u017eujme soubor hodnot 4, 20, 15, 15, 9, 30. Chceme ur\u010dit zkosen\u00ed t\u011bchto hodnot.<\/p>\n
    =SKEW.P(4, 20, 15, 15, 9, 30)<\/code><\/pre>\n
    Tento p\u0159\u00edkaz vypo\u010d\u00edt\u00e1 zkosen\u00ed pro zadan\u00e9 hodnoty.<\/p>\n<\/li>\n
  • \n
    P\u0159\u00edklad 2:<\/strong> Pou\u017eit\u00ed funkce pro v\u011bt\u0161\u00ed rozsah dat.<\/p>\n
    P\u0159edpokl\u00e1dejme, \u017ee m\u00e1me data v bu\u0148k\u00e1ch od A1 do A100. Chceme spo\u010d\u00edtat zkosen\u00ed pro tato data.<\/p>\n
    =SKEW.P(A1:A100)<\/code><\/pre>\n
    Tento vzorec vr\u00e1t\u00ed hodnotu zkosen\u00ed pro cel\u00fd rozsah dat.<\/p>\n<\/li>\n<\/ul>\n
    Aplikace ve skute\u010dn\u00fdch sc\u00e9n\u00e1\u0159\u00edch<\/h2>\n
    Funkce SKEW.P m\u00e1 \u0161irok\u00e9 uplatn\u011bn\u00ed, v\u010detn\u011b finan\u010dn\u00ed anal\u00fdzy a v\u011bdeck\u00e9ho v\u00fdzkumu. Zde jsou dva praktick\u00e9 p\u0159\u00edklady jej\u00edho vyu\u017eit\u00ed.<\/p>\n\n\n\n\n
    Sc\u00e9n\u00e1\u0159<\/th>\nPopis<\/th>\nVzorec<\/th>\n<\/tr>\n
    Analyza n\u00e1vratnosti investic<\/td>\nPro anal\u00fdzu n\u00e1vratnosti r\u016fzn\u00fdch finan\u010dn\u00edch aktiv lze ur\u010dit sklon distribuce v\u00fdnos\u016f k vy\u0161\u0161\u00edm nebo ni\u017e\u0161\u00edm extr\u00e9m\u016fm pomoc\u00ed zkosen\u00ed.<\/td>\n=SKEW.P(B2:B100)<\/code><\/td>\n<\/tr>\n
    Po\u010detn\u00ed zkoum\u00e1n\u00ed klimatick\u00fdch dat<\/td>\nZkosen\u00ed teplotn\u00edch z\u00e1znam\u016f m\u016f\u017ee napomoci porozum\u011bn\u00ed, zda maj\u00ed extremn\u00ed teplotn\u00ed ud\u00e1losti tendenci k vy\u0161\u0161\u00edm \u010di ni\u017e\u0161\u00edm hodnot\u00e1m.<\/td>\n=SKEW.P(C2:C365)<\/code><\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"
    Vr\u00e1t\u00ed koeficient \u0161ikmosti rozd\u011blen\u00ed na z\u00e1klad\u011b souboru hodnot: charakteristika stupn\u011b asymetri\u010dnosti rozd\u011blen\u00ed kolem st\u0159edn\u00ed hodnoty<\/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-5804","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nFunkce SKEW.P v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije SKEW.P 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\/skew-p\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce SKEW.P v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije SKEW.P u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/skew-p\/\" \/>\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:17+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce SKEW.P 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\/skew-p\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/skew-p\/\",\"name\":\"Funkce SKEW.P 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:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije SKEW.P u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/skew-p\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/skew-p\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/skew-p\/#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\":\"SKEW.P\"}]},{\"@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 SKEW.P v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije SKEW.P 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\/skew-p\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce SKEW.P v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije SKEW.P u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/skew-p\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T10:03:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce SKEW.P 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\/skew-p\/","url":"https:\/\/functiontranslator.com\/cs\/skew-p\/","name":"Funkce SKEW.P 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:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije SKEW.P u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/skew-p\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/skew-p\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/skew-p\/#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":"SKEW.P"}]},{"@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\/5804","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=5804"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5804\/revisions"}],"predecessor-version":[{"id":30940,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5804\/revisions\/30940"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}