{"id":1541,"date":"2023-07-25T23:18:10","date_gmt":"2023-07-25T23:18:10","guid":{"rendered":"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/"},"modified":"2023-07-25T23:18:10","modified_gmt":"2023-07-25T23:18:10","slug":"memudarkan-altman-plot-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/","title":{"rendered":"Cara membuat plot bland-altman di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/jejak-altman-memudar\/\" target=\"_blank\" rel=\"noopener\">Plot Bland-Altman<\/a> digunakan untuk memvisualisasikan perbedaan pengukuran antara dua instrumen berbeda atau dua teknik pengukuran berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berguna untuk menentukan seberapa mirip dua instrumen atau teknik dalam mengukur konsep yang sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah membuat plot Bland-Altman di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan seorang ahli biologi menggunakan dua instrumen berbeda (A dan B) untuk mengukur berat 20 katak berbeda yang sama, dalam gram.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berat katak yang diukur dengan masing-masing alat ditunjukkan di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15288 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel1.png\" alt=\"\" width=\"429\" height=\"478\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung perbedaan pengukuran<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan rumus berikut untuk menghitung rata-rata pengukuran dan selisih pengukuran setiap katak:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-15289 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel2.png\" alt=\"\" width=\"479\" height=\"463\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami kemudian dapat menyalin dan menempelkan rumus ini ke setiap sel di kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15290 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel3.png\" alt=\"\" width=\"463\" height=\"489\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung perbedaan rata-rata dan interval kepercayaan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kemudian kita dapat menggunakan rumus berikut untuk menghitung selisih rata-rata kedua instrumen serta batas atas dan bawah interval kepercayaan 95% untuk selisih rata-rata tersebut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-15292 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel4.png\" alt=\"\" width=\"487\" height=\"525\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perbedaan rata-ratanya adalah <strong>0,5<\/strong> dan interval kepercayaan 95% untuk perbedaan rata-rata tersebut adalah <strong>[-1.921, 2.921]<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Buat Plot Bland-Altman<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk membuat plot Bland-Altman, sorot sel dalam rentang <strong>C2:D21<\/strong> sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15293 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel5.png\" alt=\"\" width=\"428\" height=\"528\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di pita atas, klik <strong>Sisipkan<\/strong> , lalu klik bagan pertama di grup <strong>Sisipkan Bagan Sebar (X,Y) atau Bagan Gelembung<\/strong> di grup <strong>Bagan<\/strong> . Secara otomatis akan muncul point cloud berikut ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15294 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel6.png\" alt=\"\" width=\"461\" height=\"341\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x menunjukkan rata-rata pengukuran instrumen dan sumbu y menunjukkan selisih pengukuran kedua instrumen.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menambahkan garis horizontal yang mewakili selisih rata-rata pengukuran, kita perlu membuat rangkaian data yang menunjukkan nilai minimum dan maksimum sepanjang sumbu x (0 dan 30) serta nilai yang menunjukkan perbedaan rata-rata:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15295 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel7.png\" alt=\"\" width=\"394\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan grafik dan klik <strong>Pilih Data<\/strong> . Di jendela yang muncul, klik <strong>Tambah<\/strong> di bawah bagian <strong>Entri Legenda (Seri)<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-15296 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel8.png\" alt=\"\" width=\"544\" height=\"362\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, berikan informasi berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15297 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel9.png\" alt=\"\" width=\"478\" height=\"380\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , dua titik oranye akan muncul pada grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15300 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel12.png\" alt=\"\" width=\"474\" height=\"351\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Klik kanan pada salah satu titik oranye dan klik <strong>Format Seri Data\u2026<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul di sebelah kanan layar, klik <strong>Garis padat<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15298 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel10.png\" alt=\"\" width=\"283\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan mengubah dua titik oranye menjadi garis oranye solid yang mewakili perbedaan rata-rata antara kedua instrumen:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-15299 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel11.png\" alt=\"\" width=\"464\" height=\"345\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ulangi proses ini untuk garis interval kepercayaan atas dan bawah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk memodifikasi gaya garis, nama sumbu, dan judul bagan untuk menghasilkan plot Bland-Altman yang estetis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-15280\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fade1.png\" alt=\"Plot Bland-Altman di Excel\" width=\"476\" height=\"470\" srcset=\"\" sizes=\"\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Plot Bland-Altman digunakan untuk memvisualisasikan perbedaan pengukuran antara dua instrumen berbeda atau dua teknik pengukuran berbeda. Berguna untuk menentukan seberapa mirip dua instrumen atau teknik dalam mengukur konsep yang sama. Tutorial ini memberikan contoh langkah demi langkah membuat plot Bland-Altman di Excel. Langkah 1: Buat datanya Misalkan seorang ahli biologi menggunakan dua instrumen berbeda (A [&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 Plot Bland-Altman di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat plot Bland-Altman di Excel, dengan 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\/memudarkan-altman-plot-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Plot Bland-Altman di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat plot Bland-Altman di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T23:18:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/\",\"name\":\"Cara Membuat Plot Bland-Altman di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T23:18:10+00:00\",\"dateModified\":\"2023-07-25T23:18:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat plot Bland-Altman di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot bland-altman 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 Plot Bland-Altman di Excel","description":"Tutorial ini menjelaskan cara membuat plot Bland-Altman di Excel, dengan 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\/memudarkan-altman-plot-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot Bland-Altman di Excel","og_description":"Tutorial ini menjelaskan cara membuat plot Bland-Altman di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T23:18:10+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fadeexcel1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/","url":"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/","name":"Cara Membuat Plot Bland-Altman di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T23:18:10+00:00","dateModified":"2023-07-25T23:18:10+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat plot Bland-Altman di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/memudarkan-altman-plot-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot bland-altman 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\/1541"}],"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=1541"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1541\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}