{"id":1900,"date":"2023-07-24T13:07:57","date_gmt":"2023-07-24T13:07:57","guid":{"rendered":"https:\/\/statorials.org\/id\/persilangan-produk-excel\/"},"modified":"2023-07-24T13:07:57","modified_gmt":"2023-07-24T13:07:57","slug":"persilangan-produk-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persilangan-produk-excel\/","title":{"rendered":"Cara menghitung perkalian silang di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dengan asumsi kita memiliki vektor A dengan elemen (A <sub>1<\/sub> , A <sub>2<\/sub> , A <sub>3<\/sub> ) dan vektor B dengan elemen (B <sub>1<\/sub> , B <sub>2<\/sub> , B <sub>3<\/sub> ), kita dapat menghitung perkalian silang kedua vektor tersebut sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perkalian silang = [(A <sub>2<\/sub> *B <sub>3<\/sub> ) \u2013 (A <sub>3<\/sub> *B <sub>2<\/sub> ), (A <sub>3<\/sub> *B <sub>1<\/sub> ) \u2013 (A <sub>1<\/sub> *B <sub>3<\/sub> ), (A <sub>1<\/sub> *B <sub>2<\/sub> ) \u2013 (A <sub>2<\/sub> *B <sub>1<\/sub> )]<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya kita mempunyai vektor-vektor berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Vektor A: (1, 2, 3)<\/span><\/li>\n<li> <span style=\"color: #000000;\">Vektor B: (4, 5, 6)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat menghitung perkalian silang vektor-vektor tersebut sebagai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Perkalian silang = [(A <sub>2<\/sub> *B <sub>3<\/sub> ) \u2013 (A <sub>3<\/sub> *B <sub>2<\/sub> ), (A <sub>3<\/sub> *B <sub>1<\/sub> ) \u2013 (A <sub>1<\/sub> *B <sub>3<\/sub> ), (A <sub>1<\/sub> *B <sub>2<\/sub> ) \u2013 (A <sub>2<\/sub> *B <sub>1<\/sub> )]<\/span><\/li>\n<li> <span style=\"color: #000000;\">Perkalian silang = [(2*6) \u2013 (3*5), (3*4) \u2013 (1*6), (1*5) \u2013 (2*4)]<\/span><\/li>\n<li> <span style=\"color: #000000;\">Hasil kali silang = (-3, 6, -3)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menghitung perkalian silang eksak ini di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Menghitung Cross Product di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk menghitung perkalian silang antara dua vektor di Excel, pertama-tama kita masukkan nilai masing-masing vektor:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18173 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/croixexcel1.png\" alt=\"\" width=\"506\" height=\"299\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menghitung nilai perkalian silang pertama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18174 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/croixexcel2.png\" alt=\"\" width=\"493\" height=\"326\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menghitung nilai kedua:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18175 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/croixexcel3.png\" alt=\"\" width=\"497\" height=\"323\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kami akan menghitung nilai ketiga:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18176 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/croixexcel4.png\" alt=\"\" width=\"491\" height=\"329\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hasil perkalian silangnya adalah (-3, 6, -3).<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18177 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/croixexcel5.png\" alt=\"Lintas Produk di Excel\" width=\"498\" height=\"323\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini sesuai dengan perkalian silang yang kami hitung secara manual sebelumnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/cara-mudah-menghitung-perkalian-titik-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Perkalian Titik di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/produk-titik-ti-84\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Perkalian Titik pada Kalkulator TI-84<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dengan asumsi kita memiliki vektor A dengan elemen (A 1 , A 2 , A 3 ) dan vektor B dengan elemen (B 1 , B 2 , B 3 ), kita dapat menghitung perkalian silang kedua vektor tersebut sebagai berikut: Perkalian silang = [(A 2 *B 3 ) \u2013 (A 3 *B 2 ), [&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 Menghitung Perkalian Silang di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung perkalian silang antara dua vektor di Excel, beserta sebuah contoh.\" \/>\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\/persilangan-produk-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Perkalian Silang di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung perkalian silang antara dua vektor di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persilangan-produk-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T13:07:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/croixexcel1.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\/persilangan-produk-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/persilangan-produk-excel\/\",\"name\":\"Cara Menghitung Perkalian Silang di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T13:07:57+00:00\",\"dateModified\":\"2023-07-24T13:07:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung perkalian silang antara dua vektor di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persilangan-produk-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persilangan-produk-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persilangan-produk-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung perkalian silang 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 Menghitung Perkalian Silang di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung perkalian silang antara dua vektor di Excel, beserta sebuah contoh.","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\/persilangan-produk-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Perkalian Silang di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung perkalian silang antara dua vektor di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/persilangan-produk-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-24T13:07:57+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/croixexcel1.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\/persilangan-produk-excel\/","url":"https:\/\/statorials.org\/id\/persilangan-produk-excel\/","name":"Cara Menghitung Perkalian Silang di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T13:07:57+00:00","dateModified":"2023-07-24T13:07:57+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung perkalian silang antara dua vektor di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persilangan-produk-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persilangan-produk-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persilangan-produk-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung perkalian silang 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\/1900"}],"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=1900"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1900\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}