{"id":2122,"date":"2023-07-23T14:45:54","date_gmt":"2023-07-23T14:45:54","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-silang-excel\/"},"modified":"2023-07-23T14:45:54","modified_gmt":"2023-07-23T14:45:54","slug":"tabel-silang-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-silang-excel\/","title":{"rendered":"Cara membuat crosstab di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Tab silang<\/strong> adalah tabel yang merangkum hubungan antara dua variabel kategori.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menjelaskan cara membuat tab silang 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 masukkan kumpulan data berikut ke dalam Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19707 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise_excel1.png\" alt=\"\" width=\"511\" height=\"460\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat tab silang<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik tombol <strong>PivotTable<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19708 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise_excel2.png\" alt=\"\" width=\"468\" height=\"467\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, pilih rentang yang berisi data sebagai <strong>tabel\/rentang<\/strong> dan pilih sel mana pun dari <strong>lembar kerja yang ada<\/strong> untuk menempatkan tab silang. Kami akan memilih sel <strong>E2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19710 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise_excel3-1.png\" alt=\"\" width=\"568\" height=\"451\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Isi tab silang dengan nilai<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik OK, jendela baru di sisi kanan layar akan muncul.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Seret variabel <strong>Tim<\/strong> ke area <strong>Baris<\/strong> , variabel <strong>Posisi<\/strong> ke area <strong>Kolom<\/strong> , lalu seret variabel <strong>Posisi<\/strong> kembali ke area <strong>Nilai<\/strong> seperti berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19711 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise_excel4.png\" alt=\"\" width=\"370\" height=\"668\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah selesai, tab silang berikut akan muncul di sel yang Anda tentukan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19712 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise_excel5.png\" alt=\"\" width=\"660\" height=\"349\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Tafsirkan tab silang<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan nilai tab silang:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Total baris:<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Total ada <strong>6<\/strong> pemain yang tergabung dalam tim A.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total ada <strong>6<\/strong> pemain yang tergabung dalam Tim B.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Total kolom:<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Total ada <strong>3<\/strong> pemain yang menempati posisi Center<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total ada <strong>4<\/strong> pemain yang menempati posisi Attacker.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Total ada <strong>5<\/strong> pemain yang memiliki posisi Guard<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Sel individu:<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>1<\/strong> pemain mempunyai posisi Center di Tim A<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>3<\/strong> pemain memiliki posisi Penyerang di Tim A<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>2<\/strong> pemain memiliki posisi Penjaga di Tim A<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>2<\/strong> pemain mempunyai posisi Center di tim B<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>1<\/strong> pemain mempunyai posisi Penyerang di tim B<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>3<\/strong> pemain memiliki posisi Penjaga di tim B<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menawarkan informasi tambahan tentang cara menghitung frekuensi di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Frekuensi Relatif di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Frekuensi Kumulatif di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Poligon Frekuensi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tab silang adalah tabel yang merangkum hubungan antara dua variabel kategori. Contoh langkah demi langkah berikut menjelaskan cara membuat tab silang di Excel. Langkah 1: Masukkan datanya Pertama, mari masukkan kumpulan data berikut ke dalam Excel: Langkah 2: Buat tab silang Selanjutnya, klik tab Sisipkan di sepanjang pita atas, lalu klik tombol PivotTable . Di [&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 Crosstab di Excel (Langkah demi Langkah) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tab silang 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\/tabel-silang-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Crosstab di Excel (Langkah demi Langkah) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tab silang di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-silang-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T14:45:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise_excel1.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\/tabel-silang-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-silang-excel\/\",\"name\":\"Cara Membuat Crosstab di Excel (Langkah demi Langkah) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T14:45:54+00:00\",\"dateModified\":\"2023-07-23T14:45:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tab silang di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-silang-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-silang-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-silang-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat crosstab di excel (langkah demi langkah)\"}]},{\"@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 Crosstab di Excel (Langkah demi Langkah) - Statologi","description":"Tutorial ini menjelaskan cara membuat tab silang 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\/tabel-silang-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Crosstab di Excel (Langkah demi Langkah) - Statologi","og_description":"Tutorial ini menjelaskan cara membuat tab silang di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/tabel-silang-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-23T14:45:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-croise_excel1.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\/tabel-silang-excel\/","url":"https:\/\/statorials.org\/id\/tabel-silang-excel\/","name":"Cara Membuat Crosstab di Excel (Langkah demi Langkah) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T14:45:54+00:00","dateModified":"2023-07-23T14:45:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tab silang di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-silang-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-silang-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-silang-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat crosstab di excel (langkah demi langkah)"}]},{"@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\/2122"}],"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=2122"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2122\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}