{"id":3132,"date":"2023-07-19T01:37:23","date_gmt":"2023-07-19T01:37:23","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-mengonversi-kategorikal-ke-angka\/"},"modified":"2023-07-19T01:37:23","modified_gmt":"2023-07-19T01:37:23","slug":"excel-mengonversi-kategorikal-ke-angka","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-mengonversi-kategorikal-ke-angka\/","title":{"rendered":"Cara mengubah data kategorikal menjadi data numerik di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin mengonversi data kategorikal menjadi data numerik di Excel untuk melakukan jenis analisis tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita meminta 20 orang untuk memberikan rating kategorikal untuk sebuah film, namun sebenarnya kita ingin kategori tersebut dikonversi ke nilai numerik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26674 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_cat1.jpg\" alt=\"\" width=\"464\" height=\"475\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan nilai data ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26674 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_cat1.jpg\" alt=\"\" width=\"464\" height=\"475\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Gunakan Fungsi IFS untuk Mengubah Nilai Kategorikal menjadi Nilai Numerik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu menggunakan fungsi <strong>=IFS()<\/strong> untuk mengubah empat nilai kategori Sangat Baik, Baik, OK, Buruk menjadi nilai numerik 4, 3, 2, 1.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh kita, kita akan mengetikkan rumus berikut di sel <strong>C2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=IFS( <span style=\"color: #3366ff;\">B2<\/span> =\"Great\", 4, <span style=\"color: #3366ff;\">B2<\/span> =\"Good\", 3, <span style=\"color: #3366ff;\">B2<\/span> =\"OK\", 2, <span style=\"color: #3366ff;\">B2<\/span> =\"Bad\", 1)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26675 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_cat2.jpg\" alt=\"\" width=\"612\" height=\"525\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa nilai kategorikal pertama <strong>Great<\/strong> telah diubah menjadi nilai numerik <strong>4<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Seret rumus ke semua sel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Terakhir, kita cukup menyeret rumus dari sel C2 ke setiap sel yang tersisa di kolom C:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26676 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_cat3.jpg\" alt=\"\" width=\"489\" height=\"497\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Semua peringkat <strong>Hebat<\/strong> telah dikonversi ke nilai numerik <strong>4<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Semua peringkat <b>Baik<\/b> telah dikonversi ke nilai numerik <strong>3<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Semua peringkat <b>OK<\/b> telah dikonversi ke nilai numerik <strong>2<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Semua peringkat <b>buruk<\/b> dikonversi ke nilai numerik <strong>1<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Sekarang kita dapat melakukan analisis numerik terhadap data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita mungkin memutuskan untuk menghitung nilai rata-rata di kolom <strong>Numeric_Rating<\/strong> untuk mendapatkan gambaran tentang berapa rata-rata individu menilai film tersebut.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/jumlah-excel-berdasarkan-kategori\/\" target=\"_blank\" rel=\"noopener\">Cara menambahkan nilai berdasarkan kategori di Excel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/dihitung-berdasarkan-grup-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung berdasarkan kelompok di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin mengonversi data kategorikal menjadi data numerik di Excel untuk melakukan jenis analisis tertentu. Misalnya, kita meminta 20 orang untuk memberikan rating kategorikal untuk sebuah film, namun sebenarnya kita ingin kategori tersebut dikonversi ke nilai numerik: Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Masukkan datanya Pertama, masukkan [&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 mengubah data kategorikal menjadi data numerik di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah data kategorikal menjadi data numerik di Excel, beserta contohnya.\" \/>\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\/excel-mengonversi-kategorikal-ke-angka\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengubah data kategorikal menjadi data numerik di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah data kategorikal menjadi data numerik di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-mengonversi-kategorikal-ke-angka\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T01:37:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_cat1.jpg\" \/>\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\/excel-mengonversi-kategorikal-ke-angka\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-mengonversi-kategorikal-ke-angka\/\",\"name\":\"Cara mengubah data kategorikal menjadi data numerik di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T01:37:23+00:00\",\"dateModified\":\"2023-07-19T01:37:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah data kategorikal menjadi data numerik di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-mengonversi-kategorikal-ke-angka\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-mengonversi-kategorikal-ke-angka\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-mengonversi-kategorikal-ke-angka\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengubah data kategorikal menjadi data numerik 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 mengubah data kategorikal menjadi data numerik di Excel - Statorials","description":"Tutorial ini menjelaskan cara mengubah data kategorikal menjadi data numerik di Excel, beserta contohnya.","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\/excel-mengonversi-kategorikal-ke-angka\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengubah data kategorikal menjadi data numerik di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara mengubah data kategorikal menjadi data numerik di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/excel-mengonversi-kategorikal-ke-angka\/","og_site_name":"Statorials","article_published_time":"2023-07-19T01:37:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_cat1.jpg"}],"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\/excel-mengonversi-kategorikal-ke-angka\/","url":"https:\/\/statorials.org\/id\/excel-mengonversi-kategorikal-ke-angka\/","name":"Cara mengubah data kategorikal menjadi data numerik di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T01:37:23+00:00","dateModified":"2023-07-19T01:37:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah data kategorikal menjadi data numerik di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-mengonversi-kategorikal-ke-angka\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-mengonversi-kategorikal-ke-angka\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-mengonversi-kategorikal-ke-angka\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengubah data kategorikal menjadi data numerik 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\/3132"}],"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=3132"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3132\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}