{"id":652,"date":"2023-07-29T05:12:40","date_gmt":"2023-07-29T05:12:40","guid":{"rendered":"https:\/\/statorials.org\/id\/beberapa-plot-excel\/"},"modified":"2023-07-29T05:12:40","modified_gmt":"2023-07-29T05:12:40","slug":"beberapa-plot-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/beberapa-plot-excel\/","title":{"rendered":"Cara membuat plot qq di excel"},"content":{"rendered":"

<\/p>\n

\n

Plot QQ<\/strong> , kependekan dari “quantile-quantile”, sering digunakan untuk mengevaluasi apakah suatu kumpulan data berpotensi berasal dari distribusi teoretis atau tidak. Dalam kebanyakan kasus, jenis plot ini digunakan untuk menentukan apakah suatu kumpulan data mengikuti distribusi normal atau tidak.<\/span><\/p>\n

Tutorial ini menjelaskan cara membuat plot QQ untuk kumpulan data di Excel.<\/span><\/p>\n

Contoh: plot QQ di Excel<\/strong><\/span><\/h3>\n

Selesaikan langkah-langkah berikut untuk membuat plot QQ untuk kumpulan data.<\/span><\/p>\n

Langkah 1: Masukkan dan urutkan data.<\/strong><\/span><\/p>\n

Masukkan data berikut dalam kolom:<\/span> <\/p>\n

\"Data<\/p>\n

Perhatikan bahwa data ini sudah diurutkan dari yang terkecil hingga yang terbesar. Jika data Anda belum diurutkan, masuk ke tab Data<\/strong> di sepanjang pita atas di Excel, lalu masuk ke grup Urutkan & Filter<\/strong> , lalu klik ikon Urutkan A hingga Z.<\/strong><\/span><\/p>\n

Langkah 2: Temukan peringkat setiap nilai data.<\/strong><\/span><\/p>\n

Kemudian gunakan rumus berikut untuk menghitung peringkat nilai pertama:<\/span><\/p>\n

= PERINGKAT (A2, $A$2:$A$11, 1)<\/strong><\/span> <\/p>\n

\"Menghitung<\/p>\n

Salin rumus ini ke semua sel lain di kolom:<\/span> <\/p>\n

\"Bagan<\/p>\n

Langkah 3: Temukan persentil setiap nilai data.<\/strong><\/span><\/p>\n

Kemudian gunakan rumus berikut untuk menghitung persentil dari nilai pertama:<\/p>\n

=(B2-0,5)\/JUMLAH($B$2:$B$11)<\/strong><\/span> <\/p>\n

\"\"<\/p>\n

Salin rumus ini ke semua sel lain di kolom:<\/span> <\/p>\n

\"Perhitungan<\/p>\n

Langkah 4: Hitung skor-z untuk setiap nilai data.<\/strong><\/span><\/p>\n

Gunakan rumus berikut untuk menghitung skor-z untuk nilai data pertama:<\/span><\/p>\n

=NORM.S.INV(C2)<\/strong><\/span> <\/p>\n

\"Menghitung<\/p>\n

Salin rumus ini ke semua sel lain di kolom:<\/span> <\/p>\n

\"Skor<\/p>\n

Langkah 5: Buat plot QQ.<\/strong><\/span><\/p>\n

Copy data asli dari kolom A ke kolom E, lalu sorot data di kolom D dan E.<\/span> <\/p>\n

\"Contoh<\/p>\n

Di sepanjang pita atas, buka Sisipkan<\/strong> . Di grup Grafik<\/strong> , pilih Sisipkan Sebar (X, Y)<\/strong> dan klik opsi yang bertuliskan Sebar<\/strong> . Ini akan menghasilkan plot QQ berikut:<\/span> <\/p>\n

\"Bagan<\/p>\n

Klik tanda plus di sudut kanan atas grafik dan centang kotak di samping Garis Tren<\/strong> . Ini akan menambahkan baris berikut ke grafik:<\/span> <\/p>\n

\"Plot<\/p>\n

Jangan ragu untuk menambahkan label untuk judul dan sumbu bagan agar lebih estetis:<\/span> <\/p>\n

\"Bagan<\/p>\n

Cara menafsirkan plot QQ sederhana: jika nilai data mengikuti garis kira-kira lurus dengan sudut 45 derajat, maka data tersebut berdistribusi normal. Dapat kita lihat pada plot QQ di atas bahwa nilai data cenderung sedikit menyimpang dari garis 45 derajat, terutama pada bagian ujungnya, yang dapat menunjukkan bahwa kumpulan data tersebut tidak terdistribusi secara normal.<\/span><\/p>\n

Meskipun plot QQ bukan uji statistik formal, plot ini memberikan cara sederhana untuk memeriksa secara visual apakah kumpulan data terdistribusi normal atau tidak.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Plot QQ , kependekan dari “quantile-quantile”, sering digunakan untuk mengevaluasi apakah suatu kumpulan data berpotensi berasal dari distribusi teoretis atau tidak. Dalam kebanyakan kasus, jenis plot ini digunakan untuk menentukan apakah suatu kumpulan data mengikuti distribusi normal atau tidak. Tutorial ini menjelaskan cara membuat plot QQ untuk kumpulan data di Excel. Contoh: plot QQ di […]<\/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 Membuat Plot QQ di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat plot QQ di Excel.\" \/>\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\/beberapa-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 QQ di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat plot QQ di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/beberapa-plot-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T05:12:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/qqplotexcel1.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\/beberapa-plot-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/beberapa-plot-excel\/\",\"name\":\"Cara Membuat Plot QQ di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T05:12:40+00:00\",\"dateModified\":\"2023-07-29T05:12:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat plot QQ di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/beberapa-plot-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/beberapa-plot-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/beberapa-plot-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot qq 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 QQ di Excel \u2013 Statologi","description":"Penjelasan sederhana cara membuat plot QQ di Excel.","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\/beberapa-plot-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot QQ di Excel \u2013 Statologi","og_description":"Penjelasan sederhana cara membuat plot QQ di Excel.","og_url":"https:\/\/statorials.org\/id\/beberapa-plot-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T05:12:40+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/qqplotexcel1.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\/beberapa-plot-excel\/","url":"https:\/\/statorials.org\/id\/beberapa-plot-excel\/","name":"Cara Membuat Plot QQ di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T05:12:40+00:00","dateModified":"2023-07-29T05:12:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat plot QQ di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/beberapa-plot-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/beberapa-plot-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/beberapa-plot-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot qq 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\/652"}],"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=652"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/652\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}