{"id":1650,"date":"2023-11-13T18:13:54","date_gmt":"2023-11-13T18:13:54","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/"},"modified":"2023-12-10T06:00:09","modified_gmt":"2023-12-10T06:00:09","slug":"agirlikli-ortalama","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/","title":{"rendered":"Excel&#39;de a\u011f\u0131rl\u0131kl\u0131 ortalama nas\u0131l hesaplan\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1164706588\"><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 class=\"has-text-align-left\">Ortalama, verilere genel bir bak\u0131\u015f elde etmenin en iyi yoludur. Ancak bazen ortalama size tarafl\u0131 bir de\u011fer verir. Bu durumlarda [her zaman] en iyi yol a\u011f\u0131rl\u0131kl\u0131 ortalamay\u0131 hesaplamakt\u0131r.<\/p><p> Ve en iyi yolun SUMproduct ve SUM i\u015flevlerini birle\u015ftirerek bir form\u00fcl kullanmak oldu\u011funu buldum.<\/p><p> Bu y\u00f6ntemin uygulanmas\u0131 basit ve kolayd\u0131r. Bu y\u00fczden bug\u00fcn bu yaz\u0131mda SUMproduct ve SUM kullanarak Excel&#8217;de a\u011f\u0131rl\u0131kl\u0131 ortalaman\u0131n nas\u0131l hesaplanaca\u011f\u0131n\u0131 sizlerle payla\u015fmak istiyorum.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> Normal ve a\u011f\u0131rl\u0131kl\u0131 ortalama aras\u0131ndaki fark<\/h2><p> A\u015fa\u011f\u0131daki \u00f6rnekte normal ortalama olarak 1658 ve a\u011f\u0131rl\u0131kl\u0131 ortalama olarak 1445&#8217;e sahibiz. Bu fark\u0131 iki noktada a\u00e7\u0131kl\u0131\u011fa kavu\u015fturay\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\" sizes=\"\" srcset=\"\" alt=\"normal a\u011f\u0131rl\u0131kl\u0131 ortalama ile Excel'de a\u011f\u0131rl\u0131kl\u0131 ortalaman\u0131n sumproduct ile nas\u0131l hesaplanaca\u011f\u0131 aras\u0131ndaki fark\"><\/figure><\/div><ul><li> <strong>Birincisi:<\/strong> 1658&#8217;i (ortalama) 68&#8217;le (miktar) \u00e7arparsan\u0131z 112742 elde edersiniz ki bu da toplam tutara e\u015fit de\u011fildir. Ancak 1445&#8217;i (a\u011f\u0131rl\u0131kl\u0131 ortalama) 68&#8217;le (miktar) \u00e7arparsan\u0131z toplam tutara e\u015fit olan 98289 sonucunu elde edersiniz.<\/li><li> <strong>\u0130kincisi:<\/strong> \u00dcr\u00fcn-1 en d\u00fc\u015f\u00fck fiyata ve en y\u00fcksek adede sahipken, \u00dcr\u00fcn-4 en y\u00fcksek fiyata ve en d\u00fc\u015f\u00fck adede sahiptir.<\/li><\/ul><p> Normal ortalamay\u0131 hesaplarken miktar\u0131 dikkate almazs\u0131n\u0131z ve miktarda bir de\u011fi\u015fiklik olmas\u0131 durumunda ortalama fiyata bir etkisi olmaz. A\u011f\u0131rl\u0131kl\u0131 ortalamada ise miktar\u0131 a\u011f\u0131rl\u0131k olarak alabilirsiniz.<\/p><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> Excel&#8217;de a\u011f\u0131rl\u0131kl\u0131 ortalamay\u0131 hesaplama ad\u0131m\u0131<\/h2><p> A\u011f\u0131rl\u0131kl\u0131 ortalamay\u0131 hesaplamak i\u00e7in yukar\u0131daki \u00f6rnekte size g\u00f6sterdi\u011fim veri tablosunun ayn\u0131s\u0131n\u0131 kullan\u0131yoruz. <\/p><div class=\"gb-container gb-container-bafb25cc gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-91201309\"><div class=\"gb-grid-column gb-grid-column-15a917ef\"><div class=\"gb-container gb-container-15a917ef\"><h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text gb-headline-download-2\"> Excel dosyas\u0131n\u0131 al\u0131n <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-18357188\"><div class=\"gb-container gb-container-18357188\"><div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-cb63d00a gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/donnees-pour-calculer-la-moyenne-mobile-avec-sumproduct.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a> <\/div><\/div><\/div><\/div><\/div><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-a-utiliser-pour-calculer-la-moyenne-ponderee-dans-excel-avec-la-formule-sumproduct.png\" sizes=\"\" srcset=\"\" alt=\"normal a\u011f\u0131rl\u0131kl\u0131 ortalama ile Excel'de a\u011f\u0131rl\u0131kl\u0131 ortalaman\u0131n sumproduct ile nas\u0131l hesaplanaca\u011f\u0131 aras\u0131ndaki fark\"><\/figure><\/div><p> \u015eimdi bu iki basit ad\u0131m\u0131 izleyin.<\/p><ul><li> C7 h\u00fccresine \u015fu form\u00fcl\u00fc girin: =TOPLA\u00c7ARP(B2:B6;C2:C6)\/TOPLA(B2:B6). <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/entrer-des-formules-dans-le-tableau-de-donnees-a-utiliser-pour-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\" sizes=\"\" srcset=\"\" alt=\"sumproduct ile Excel'de a\u011f\u0131rl\u0131kl\u0131 ortalamay\u0131 hesaplamak i\u00e7in kullan\u0131lacak form\u00fclleri veri tablosuna girin\"><\/figure><\/div><ul><li> Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-ok-dans-le-tableau-de-donnees-a-utiliser-pour-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\" sizes=\"\" srcset=\"\" alt=\"sumproduct ile Excel'deki a\u011f\u0131rl\u0131kl\u0131 ortalamay\u0131 hesaplamak i\u00e7in veri tablosunda Tamam'\u0131 t\u0131klay\u0131n\"><\/figure><\/div><p> Art\u0131k fiyat ve \u00fcr\u00fcn\u00fcn a\u011f\u0131rl\u0131kl\u0131 ortalamas\u0131 olarak 1445&#8217;e sahipsiniz. S\u00f6yledi\u011fim gibi SUMproduct, Excel&#8217;de a\u011f\u0131rl\u0131kl\u0131 ortalama veya a\u011f\u0131rl\u0131kl\u0131 ortalama hesaplaman\u0131n basit bir yoludur. SUMPROP&#8217;un en iyi yan\u0131, tek bir h\u00fccrede bir diziyi \u00e7o\u011falt\u0131p ekleyebilmesidir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(B2:B6,C2:C6)\/SUM(C2:C6)<\/code><\/pre><h3 id=\"tab-con-3\" class=\"wp-block-heading\"> Bu nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> Anlamak i\u00e7in bu form\u00fcl\u00fc par\u00e7alara ay\u0131rmam\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/les-formules-se-decomposent-pour-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\" sizes=\"\" srcset=\"\" alt=\"form\u00fcller Excel'de toplam \u00fcr\u00fcnle a\u011f\u0131rl\u0131kl\u0131 ortalamay\u0131 hesaplamak i\u00e7in ayr\u0131\u015ft\u0131r\u0131l\u0131r\"><\/figure><\/div><p> SUMproduct \u00f6ncelikle t\u00fcm \u00fcr\u00fcnler i\u00e7in fiyat ve miktar \u00e7arp\u0131m\u0131n\u0131 hesaplayacak ve hepsinin toplam\u0131n\u0131 d\u00f6nd\u00fcrecektir. Bundan sonra baz\u0131 i\u015flevler size miktar\u0131n toplam\u0131n\u0131 verecektir. Ve sonunda her iki fonksiyonun de\u011ferlerini b\u00f6lerek a\u011f\u0131rl\u0131kl\u0131 ortalamay\u0131 elde edeceksiniz.<\/p><p> \u015euna bir g\u00f6z at\u0131n: <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-urundeki-durum\/\"><strong>\u00d6ZET<\/strong><\/a><\/p><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> A\u011f\u0131rl\u0131kl\u0131 hareketli ortalamay\u0131 hesaplay\u0131n<\/h2><p> Biraz daha ileri gidelim. Veri analizi k\u0131sm\u0131na ge\u00e7elim. Ayn\u0131 form\u00fcl\u00fc kullanarak a\u011f\u0131rl\u0131kl\u0131 hareketli ortalamay\u0131 da hesaplayabilirsiniz. <\/p><div class=\"gb-container gb-container-d0894b79 gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-fb05a72a\"><div class=\"gb-grid-column gb-grid-column-977d91db\"><div class=\"gb-container gb-container-977d91db\"><h2 class=\"gb-headline gb-headline-21846cd9 gb-headline-text gb-headline-download-2\"> Excel dosyas\u0131n\u0131 al\u0131n <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-098be44d\"><div class=\"gb-container gb-container-098be44d\"><div class=\"gb-container gb-container-1d96da0a\"> <a class=\"gb-button gb-button-e86530c2 gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/donnees-pour-calculer-la-moyenne-mobile-avec-sumproduct.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a> <\/div><\/div><\/div><\/div><\/div><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/avec-moyenne-mobile-calculer-la-moyenne-ponderee-avec-sumproduct-1.png\" sizes=\"\" srcset=\"\" alt=\"hareketli ortalama ile excel'de a\u011f\u0131rl\u0131kl\u0131 a\u011f\u0131rl\u0131kl\u0131 ortalamay\u0131 sumproduct ile hesaplay\u0131n\"><\/figure><\/div><p> \u0130\u015fte ad\u0131mlar:<\/p><ul><li> A\u015fa\u011f\u0131daki form\u00fcl\u00fc D4 h\u00fccresine girin ve sonuna s\u00fcr\u00fckleyin. =TOPLA\u00c7ARP(B2:B4;C2:C4)\/TOPLA(C2:C4) <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-formules-pour-calculer-la-moyenne-mobile-et-calculer-la-moyenne-ponderee-avec-sumproduct-1.png\" sizes=\"\" srcset=\"\" alt=\"sumproduct ile hareketli ortalamay\u0131 hesaplamak ve Excel'de a\u011f\u0131rl\u0131kl\u0131 ortalamay\u0131 hesaplamak i\u00e7in form\u00fcller ekleyin\"><\/figure><\/div><ul><li> Bu form\u00fcl\u00fc s\u00fcr\u00fckledi\u011finizde her ay i\u00e7in 3 aya g\u00f6re hareketli ortalamay\u0131 hesaplayacakt\u0131r.<\/li><\/ul><h3 id=\"tab-con-3\" class=\"wp-block-heading\"> Bu nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> Yukar\u0131daki D4 h\u00fccresindeki anl\u0131k g\u00f6r\u00fcnt\u00fcy\u00fc kontrol ederseniz Ocak, \u015eubat ve Mart aylar\u0131na ait hareketli ortalamay\u0131 elde edersiniz. Ve D5 h\u00fccresinde \u015eubat, Mart ve Nisan aylar\u0131n\u0131n hareketli ortalamas\u0131n\u0131 g\u00f6r\u00fcyorsunuz.<\/p><p> Yani her yeni aya ge\u00e7ti\u011finizde, i\u00e7inde bulundu\u011funuz ay ve son iki ay dahil olmak \u00fczere hareketli ortalamay\u0131 alacaks\u0131n\u0131z. Form\u00fcl\u00fcn\u00fcz\u00fc s\u00fcr\u00fcklerken h\u00fccre referanslar\u0131n\u0131z\u0131 g\u00f6receli hale getirmeniz yeterli. <\/p><div class=\"gb-container gb-container-3c0c09cb gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-2ce0b1ad\"><div class=\"gb-grid-column gb-grid-column-03e068ab\"><div class=\"gb-container gb-container-03e068ab\"><h2 class=\"gb-headline gb-headline-9978411b gb-headline-text gb-headline-download-2\"> Excel dosyas\u0131n\u0131 al\u0131n <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-3f9fba78\"><div class=\"gb-container gb-container-3f9fba78\"><div class=\"gb-container gb-container-ee718499\"> <a class=\"gb-button gb-button-94105543 gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/moyenne-ponderee-avec-somme-du-produit.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/div><\/div><\/div><\/div><\/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\/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><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-olmayan-hucrelerin-ortalamasi-2\/\">Yaln\u0131zca bo\u015f olmayan h\u00fccrelerin ortalamas\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/\">Y\u00fczde de\u011ferlerinin ortalamas\u0131n\u0131 hesaplay\u0131n<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1650","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>\u25b7 Excel&#039;de a\u011f\u0131rl\u0131kl\u0131 ortalama nas\u0131l hesaplan\u0131r?<\/title>\n<meta name=\"description\" content=\"A\u011f\u0131rl\u0131kl\u0131 ortalama en \u00f6nemli hesaplamalardan biridir ve \u00e7arp\u0131mlar\u0131n toplam\u0131 bunu hesaplaman\u0131n en basit y\u00f6ntemlerinden biridir.\" \/>\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\/agirlikli-ortalama\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel&#039;de a\u011f\u0131rl\u0131kl\u0131 ortalama nas\u0131l hesaplan\u0131r?\" \/>\n<meta property=\"og:description\" content=\"A\u011f\u0131rl\u0131kl\u0131 ortalama en \u00f6nemli hesaplamalardan biridir ve \u00e7arp\u0131mlar\u0131n toplam\u0131 bunu hesaplaman\u0131n en basit y\u00f6ntemlerinden biridir.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:00:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/\",\"name\":\"\u25b7 Excel&#39;de a\u011f\u0131rl\u0131kl\u0131 ortalama nas\u0131l hesaplan\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\",\"datePublished\":\"2023-11-13T18:13:54+00:00\",\"dateModified\":\"2023-12-10T06:00:09+00:00\",\"description\":\"A\u011f\u0131rl\u0131kl\u0131 ortalama en \u00f6nemli hesaplamalardan biridir ve \u00e7arp\u0131mlar\u0131n toplam\u0131 bunu hesaplaman\u0131n en basit y\u00f6ntemlerinden biridir.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de a\u011f\u0131rl\u0131kl\u0131 ortalama 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":"\u25b7 Excel&#39;de a\u011f\u0131rl\u0131kl\u0131 ortalama nas\u0131l hesaplan\u0131r?","description":"A\u011f\u0131rl\u0131kl\u0131 ortalama en \u00f6nemli hesaplamalardan biridir ve \u00e7arp\u0131mlar\u0131n toplam\u0131 bunu hesaplaman\u0131n en basit y\u00f6ntemlerinden biridir.","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\/agirlikli-ortalama\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de a\u011f\u0131rl\u0131kl\u0131 ortalama nas\u0131l hesaplan\u0131r?","og_description":"A\u011f\u0131rl\u0131kl\u0131 ortalama en \u00f6nemli hesaplamalardan biridir ve \u00e7arp\u0131mlar\u0131n toplam\u0131 bunu hesaplaman\u0131n en basit y\u00f6ntemlerinden biridir.","og_url":"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:00:09+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/","url":"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/","name":"\u25b7 Excel&#39;de a\u011f\u0131rl\u0131kl\u0131 ortalama nas\u0131l hesaplan\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png","datePublished":"2023-11-13T18:13:54+00:00","dateModified":"2023-12-10T06:00:09+00:00","description":"A\u011f\u0131rl\u0131kl\u0131 ortalama en \u00f6nemli hesaplamalardan biridir ve \u00e7arp\u0131mlar\u0131n toplam\u0131 bunu hesaplaman\u0131n en basit y\u00f6ntemlerinden biridir.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de a\u011f\u0131rl\u0131kl\u0131 ortalama 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\/1650","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=1650"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1650\/revisions"}],"predecessor-version":[{"id":2383,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1650\/revisions\/2383"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}