{"id":1058,"date":"2023-07-27T19:45:54","date_gmt":"2023-07-27T19:45:54","guid":{"rendered":"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/"},"modified":"2023-07-27T19:45:54","modified_gmt":"2023-07-27T19:45:54","slug":"asymetria-kurtoza-arkusze-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/","title":{"rendered":"Jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 w arkuszach google"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">W statystyce <strong>sko\u015bno\u015b\u0107<\/strong> i <strong>kurtoza<\/strong> to dwa sposoby pomiaru kszta\u0142tu rozk\u0142adu.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Sko\u015bno\u015b\u0107<\/strong> jest miar\u0105 sko\u015bno\u015bci rozk\u0142adu. Warto\u015b\u0107 ta mo\u017ce by\u0107 dodatnia lub ujemna.<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Ujemna sko\u015bno\u015b\u0107 wskazuje, \u017ce ogon znajduje si\u0119 po lewej stronie rozk\u0142adu, kt\u00f3ry rozci\u0105ga si\u0119 w stron\u0119 bardziej ujemnych warto\u015bci.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Dodatnie pochylenie wskazuje, \u017ce ogon znajduje si\u0119 po prawej stronie rozk\u0142adu, kt\u00f3ry rozci\u0105ga si\u0119 w kierunku bardziej dodatnich warto\u015bci.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Warto\u015b\u0107 zero oznacza, \u017ce w rozk\u0142adzie nie ma asymetrii, co oznacza, \u017ce rozk\u0142ad jest doskonale symetryczny.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Kurtoza<\/strong> jest miar\u0105 tego, czy rozk\u0142ad jest ci\u0119\u017cki czy lekki w por\u00f3wnaniu z <a href=\"https:\/\/statorials.org\/pl\/rozk\u0142ad-normalny\/\" target=\"_blank\" rel=\"noopener noreferrer\">rozk\u0142adem normalnym<\/a> .<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Kurtoza rozk\u0142adu normalnego wynosi 3.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Je\u015bli dany rozk\u0142ad ma kurtoz\u0119 mniejsz\u0105 ni\u017c 3, nazywa si\u0119 go <em>playkurtycznym<\/em> , co oznacza, \u017ce ma tendencj\u0119 do tworzenia mniejszej liczby i mniej ekstremalnych warto\u015bci odstaj\u0105cych ni\u017c rozk\u0142ad normalny.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Je\u015bli dany rozk\u0142ad ma kurtoz\u0119 wi\u0119ksz\u0105 ni\u017c 3, nazywa si\u0119 go <em>leptokurtycznym<\/em> , co oznacza, \u017ce ma tendencj\u0119 do tworzenia wi\u0119kszej liczby warto\u015bci odstaj\u0105cych ni\u017c rozk\u0142ad normalny.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">W tym samouczku wyja\u015bniono, jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 dla danego zbioru danych w Arkuszach Google.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Przyk\u0142ad: sko\u015bno\u015b\u0107 i sp\u0142aszczenie w Arkuszach Google<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Za\u0142\u00f3\u017cmy, \u017ce mamy nast\u0119puj\u0105cy zbi\u00f3r danych:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10936 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/skew_kurt_sheets1-1.png\" alt=\"\" width=\"371\" height=\"477\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Aby obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 tego zbioru danych, mo\u017cemy u\u017cy\u0107 funkcji <strong>SKEW()<\/strong> i <strong>KURT()<\/strong> o nast\u0119puj\u0105cej sk\u0142adni:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>SKEW (tabela warto\u015bci)<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>KURT (Tabela warto\u015bci)<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Nale\u017cy pami\u0119ta\u0107, \u017ce ka\u017cda funkcja zwr\u00f3ci <strong>b\u0142\u0105d #DIV\/0!<\/strong> w dw\u00f3ch nast\u0119puj\u0105cych scenariuszach:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Je\u015bli jest mniej ni\u017c trzy punkty danych.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Je\u015bli odchylenie standardowe pr\u00f3bki wynosi zero.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Poni\u017cszy obrazek pokazuje, jak u\u017cywa\u0107 tych funkcji dla naszego konkretnego zbioru danych:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10937 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/skew_kurt_sheets2.png\" alt=\"Sko\u015bno\u015b\u0107 i sp\u0142aszczenie w Arkuszach Google\" width=\"510\" height=\"492\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Sko\u015bno\u015b\u0107 wynosi <strong>-0,18490<\/strong> , a kurtoza wynosi <strong>0,34624<\/strong> .<\/span><\/p>\n<h3> <strong>Dodatkowe \u017ar\u00f3d\u0142o: Kalkulator sko\u015bno\u015bci i kurtozy<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Mo\u017cna tak\u017ce obliczy\u0107 sko\u015bno\u015b\u0107 dla danego zbioru danych, korzystaj\u0105c ze<\/span> <a href=\"https:\/\/statorials.org\/pl\" target=\"_blank\" rel=\"noopener noreferrer\">statystycznego kalkulatora sko\u015bno\u015bci i kurtozy<\/a> <span style=\"color: #000000;\">, kt\u00f3ry automatycznie oblicza sko\u015bno\u015b\u0107 i kurtoz\u0119 dla danego zbioru danych.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>W statystyce sko\u015bno\u015b\u0107 i kurtoza to dwa sposoby pomiaru kszta\u0142tu rozk\u0142adu. Sko\u015bno\u015b\u0107 jest miar\u0105 sko\u015bno\u015bci rozk\u0142adu. Warto\u015b\u0107 ta mo\u017ce by\u0107 dodatnia lub ujemna. Ujemna sko\u015bno\u015b\u0107 wskazuje, \u017ce ogon znajduje si\u0119 po lewej stronie rozk\u0142adu, kt\u00f3ry rozci\u0105ga si\u0119 w stron\u0119 bardziej ujemnych warto\u015bci. Dodatnie pochylenie wskazuje, \u017ce ogon znajduje si\u0119 po prawej stronie rozk\u0142adu, kt\u00f3ry rozci\u0105ga [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1058","post","type-post","status-publish","format-standard","hentry","category-przewodnik"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 w Arkuszach Google<\/title>\n<meta name=\"description\" content=\"Proste wyja\u015bnienie, jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 zbioru danych w Arkuszach Google, z przyk\u0142adem.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 w Arkuszach Google\" \/>\n<meta property=\"og:description\" content=\"Proste wyja\u015bnienie, jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 zbioru danych w Arkuszach Google, z przyk\u0142adem.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T19:45:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/skew_kurt_sheets1-1.png\" \/>\n<meta name=\"author\" content=\"Benjamin Anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\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:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/\",\"url\":\"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/\",\"name\":\"Jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 w Arkuszach Google\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pl\/#website\"},\"datePublished\":\"2023-07-27T19:45:54+00:00\",\"dateModified\":\"2023-07-27T19:45:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965\"},\"description\":\"Proste wyja\u015bnienie, jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 zbioru danych w Arkuszach Google, z przyk\u0142adem.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Dom\",\"item\":\"https:\/\/statorials.org\/pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 w arkuszach google\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/pl\/#website\",\"url\":\"https:\/\/statorials.org\/pl\/\",\"name\":\"Statorials\",\"description\":\"Tw\u00f3j przewodnik po kompetencjach statystycznych!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/pl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965\",\"name\":\"Benjamin Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin Anderson\"},\"description\":\"Cze\u015b\u0107, jestem Benjamin i jestem emerytowanym profesorem statystyki, kt\u00f3ry zosta\u0142 oddanym nauczycielem Statorials. Dzi\u0119ki bogatemu do\u015bwiadczeniu i wiedzy specjalistycznej w dziedzinie statystyki ch\u0119tnie dziel\u0119 si\u0119 swoj\u0105 wiedz\u0105, aby wzmocni\u0107 pozycj\u0119 uczni\u00f3w za po\u015brednictwem Statorials. Wiedzie\u0107 wi\u0119cej\",\"sameAs\":[\"https:\/\/statorials.org\/pl\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 w Arkuszach Google","description":"Proste wyja\u015bnienie, jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 zbioru danych w Arkuszach Google, z przyk\u0142adem.","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:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/","og_locale":"pl_PL","og_type":"article","og_title":"Jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 w Arkuszach Google","og_description":"Proste wyja\u015bnienie, jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 zbioru danych w Arkuszach Google, z przyk\u0142adem.","og_url":"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/","og_site_name":"Statorials","article_published_time":"2023-07-27T19:45:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/skew_kurt_sheets1-1.png"}],"author":"Benjamin Anderson","twitter_card":"summary_large_image","twitter_misc":{"Napisane przez":"Benjamin Anderson","Szacowany czas czytania":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/","url":"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/","name":"Jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 w Arkuszach Google","isPartOf":{"@id":"https:\/\/statorials.org\/pl\/#website"},"datePublished":"2023-07-27T19:45:54+00:00","dateModified":"2023-07-27T19:45:54+00:00","author":{"@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965"},"description":"Proste wyja\u015bnienie, jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 zbioru danych w Arkuszach Google, z przyk\u0142adem.","breadcrumb":{"@id":"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pl\/asymetria-kurtoza-arkusze-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Dom","item":"https:\/\/statorials.org\/pl\/"},{"@type":"ListItem","position":2,"name":"Jak obliczy\u0107 sko\u015bno\u015b\u0107 i kurtoz\u0119 w arkuszach google"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/pl\/#website","url":"https:\/\/statorials.org\/pl\/","name":"Statorials","description":"Tw\u00f3j przewodnik po kompetencjach statystycznych!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/pl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pl-PL"},{"@type":"Person","@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965","name":"Benjamin Anderson","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/pl\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg","caption":"Benjamin Anderson"},"description":"Cze\u015b\u0107, jestem Benjamin i jestem emerytowanym profesorem statystyki, kt\u00f3ry zosta\u0142 oddanym nauczycielem Statorials. Dzi\u0119ki bogatemu do\u015bwiadczeniu i wiedzy specjalistycznej w dziedzinie statystyki ch\u0119tnie dziel\u0119 si\u0119 swoj\u0105 wiedz\u0105, aby wzmocni\u0107 pozycj\u0119 uczni\u00f3w za po\u015brednictwem Statorials. Wiedzie\u0107 wi\u0119cej","sameAs":["https:\/\/statorials.org\/pl"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts\/1058","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/comments?post=1058"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts\/1058\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/media?parent=1058"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/categories?post=1058"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/tags?post=1058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}