{"id":4720,"date":"2023-07-08T15:16:51","date_gmt":"2023-07-08T15:16:51","guid":{"rendered":"https:\/\/statorials.org\/id\/model-penilaian-tertimbang-excel\/"},"modified":"2023-07-08T15:16:51","modified_gmt":"2023-07-08T15:16:51","slug":"model-penilaian-tertimbang-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/model-penilaian-tertimbang-excel\/","title":{"rendered":"Cara membuat model penilaian tertimbang di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Model penilaian tertimbang<\/strong> adalah jenis model yang dapat Anda gunakan untuk memilih opsi terbaik di antara beberapa opsi berdasarkan faktor-faktor yang diberi bobot dengan nilai tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda ingin memilih tempat tinggal terbaik di antara tiga kemungkinan pilihan dan Anda memiliki beberapa faktor yang perlu dipertimbangkan untuk setiap lokasi, termasuk:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Keterjangkauan<\/span><\/li>\n<li> <span style=\"color: #000000;\">Laporan cuaca<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pilihan karir<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kejahatan<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kualitas makanan<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara membuat model penilaian berbobot di Excel untuk skenario spesifik ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara Membuat Model Penilaian Tertimbang di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, kita akan membuat kumpulan data berikut yang memberikan nilai dari 1 hingga 10 untuk masing-masing dari lima faktor yang kami pertimbangkan untuk setiap lokasi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36861 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/score1.png\" alt=\"\" width=\"555\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Nilai bobot harus berjumlah 1.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menghitung rata-rata tertimbang untuk setiap lokasi menggunakan bobot masing-masing faktor dan nilai individual untuk setiap lokasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus berikut di sel <strong>G3<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT( <span style=\"color: #3366ff;\">B3:F3<\/span> , <span style=\"color: #ff0000;\">$B$2:$F$2<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke sel yang tersisa di kolom G:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36862 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/score2.png\" alt=\"\" width=\"627\" height=\"274\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Lokasi 1 memiliki rata-rata tertimbang sebesar <strong>6,6<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Lokasi 2 memiliki rata-rata tertimbang sebesar <strong>6,2<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Lokasi 3 memiliki rata-rata tertimbang sebesar <strong>5,95<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Berdasarkan perhitungan ini, kami dapat mengatakan bahwa lokasi 1 adalah keseluruhan lokasi terbaik berdasarkan bobot spesifik yang kami gunakan untuk setiap faktor.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Bagaimana rumusnya bekerja<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Ingat rumus yang kami gunakan untuk menghitung rata-rata tertimbang untuk setiap lokasi:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=SUMPRODUCT( <span style=\"color: #3366ff;\">B3:F3<\/span> , <span style=\"color: #ff0000;\">$B$2:$F$2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini bekerja dengan mengalikan setiap bobot dengan setiap nilai individual untuk setiap lokasi, lalu menjumlahkan semua nilai tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, berikut cara menghitung rata-rata tertimbang untuk lokasi 1:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata tertimbang: (0,4*8) + (0,2*4) + (0,15*6) + (0,15*8) + (0,1*5) = <strong>6,6<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata tertimbang untuk setiap lokasi dihitung dengan cara yang sama.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/persentase-tertimbang-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Persentase Tertimbang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-bergerak-tertimbang-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menemukan Rata-Rata Pergerakan Tertimbang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Deviasi Standar Tertimbang di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Model penilaian tertimbang adalah jenis model yang dapat Anda gunakan untuk memilih opsi terbaik di antara beberapa opsi berdasarkan faktor-faktor yang diberi bobot dengan nilai tertentu. Misalnya, Anda ingin memilih tempat tinggal terbaik di antara tiga kemungkinan pilihan dan Anda memiliki beberapa faktor yang perlu dipertimbangkan untuk setiap lokasi, termasuk: Keterjangkauan Laporan cuaca Pilihan karir [&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 Model Penilaian Tertimbang di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat model penilaian berbobot di Excel, dengan contoh lengkap.\" \/>\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\/model-penilaian-tertimbang-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Model Penilaian Tertimbang di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat model penilaian berbobot di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/model-penilaian-tertimbang-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T15:16:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/score1.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\/model-penilaian-tertimbang-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/model-penilaian-tertimbang-excel\/\",\"name\":\"Cara Membuat Model Penilaian Tertimbang di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T15:16:51+00:00\",\"dateModified\":\"2023-07-08T15:16:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat model penilaian berbobot di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/model-penilaian-tertimbang-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/model-penilaian-tertimbang-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/model-penilaian-tertimbang-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat model penilaian tertimbang 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 Membuat Model Penilaian Tertimbang di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara membuat model penilaian berbobot di Excel, dengan contoh lengkap.","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\/model-penilaian-tertimbang-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Model Penilaian Tertimbang di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara membuat model penilaian berbobot di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/model-penilaian-tertimbang-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-08T15:16:51+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/score1.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\/model-penilaian-tertimbang-excel\/","url":"https:\/\/statorials.org\/id\/model-penilaian-tertimbang-excel\/","name":"Cara Membuat Model Penilaian Tertimbang di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T15:16:51+00:00","dateModified":"2023-07-08T15:16:51+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat model penilaian berbobot di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/model-penilaian-tertimbang-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/model-penilaian-tertimbang-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/model-penilaian-tertimbang-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat model penilaian tertimbang 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\/4720"}],"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=4720"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4720\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}