{"id":3545,"date":"2023-07-16T22:16:43","date_gmt":"2023-07-16T22:16:43","guid":{"rendered":"https:\/\/statorials.org\/id\/devsq-lembar-google\/"},"modified":"2023-07-16T22:16:43","modified_gmt":"2023-07-16T22:16:43","slug":"devsq-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/devsq-lembar-google\/","title":{"rendered":"Cara menggunakan devsq di google sheets (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>DEVSQ<\/strong> di Google Spreadsheet untuk menghitung jumlah deviasi kuadrat untuk sampel tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">DEVSQ<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\">value1, value2, value3, ...<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Berikut rumus yang sebenarnya digunakan <strong>oleh DEVSQ<\/strong> :<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jumlah kuadrat simpangan = \u03a3( <sub>xi<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">x<\/span> ) <sup>2<\/sup><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub><\/strong> : Nilai <sup>data<\/sup> ke-i<\/span><\/li>\n<li> <span style=\"color: #000000;\"><span style=\"border-top: 1px solid black;\">x<\/span> : Maksud sampel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menggunakan DEVSQ di Google Sheets<\/strong><\/span><\/h2>\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=\" wp-image-29376 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/devq1.jpg\" alt=\"\" width=\"479\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung jumlah deviasi kuadrat untuk kumpulan data ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">DEVSQ<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A2:A13<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-29377\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/devq2.jpg\" alt=\"Fungsi DEVSQ di Google Spreadsheet\" width=\"478\" height=\"456\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jumlah kuadrat simpangannya adalah <strong>319<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat mengonfirmasi kebenarannya dengan menghitung jumlah kuadrat deviasi untuk kumpulan data ini secara manual.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Nilai rata-rata untuk dataset ini adalah 9,5.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Mengetahui hal ini, kita cukup memasukkan nilai dari kumpulan data ke dalam rumus jumlah kuadrat deviasi:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jumlah kuadrat simpangan = \u03a3( <sub>xi<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">x<\/span> ) <sup>2<\/sup><\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah simpangan kuadrat = (2-9.5) <sup>2<\/sup> + (3-9.5) <sup>2<\/sup> + (5-9.5) <sup>2<\/sup> <sup>+<\/sup> (5-9.5) <sup>2<\/sup> + (7-9.5) 2 + (8-9.5) <sup>2<\/sup> + (9 -9.5) <sup>2<\/sup> + (12-9.5) <sup>2<\/sup> + (14-9.5) <sup>2<\/sup> + (15-9.5) <sup>2<\/sup> + (16-9.5) <sup>2<\/sup> + (18-9.5) <sup>2<\/sup><\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah simpangan kuadrat = 56,25 + 42,25 + 20,25 + 20,25 + 6,25 + 2,25 + 0,25 + 6,25 + 20,25 + 30,25 + 42,25 + 72,25<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah kuadrat simpangan = <strong>319<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Jumlah kuadrat simpangannya adalah <strong>319<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini cocok dengan nilai yang kami hitung menggunakan fungsi <strong>DEVSQ<\/strong> .<\/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 hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menghitung-beberapa-rentang\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan COUNTIF dengan banyak rentang di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sumif-lembar-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan SUMIF dengan banyak kolom di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlahkan-di-beberapa-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menambahkan beberapa lembar di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi DEVSQ di Google Spreadsheet untuk menghitung jumlah deviasi kuadrat untuk sampel tertentu. Fungsi ini menggunakan sintaks dasar berikut: = DEVSQ ( value1, value2, value3, &#8230; ) Berikut rumus yang sebenarnya digunakan oleh DEVSQ : Jumlah kuadrat simpangan = \u03a3( xi \u2013 x ) 2 Emas: x i : Nilai data ke-i [&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 menggunakan DEVSQ di Google Sheets (dengan contoh) \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi DEVSQ di Google Spreadsheet untuk menghitung jumlah deviasi kuadrat untuk sampel tertentu.\" \/>\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\/devsq-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan DEVSQ di Google Sheets (dengan contoh) \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi DEVSQ di Google Spreadsheet untuk menghitung jumlah deviasi kuadrat untuk sampel tertentu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/devsq-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T22:16:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/devq1.jpg\" \/>\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\/devsq-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/devsq-lembar-google\/\",\"name\":\"Cara menggunakan DEVSQ di Google Sheets (dengan contoh) \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T22:16:43+00:00\",\"dateModified\":\"2023-07-16T22:16:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi DEVSQ di Google Spreadsheet untuk menghitung jumlah deviasi kuadrat untuk sampel tertentu.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/devsq-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/devsq-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/devsq-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan devsq di google sheets (dengan contoh)\"}]},{\"@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 menggunakan DEVSQ di Google Sheets (dengan contoh) \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi DEVSQ di Google Spreadsheet untuk menghitung jumlah deviasi kuadrat untuk sampel tertentu.","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\/devsq-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan DEVSQ di Google Sheets (dengan contoh) \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi DEVSQ di Google Spreadsheet untuk menghitung jumlah deviasi kuadrat untuk sampel tertentu.","og_url":"https:\/\/statorials.org\/id\/devsq-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-16T22:16:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/devq1.jpg"}],"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\/devsq-lembar-google\/","url":"https:\/\/statorials.org\/id\/devsq-lembar-google\/","name":"Cara menggunakan DEVSQ di Google Sheets (dengan contoh) \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T22:16:43+00:00","dateModified":"2023-07-16T22:16:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi DEVSQ di Google Spreadsheet untuk menghitung jumlah deviasi kuadrat untuk sampel tertentu.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/devsq-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/devsq-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/devsq-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan devsq di google sheets (dengan contoh)"}]},{"@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\/3545"}],"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=3545"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3545\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}