{"id":1653,"date":"2023-07-25T12:30:30","date_gmt":"2023-07-25T12:30:30","guid":{"rendered":"https:\/\/statorials.org\/tr\/yari-log-grafigi-excel\/"},"modified":"2023-07-25T12:30:30","modified_gmt":"2023-07-25T12:30:30","slug":"yari-log-grafigi-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/yari-log-grafigi-excel\/","title":{"rendered":"Excel&#39;de yar\u0131 g\u00fcnl\u00fck grafik nas\u0131l olu\u015fturulur"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Yar\u0131 logaritmik grafik,<\/strong> y ekseninde logaritmik \u00f6l\u00e7ek ve x ekseninde do\u011frusal \u00f6l\u00e7ek kullanan bir grafik t\u00fcr\u00fcd\u00fcr.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu t\u00fcr grafik genellikle y de\u011fi\u015fkeninin de\u011ferlerinin x de\u011fi\u015fkeninin de\u011ferlerinden \u00e7ok daha b\u00fcy\u00fck de\u011fi\u015fkenli\u011fe sahip oldu\u011fu durumlarda kullan\u0131l\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu genellikle di\u011fer alanlar\u0131n yan\u0131 s\u0131ra finans, ekonomi, biyoloji ve astronomi alan\u0131ndaki veri k\u00fcmelerinde meydana gelir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, belirli bir veri k\u00fcmesi i\u00e7in Excel&#8217;de yar\u0131 logaritmik bir grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>1. Ad\u0131m: Verileri girin<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Sahte bir veri k\u00fcmesinden de\u011ferleri girerek ba\u015flayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16292 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel1.png\" alt=\"\" width=\"494\" height=\"481\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>2. Ad\u0131m: Da\u011f\u0131l\u0131m grafi\u011fi olu\u015fturun<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Ard\u0131ndan veri de\u011ferlerini vurgulay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16293 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel2.png\" alt=\"\" width=\"470\" height=\"467\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u00dcst \u015feritte <strong>Ekle&#8217;yi<\/strong> t\u0131klay\u0131n. Ard\u0131ndan <strong>Da\u011f\u0131l\u0131m<\/strong> Grafi\u011fi se\u00e7ene\u011finin alt\u0131ndaki ilk se\u00e7ene\u011fe t\u0131klay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16294 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/disperserexcel.png\" alt=\"\" width=\"530\" height=\"218\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki nokta bulutu otomatik olarak g\u00f6r\u00fcnt\u00fclenecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16295 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel3.png\" alt=\"\" width=\"586\" height=\"433\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Grafikten y de\u011fi\u015fkeninin de\u011ferlerinin x de\u011fi\u015fkeninin de\u011ferlerine g\u00f6re \u00e7ok daha y\u00fcksek de\u011fi\u015fkenli\u011fe sahip oldu\u011funu g\u00f6rebiliyoruz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu, y de\u011ferlerini daha etkili bir \u015fekilde g\u00f6rselle\u015ftirmek i\u00e7in y eksenini logaritmik \u00f6l\u00e7e\u011fe d\u00f6n\u00fc\u015ft\u00fcrmenin iyi bir fikir oldu\u011fu anlam\u0131na gelir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ad\u0131m 3: Y Ekseni \u00d6l\u00e7e\u011fini De\u011fi\u015ftirin<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Daha sonra Y eksenine sa\u011f t\u0131klay\u0131n. G\u00f6r\u00fcnt\u00fclenen a\u00e7\u0131l\u0131r men\u00fcde <strong>Ekseni Bi\u00e7imlendir&#8217;i<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16296 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel4.png\" alt=\"\" width=\"563\" height=\"386\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Ekran\u0131n sa\u011f\u0131nda g\u00f6r\u00fcnen pencerede <strong>Logaritmik \u00f6l\u00e7ek&#8217;in<\/strong> yan\u0131ndaki kutuyu i\u015faretleyin:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16297 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel5.png\" alt=\"\" width=\"284\" height=\"566\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Y ekseni otomatik olarak logaritmik \u00f6l\u00e7e\u011fe d\u00f6n\u00fc\u015ft\u00fcr\u00fclecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16298 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel6.png\" alt=\"\" width=\"540\" height=\"421\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">X ekseni do\u011frusal \u00f6l\u00e7ekte kal\u0131r, ancak y ekseni logaritmik \u00f6l\u00e7e\u011fe d\u00f6n\u00fc\u015ft\u00fcr\u00fcl\u00fcr.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu grafikteki y de\u011ferlerini yorumlaman\u0131n \u00f6nceki grafi\u011fe g\u00f6re ne kadar kolay oldu\u011funa dikkat edin.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/tr\/gunluk-gunluk-grafigi-excel\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de G\u00fcnl\u00fck-G\u00fcnl\u00fck Grafi\u011fi Nas\u0131l Olu\u015fturulur<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/verileri-excele-donusturun\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de Veri D\u00f6n\u00fc\u015ft\u00fcrme (Log, Karek\u00f6k, K\u00fcp K\u00f6k)<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/kutu-cox-donusumu-excel\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de Box-Cox d\u00f6n\u00fc\u015f\u00fcm\u00fc nas\u0131l ger\u00e7ekle\u015ftirilir<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yar\u0131 logaritmik grafik, y ekseninde logaritmik \u00f6l\u00e7ek ve x ekseninde do\u011frusal \u00f6l\u00e7ek kullanan bir grafik t\u00fcr\u00fcd\u00fcr. Bu t\u00fcr grafik genellikle y de\u011fi\u015fkeninin de\u011ferlerinin x de\u011fi\u015fkeninin de\u011ferlerinden \u00e7ok daha b\u00fcy\u00fck de\u011fi\u015fkenli\u011fe sahip oldu\u011fu durumlarda kullan\u0131l\u0131r. Bu genellikle di\u011fer alanlar\u0131n yan\u0131 s\u0131ra finans, ekonomi, biyoloji ve astronomi alan\u0131ndaki veri k\u00fcmelerinde meydana gelir. A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, belirli [&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-1653","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 Yar\u0131 G\u00fcnl\u00fck Grafik Nas\u0131l Olu\u015fturulur<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#039;de yar\u0131 logaritmik bir grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\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\/yari-log-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 Yar\u0131 G\u00fcnl\u00fck Grafik Nas\u0131l Olu\u015fturulur\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#039;de yar\u0131 logaritmik bir grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/yari-log-grafigi-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T12:30:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel1.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\/yari-log-grafigi-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/yari-log-grafigi-excel\/\",\"name\":\"Excel&#39;de Yar\u0131 G\u00fcnl\u00fck Grafik Nas\u0131l Olu\u015fturulur\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-25T12:30:30+00:00\",\"dateModified\":\"2023-07-25T12:30:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#39;de yar\u0131 logaritmik bir grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/yari-log-grafigi-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/yari-log-grafigi-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/yari-log-grafigi-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de yar\u0131 g\u00fcnl\u00fck grafik 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 Yar\u0131 G\u00fcnl\u00fck Grafik Nas\u0131l Olu\u015fturulur","description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#39;de yar\u0131 logaritmik bir grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","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\/yari-log-grafigi-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Yar\u0131 G\u00fcnl\u00fck Grafik Nas\u0131l Olu\u015fturulur","og_description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#39;de yar\u0131 logaritmik bir grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/yari-log-grafigi-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T12:30:30+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel1.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\/yari-log-grafigi-excel\/","url":"https:\/\/statorials.org\/tr\/yari-log-grafigi-excel\/","name":"Excel&#39;de Yar\u0131 G\u00fcnl\u00fck Grafik Nas\u0131l Olu\u015fturulur","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-25T12:30:30+00:00","dateModified":"2023-07-25T12:30:30+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#39;de yar\u0131 logaritmik bir grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/yari-log-grafigi-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/yari-log-grafigi-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/yari-log-grafigi-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de yar\u0131 g\u00fcnl\u00fck grafik 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\/1653","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=1653"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/1653\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=1653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=1653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=1653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}