{"id":654,"date":"2023-07-29T05:04:11","date_gmt":"2023-07-29T05:04:11","guid":{"rendered":"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/"},"modified":"2023-07-29T05:04:11","modified_gmt":"2023-07-29T05:04:11","slug":"kisaran-menengah-yang-sangat-baik","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/","title":{"rendered":"Cara menghitung midrange di excel"},"content":{"rendered":"

<\/p>\n

\n

Rentang tengah<\/strong> kumpulan data dihitung sebagai:<\/span><\/p>\n

Midrange = (nilai terbesar + nilai terkecil) \/ 2<\/span><\/p>\n

Nilai ini hanyalah rata-rata dari nilai terbesar dan terkecil dalam kumpulan data dan memberi kita gambaran di mana pusat kumpulan data berada.<\/span><\/p>\n

Tutorial ini menjelaskan cara menghitung rentang tengah suatu kumpulan data di Excel.<\/span><\/p>\n

Contoh: Menghitung Midrange di Excel<\/strong><\/span><\/h3>\n

Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n

\"Nilai<\/p>\n

Untuk menghitung medium, kita dapat menggunakan rumus sederhana:<\/span><\/p>\n

=(MAX(rentang nilai) + MIN(rentang nilai)) \/ 2<\/strong><\/span><\/p>\n

Kolom D menunjukkan kisaran tengah kumpulan data kita dan kolom E menunjukkan rumus yang kita gunakan untuk menghitungnya:<\/span> <\/p>\n

\"Perhitungan<\/p>\n

Kisaran menengah untuk kumpulan data ini adalah 24,5<\/strong> .<\/span><\/p>\n

Kelemahan menggunakan kelas menengah<\/strong><\/span><\/h3>\n

Kerugian menggunakan media adalah kenyataan bahwa media tersebut mudah dipengaruhi oleh outlier. Jika nilai minimum suatu kumpulan data sangat kecil atau nilai maksimumnya sangat besar, hal ini dapat berdampak besar pada penghitungan rentang menengah.<\/span><\/p>\n

Misalnya, pertimbangkan jika nilai maksimum dalam kumpulan data kita adalah 120. Nilai tengahnya adalah 66:<\/span> <\/p>\n

\"Kelas<\/p>\n

Ingatlah bahwa rentang menengah seharusnya memberi kita gambaran tentang di mana pusat kumpulan data berada. Namun dalam skenario ini, karena nilai maksimumnya adalah outlier, rentang tengahnya adalah 66, yang sama sekali tidak dekat dengan pusat kumpulan data kami.<\/span><\/p>\n

Alternatif Kelas Menengah<\/strong><\/span><\/h3>\n

Dalam praktiknya, rentang menengah jarang digunakan sebagai cara untuk menghitung pusat kumpulan data hanya karena tersedia pengukuran yang lebih baik dan lebih kuat terhadap outlier. Secara khusus, dua pengukuran berikut cenderung merupakan pengukuran pusat<\/a> yang lebih akurat:<\/span><\/p>\n

Rata-rata:<\/strong> Nilai rata-rata dalam kumpulan data.<\/span><\/p>\n

Median:<\/strong> Nilai median dalam kumpulan data.<\/span><\/p>\n

Gambar berikut menunjukkan rumus yang dapat kita gunakan untuk menghitung mean dan median dari dataset:<\/span> <\/p>\n

\"Menghitung<\/p>\n

Perhatikan bahwa mean hanya sedikit dipengaruhi oleh outlier sedangkan median tidak terpengaruh sama sekali.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Rentang tengah kumpulan data dihitung sebagai: Midrange = (nilai terbesar + nilai terkecil) \/ 2 Nilai ini hanyalah rata-rata dari nilai terbesar dan terkecil dalam kumpulan data dan memberi kita gambaran di mana pusat kumpulan data berada. Tutorial ini menjelaskan cara menghitung rentang tengah suatu kumpulan data di Excel. Contoh: Menghitung Midrange di Excel Misalkan […]<\/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":"\nCara Menghitung Midrange di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung midrange di Excel, termasuk contoh langkah demi langkah.\" \/>\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\/kisaran-menengah-yang-sangat-baik\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Midrange di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung midrange di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T05:04:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu-de-gammeexcel1.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\/kisaran-menengah-yang-sangat-baik\/\",\"url\":\"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/\",\"name\":\"Cara Menghitung Midrange di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T05:04:11+00:00\",\"dateModified\":\"2023-07-29T05:04:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung midrange di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung midrange 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 Midrange di Excel \u2013 Statorials","description":"Penjelasan sederhana cara menghitung midrange di Excel, termasuk contoh langkah demi langkah.","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\/kisaran-menengah-yang-sangat-baik\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Midrange di Excel \u2013 Statorials","og_description":"Penjelasan sederhana cara menghitung midrange di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/","og_site_name":"Statorials","article_published_time":"2023-07-29T05:04:11+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu-de-gammeexcel1.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\/kisaran-menengah-yang-sangat-baik\/","url":"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/","name":"Cara Menghitung Midrange di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T05:04:11+00:00","dateModified":"2023-07-29T05:04:11+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung midrange di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung midrange 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\/654"}],"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=654"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/654\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}