{"id":2718,"date":"2023-07-21T01:08:00","date_gmt":"2023-07-21T01:08:00","guid":{"rendered":"https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/"},"modified":"2023-07-21T01:08:00","modified_gmt":"2023-07-21T01:08:00","slug":"persamaan-kuadrat-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/","title":{"rendered":"Cara menyelesaikan persamaan kuadrat di excel (langkah demi langkah)"},"content":{"rendered":"

<\/p>\n

\n

Persamaan kuadrat berbentuk berikut:<\/span><\/p>\n

kapak 2<\/sup> + bx + c = y<\/strong><\/span><\/p>\n

Seringkali Anda akan diberi nilai y<\/strong> dan diminta menyelesaikan nilai x<\/strong> .<\/span><\/p>\n

Misalnya, kita mempunyai persamaan kuadrat berikut:<\/span><\/p>\n

4\u00d72<\/sup> \u2013 20x + 16 = -8<\/strong><\/span><\/p>\n

Ternyata pengaturan x = 3<\/strong> atau x = 2<\/strong> akan menyelesaikan persamaan ini.<\/span><\/p>\n

Untuk menyelesaikan persamaan kuadrat di Excel, Anda dapat menggunakan fungsi Goal Seek<\/strong> .<\/span><\/p>\n

Contoh langkah demi langkah berikut menunjukkan cara menggunakan fungsi Pencarian Sasaran dalam praktiknya.<\/span><\/p>\n

Langkah 1: Masukkan persamaannya<\/strong><\/span><\/h3>\n

Pertama, masukkan nilai acak untuk x dan rumus persamaan kuadrat untuk y:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 2: Temukan Nilai X Pertama Menggunakan Pencarian Sasaran<\/strong><\/span><\/h3>\n

Selanjutnya, klik tab Data<\/strong> di sepanjang pita atas, lalu klik tombol Analisis Bagaimana-Jika<\/strong> , lalu Pencarian Sasaran<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Pada jendela baru yang muncul, tentukan bahwa Anda ingin mengatur sel B2<\/strong> sama dengan -8<\/strong> dengan memodifikasi nilai sel A2<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Setelah kita mengklik OK<\/strong> , fungsi Goal Seek akan secara otomatis mencari nilai x yang menyelesaikan persamaan:<\/span> <\/p>\n

\"\"<\/p>\n

Goal Seek menemukan bahwa nilai x = 2<\/strong> (dengan asumsi 1,9999 dibulatkan menjadi 2) menyelesaikan persamaan kuadrat.<\/span><\/p>\n

Langkah 3: Temukan Nilai X Kedua Menggunakan Goal Finder<\/strong><\/span><\/h3>\n

Untuk mencari nilai x kedua yang menyelesaikan persamaan kuadrat, atur nilai x awal ke angka lain.<\/span><\/p>\n

Misalnya, kita dapat memilih untuk menetapkan nilai x awal menjadi 4:<\/span> <\/p>\n

\"\"<\/p>\n

Kita kemudian dapat menjalankan fungsi Goal Seek<\/strong> lagi dan melihat bahwa fungsi tersebut menemukan solusi baru x=3<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Jadi, dua nilai x yang dapat menyelesaikan persamaan kuadrat tersebut adalah x=2<\/strong> dan x=3<\/strong> .<\/span><\/p>\n

Sumber daya tambahan<\/strong><\/span><\/h3>\n

Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/p>\n

Cara menyelesaikan sistem persamaan di excel<\/a>
Cara memplot persamaan di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Persamaan kuadrat berbentuk berikut: kapak 2 + bx + c = y Seringkali Anda akan diberi nilai y dan diminta menyelesaikan nilai x . Misalnya, kita mempunyai persamaan kuadrat berikut: 4\u00d72 \u2013 20x + 16 = -8 Ternyata pengaturan x = 3 atau x = 2 akan menyelesaikan persamaan ini. Untuk menyelesaikan persamaan kuadrat 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 Menyelesaikan Persamaan Kuadrat di Excel (Langkah demi Langkah) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menyelesaikan persamaan kuadrat di Excel, beserta contoh lengkapnya.\" \/>\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\/persamaan-kuadrat-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menyelesaikan Persamaan Kuadrat di Excel (Langkah demi Langkah) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menyelesaikan persamaan kuadrat di Excel, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T01:08:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quad1.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\/persamaan-kuadrat-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/\",\"name\":\"Cara Menyelesaikan Persamaan Kuadrat di Excel (Langkah demi Langkah) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T01:08:00+00:00\",\"dateModified\":\"2023-07-21T01:08:00+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menyelesaikan persamaan kuadrat di Excel, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menyelesaikan persamaan kuadrat di excel (langkah demi langkah)\"}]},{\"@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 Menyelesaikan Persamaan Kuadrat di Excel (Langkah demi Langkah) - Statologi","description":"Tutorial ini menjelaskan cara menyelesaikan persamaan kuadrat di Excel, beserta contoh lengkapnya.","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\/persamaan-kuadrat-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menyelesaikan Persamaan Kuadrat di Excel (Langkah demi Langkah) - Statologi","og_description":"Tutorial ini menjelaskan cara menyelesaikan persamaan kuadrat di Excel, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-21T01:08:00+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quad1.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\/persamaan-kuadrat-unggul\/","url":"https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/","name":"Cara Menyelesaikan Persamaan Kuadrat di Excel (Langkah demi Langkah) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T01:08:00+00:00","dateModified":"2023-07-21T01:08:00+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menyelesaikan persamaan kuadrat di Excel, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persamaan-kuadrat-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menyelesaikan persamaan kuadrat di excel (langkah demi langkah)"}]},{"@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\/2718"}],"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=2718"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2718\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2718"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2718"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}