{"id":1271,"date":"2023-07-27T01:48:37","date_gmt":"2023-07-27T01:48:37","guid":{"rendered":"https:\/\/statorials.org\/tr\/eksik-degerleri-enterpolasyonla-excel\/"},"modified":"2023-07-27T01:48:37","modified_gmt":"2023-07-27T01:48:37","slug":"eksik-degerleri-enterpolasyonla-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/eksik-degerleri-enterpolasyonla-excel\/","title":{"rendered":"Excel&#39;de eksik de\u011ferlerin enterpolasyonu nas\u0131l yap\u0131l\u0131r"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Genellikle Excel&#8217;deki bir dizide doldurmak istedi\u011finiz bir veya daha fazla eksik de\u011fere sahip olursunuz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Eksik de\u011ferleri doldurman\u0131n en kolay yolu <strong>Giri\u015f<\/strong> sekmesinin <strong>D\u00fczenle<\/strong> b\u00f6l\u00fcm\u00fcndeki <strong>Seriyi Doldur<\/strong> i\u015flevini kullanmakt\u0131r.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12509 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill1.png\" alt=\"Excel'de seri doldurma se\u00e7ene\u011fi\" width=\"484\" height=\"336\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu e\u011fitimde bu \u00f6zelli\u011fin pratikte nas\u0131l kullan\u0131laca\u011f\u0131na dair iki \u00f6rnek verilmektedir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>\u00d6rnek 1: Do\u011frusal bir trend i\u00e7in eksik de\u011ferleri doldurun<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Excel&#8217;de birka\u00e7 eksik de\u011fer i\u00e7eren 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-12510 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill2.png\" alt=\"Excel'de eksik de\u011ferleri enterpolasyonla\" width=\"404\" height=\"448\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu verilerin h\u0131zl\u0131 bir \u00e7izgi grafi\u011fini olu\u015fturursak, verilerin do\u011frusal bir trend izledi\u011fini g\u00f6r\u00fcr\u00fcz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12512 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill3.png\" alt=\"\" width=\"578\" height=\"457\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Eksik de\u011ferleri doldurmak i\u00e7in eksik de\u011ferlerden \u00f6nce ve sonra ba\u015flayan aral\u0131\u011f\u0131 vurgulayabilir ve ard\u0131ndan <strong>Ana Sayfa &gt; D\u00fczenle &gt; Doldur &gt; Seriler<\/strong> \u00f6\u011fesine t\u0131klayabiliriz.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12513 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill4.png\" alt=\"Excel'de bir seriyi do\u011frusal doldurma\" width=\"536\" height=\"455\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Type&#8217;\u0131 <strong>Linear<\/strong> olarak b\u0131rak\u0131rsak Excel, eksik verileri doldurmak i\u00e7in kullan\u0131lacak ad\u0131m de\u011ferini belirlemek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanacakt\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ad\u0131m = (Biti\u015f \u2013 Ba\u015flang\u0131\u00e7) \/ (#Eksik G\u00f6zlemler + 1)<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu \u00f6rnekte ad\u0131m de\u011ferini (35-20) \/ (4+1) = <strong>3<\/strong> olarak belirler.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Tamam&#8217;a<\/strong> t\u0131klad\u0131\u011f\u0131m\u0131zda Excel, a\u015fa\u011f\u0131daki de\u011ferlerin her birine 3 ekleyerek eksik de\u011ferleri otomatik olarak dolduracakt\u0131r:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12514 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill5.png\" alt=\"\" width=\"474\" height=\"408\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>\u00d6rnek 2: Bir b\u00fcy\u00fcme trendi i\u00e7in eksik de\u011ferleri doldurun<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Excel&#8217;de birka\u00e7 eksik de\u011fer i\u00e7eren 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-12515 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill6.png\" alt=\"\" width=\"426\" height=\"454\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu verilerin h\u0131zl\u0131 bir \u00e7izgi grafi\u011fini olu\u015fturursak, verilerin \u00fcstel (veya &#8220;b\u00fcy\u00fcyen&#8221;) bir trend izledi\u011fini g\u00f6r\u00fcr\u00fcz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12516 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill7.png\" alt=\"\" width=\"536\" height=\"433\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Eksik de\u011ferleri doldurmak i\u00e7in eksik de\u011ferlerden \u00f6nce ve sonra ba\u015flayan aral\u0131\u011f\u0131 vurgulayabilir ve ard\u0131ndan <strong>Ana Sayfa &gt; D\u00fczenle &gt; Doldur &gt; Seriler<\/strong> \u00f6\u011fesine t\u0131klayabiliriz.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12517 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill8.png\" alt=\"\" width=\"495\" height=\"432\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Type&#8217;\u0131 <strong>Growth<\/strong> olarak se\u00e7ip <strong>Trend&#8217;in<\/strong> yan\u0131ndaki kutuya t\u0131klarsak Excel otomatik olarak verilerdeki b\u00fcy\u00fcme trendini tespit eder ve eksik de\u011ferleri doldurur.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Tamam&#8217;a<\/strong> t\u0131klad\u0131\u011f\u0131m\u0131zda Excel eksik de\u011ferleri doldurur:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12518 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill9.png\" alt=\"Excel'de eksik de\u011ferleri enterpolasyonla\" width=\"551\" height=\"432\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Grafikten girilen de\u011ferlerin verilerin genel e\u011filimiyle olduk\u00e7a iyi e\u015fle\u015fti\u011fini g\u00f6rebiliyoruz.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><em>Daha fazla Excel e\u011fitimini burada bulabilirsiniz.<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Genellikle Excel&#8217;deki bir dizide doldurmak istedi\u011finiz bir veya daha fazla eksik de\u011fere sahip olursunuz. Eksik de\u011ferleri doldurman\u0131n en kolay yolu Giri\u015f sekmesinin D\u00fczenle b\u00f6l\u00fcm\u00fcndeki Seriyi Doldur i\u015flevini kullanmakt\u0131r. Bu e\u011fitimde bu \u00f6zelli\u011fin pratikte nas\u0131l kullan\u0131laca\u011f\u0131na dair iki \u00f6rnek verilmektedir. \u00d6rnek 1: Do\u011frusal bir trend i\u00e7in eksik de\u011ferleri doldurun Excel&#8217;de birka\u00e7 eksik de\u011fer i\u00e7eren a\u015fa\u011f\u0131daki veri [&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-1271","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 Eksik De\u011ferlerin Enterpolasyonu Nas\u0131l Yap\u0131l\u0131r - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel&#039;deki bir serideki eksik de\u011ferlerin nas\u0131l enterpolasyona tabi tutulaca\u011f\u0131 birka\u00e7 \u00f6rnekle 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\/eksik-degerleri-enterpolasyonla-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 Eksik De\u011ferlerin Enterpolasyonu Nas\u0131l Yap\u0131l\u0131r - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel&#039;deki bir serideki eksik de\u011ferlerin nas\u0131l enterpolasyona tabi tutulaca\u011f\u0131 birka\u00e7 \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/eksik-degerleri-enterpolasyonla-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T01:48:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill1.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\/eksik-degerleri-enterpolasyonla-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/eksik-degerleri-enterpolasyonla-excel\/\",\"name\":\"Excel&#39;de Eksik De\u011ferlerin Enterpolasyonu Nas\u0131l Yap\u0131l\u0131r - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-27T01:48:37+00:00\",\"dateModified\":\"2023-07-27T01:48:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, Excel&#39;deki bir serideki eksik de\u011ferlerin nas\u0131l enterpolasyona tabi tutulaca\u011f\u0131 birka\u00e7 \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/eksik-degerleri-enterpolasyonla-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/eksik-degerleri-enterpolasyonla-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/eksik-degerleri-enterpolasyonla-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de eksik de\u011ferlerin enterpolasyonu nas\u0131l yap\u0131l\u0131r\"}]},{\"@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 Eksik De\u011ferlerin Enterpolasyonu Nas\u0131l Yap\u0131l\u0131r - Statorials","description":"Bu e\u011fitimde, Excel&#39;deki bir serideki eksik de\u011ferlerin nas\u0131l enterpolasyona tabi tutulaca\u011f\u0131 birka\u00e7 \u00f6rnekle 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\/eksik-degerleri-enterpolasyonla-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Eksik De\u011ferlerin Enterpolasyonu Nas\u0131l Yap\u0131l\u0131r - Statorials","og_description":"Bu e\u011fitimde, Excel&#39;deki bir serideki eksik de\u011ferlerin nas\u0131l enterpolasyona tabi tutulaca\u011f\u0131 birka\u00e7 \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/eksik-degerleri-enterpolasyonla-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-27T01:48:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/seriefill1.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\/eksik-degerleri-enterpolasyonla-excel\/","url":"https:\/\/statorials.org\/tr\/eksik-degerleri-enterpolasyonla-excel\/","name":"Excel&#39;de Eksik De\u011ferlerin Enterpolasyonu Nas\u0131l Yap\u0131l\u0131r - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-27T01:48:37+00:00","dateModified":"2023-07-27T01:48:37+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, Excel&#39;deki bir serideki eksik de\u011ferlerin nas\u0131l enterpolasyona tabi tutulaca\u011f\u0131 birka\u00e7 \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/eksik-degerleri-enterpolasyonla-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/eksik-degerleri-enterpolasyonla-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/eksik-degerleri-enterpolasyonla-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de eksik de\u011ferlerin enterpolasyonu nas\u0131l yap\u0131l\u0131r"}]},{"@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\/1271","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=1271"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/1271\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=1271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=1271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=1271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}