{"id":2376,"date":"2023-07-22T13:18:16","date_gmt":"2023-07-22T13:18:16","guid":{"rendered":"https:\/\/statorials.org\/id\/dan-jika-analisis-google-sheet\/"},"modified":"2023-07-22T13:18:16","modified_gmt":"2023-07-22T13:18:16","slug":"dan-jika-analisis-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/dan-jika-analisis-google-sheet\/","title":{"rendered":"Cara melakukan analisis bagaimana-jika di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Analisis bagaimana-jika<\/strong> adalah jenis analisis yang memungkinkan Anda memasukkan angka-angka berbeda ke dalam rumus untuk melihat bagaimana hasilnya berubah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, sebuah toko menjual tiga produk berbeda dengan harga berbeda dan menghitung total pendapatan yang dihasilkan oleh produk tersebut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21469 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/et-si1.png\" alt=\"\" width=\"573\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan manajer toko ingin mengetahui berapa unit tambahan produk A yang harus dijual untuk mencapai total penjualan $2.000.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan analisis bagaimana-jika di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Dapatkan Addon Pencari Sasaran<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Sebelum melakukan analisis bagaimana-jika, pertama-tama kita perlu mendapatkan add-on Goal Seek.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, klik tab <strong>Add-on<\/strong> lalu klik <strong>Dapatkan Add-on<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21470 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/et-si2.png\" alt=\"\" width=\"607\" height=\"420\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Telusuri \u201cLens Finder\u201d, lalu klik hasil pertama yang bertuliskan <strong>Lens Finder for Leaves<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21471 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/et-si3.png\" alt=\"\" width=\"624\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik <strong>Instal<\/strong> . Anda akan dimintai izin untuk menginstal Goal Seek. Pilih untuk menerima.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Add-on Goal Seek kemudian akan ditambahkan ke tab <strong>Add-on<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Lakukan Analisis Bagaimana-Jika<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya klik tab <strong>Add-ons<\/strong> , lalu klik <strong>Lens Search<\/strong> , lalu klik <strong>Open<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21472 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/et-si4.png\" alt=\"\" width=\"499\" height=\"367\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di panel Pencarian Sasaran yang muncul, masukkan nilai sel berikut, lalu klik <strong>Selesaikan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21473 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/et-si5.png\" alt=\"\" width=\"326\" height=\"525\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Goal Seek akan mencoba nilai berbeda di D2 hingga bisa mencapai nilai 2000 di sel D5.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Inilah hasil yang dia temukan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21474 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/et-si6.png\" alt=\"\" width=\"553\" height=\"383\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hal ini menunjukkan bahwa toko tersebut perlu menjual sekitar 860 unit Produk A untuk meningkatkan total penjualan menjadi $2.000.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Panel Goal Seek juga memberi kami informasi tentang berapa lama waktu yang dibutuhkan Goal Seek untuk menemukan solusi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21475 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/et-si7.png\" alt=\"\" width=\"297\" height=\"318\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Butuh waktu 20,3 detik untuk menemukan solusi dan Goal Seek mencoba 48 iterasi hingga menemukan solusi akhir.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Pada panel Goal Seek, terdapat tombol \u201cOptions\u201d di mana Anda dapat menentukan jumlah detik atau iterasi maksimum yang akan digunakan hingga Goal Seek berhenti berjalan. Secara default, jumlah maksimum iterasi diatur ke 200 dan batas waktu maksimum diatur ke 120 detik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/statistik-deskriptif-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung statistik deskriptif di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lima-digit-melanjutkan-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung ringkasan lima digit di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Matriks Korelasi di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Analisis bagaimana-jika adalah jenis analisis yang memungkinkan Anda memasukkan angka-angka berbeda ke dalam rumus untuk melihat bagaimana hasilnya berubah. Misalnya, sebuah toko menjual tiga produk berbeda dengan harga berbeda dan menghitung total pendapatan yang dihasilkan oleh produk tersebut: Sekarang misalkan manajer toko ingin mengetahui berapa unit tambahan produk A yang harus dijual untuk mencapai total [&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 melakukan analisis bagaimana-jika di Google Spreadsheet - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan analisis bagaimana-jika di Google Spreadsheet, 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\/dan-jika-analisis-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara melakukan analisis bagaimana-jika di Google Spreadsheet - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan analisis bagaimana-jika di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/dan-jika-analisis-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T13:18:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/et-si1.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\/dan-jika-analisis-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/dan-jika-analisis-google-sheet\/\",\"name\":\"Cara melakukan analisis bagaimana-jika di Google Spreadsheet - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T13:18:16+00:00\",\"dateModified\":\"2023-07-22T13:18:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan analisis bagaimana-jika di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/dan-jika-analisis-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/dan-jika-analisis-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/dan-jika-analisis-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan analisis bagaimana-jika di google spreadsheet\"}]},{\"@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 melakukan analisis bagaimana-jika di Google Spreadsheet - Statorials","description":"Tutorial ini menjelaskan cara melakukan analisis bagaimana-jika di Google Spreadsheet, 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\/dan-jika-analisis-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara melakukan analisis bagaimana-jika di Google Spreadsheet - Statorials","og_description":"Tutorial ini menjelaskan cara melakukan analisis bagaimana-jika di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/dan-jika-analisis-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-22T13:18:16+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/et-si1.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\/dan-jika-analisis-google-sheet\/","url":"https:\/\/statorials.org\/id\/dan-jika-analisis-google-sheet\/","name":"Cara melakukan analisis bagaimana-jika di Google Spreadsheet - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T13:18:16+00:00","dateModified":"2023-07-22T13:18:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan analisis bagaimana-jika di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/dan-jika-analisis-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/dan-jika-analisis-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/dan-jika-analisis-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan analisis bagaimana-jika di google spreadsheet"}]},{"@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\/2376"}],"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=2376"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2376\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}