{"id":909,"date":"2023-07-28T08:42:23","date_gmt":"2023-07-28T08:42:23","guid":{"rendered":"https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/"},"modified":"2023-07-28T08:42:23","modified_gmt":"2023-07-28T08:42:23","slug":"menggambar-persamaan-excelnya","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/","title":{"rendered":"Cara memplot persamaan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin memplot persamaan atau fungsi di Excel. Untungnya, hal ini mudah dilakukan berkat rumus bawaan Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan beberapa contoh cara memplot persamaan\/fungsi di Excel.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh 1:<\/span> <span style=\"color: #000000;\">Menggambar Persamaan Linier<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan Anda ingin memplot persamaan berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>kamu = 2x + 5<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Gambar berikut memperlihatkan cara membuat nilai y untuk persamaan linier ini di Excel, menggunakan rentang 1 hingga 10 untuk nilai x:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9690\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel1.png\" alt=\"Plot persamaan atau fungsi di Excel\" width=\"309\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot nilai dalam rentang <strong>A2:B11<\/strong> . Kemudian klik pada tab <strong>Sisipkan<\/strong> . Di grup <strong>Charts<\/strong> , klik opsi plot yang disebut <strong>Scatter<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9681 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel3.png\" alt=\"\" width=\"433\" height=\"323\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Plot berikut akan muncul secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9691 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel2.png\" alt=\"\" width=\"438\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa plotnya mengikuti garis lurus karena persamaan yang kita gunakan bersifat linier.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh 2:<\/span> <span style=\"color: #000000;\">Menggambar Persamaan Kuadrat<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan Anda ingin memplot persamaan berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>kamu = <sup>3&#215;2<\/sup><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Gambar berikut memperlihatkan cara membuat nilai y untuk persamaan ini di Excel, menggunakan rentang 1 hingga 10 untuk nilai x:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9694 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel3.png\" alt=\"\" width=\"315\" height=\"446\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot nilai dalam rentang <strong>A2:B11<\/strong> . Kemudian klik pada tab <strong>Sisipkan<\/strong> . Di grup <strong>Charts<\/strong> , klik opsi plot yang disebut <strong>Scatter<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9681 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel3.png\" alt=\"\" width=\"433\" height=\"323\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Plot berikut akan muncul secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9695 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel4.png\" alt=\"\" width=\"420\" height=\"382\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa plotnya mengikuti garis lengkung karena persamaan yang kita gunakan adalah persamaan kuadrat.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh 3:<\/span> <span style=\"color: #000000;\">Menggambar Persamaan Timbal Balik<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan Anda ingin memplot persamaan berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>kamu = 1\/x<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Gambar berikut memperlihatkan cara membuat nilai y untuk persamaan ini di Excel, menggunakan rentang 1 hingga 10 untuk nilai x:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9696 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel5.png\" alt=\"\" width=\"314\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot nilai dalam rentang <strong>A2:B11<\/strong> . Kemudian klik pada tab <strong>Sisipkan<\/strong> . Di grup <strong>Charts<\/strong> , klik opsi plot yang disebut <strong>Scatter<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9681 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel3.png\" alt=\"\" width=\"433\" height=\"323\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Plot berikut akan muncul secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9697 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel6.png\" alt=\"\" width=\"451\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa plotnya mengikuti garis lengkung ke bawah karena mewakili persamaan y = 1\/x.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Contoh 4:<\/span> <span style=\"color: #000000;\">Menggambar Persamaan Sinusoidal<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan Anda ingin memplot persamaan berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>kamu = dosa(x)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Gambar berikut memperlihatkan cara membuat nilai y untuk persamaan ini di Excel, menggunakan rentang 1 hingga 10 untuk nilai x:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-9698 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel7.png\" alt=\"\" width=\"346\" height=\"376\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot nilai dalam rentang <strong>A2:B11<\/strong> . Kemudian klik pada tab <strong>Sisipkan<\/strong> . Di grup <strong>Grafik<\/strong> , klik opsi plot yang disebut <strong>Sebar dengan Garis Halus dan Penanda<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Plot berikut akan muncul secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9699 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel8.png\" alt=\"Plot fungsi sinus di Excel\" width=\"469\" height=\"361\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <strong>Kesimpulan<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan teknik serupa untuk memplot fungsi atau persamaan apa pun di Excel. Cukup pilih rentang nilai x untuk digunakan dalam kolom, lalu gunakan persamaan di kolom terpisah untuk menentukan nilai y berdasarkan nilai x.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin memplot persamaan atau fungsi di Excel. Untungnya, hal ini mudah dilakukan berkat rumus bawaan Excel. Tutorial ini memberikan beberapa contoh cara memplot persamaan\/fungsi di Excel. Contoh 1: Menggambar Persamaan Linier Misalkan Anda ingin memplot persamaan berikut: kamu = 2x + 5 Gambar berikut memperlihatkan cara membuat nilai y untuk persamaan linier [&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 memplot persamaan di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara memplot persamaan atau fungsi 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\/menggambar-persamaan-excelnya\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara memplot persamaan di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara memplot persamaan atau fungsi di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T08:42:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel1.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\/menggambar-persamaan-excelnya\/\",\"url\":\"https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/\",\"name\":\"Cara memplot persamaan di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T08:42:23+00:00\",\"dateModified\":\"2023-07-28T08:42:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara memplot persamaan atau fungsi di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memplot persamaan 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 memplot persamaan di Excel - Statologi","description":"Penjelasan sederhana tentang cara memplot persamaan atau fungsi 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\/menggambar-persamaan-excelnya\/","og_locale":"id_ID","og_type":"article","og_title":"Cara memplot persamaan di Excel - Statologi","og_description":"Penjelasan sederhana tentang cara memplot persamaan atau fungsi di Excel.","og_url":"https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/","og_site_name":"Statorials","article_published_time":"2023-07-28T08:42:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plot_function_excel1.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\/menggambar-persamaan-excelnya\/","url":"https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/","name":"Cara memplot persamaan di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T08:42:23+00:00","dateModified":"2023-07-28T08:42:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara memplot persamaan atau fungsi di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/menggambar-persamaan-excelnya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memplot persamaan 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\/909"}],"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=909"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/909\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=909"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=909"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=909"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}