{"id":1071,"date":"2023-07-27T18:49:04","date_gmt":"2023-07-27T18:49:04","guid":{"rendered":"https:\/\/statorials.org\/id\/lembar-google-produk-titik\/"},"modified":"2023-07-27T18:49:04","modified_gmt":"2023-07-27T18:49:04","slug":"lembar-google-produk-titik","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lembar-google-produk-titik\/","title":{"rendered":"Cara mudah menghitung dot product di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung perkalian titik di Google Sheets.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Apa produk titiknya?<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Diketahui vektor <em>a<\/em> = [a <sub>1<\/sub> , a <sub>2<\/sub> , a <sub>3<\/sub> ] dan vektor <em>b<\/em> = [b <sub>1<\/sub> , b <sub>2<\/sub> , b <sub>3<\/sub> ], <strong>hasil kali skalar<\/strong> vektor a dan vektor b, dilambangkan <strong>ab<\/strong> , diberikan oleh:<\/span><\/p>\n<p style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>ab<\/strong> = a <sub>1<\/sub> * b <sub>1<\/sub> + a <sub>2<\/sub> * b <sub>2<\/sub> + a <sub>3<\/sub> * b <sub>3<\/sub><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, jika <em>a<\/em> = [2, 5, 6] dan <em>b<\/em> = [4, 3, 2], maka hasil kali titik dari <em>a<\/em> dan <em>b<\/em> sama dengan:<\/span><\/p>\n<p style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>ab =<\/strong> 2*4 + 5*3 + 6*2<\/span><\/p>\n<p style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>ab =<\/strong> 8 + 15 + 12<\/span><\/p>\n<p style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>ab =<\/strong> 35<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada dasarnya, <strong>perkalian titik<\/strong> adalah jumlah perkalian entri-entri yang bersesuaian dalam dua vektor.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Cara menemukan perkalian titik di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk mencari perkalian titik dua vektor di Google Sheets, kita dapat mengikuti langkah-langkah berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. Masukkan datanya<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, masukkan nilai data vektor pertama pada satu kolom dan nilai data vektor kedua pada kolom kedua:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11002 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dotprodfeuilles1.png\" alt=\"\" width=\"385\" height=\"380\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>2. Hitung perkalian titiknya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung perkalian titik, kita dapat menggunakan fungsi <strong>SUMPRODUK()<\/strong> , yang menggunakan sintaks berikut:<\/span><\/p>\n<p style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>SUMPRODUK(tabel1, [tabel2], \u2026)<\/strong><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>array<\/strong> \u2013 array atau rentang pertama yang dikalikan lalu dijumlahkan.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>array2<\/strong> \u2013 array atau rentang kedua yang akan dikalikan lalu dijumlahkan.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan cara menggunakan fungsi ini untuk menghitung perkalian titik antara dua vektor:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11003 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dotprodfeuilles2.png\" alt=\"Produk titik di Google Spreadsheet\" width=\"653\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini menghasilkan nilai <strong>35<\/strong> , yang merupakan jawaban yang kita dapatkan secara manual.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi <strong>SUMRRODUCT()<\/strong> berfungsi untuk vektor dengan panjang berapa pun. Misalnya, kita dapat menggunakan fungsi ini untuk menghitung perkalian titik antara dua vektor dengan panjang 20:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11005 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dotprodfeuilles3.png\" alt=\"Rumus perkalian titik di Google Spreadsheet\" width=\"658\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Potensi kesalahan dalam menghitung perkalian titik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Fungsi <strong>SUMPRODUK()<\/strong> akan mengembalikan <strong>#VALUE!<\/strong> kesalahan jika vektor-vektornya tidak mempunyai panjang yang sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya vektor pertama panjangnya 20 dan vektor kedua panjangnya 20<i> <\/i>memiliki panjang 19, maka rumus <strong>=SUMPRODUK(A1:A20, B1:B19)<\/strong> akan menghasilkan error.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kedua vektor harus memiliki panjang yang sama agar perkalian titik dapat dihitung.<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">Terkait:<\/span><\/strong> <a href=\"https:\/\/statorials.org\/id\/cara-mudah-menghitung-perkalian-titik-di-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Menghitung Perkalian Titik di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial ini menjelaskan cara menghitung perkalian titik di Google Sheets. Apa produk titiknya? Diketahui vektor a = [a 1 , a 2 , a 3 ] dan vektor b = [b 1 , b 2 , b 3 ], hasil kali skalar vektor a dan vektor b, dilambangkan ab , diberikan oleh: ab = a [&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 Mudah Menghitung Dot Product di Google Sheets<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung perkalian titik di Google Sheets, 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\/lembar-google-produk-titik\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mudah Menghitung Dot Product di Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung perkalian titik di Google Sheets, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lembar-google-produk-titik\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T18:49:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dotprodfeuilles1.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\/lembar-google-produk-titik\/\",\"url\":\"https:\/\/statorials.org\/id\/lembar-google-produk-titik\/\",\"name\":\"Cara Mudah Menghitung Dot Product di Google Sheets\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T18:49:04+00:00\",\"dateModified\":\"2023-07-27T18:49:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung perkalian titik di Google Sheets, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lembar-google-produk-titik\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lembar-google-produk-titik\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lembar-google-produk-titik\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mudah menghitung dot product di google sheets\"}]},{\"@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 Mudah Menghitung Dot Product di Google Sheets","description":"Penjelasan sederhana cara menghitung perkalian titik di Google Sheets, 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\/lembar-google-produk-titik\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mudah Menghitung Dot Product di Google Sheets","og_description":"Penjelasan sederhana cara menghitung perkalian titik di Google Sheets, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/lembar-google-produk-titik\/","og_site_name":"Statorials","article_published_time":"2023-07-27T18:49:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dotprodfeuilles1.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\/lembar-google-produk-titik\/","url":"https:\/\/statorials.org\/id\/lembar-google-produk-titik\/","name":"Cara Mudah Menghitung Dot Product di Google Sheets","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T18:49:04+00:00","dateModified":"2023-07-27T18:49:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung perkalian titik di Google Sheets, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lembar-google-produk-titik\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lembar-google-produk-titik\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lembar-google-produk-titik\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mudah menghitung dot product di google sheets"}]},{"@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\/1071"}],"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=1071"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1071\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}