{"id":2144,"date":"2023-07-23T12:31:50","date_gmt":"2023-07-23T12:31:50","guid":{"rendered":"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/"},"modified":"2023-07-23T12:31:50","modified_gmt":"2023-07-23T12:31:50","slug":"kebingungan-matriks-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/","title":{"rendered":"Cara membuat matriks kebingungan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/regresi-logistik-1\/\" target=\"_blank\" rel=\"noopener\">Regresi logistik<\/a> adalah jenis regresi yang dapat kita gunakan jika variabel responnya adalah biner.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Cara umum untuk menilai kualitas model regresi logistik adalah dengan membuat <strong>matriks konfusi<\/strong> , yaitu tabel berukuran 2 \u00d7 2 yang menunjukkan nilai prediksi model versus nilai sebenarnya dari kumpulan data pengujian.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15654 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confusionr1.png\" alt=\"\" width=\"292\" height=\"129\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara membuat matriks konfusi di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari kita masukkan kolom nilai aktual suatu variabel respon beserta nilai yang diprediksi oleh model regresi logistik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19855 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confexcel1.png\" alt=\"\" width=\"467\" height=\"455\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Matriks Kebingungan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menggunakan rumus <strong>COUNTIFS()<\/strong> untuk menghitung banyaknya nilai yaitu \u201c0\u201d pada kolom Actual dan juga \u201c0\u201d pada kolom Predicted:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19856 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confexcel2.png\" alt=\"\" width=\"583\" height=\"489\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami akan menggunakan rumus serupa untuk mengisi semua sel lain dalam matriks konfusi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-19857\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confexcel3.png\" alt=\"matriks kebingungan di Excel\" width=\"571\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung Akurasi, Presisi, dan Perolehan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Setelah kita membuat matriks konfusi, kita dapat menghitung metrik berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Akurasi<\/strong> : Persentase prediksi yang benar<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Akurasi<\/strong> : Benar prediksi positif relatif terhadap total prediksi positif<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Pengingat<\/strong> : Mengoreksi prediksi positif terhadap total positif aktual<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Rumus berikut memperlihatkan cara menghitung setiap pengukuran ini di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19858 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confexcel4.png\" alt=\"\" width=\"542\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Semakin tinggi presisinya, semakin mampu suatu model mengklasifikasikan observasi dengan benar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, model kita memiliki akurasi <strong>0,7<\/strong> yang menunjukkan bahwa model tersebut mengklasifikasikan 70% observasi dengan benar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika diinginkan, kita dapat membandingkan akurasi ini dengan model regresi logistik lainnya untuk menentukan model mana yang paling baik dalam mengklasifikasikan observasi ke dalam kategori 0 atau 1.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/regresi-logistik-1\/\" target=\"_blank\" rel=\"noopener\">Pengantar Regresi Logistik<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jenis-regresi-logistik\/\" target=\"_blank\" rel=\"noopener\">3 jenis regresi logistik<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/regresi-logistik-vs-regresi-linier\/\" target=\"_blank\" rel=\"noopener\">Regresi logistik vs regresi linier<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Regresi logistik adalah jenis regresi yang dapat kita gunakan jika variabel responnya adalah biner. Cara umum untuk menilai kualitas model regresi logistik adalah dengan membuat matriks konfusi , yaitu tabel berukuran 2 \u00d7 2 yang menunjukkan nilai prediksi model versus nilai sebenarnya dari kumpulan data pengujian. Contoh langkah demi langkah berikut menunjukkan cara membuat matriks [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Membuat Matriks Kebingungan di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat matriks konfusi di Excel, dengan contoh langkah demi langkah.\" \/>\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\/id\/kebingungan-matriks-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Matriks Kebingungan di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat matriks konfusi di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T12:31:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confusionr1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/\",\"name\":\"Cara Membuat Matriks Kebingungan di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T12:31:50+00:00\",\"dateModified\":\"2023-07-23T12:31:50+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat matriks konfusi di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat matriks kebingungan di excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Membuat Matriks Kebingungan di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara membuat matriks konfusi di Excel, dengan contoh langkah demi langkah.","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\/id\/kebingungan-matriks-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Matriks Kebingungan di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara membuat matriks konfusi di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-23T12:31:50+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/confusionr1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/","url":"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/","name":"Cara Membuat Matriks Kebingungan di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T12:31:50+00:00","dateModified":"2023-07-23T12:31:50+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat matriks konfusi di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kebingungan-matriks-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat matriks kebingungan di excel"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2144"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2144"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2144\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}