{"id":1992,"date":"2023-07-24T04:23:50","date_gmt":"2023-07-24T04:23:50","guid":{"rendered":"https:\/\/statorials.org\/id\/persamaan-kosinus-unggul\/"},"modified":"2023-07-24T04:23:50","modified_gmt":"2023-07-24T04:23:50","slug":"persamaan-kosinus-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persamaan-kosinus-unggul\/","title":{"rendered":"Cara menghitung kesamaan cosinus di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Kemiripan kosinus<\/strong> adalah ukuran kemiripan antara dua vektor pada ruang hasil kali dalam.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk dua vektor, A dan B, persamaan cosinus dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Kemiripan kosinus<\/strong> = \u03a3A <sub>i<\/sub> B <sub>i<\/sub> \/ (\u221a\u03a3A <sub>i<\/sub> <sup>2<\/sup> \u221a\u03a3B <sub>i<\/sub> <sup>2<\/sup> )<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung kesamaan kosinus antar vektor di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Kesamaan kosinus antara dua vektor di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki dua vektor berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18756 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cosinus1.png\" alt=\"\" width=\"555\" height=\"450\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung cosine-similarity antara dua vektor di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT( <span style=\"color: #3366ff;\">A$2:A$9<\/span> , <span style=\"color: #ff0000;\">B2:B9<\/span> )\/(SQRT(SUMSQ( <span style=\"color: #ff0000;\">B2:B9<\/span> ))*SQRT(SUMSQ( <span style=\"color: #3366ff;\">$A$2:$A$9<\/span> )))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18757\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cosinus2.png\" alt=\"rumus kesamaan cosinus di excel\" width=\"677\" height=\"316\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemiripan kosinus kedua vektor tersebut ternyata adalah <strong>0,965195<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kami menafsirkan nilai kesamaan kosinus sebagai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai -1 menunjukkan ketidaksamaan maksimum<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai 0 menunjukkan bahwa kedua vektor tersebut ortogonal<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai 1 menunjukkan kesamaan maksimum<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Nilai sebesar <strong>0,965195<\/strong> menunjukkan tingkat kemiripan yang tinggi antara kedua vektor pada contoh kita.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara menghitung cosine kesamaan pada software statistik lainnya:<\/span><\/p>\n<ul>\n<li> <a href=\"https:\/\/statorials.org\/id\/kesamaan-kosinus-r\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung kesamaan kosinus di R<\/a><\/li>\n<li> <a href=\"https:\/\/statorials.org\/id\/kesamaan-kosinus-python\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung kesamaan kosinus dengan Python<\/a><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk penjelasan rinci tentang kesamaan kosinus, lihat artikel Wikipedia berikut:<\/span><\/p>\n<ul>\n<li> <a href=\"https:\/\/en.wikipedia.org\/wiki\/Cosine_similarity\" target=\"_blank\" rel=\"noopener\">Wikipedia: Penjelasan rinci tentang kesamaan kosinus<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Kemiripan kosinus adalah ukuran kemiripan antara dua vektor pada ruang hasil kali dalam. Untuk dua vektor, A dan B, persamaan cosinus dihitung sebagai berikut: Kemiripan kosinus = \u03a3A i B i \/ (\u221a\u03a3A i 2 \u221a\u03a3B i 2 ) Tutorial ini menjelaskan cara menghitung kesamaan kosinus antar vektor di Excel. Kesamaan kosinus antara dua vektor [&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 Kesamaan Cosinus di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung kesamaan kosinus 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\/persamaan-kosinus-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Kesamaan Cosinus di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung kesamaan kosinus di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persamaan-kosinus-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T04:23:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cosinus1.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\/persamaan-kosinus-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/persamaan-kosinus-unggul\/\",\"name\":\"Cara Menghitung Kesamaan Cosinus di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T04:23:50+00:00\",\"dateModified\":\"2023-07-24T04:23:50+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung kesamaan kosinus di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persamaan-kosinus-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persamaan-kosinus-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persamaan-kosinus-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung kesamaan cosinus 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 Kesamaan Cosinus di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung kesamaan kosinus 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\/persamaan-kosinus-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Kesamaan Cosinus di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung kesamaan kosinus di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/persamaan-kosinus-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-24T04:23:50+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cosinus1.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\/persamaan-kosinus-unggul\/","url":"https:\/\/statorials.org\/id\/persamaan-kosinus-unggul\/","name":"Cara Menghitung Kesamaan Cosinus di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T04:23:50+00:00","dateModified":"2023-07-24T04:23:50+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung kesamaan kosinus di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persamaan-kosinus-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persamaan-kosinus-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persamaan-kosinus-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung kesamaan cosinus 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\/1992"}],"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=1992"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1992\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}