{"id":1297,"date":"2023-07-26T23:32:57","date_gmt":"2023-07-26T23:32:57","guid":{"rendered":"https:\/\/statorials.org\/id\/jarak-euclidean-unggul\/"},"modified":"2023-07-26T23:32:57","modified_gmt":"2023-07-26T23:32:57","slug":"jarak-euclidean-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jarak-euclidean-unggul\/","title":{"rendered":"Cara menghitung jarak euclidean di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Jarak Euclidean<\/strong> antara dua vektor A dan B dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Jarak Euclidean = \u221a <span style=\"border-top: 1px solid black;\">\u03a3(A <sub>i<\/sub> -B <sub>i<\/sub> ) <sup>2<\/sup><\/span><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3<\/strong> adalah simbol Yunani yang berarti \u201cjumlah\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>A <sub>i<\/sub><\/strong> adalah nilai <sup>ke-i<\/sup> dari vektor A<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>B <sub>i<\/sub><\/strong> adalah nilai <sup>ke-i<\/sup> dari vektor B<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk menghitung jarak Euclidean antara dua vektor di Excel, kita dapat menggunakan fungsi berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>= <span style=\"color: #3366ff;\">SQRT<\/span> ( <span style=\"color: #3366ff;\">SUMXMY2<\/span> (RANGE1,RANGE2))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut ringkasan fungsi rumusnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>SUMXMY2<\/strong> mencari jumlah kuadrat selisih elemen-elemen yang bersesuaian pada rentang 1 dan rentang 2.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>SQRT<\/strong> mengambil akar kuadrat dari jumlah kuadrat selisihnya.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Hasil akhirnya adalah jarak Euclidean antara kedua rentang tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita memiliki dua vektor berikut, A dan B, di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12711 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/euclideexcel1.png\" alt=\"\" width=\"435\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan fungsi berikut untuk menghitung jarak Euclidean antara dua vektor:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12712 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/euclideexcel2.png\" alt=\"Jarak Euclidean di Excel\" width=\"576\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jarak Euclidean antara kedua vektor tersebut ternyata adalah <strong>12.40967<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi ini hanya akan mencakup observasi berpasangan lengkap saat menghitung jarak Euclidean.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, dua baris terakhir kolom A tidak akan dimasukkan dalam penghitungan jarak Euclidean antara dua vektor berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12713 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/euclideexcel3.png\" alt=\"Contoh jarak Euclidean di Excel\" width=\"546\" height=\"444\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jarak Euclidean antara kedua vektor tersebut ternyata adalah <strong>5.656854<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/jarak-euclidean-di-sungai\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jarak Euclidean di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/python-jarak-euclidean\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jarak Euclidean dengan Python<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Jarak Euclidean antara dua vektor A dan B dihitung sebagai berikut: Jarak Euclidean = \u221a \u03a3(A i -B i ) 2 Emas: \u03a3 adalah simbol Yunani yang berarti \u201cjumlah\u201d A i adalah nilai ke-i dari vektor A B i adalah nilai ke-i dari vektor B Untuk menghitung jarak Euclidean antara dua vektor di Excel, kita [&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 Jarak Euclidean di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jarak Euclidean di Excel, dengan beberapa 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\/jarak-euclidean-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Jarak Euclidean di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jarak Euclidean di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jarak-euclidean-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T23:32:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/euclideexcel1.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\/jarak-euclidean-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/jarak-euclidean-unggul\/\",\"name\":\"Cara Menghitung Jarak Euclidean di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T23:32:57+00:00\",\"dateModified\":\"2023-07-26T23:32:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jarak Euclidean di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jarak-euclidean-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jarak-euclidean-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jarak-euclidean-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung jarak euclidean 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 Jarak Euclidean di Excel - Statologi","description":"Tutorial ini menjelaskan cara menghitung jarak Euclidean di Excel, dengan beberapa 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\/jarak-euclidean-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Jarak Euclidean di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung jarak Euclidean di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/jarak-euclidean-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-26T23:32:57+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/euclideexcel1.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\/jarak-euclidean-unggul\/","url":"https:\/\/statorials.org\/id\/jarak-euclidean-unggul\/","name":"Cara Menghitung Jarak Euclidean di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T23:32:57+00:00","dateModified":"2023-07-26T23:32:57+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jarak Euclidean di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jarak-euclidean-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jarak-euclidean-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jarak-euclidean-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung jarak euclidean 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\/1297"}],"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=1297"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1297\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}