{"id":532,"date":"2023-07-29T14:40:43","date_gmt":"2023-07-29T14:40:43","guid":{"rendered":"https:\/\/statorials.org\/tr\/excelde-artik-iz-nasil-olusturulur\/"},"modified":"2023-07-29T14:40:43","modified_gmt":"2023-07-29T14:40:43","slug":"excelde-artik-iz-nasil-olusturulur","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excelde-artik-iz-nasil-olusturulur\/","title":{"rendered":"Excel&#39;de art\u0131k grafik nas\u0131l olu\u015fturulur"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Art\u0131k grafi\u011fi,<\/strong> bir regresyon modeli i\u00e7in art\u0131klara kar\u015f\u0131 uygun de\u011ferleri g\u00f6steren bir grafik t\u00fcr\u00fcd\u00fcr.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu t\u00fcr \u00e7izim genellikle do\u011frusal bir regresyon modelinin belirli bir veri seti i\u00e7in uygun olup olmad\u0131\u011f\u0131n\u0131 de\u011ferlendirmek ve heteroskedastisite i\u00e7in art\u0131klar\u0131 kontrol etmek i\u00e7in kullan\u0131l\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu e\u011fitimde, Excel&#8217;de basit bir do\u011frusal regresyon modeli i\u00e7in art\u0131k grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Excel&#8217;de Art\u0131k Grafik Nas\u0131l Olu\u015fturulur<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Excel&#8217;de art\u0131k \u00e7izim olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullan\u0131n:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ad\u0131m 1: \u0130lk iki s\u00fctuna veri de\u011ferlerini girin.<\/strong> \u00d6rne\u011fin, tahmin de\u011fi\u015fkeni de\u011ferlerini A2:A13&#8217;e ve yan\u0131t de\u011fi\u015fkeni de\u011ferlerini B2:B13&#8217;e girin.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ad\u0131m 2: Bir da\u011f\u0131l\u0131m grafi\u011fi olu\u015fturun.<\/strong> A2:B13 h\u00fccrelerindeki de\u011ferleri vurgulay\u0131n. Ard\u0131ndan, \u00fcst \u015feritteki <em>INSERT<\/em> sekmesine gidin. <em>Grafikler<\/em> alan\u0131nda <em>Da\u011f\u0131l\u0131m<\/em> i\u00e7in ilk se\u00e7ene\u011fe t\u0131klay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki tablo g\u00f6r\u00fcnecektir:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><b>Ad\u0131m 3:<\/b> <span style=\"color: #000000;\"><b>Trend \u00e7izgisi<\/b><\/span> denklemini <b>da\u011f\u0131l\u0131m grafi\u011finde g\u00f6r\u00fcnt\u00fcleyin.<\/b> <em>TASARIM<\/em> sekmesinde &#8220;Grafik \u00d6\u011feleri Ekle&#8221;yi t\u0131klay\u0131n, ard\u0131ndan &#8220;Trend \u00c7izgisi&#8221;ni ve ard\u0131ndan &#8220;Di\u011fer Trend \u00c7izgisi Se\u00e7enekleri&#8221;ni t\u0131klay\u0131n. \u201cDo\u011frusal\u201d\u0131 se\u00e7ili b\u0131rak\u0131n ve \u201cDenklemleri grafikte g\u00f6ster\u201d se\u00e7ene\u011fini i\u015faretleyin. \u201cTrend \u00c7izgisini Bi\u00e7imlendir\u201d panelini kapat\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Trend \u00e7izgisi denklemi art\u0131k da\u011f\u0131l\u0131m grafi\u011finde g\u00f6r\u00fcnt\u00fclenecektir:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ad\u0131m 4: Tahmin edilen de\u011ferleri hesaplay\u0131n.<\/strong> Trend \u00e7izgisi denklemini C2 h\u00fccresine girin ve &#8220;x&#8221; yerine &#8220;A1&#8221; ifadesini \u015fu \u015fekilde kullan\u0131n:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra C2 h\u00fccresine t\u0131klay\u0131n ve h\u00fccrenin sa\u011f alt k\u0131sm\u0131ndaki k\u00fc\u00e7\u00fck \u201cDoldurma Tutamac\u0131na\u201d \u00e7ift t\u0131klay\u0131n. Bu, form\u00fcl\u00fc C2 h\u00fccresinden s\u00fctundaki di\u011fer h\u00fccrelere kopyalayacakt\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ad\u0131m 5: Art\u0131klar\u0131 hesaplay\u0131n.<\/strong> D2 h\u00fccresine <em>B2-C2<\/em> girin. Daha sonra D2 h\u00fccresine t\u0131klay\u0131n ve h\u00fccrenin sa\u011f alt k\u0131sm\u0131ndaki k\u00fc\u00e7\u00fck \u201cDoldurma Tutamac\u0131na\u201d \u00e7ift t\u0131klay\u0131n. Bu, form\u00fcl\u00fc D2 h\u00fccresinden s\u00fctundaki di\u011fer h\u00fccrelere kopyalayacakt\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ad\u0131m 6: Kalan grafi\u011fi olu\u015fturun.<\/strong> A2:A13 h\u00fccrelerini vurgulay\u0131n. \u201cCtrl\u201d tu\u015funu bas\u0131l\u0131 tutun ve D2:D13 h\u00fccrelerini vurgulay\u0131n. Ard\u0131ndan, \u00fcst \u015feritteki <em>INSERT<\/em> sekmesine gidin. <em>Grafikler<\/em> alan\u0131nda <em>Da\u011f\u0131l\u0131m<\/em> i\u00e7in ilk se\u00e7ene\u011fe t\u0131klay\u0131n. A\u015fa\u011f\u0131daki tablo g\u00f6r\u00fcnecektir:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu kalan arsa. X ekseni tak\u0131lan de\u011ferleri, y ekseni ise art\u0131klar\u0131 g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Konuyu g\u00f6rsel olarak daha \u00e7ekici hale getirmek i\u00e7in ba\u015fl\u0131\u011f\u0131, eksenleri ve \u0131zgaralar\u0131 de\u011fi\u015ftirmekten \u00e7ekinmeyin:<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Art\u0131k grafi\u011fi, bir regresyon modeli i\u00e7in art\u0131klara kar\u015f\u0131 uygun de\u011ferleri g\u00f6steren bir grafik t\u00fcr\u00fcd\u00fcr. Bu t\u00fcr \u00e7izim genellikle do\u011frusal bir regresyon modelinin belirli bir veri seti i\u00e7in uygun olup olmad\u0131\u011f\u0131n\u0131 de\u011ferlendirmek ve heteroskedastisite i\u00e7in art\u0131klar\u0131 kontrol etmek i\u00e7in kullan\u0131l\u0131r. Bu e\u011fitimde, Excel&#8217;de basit bir do\u011frusal regresyon modeli i\u00e7in art\u0131k grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r. Excel&#8217;de Art\u0131k [&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-532","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 Art\u0131k Grafik Nas\u0131l Olu\u015fturulur - Statorials<\/title>\n<meta name=\"description\" content=\"Excel&#039;de art\u0131k grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 a\u00e7\u0131klayan basit bir e\u011fitim.\" \/>\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\/excelde-artik-iz-nasil-olusturulur\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Art\u0131k Grafik Nas\u0131l Olu\u015fturulur - Statorials\" \/>\n<meta property=\"og:description\" content=\"Excel&#039;de art\u0131k grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 a\u00e7\u0131klayan basit bir e\u011fitim.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excelde-artik-iz-nasil-olusturulur\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T14:40:43+00:00\" \/>\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\/excelde-artik-iz-nasil-olusturulur\/\",\"url\":\"https:\/\/statorials.org\/tr\/excelde-artik-iz-nasil-olusturulur\/\",\"name\":\"Excel&#39;de Art\u0131k Grafik Nas\u0131l Olu\u015fturulur - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-29T14:40:43+00:00\",\"dateModified\":\"2023-07-29T14:40:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Excel&#39;de art\u0131k grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 a\u00e7\u0131klayan basit bir e\u011fitim.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excelde-artik-iz-nasil-olusturulur\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excelde-artik-iz-nasil-olusturulur\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excelde-artik-iz-nasil-olusturulur\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de art\u0131k 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 Art\u0131k Grafik Nas\u0131l Olu\u015fturulur - Statorials","description":"Excel&#39;de art\u0131k grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 a\u00e7\u0131klayan basit bir e\u011fitim.","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\/excelde-artik-iz-nasil-olusturulur\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Art\u0131k Grafik Nas\u0131l Olu\u015fturulur - Statorials","og_description":"Excel&#39;de art\u0131k grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 a\u00e7\u0131klayan basit bir e\u011fitim.","og_url":"https:\/\/statorials.org\/tr\/excelde-artik-iz-nasil-olusturulur\/","og_site_name":"Statorials","article_published_time":"2023-07-29T14:40:43+00:00","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\/excelde-artik-iz-nasil-olusturulur\/","url":"https:\/\/statorials.org\/tr\/excelde-artik-iz-nasil-olusturulur\/","name":"Excel&#39;de Art\u0131k Grafik Nas\u0131l Olu\u015fturulur - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-29T14:40:43+00:00","dateModified":"2023-07-29T14:40:43+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Excel&#39;de art\u0131k grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 a\u00e7\u0131klayan basit bir e\u011fitim.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excelde-artik-iz-nasil-olusturulur\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excelde-artik-iz-nasil-olusturulur\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excelde-artik-iz-nasil-olusturulur\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de art\u0131k 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\/532","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=532"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/532\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}