{"id":647,"date":"2023-07-29T05:35:33","date_gmt":"2023-07-29T05:35:33","guid":{"rendered":"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/"},"modified":"2023-07-29T05:35:33","modified_gmt":"2023-07-29T05:35:33","slug":"hulu-ledak-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/","title":{"rendered":"Cara membuat bagan ogive di excel"},"content":{"rendered":"

<\/p>\n

\n

Ogive<\/strong> adalah grafik yang menunjukkan berapa banyak nilai data yang berada di atas atau di bawah nilai tertentu dalam suatu kumpulan data. Tutorial ini menjelaskan cara membuat ogive di Excel.<\/span><\/p>\n

Contoh: Cara membuat ogive di Excel<\/strong><\/span><\/h3>\n

Selesaikan langkah-langkah berikut untuk membuat ogive untuk kumpulan data di Excel.<\/span><\/p>\n

Langkah 1: Masukkan datanya.<\/strong><\/span><\/p>\n

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

\"\"<\/p>\n

Langkah 2: Tetapkan batasan kelas.<\/strong><\/span><\/p>\n

Selanjutnya, tetapkan batasan kelas yang ingin Anda gunakan untuk hulu ledak. Saya akan memilih lebar kelas 10:<\/span> <\/p>\n

\"Menetapkan<\/p>\n

Langkah 3: Temukan frekuensi kelas.<\/strong><\/span><\/p>\n

Selanjutnya kita akan menggunakan rumus berikut untuk menghitung frekuensi kelas satu:<\/span> <\/p>\n

\"Hitung<\/p>\n

Salin rumus ini ke kelas lainnya:<\/span> <\/p>\n

\"Menghitung<\/p>\n

Langkah 4: Temukan frekuensi kumulatif.<\/strong><\/span><\/p>\n

Selanjutnya, kita akan menggunakan rumus berikut untuk menghitung frekuensi kumulatif setiap kursus:<\/span> <\/p>\n

\"Menghitung<\/p>\n

Langkah 5: Buat grafik poin.<\/strong><\/span><\/p>\n

Untuk membuat grafik hulu ledak, tahan CTRL dan sorot kolom D dan F.<\/span> <\/p>\n

\"\"<\/p>\n

Di pita atas Excel, buka tab Sisipkan<\/strong> , lalu grup Bagan<\/strong> . Klik Scatter Cloud<\/strong> , lalu Scatter Cloud dengan Garis Lurus dan Marker<\/strong> .<\/span> <\/p>\n

\"\"<\/p>\n

Ini secara otomatis akan menghasilkan grafik ogive berikut:<\/span> <\/p>\n

\"Bagan<\/p>\n

Jangan ragu untuk memodifikasi sumbu dan judulnya agar grafiknya lebih estetis:<\/span> <\/p>\n

\"Bagan<\/p>\n","protected":false},"excerpt":{"rendered":"

Ogive adalah grafik yang menunjukkan berapa banyak nilai data yang berada di atas atau di bawah nilai tertentu dalam suatu kumpulan data. Tutorial ini menjelaskan cara membuat ogive di Excel. Contoh: Cara membuat ogive di Excel Selesaikan langkah-langkah berikut untuk membuat ogive untuk kumpulan data di Excel. Langkah 1: Masukkan datanya. Masukkan nilai data dalam […]<\/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 Bagan Ogive di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat grafik ogive 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\/hulu-ledak-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Bagan Ogive di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat grafik ogive di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T05:35:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ogiveexcel1.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\/hulu-ledak-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/\",\"name\":\"Cara Membuat Bagan Ogive di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T05:35:33+00:00\",\"dateModified\":\"2023-07-29T05:35:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat grafik ogive di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bagan ogive 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 Bagan Ogive di Excel - Statorials","description":"Penjelasan sederhana cara membuat grafik ogive 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\/hulu-ledak-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bagan Ogive di Excel - Statorials","og_description":"Penjelasan sederhana cara membuat grafik ogive di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-29T05:35:33+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ogiveexcel1.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\/hulu-ledak-unggul\/","url":"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/","name":"Cara Membuat Bagan Ogive di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T05:35:33+00:00","dateModified":"2023-07-29T05:35:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat grafik ogive di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/hulu-ledak-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/hulu-ledak-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bagan ogive 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\/647"}],"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=647"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/647\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}