{"id":2618,"date":"2023-07-21T11:40:21","date_gmt":"2023-07-21T11:40:21","guid":{"rendered":"https:\/\/statorials.org\/pl\/cohens-kappa-excel\/"},"modified":"2023-07-21T11:40:21","modified_gmt":"2023-07-21T11:40:21","slug":"cohens-kappa-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/pl\/cohens-kappa-excel\/","title":{"rendered":"Jak obliczy\u0107 kappa cohena w excelu"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Kappa Cohena<\/strong> s\u0142u\u017cy do pomiaru poziomu zgodno\u015bci mi\u0119dzy dwoma oceniaj\u0105cymi lub s\u0119dziami, kt\u00f3rzy klasyfikuj\u0105 ka\u017cdy element na wzajemnie wykluczaj\u0105ce si\u0119 kategorie.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Wz\u00f3r kappa Cohena oblicza si\u0119 w nast\u0119puj\u0105cy spos\u00f3b:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>k = (p <sub>o<\/sub> \u2013 p <sub>mi<\/sub> ) \/ (1 \u2013 p <sub>mi<\/sub> )<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Z\u0142oto:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>p <sub>o<\/sub> :<\/strong> Wzgl\u0119dna zgodno\u015b\u0107 zaobserwowana w\u015br\u00f3d oceniaj\u0105cych<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>p <sub>e<\/sub> :<\/strong> Hipotetyczne prawdopodobie\u0144stwo przypadkowej zgodno\u015bci<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Zamiast po prostu oblicza\u0107 odsetek pozycji, co do kt\u00f3rych osoby oceniaj\u0105ce si\u0119 zgadzaj\u0105, Kappa Cohena pr\u00f3buje uwzgl\u0119dni\u0107 fakt, \u017ce osoby oceniaj\u0105ce mog\u0105 zgodzi\u0107 si\u0119 co do niekt\u00f3rych pozycji przez zwyk\u0142y przypadek.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Warto\u015b\u0107 Kappa Cohena zawsze mie\u015bci si\u0119 w przedziale od 0 do 1, gdzie 0 oznacza brak zgodno\u015bci mi\u0119dzy dwoma oceniaj\u0105cymi, a 1 oznacza doskona\u0142\u0105 zgodno\u015b\u0107 mi\u0119dzy dwoma oceniaj\u0105cymi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Poni\u017csza tabela podsumowuje, jak interpretowa\u0107 r\u00f3\u017cne warto\u015bci Kappa Cohena:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14573 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/kappa1.png\" alt=\"Kappa Cohena\" width=\"296\" height=\"226\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Poni\u017cszy przyk\u0142ad pokazuje, jak obliczy\u0107 Kappa Cohena w programie Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Przyk\u0142ad: Oblicz Kappa Cohena w Excelu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Za\u0142\u00f3\u017cmy, \u017ce dw\u00f3ch kurator\u00f3w w muzeum sztuki zostaje poproszonych o ocen\u0119 70 obraz\u00f3w, aby sprawdzi\u0107, czy s\u0105 wystarczaj\u0105co dobre, aby mo\u017cna je by\u0142o pokaza\u0107 na nowej wystawie.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Poni\u017csza tabela 2&#215;2 przedstawia wyniki ocen:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23117 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cohenexcel1.jpg\" alt=\"\" width=\"507\" height=\"349\" srcset=\"\" sizes=\"auto, \"><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Poni\u017cszy zrzut ekranu pokazuje, jak obliczy\u0107 zar\u00f3wno Kappa Cohena dla oceniaj\u0105cych, \u0142\u0105cznie z zastosowanymi wzorami:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-23118\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cohenexcel2.jpg\" alt=\"Kappa Cohena w Excelu\" width=\"489\" height=\"390\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Warto\u015b\u0107 p <sub>0<\/sub><\/strong> reprezentuje wzgl\u0119dn\u0105 zgodno\u015b\u0107 pomi\u0119dzy oceniaj\u0105cymi. Jest to proporcja ca\u0142kowitych wynik\u00f3w, w przypadku kt\u00f3rych obaj oceniaj\u0105cy odpowiedzieli \u201eTak\u201d lub \u201eNie\u201d.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Okazuje si\u0119, \u017ce wynosi <strong>0,6429<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Warto\u015b\u0107 <strong>p <sub>e<\/sub><\/strong> reprezentuje prawdopodobie\u0144stwo, \u017ce oceniaj\u0105cy byli w stanie osi\u0105gn\u0105\u0107 porozumienie przez czysty przypadek.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Okazuje si\u0119, \u017ce jest to <strong>0,5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Warto\u015b\u0107 <strong>k<\/strong> reprezentuje Kappa Cohena, kt\u00f3r\u0105 oblicza si\u0119 w nast\u0119puj\u0105cy spos\u00f3b:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">k = (p <sub>o<\/sub> \u2013 p <sub>mi<\/sub> ) \/ (1 \u2013 p <sub>mi<\/sub> )<\/span><\/li>\n<li> <span style=\"color: #000000;\">k = (0,6429 \u2013 0,5) \/ (1 \u2013 0,5)<\/span><\/li>\n<li> <span style=\"color: #000000;\">k = <strong>0,2857<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Okazuje si\u0119, \u017ce Kappa Cohena wynosi <strong>0,2857<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Na podstawie poprzedniej tabeli powiedzieliby\u015bmy, \u017ce poziom zgodno\u015bci obu oceniaj\u0105cych by\u0142 \u201edo\u015b\u0107\u201d zadowalaj\u0105cy.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Dodatkowe zasoby<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Poni\u017csze samouczki zapewniaj\u0105 dodatkowe zasoby na temat Kappa Cohena:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/pl\/statystyka-cohensa-kappa\/\" target=\"_blank\" rel=\"noopener\">Wprowadzenie do Kappy Cohena<\/a><br \/> Kalkulator Kappa Cohena<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kappa Cohena s\u0142u\u017cy do pomiaru poziomu zgodno\u015bci mi\u0119dzy dwoma oceniaj\u0105cymi lub s\u0119dziami, kt\u00f3rzy klasyfikuj\u0105 ka\u017cdy element na wzajemnie wykluczaj\u0105ce si\u0119 kategorie. Wz\u00f3r kappa Cohena oblicza si\u0119 w nast\u0119puj\u0105cy spos\u00f3b: k = (p o \u2013 p mi ) \/ (1 \u2013 p mi ) Z\u0142oto: p o : Wzgl\u0119dna zgodno\u015b\u0107 zaobserwowana w\u015br\u00f3d oceniaj\u0105cych p e : [&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-2618","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 Kappa Cohena w Excelu \u2013 Statologia<\/title>\n<meta name=\"description\" content=\"W tym samouczku wyja\u015bniono, jak obliczy\u0107 Kappa Cohena w programie Excel, podaj\u0105c pe\u0142ny przyk\u0142ad.\" \/>\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\/cohens-kappa-excel\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jak obliczy\u0107 Kappa Cohena w Excelu \u2013 Statologia\" \/>\n<meta property=\"og:description\" content=\"W tym samouczku wyja\u015bniono, jak obliczy\u0107 Kappa Cohena w programie Excel, podaj\u0105c pe\u0142ny przyk\u0142ad.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pl\/cohens-kappa-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T11:40:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/kappa1.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\/cohens-kappa-excel\/\",\"url\":\"https:\/\/statorials.org\/pl\/cohens-kappa-excel\/\",\"name\":\"Jak obliczy\u0107 Kappa Cohena w Excelu \u2013 Statologia\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pl\/#website\"},\"datePublished\":\"2023-07-21T11:40:21+00:00\",\"dateModified\":\"2023-07-21T11:40:21+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965\"},\"description\":\"W tym samouczku wyja\u015bniono, jak obliczy\u0107 Kappa Cohena w programie Excel, podaj\u0105c pe\u0142ny przyk\u0142ad.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pl\/cohens-kappa-excel\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pl\/cohens-kappa-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pl\/cohens-kappa-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Dom\",\"item\":\"https:\/\/statorials.org\/pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Jak obliczy\u0107 kappa cohena w excelu\"}]},{\"@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 Kappa Cohena w Excelu \u2013 Statologia","description":"W tym samouczku wyja\u015bniono, jak obliczy\u0107 Kappa Cohena w programie Excel, podaj\u0105c pe\u0142ny przyk\u0142ad.","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\/cohens-kappa-excel\/","og_locale":"pl_PL","og_type":"article","og_title":"Jak obliczy\u0107 Kappa Cohena w Excelu \u2013 Statologia","og_description":"W tym samouczku wyja\u015bniono, jak obliczy\u0107 Kappa Cohena w programie Excel, podaj\u0105c pe\u0142ny przyk\u0142ad.","og_url":"https:\/\/statorials.org\/pl\/cohens-kappa-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-21T11:40:21+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/kappa1.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\/cohens-kappa-excel\/","url":"https:\/\/statorials.org\/pl\/cohens-kappa-excel\/","name":"Jak obliczy\u0107 Kappa Cohena w Excelu \u2013 Statologia","isPartOf":{"@id":"https:\/\/statorials.org\/pl\/#website"},"datePublished":"2023-07-21T11:40:21+00:00","dateModified":"2023-07-21T11:40:21+00:00","author":{"@id":"https:\/\/statorials.org\/pl\/#\/schema\/person\/6484727a4612df3e69f016c3129c6965"},"description":"W tym samouczku wyja\u015bniono, jak obliczy\u0107 Kappa Cohena w programie Excel, podaj\u0105c pe\u0142ny przyk\u0142ad.","breadcrumb":{"@id":"https:\/\/statorials.org\/pl\/cohens-kappa-excel\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pl\/cohens-kappa-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pl\/cohens-kappa-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Dom","item":"https:\/\/statorials.org\/pl\/"},{"@type":"ListItem","position":2,"name":"Jak obliczy\u0107 kappa cohena w excelu"}]},{"@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\/2618","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=2618"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/posts\/2618\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/media?parent=2618"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/categories?post=2618"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pl\/wp-json\/wp\/v2\/tags?post=2618"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}