{"id":931,"date":"2023-07-28T06:53:10","date_gmt":"2023-07-28T06:53:10","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/"},"modified":"2023-07-28T06:53:10","modified_gmt":"2023-07-28T06:53:10","slug":"tabel-kontingensi-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/","title":{"rendered":"Cara membuat tabel kontingensi di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Tabel kontingensi<\/strong> (terkadang disebut &#8220;tab silang&#8221;) adalah jenis tabel yang merangkum hubungan antara dua variabel kategori.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, mudah untuk membuat tabel kontingensi untuk variabel di Excel menggunakan fitur PivotTable. Tutorial ini menunjukkan contoh cara melakukan ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: tabel kontingensi di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang menampilkan informasi tentang 20 pesanan produk berbeda, termasuk jenis produk yang dibeli (TV, komputer, atau radio) serta negara (A, B, atau C) tempat produk tersebut dibeli:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9860 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-de-contingenceexcel1.png\" alt=\"\" width=\"444\" height=\"503\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selesaikan langkah-langkah berikut untuk membuat tabel kontingensi untuk kumpulan data ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Pilih opsi PivotTable.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Klik tab <strong>Sisipkan<\/strong> , lalu klik <strong>PivotTable<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9861 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-de-contingenceexcel2.png\" alt=\"\" width=\"488\" height=\"419\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul, pilih <strong>A1:C21<\/strong> untuk rentang nilai. Kemudian pilih lokasi untuk meletakkan tabel pivot. Kami akan memilih sel <strong>E2<\/strong> dari spreadsheet yang ada:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9862 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-de-contingenceexcel3.png\" alt=\"\" width=\"595\" height=\"441\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , tabel kontingensi kosong akan muncul di sel E2.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9863 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-de-contingenceexcel4.png\" alt=\"\" width=\"513\" height=\"480\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Lengkapi tabel kontingensi<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela yang muncul di sebelah kanan, seret Negara ke dalam area berlabel <strong>Rows<\/strong> , seret Produk ke dalam area berlabel <strong>Columns<\/strong> , dan seret Nomor Pesanan ke dalam area berlabel <strong>Values<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9866 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-de-contingenceexcel5-1.png\" alt=\"\" width=\"369\" height=\"621\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><em><strong>Catatan:<\/strong> Jika nilai pertama kali muncul sebagai &#8220;Jumlah Nomor Pesanan&#8221;, cukup klik panah tarik-turun dan pilih <strong>Pengaturan Bidang Nilai<\/strong> . Kemudian pilih <strong>Hitung<\/strong> dan klik <strong>OK<\/strong> .<\/em><\/span><\/p>\n<p> <span style=\"color: #000000;\">Setelah ini selesai, nilai frekuensi akan otomatis terisi di tabel kontingensi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9867 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-de-contingenceexcel6-1.png\" alt=\"Tabel kontingensi di Excel\" width=\"483\" height=\"338\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Tafsirkan tabel kontingensi<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Cara mengartikan nilai tabel adalah sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Total baris:<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>4<\/strong> pesanan dilakukan dari negara A.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>8<\/strong> pesanan dilakukan dari negara B.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>8<\/strong> pesanan dilakukan dari negara C.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Total kolom:<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>6<\/strong> komputer dibeli.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>5<\/strong> radio dibeli.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>9<\/strong> televisi dibeli.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Sel individu:<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>1<\/strong> komputer dibeli di negara A.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>3<\/strong> komputer dibeli di negara B.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>2<\/strong> komputer dibeli di negara C.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>0<\/strong> radio dibeli di negara A.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>2<\/strong> radio dibeli di negara B.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>3<\/strong> radio dibeli di negara C.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>3<\/strong> televisi dibeli di negara A.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>3<\/strong> televisi dibeli di negara B.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Sebanyak <strong>3<\/strong> televisi dibeli di negara C.<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/tabel-kontingensi-di-r\/\" target=\"_blank\" rel=\"noopener\">Cara membuat tabel kontingensi di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-kontingensi-python\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Tabel Kontingensi dengan Python<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tabel kontingensi (terkadang disebut &#8220;tab silang&#8221;) adalah jenis tabel yang merangkum hubungan antara dua variabel kategori. Untungnya, mudah untuk membuat tabel kontingensi untuk variabel di Excel menggunakan fitur PivotTable. Tutorial ini menunjukkan contoh cara melakukan ini. Contoh: tabel kontingensi di Excel Misalkan kita memiliki kumpulan data berikut yang menampilkan informasi tentang 20 pesanan produk berbeda, [&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 Tabel Kontingensi di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat tabel kontingensi di Excel.\" \/>\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\/tabel-kontingensi-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Tabel Kontingensi di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat tabel kontingensi di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T06:53:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-de-contingenceexcel1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/\",\"name\":\"Cara Membuat Tabel Kontingensi di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T06:53:10+00:00\",\"dateModified\":\"2023-07-28T06:53:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat tabel kontingensi di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat tabel kontingensi 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 Tabel Kontingensi di Excel - Statologi","description":"Penjelasan sederhana cara membuat tabel kontingensi di Excel.","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\/tabel-kontingensi-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Tabel Kontingensi di Excel - Statologi","og_description":"Penjelasan sederhana cara membuat tabel kontingensi di Excel.","og_url":"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T06:53:10+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-de-contingenceexcel1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/","url":"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/","name":"Cara Membuat Tabel Kontingensi di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T06:53:10+00:00","dateModified":"2023-07-28T06:53:10+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat tabel kontingensi di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-kontingensi-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat tabel kontingensi 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\/931"}],"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=931"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/931\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}