{"id":1058,"date":"2023-07-27T19:58:34","date_gmt":"2023-07-27T19:58:34","guid":{"rendered":"https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/"},"modified":"2023-07-27T19:58:34","modified_gmt":"2023-07-27T19:58:34","slug":"spreadsheet-google-kelas-menengah","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/","title":{"rendered":"Cara menghitung kelas menengah di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Rentang tengah<\/strong> kumpulan data dihitung sebagai:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Midrange = (nilai terbesar + nilai terkecil) \/ 2<\/span><\/p>\n<p> <span style=\"color: #000000;\">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<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung rentang tengah kumpulan data di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Cara Menghitung Midrange di Google Sheets<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10905 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu-de-gammefeuilles1.png\" alt=\"\" width=\"404\" height=\"423\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung midrange dari kumpulan data ini, kita dapat menggunakan rumus berikut:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>=(MAX(rentang nilai) + MIN(rentang nilai)) \/ 2<\/strong><\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Berikut tampilan kumpulan data kami:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10907 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu-de-gammefeuilles2.png\" alt=\"Kelas menengah di Google Spreadsheet\" width=\"555\" height=\"393\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kisaran menengah untuk kumpulan data ini adalah <strong>24,5<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Kerugian menggunakan media<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kerugian menggunakan media ini adalah 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<p> <span style=\"color: #000000;\">Misalnya, pertimbangkan jika nilai maksimum dalam kumpulan data kita adalah 120. Nilai tengahnya adalah 66:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10908 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu-de-gammefeuilles3.png\" alt=\"Kelas menengah di Google Spreadsheet\" width=\"563\" height=\"401\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Cara yang lebih baik untuk menemukan di mana \u201cpusat\u201d kumpulan data ini adalah dengan menggunakan <a href=\"https:\/\/statorials.org\/id\/mengukur-tendensi-sentral\/\" target=\"_blank\" rel=\"noopener noreferrer\">mean<\/a> atau <a href=\"https:\/\/statorials.org\/id\/mengukur-tendensi-sentral\/\" target=\"_blank\" rel=\"noopener noreferrer\">median<\/a> kumpulan data tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus berikut menunjukkan cara menghitung kedua metrik ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10909 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu-de-gammefeuilles4.png\" alt=\"Kelas menengah vs. Rata-rata dan Median di Google Spreadsheet\" width=\"572\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> Perhatikan bahwa rata-rata dan median lebih kecil kemungkinannya untuk dipengaruhi oleh outlier dibandingkan dengan nilai tengah dan keduanya memberi kita gambaran yang lebih akurat tentang di mana sebenarnya pusat kumpulan data berada.<\/p>\n<p> <strong><span style=\"color: #000000;\">Terkait:<\/span><\/strong> <a href=\"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Menghitung Midrange di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 kumpulan data di Google Spreadsheet. Contoh: Cara Menghitung Midrange di Google [&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 Kelas Menengah di Google Spreadsheet<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara menghitung nilai median untuk kumpulan data tertentu di Google Spreadsheet, 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\/spreadsheet-google-kelas-menengah\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Kelas Menengah di Google Spreadsheet\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara menghitung nilai median untuk kumpulan data tertentu di Google Spreadsheet, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T19:58:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu-de-gammefeuilles1.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\/spreadsheet-google-kelas-menengah\/\",\"url\":\"https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/\",\"name\":\"Cara Menghitung Kelas Menengah di Google Spreadsheet\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T19:58:34+00:00\",\"dateModified\":\"2023-07-27T19:58:34+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara menghitung nilai median untuk kumpulan data tertentu di Google Spreadsheet, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung kelas menengah di google spreadsheet\"}]},{\"@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 Kelas Menengah di Google Spreadsheet","description":"Penjelasan sederhana tentang cara menghitung nilai median untuk kumpulan data tertentu di Google Spreadsheet, 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\/spreadsheet-google-kelas-menengah\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Kelas Menengah di Google Spreadsheet","og_description":"Penjelasan sederhana tentang cara menghitung nilai median untuk kumpulan data tertentu di Google Spreadsheet, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/","og_site_name":"Statorials","article_published_time":"2023-07-27T19:58:34+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/milieu-de-gammefeuilles1.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\/spreadsheet-google-kelas-menengah\/","url":"https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/","name":"Cara Menghitung Kelas Menengah di Google Spreadsheet","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T19:58:34+00:00","dateModified":"2023-07-27T19:58:34+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara menghitung nilai median untuk kumpulan data tertentu di Google Spreadsheet, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/spreadsheet-google-kelas-menengah\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung kelas menengah di google spreadsheet"}]},{"@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\/1058"}],"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=1058"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1058\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1058"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1058"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}