{"id":2191,"date":"2023-09-25T11:03:23","date_gmt":"2023-09-25T11:03:23","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/"},"modified":"2023-12-10T06:08:07","modified_gmt":"2023-12-10T06:08:07","slug":"ortalama-yuzde-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/","title":{"rendered":"Y\u00fczde de\u011ferlerinin ortalamas\u0131 nas\u0131l hesaplan\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3702716457\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Excel&#8217;deki y\u00fczdelerin ortalamas\u0131n\u0131 hesaplamak i\u00e7in ORTALAMA i\u015flevini kullanabilirsiniz. De\u011ferlerin bulundu\u011fu aral\u0131\u011fa bak\u0131n ve sonucu almak i\u00e7in Enter tu\u015funa bas\u0131n. Tek yapman\u0131z gereken bu form\u00fcl\u00fc kullanaca\u011f\u0131n\u0131z h\u00fccrenin y\u00fczde h\u00fccre format\u0131na sahip olmas\u0131. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79276\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png\" sizes=\"auto, \" srcset=\"\" alt=\"de\u011ferlerin ortalamas\u0131 y\u00fczdesi\" width=\"614\" height=\"332\"><\/figure><\/div><p> Bu dersimizde bunun i\u00e7in nas\u0131l form\u00fcl yazaca\u011f\u0131m\u0131z\u0131 \u00f6\u011frenece\u011fiz.<\/p><h2 class=\"wp-block-heading\"> Ortalama y\u00fczde form\u00fcl\u00fc<\/h2><p> Bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullanabilirsiniz:<\/p><ol type=\"1\"><li> \u0130lk olarak, =ORTALAMA t\u00fcr\u00fcnde bir h\u00fccrede.<\/li><li> \u015eimdi ba\u015f parantezleri \u201c(\u201d girin.<\/li><li> Bundan sonra ortalamas\u0131n\u0131 almak istedi\u011finiz de\u011ferlerin bulundu\u011fu aral\u0131\u011fa bak\u0131n.<\/li><li> Sonunda kapatma parantezlerini girin ve sonucu almak i\u00e7in Enter tu\u015funa bas\u0131n.<\/li><\/ol><p> Enter tu\u015funa bast\u0131\u011f\u0131n\u0131z an aral\u0131\u011f\u0131n y\u00fczde de\u011ferlerinin ortalamas\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=AVERAGE(A1:A3)<\/code><\/pre><p> Excel, Enter tu\u015funa bast\u0131\u011f\u0131n\u0131zda h\u00fccre bi\u00e7imini y\u00fczde olarak de\u011fi\u015ftirecek kadar ak\u0131ll\u0131d\u0131r.<\/p><h2 class=\"wp-block-heading\"> Y\u00fczdelerin a\u011f\u0131rl\u0131kl\u0131 ortalamas\u0131<\/h2><p> Evet, y\u00fczdelerin <a href=\"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/\">a\u011f\u0131rl\u0131kl\u0131 ortalamas\u0131n\u0131 da hesaplayabilirsiniz<\/a> . A\u015fa\u011f\u0131da levha y\u00fczdesinin \u00fczerinde puan alan \u00f6\u011frenci say\u0131s\u0131n\u0131 g\u00f6r\u00fcyoruz. \u015eimdi bu y\u00fczde de\u011ferlerinin a\u011f\u0131rl\u0131kl\u0131 ortalamas\u0131n\u0131 hesaplaman\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79277\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-moyenne-ponderee-des-pourcentages.png\" sizes=\"auto, \" srcset=\"\" alt=\"a\u011f\u0131rl\u0131kl\u0131 ortalama y\u00fczdeler\" width=\"636\" height=\"290\"><\/figure><\/div><p> Bu form\u00fcl SUMproduct ve SUM&#8217;un birle\u015fimidir.<\/p><ol><li> SUMproduct her \u00f6\u011frenci say\u0131s\u0131n\u0131 y\u00fczdeyle \u00e7arpar ve ard\u0131ndan bu \u00e7arp\u0131mlar\u0131n t\u00fcm\u00fcn\u00fc toplar.<\/li><li> SUM, toplam \u00f6\u011frenci say\u0131s\u0131n\u0131 (\u00f6\u011frenci say\u0131s\u0131n\u0131n toplam\u0131) d\u00f6nd\u00fcr\u00fcr.<\/li><li> Son olarak y\u00fczdelerin a\u011f\u0131rl\u0131kl\u0131 ortalamas\u0131n\u0131 elde etmek i\u00e7in iki de\u011feri b\u00f6l\u00fcn.<\/li><\/ol><h2 class=\"wp-block-heading\"> ORTALAMAI kullan<\/h2><p> Ayr\u0131ca y\u00fczdelerin ortalamas\u0131n\u0131 almak i\u00e7in ORTALAMAIF&#8217;yi kullanabilir veya ortalamay\u0131 hesaplamak i\u00e7in bir ko\u015ful olu\u015fturabilirsiniz. %50&#8217;den b\u00fcy\u00fck de\u011ferlerin ortalamas\u0131n\u0131 almak istedi\u011finizi varsayal\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79278\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-moyenne-si-pour-les-valeurs-en-pourcentage.png\" sizes=\"auto, \" srcset=\"\" alt=\"ortalama-y\u00fczde-de\u011ferler\" width=\"563\" height=\"368\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=AVERAGEIF(A2:A12,\"&gt;50%\")<\/code><\/pre><p> Bu yaln\u0131zca y\u00fczdenin 50&#8217;den b\u00fcy\u00fck oldu\u011fu h\u00fccreleri dikkate al\u0131r. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/pourcentage-moyen.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ortalama-maksimum-degerler\/\">Excel&#8217;deki en y\u00fcksek 5 de\u011ferin ortalamas\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/\">Excel&#8217;de a\u011f\u0131rl\u0131kl\u0131 ortalamay\u0131 hesaplay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ortalama-goz-ardi-edilen-hatalar-2\/\">Ortalama ancak hatalar\u0131 g\u00f6z ard\u0131 edin (#YOK ve di\u011fer hatalar)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ortalama-sifirlari-haric-tutar-2\/\">Ortalama say\u0131 ancak s\u0131f\u0131rlar\u0131 hari\u00e7 tutun<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2191","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Y\u00fczde de\u011ferlerinin ortalamas\u0131 nas\u0131l hesaplan\u0131r?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitim size ortalama y\u00fczde de\u011ferleri i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Y\u00fczde de\u011ferlerinin ortalamas\u0131 nas\u0131l hesaplan\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitim size ortalama y\u00fczde de\u011ferleri i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:08:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/\",\"name\":\"Y\u00fczde de\u011ferlerinin ortalamas\u0131 nas\u0131l hesaplan\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png\",\"datePublished\":\"2023-09-25T11:03:23+00:00\",\"dateModified\":\"2023-12-10T06:08:07+00:00\",\"description\":\"Bu e\u011fitim size ortalama y\u00fczde de\u011ferleri i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Y\u00fczde de\u011ferlerinin ortalamas\u0131 nas\u0131l hesaplan\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Y\u00fczde de\u011ferlerinin ortalamas\u0131 nas\u0131l hesaplan\u0131r?","description":"Bu e\u011fitim size ortalama y\u00fczde de\u011ferleri i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","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:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/","og_locale":"tr_TR","og_type":"article","og_title":"Y\u00fczde de\u011ferlerinin ortalamas\u0131 nas\u0131l hesaplan\u0131r?","og_description":"Bu e\u011fitim size ortalama y\u00fczde de\u011ferleri i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","og_url":"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:08:07+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/","url":"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/","name":"Y\u00fczde de\u011ferlerinin ortalamas\u0131 nas\u0131l hesaplan\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png","datePublished":"2023-09-25T11:03:23+00:00","dateModified":"2023-12-10T06:08:07+00:00","description":"Bu e\u011fitim size ortalama y\u00fczde de\u011ferleri i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Y\u00fczde de\u011ferlerinin ortalamas\u0131 nas\u0131l hesaplan\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2191","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=2191"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2191\/revisions"}],"predecessor-version":[{"id":2970,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2191\/revisions\/2970"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}