{"id":908,"date":"2023-07-28T08:45:02","date_gmt":"2023-07-28T08:45:02","guid":{"rendered":"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/"},"modified":"2023-07-28T08:45:02","modified_gmt":"2023-07-28T08:45:02","slug":"gunluk-gunluk-grafigi-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/","title":{"rendered":"Excel&#39;de g\u00fcnl\u00fck-g\u00fcnl\u00fck grafi\u011fi nas\u0131l olu\u015fturulur"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Log-log grafi\u011fi,<\/strong> x ekseni ve y ekseninde logaritmik \u00f6l\u00e7ekler kullanan bir da\u011f\u0131l\u0131m grafi\u011fidir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu t\u00fcr \u00e7izim, aralar\u0131ndaki ger\u00e7ek ili\u015fki bir g\u00fc\u00e7 yasas\u0131n\u0131 takip etti\u011finde iki de\u011fi\u015fkeni g\u00f6rselle\u015ftirmek i\u00e7in kullan\u0131\u015fl\u0131d\u0131r. Bu fenomen astronomi, biyoloji, kimya ve fizik dahil olmak \u00fczere ger\u00e7ek hayattaki bir\u00e7ok alanda meydana gelir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu e\u011fitim, Excel&#8217;de iki de\u011fi\u015fken i\u00e7in g\u00fcnl\u00fck-g\u00fcnl\u00fck grafi\u011finin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>\u00d6rnek: Excel&#8217;de G\u00fcnl\u00fck-G\u00fcnl\u00fck Grafi\u011fi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Excel&#8217;de x ve y olmak \u00fczere iki de\u011fi\u015fkenin de\u011ferlerini g\u00f6steren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9679 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel1.png\" alt=\"\" width=\"344\" height=\"418\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu veri k\u00fcmesi i\u00e7in bir g\u00fcnl\u00fck-g\u00fcnl\u00fck grafi\u011fi olu\u015fturmak \u00fczere a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullan\u0131n:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ad\u0131m 1: Bir da\u011f\u0131l\u0131m grafi\u011fi olu\u015fturun.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>A2:B11<\/strong> aral\u0131\u011f\u0131ndaki verileri vurgulay\u0131n.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9680 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel2.png\" alt=\"\" width=\"399\" height=\"379\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u00dcst \u015feritte <strong>Ekle<\/strong> sekmesine t\u0131klay\u0131n. <strong>Grafik<\/strong> grubunda <strong>Da\u011f\u0131l\u0131m&#8217;\u0131<\/strong> t\u0131klay\u0131n.<\/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=\"478\" height=\"356\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki nokta bulutu otomatik olarak g\u00f6r\u00fcnecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9682 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel4.png\" alt=\"\" width=\"446\" height=\"363\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ad\u0131m 2: X ekseninin \u00f6l\u00e7e\u011fini logaritmik olarak de\u011fi\u015ftirin.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">X ekseni boyunca de\u011ferlere sa\u011f t\u0131klay\u0131n ve <strong>Ekseni Bi\u00e7imlendir se\u00e7ene\u011fine<\/strong> t\u0131klay\u0131n.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9683 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel5.png\" alt=\"\" width=\"452\" height=\"423\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">G\u00f6r\u00fcnt\u00fclenen yeni pencerede, X ekseninin \u00f6l\u00e7e\u011fini de\u011fi\u015ftirmek i\u00e7in <strong>Logaritmik \u00f6l\u00e7ek&#8217;in<\/strong> yan\u0131ndaki kutuyu i\u015faretleyin.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9684 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel6.png\" alt=\"Excel'de \u00e7izim yapmak i\u00e7in logaritmik \u00f6l\u00e7ek\" width=\"280\" height=\"575\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ad\u0131m 3: Y ekseni \u00f6l\u00e7e\u011fini logaritmik olarak de\u011fi\u015ftirin.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra, y eksenine t\u0131klay\u0131n ve y ekseni \u00f6l\u00e7e\u011fini logaritmik olarak de\u011fi\u015ftirmek i\u00e7in ayn\u0131 ad\u0131m\u0131 tekrarlay\u0131n. Ortaya \u00e7\u0131kan arsa \u015f\u00f6yle g\u00f6r\u00fcnecek:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9685 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel7.png\" alt=\"Excel'de G\u00fcnl\u00fck-G\u00fcnl\u00fck Grafi\u011fi\" width=\"538\" height=\"439\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bunun, iki de\u011fi\u015fkenin ger\u00e7ekten de bir g\u00fc\u00e7 yasas\u0131 ili\u015fkisine sahip oldu\u011funu g\u00f6sterdi\u011fine dikkat edin.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><em><strong>Daha fazla Excel e\u011fitimini burada bulabilirsiniz.<\/strong><\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Log-log grafi\u011fi, x ekseni ve y ekseninde logaritmik \u00f6l\u00e7ekler kullanan bir da\u011f\u0131l\u0131m grafi\u011fidir. Bu t\u00fcr \u00e7izim, aralar\u0131ndaki ger\u00e7ek ili\u015fki bir g\u00fc\u00e7 yasas\u0131n\u0131 takip etti\u011finde iki de\u011fi\u015fkeni g\u00f6rselle\u015ftirmek i\u00e7in kullan\u0131\u015fl\u0131d\u0131r. Bu fenomen astronomi, biyoloji, kimya ve fizik dahil olmak \u00fczere ger\u00e7ek hayattaki bir\u00e7ok alanda meydana gelir. Bu e\u011fitim, Excel&#8217;de iki de\u011fi\u015fken i\u00e7in g\u00fcnl\u00fck-g\u00fcnl\u00fck grafi\u011finin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 [&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":[],"class_list":["post-908","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de G\u00fcnl\u00fck-G\u00fcnl\u00fck Grafi\u011fi Nas\u0131l Olu\u015fturulur - Statorials<\/title>\n<meta name=\"description\" content=\"Bir \u00f6rnekle, Excel&#039;de g\u00fcnl\u00fck-g\u00fcnl\u00fck grafi\u011finin nas\u0131l olu\u015fturulaca\u011f\u0131na ili\u015fkin basit bir a\u00e7\u0131klama.\" \/>\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\/tr\/gunluk-gunluk-grafigi-excel\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de G\u00fcnl\u00fck-G\u00fcnl\u00fck Grafi\u011fi Nas\u0131l Olu\u015fturulur - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bir \u00f6rnekle, Excel&#039;de g\u00fcnl\u00fck-g\u00fcnl\u00fck grafi\u011finin nas\u0131l olu\u015fturulaca\u011f\u0131na ili\u015fkin basit bir a\u00e7\u0131klama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T08:45:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel1.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/\",\"name\":\"Excel&#39;de G\u00fcnl\u00fck-G\u00fcnl\u00fck Grafi\u011fi Nas\u0131l Olu\u015fturulur - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-28T08:45:02+00:00\",\"dateModified\":\"2023-07-28T08:45:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bir \u00f6rnekle, Excel&#39;de g\u00fcnl\u00fck-g\u00fcnl\u00fck grafi\u011finin nas\u0131l olu\u015fturulaca\u011f\u0131na ili\u015fkin basit bir a\u00e7\u0131klama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de g\u00fcnl\u00fck-g\u00fcnl\u00fck grafi\u011fi nas\u0131l olu\u015fturulur\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de G\u00fcnl\u00fck-G\u00fcnl\u00fck Grafi\u011fi Nas\u0131l Olu\u015fturulur - Statorials","description":"Bir \u00f6rnekle, Excel&#39;de g\u00fcnl\u00fck-g\u00fcnl\u00fck grafi\u011finin nas\u0131l olu\u015fturulaca\u011f\u0131na ili\u015fkin basit bir a\u00e7\u0131klama.","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\/tr\/gunluk-gunluk-grafigi-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de G\u00fcnl\u00fck-G\u00fcnl\u00fck Grafi\u011fi Nas\u0131l Olu\u015fturulur - Statorials","og_description":"Bir \u00f6rnekle, Excel&#39;de g\u00fcnl\u00fck-g\u00fcnl\u00fck grafi\u011finin nas\u0131l olu\u015fturulaca\u011f\u0131na ili\u015fkin basit bir a\u00e7\u0131klama.","og_url":"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T08:45:02+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/","url":"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/","name":"Excel&#39;de G\u00fcnl\u00fck-G\u00fcnl\u00fck Grafi\u011fi Nas\u0131l Olu\u015fturulur - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-28T08:45:02+00:00","dateModified":"2023-07-28T08:45:02+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bir \u00f6rnekle, Excel&#39;de g\u00fcnl\u00fck-g\u00fcnl\u00fck grafi\u011finin nas\u0131l olu\u015fturulaca\u011f\u0131na ili\u015fkin basit bir a\u00e7\u0131klama.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de g\u00fcnl\u00fck-g\u00fcnl\u00fck grafi\u011fi nas\u0131l olu\u015fturulur"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/908","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=908"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/908\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}