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

P\u0159ehled a syntaxe funkce pro v\u00fdpo\u010det standardn\u00ed chyby odhadu predikce<\/h2>\n

Standardn\u00ed chyba odhadu predikce je kl\u00ed\u010dov\u00fdm n\u00e1strojem ve finan\u010dn\u00ed anal\u00fdze, statistice a obecn\u00e9m zpracov\u00e1n\u00ed dat, kdy\u017e pot\u0159ebujeme ur\u010dit m\u00edru nejistoty asociovanou s predikcemi vygenerovan\u00fdmi pomoc\u00ed regresn\u00ed anal\u00fdzy. Tanto v Excelu, tak ve Google Sheets m\u016f\u017eeme tuto metriku vypo\u010d\u00edtat pomoc\u00ed funkce STEYX, kter\u00e1 je nezbytn\u00e1 pro hodnocen\u00ed p\u0159esnosti regresn\u00edch model\u016f.<\/p>\n

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

STEYX(y_hodnoty, x_hodnoty)<\/code><\/pre>\n
    \n
  • y_hodnoty<\/code> \u2013 pole nebo rozsah dat, z\u00e1visl\u00fdch prom\u011bnn\u00fdch.<\/li>\n
  • x_hodnoty<\/code> \u2013 pole nebo rozsah dat, nez\u00e1visl\u00fdch prom\u011bnn\u00fdch, kter\u00e9 se pou\u017e\u00edvaj\u00ed pro predikci y_hodnot.<\/li>\n<\/ul>\n
    Je d\u016fle\u017eit\u00e9, aby oba rozsahy obsahovaly stejn\u00fd po\u010det datov\u00fdch bod\u016f; v opa\u010dn\u00e9m p\u0159\u00edpad\u011b funkce vr\u00e1t\u00ed chybovou hl\u00e1\u0161ku.<\/p>\n
    P\u0159\u00edklad vyu\u017eit\u00ed funkce ve finan\u010dn\u00ed anal\u00fdze<\/h2>\n
    P\u0159edpokl\u00e1dejme, \u017ee analyzujeme vztah mezi v\u00fddaji na reklamu (X) a prodeji (Y). Chceme ur\u010dit standardn\u00ed chybu odhadu prodej\u016f zalo\u017eenou na v\u00fddaj\u00edch na reklamu, abychom mohli l\u00e9pe posoudit p\u0159esnost na\u0161eho regresn\u00edho modelu. M\u00e1me k dispozici n\u00e1sleduj\u00edc\u00ed data:<\/p>\n\n\n\n\n\n\n\n
    M\u011bs\u00edc<\/th>\nReklamn\u00ed v\u00fddaje (tis. K\u010d)<\/th>\nProdeje (tis. K\u010d)<\/th>\n<\/tr>\n
    Leden<\/td>\n200<\/td>\n1500<\/td>\n<\/tr>\n
    \u00danor<\/td>\n300<\/td>\n2000<\/td>\n<\/tr>\n
    B\u0159ezen<\/td>\n250<\/td>\n1800<\/td>\n<\/tr>\n
    Duben<\/td>\n500<\/td>\n3000<\/td>\n<\/tr>\n
    Kv\u011bten<\/td>\n400<\/td>\n2500<\/td>\n<\/tr>\n<\/table>\n
    Pou\u017eijeme funkci n\u00e1sledovn\u011b:<\/p>\n
    =STEYX(B2:B6, C2:C6)<\/code><\/pre>\n
    V\u00fdsledek funkce n\u00e1m uk\u00e1\u017ee pr\u016fm\u011brnou odchylku skute\u010dn\u00fdch prodej\u016f od predikovan\u00fdch hodnot na z\u00e1klad\u011b v\u00fddaj\u016f na reklamu. Ni\u017e\u0161\u00ed hodnota standardn\u00ed chyby indikuje vy\u0161\u0161\u00ed p\u0159esnost predikce.<\/p>\n
    Anal\u00fdza a interpretace v\u00fdsledk\u016f<\/h2>\n
    V\u00fdsledky n\u00e1m poskytnou standardn\u00ed chybu, kter\u00e1 pom\u00e1h\u00e1 ur\u010dit, nakolik jsou na\u0161e investice do reklamy efektivn\u00ed p\u0159i generov\u00e1n\u00ed prodej\u016f. Vysok\u00e1 standardn\u00ed chyba by mohla nazna\u010dovat, \u017ee prodeje jsou siln\u011b ovlivn\u011bny dal\u0161\u00edmi faktory a \u017ee reklama nem\u00e1 tak signifikantn\u00ed vliv, jak jsme p\u0159edpokl\u00e1dali.<\/p>\n
    Aplikace funkce v oblasti vzd\u011bl\u00e1v\u00e1n\u00ed<\/h2>\n
    Zva\u017eme situaci, kdy disponujeme daty o \u010dasu str\u00e1ven\u00e9m studiem (X) a v\u00fdsledc\u00edch test\u016f (Y) student\u016f. Cht\u011bli bychom zjistit, s jakou p\u0159esnost\u00ed lze predikovat v\u00fdsledky test\u016f na z\u00e1klad\u011b str\u00e1ven\u00e9ho \u010dasu na studium.<\/p>\n
    Disponujeme n\u00e1sleduj\u00edc\u00edmi daty:<\/p>\n\n\n\n\n\n\n\n
    Student<\/th>\n\u010cas studia (hodiny)<\/th>\nSk\u00f3re testu<\/th>\n<\/tr>\n
    Alice<\/td>\n25<\/td>\n78<\/td>\n<\/tr>\n
    Bob<\/td>\n15<\/td>\n66<\/td>\n<\/tr>\n
    Charlie<\/td>\n20<\/td>\n73<\/td>\n<\/tr>\n
    Diana<\/td>\n30<\/td>\n85<\/td>\n<\/tr>\n
    Edward<\/td>\n10<\/td>\n59<\/td>\n<\/tr>\n<\/table>\n
    Pou\u017eijeme funkci takto:<\/p>\n
    =STEYX(B2:B6, C2:C6)<\/code><\/pre>\n
    V\u00fdpo\u010det poskytne pr\u016fm\u011brnou odchylku mezi skute\u010dn\u00fdmi a predikovan\u00fdmi v\u00fdsledky test\u016f zalo\u017een\u00fdch na \u010dase p\u0159id\u011blen\u00e9m studiu. Tato metrika n\u00e1m umo\u017en\u00ed posoudit, zda \u010das studia je spolehliv\u00fdm ukazatelem akademick\u00e9ho \u00fasp\u011bchu.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Vr\u00e1t\u00ed standardn\u00ed chybu p\u0159edpov\u011bzen\u00e9 hodnoty\u00a0y pro\u00a0ka\u017edou hodnotu\u00a0x v\u00a0regresi<\/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-5819","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nFunkce STEYX v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije STEYX 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\/steyx\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce STEYX v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije STEYX u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/steyx\/\" \/>\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:52+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce STEYX 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\/steyx\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/steyx\/\",\"name\":\"Funkce STEYX 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:52+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije STEYX u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/steyx\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/steyx\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/steyx\/#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\":\"STEYX\"}]},{\"@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 STEYX v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije STEYX 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\/steyx\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce STEYX v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije STEYX u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/steyx\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T10:03:52+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce STEYX 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\/steyx\/","url":"https:\/\/functiontranslator.com\/cs\/steyx\/","name":"Funkce STEYX 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:52+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije STEYX u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/steyx\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/steyx\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/steyx\/#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":"STEYX"}]},{"@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\/5819","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=5819"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5819\/revisions"}],"predecessor-version":[{"id":30953,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5819\/revisions\/30953"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}