{"id":540,"date":"2023-07-29T14:03:46","date_gmt":"2023-07-29T14:03:46","guid":{"rendered":"https:\/\/statorials.org\/tr\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/"},"modified":"2023-07-29T14:03:46","modified_gmt":"2023-07-29T14:03:46","slug":"excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/","title":{"rendered":"Excel&#39;de ortalama mutlak sapma kolayca nas\u0131l hesaplan\u0131r?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Ortalama mutlak sapma,<\/strong> bir dizi veri de\u011ferinin da\u011f\u0131l\u0131m\u0131n\u0131 \u00f6l\u00e7menin bir yoludur.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ortalama mutlak sapman\u0131n d\u00fc\u015f\u00fck bir de\u011feri, veri de\u011ferlerinin s\u0131k\u0131 bir \u015fekilde yo\u011funla\u015ft\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/span> <span style=\"color: #000000;\">Ortalama mutlak sapman\u0131n daha y\u00fcksek bir de\u011feri, veri de\u011ferlerinin daha da\u011f\u0131n\u0131k oldu\u011funu g\u00f6sterir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ortalama mutlak sapmay\u0131 hesaplama form\u00fcl\u00fc \u015f\u00f6yledir:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ortalama mutlak sapma<\/strong> = (\u03a3 |x <sub>i<\/sub> \u2013 <span style=\"text-decoration: overline;\">x<\/span> |) \/ n<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3<\/strong> \u2013 \u201ctoplam\u201d anlam\u0131na gelen sadece s\u00fcsl\u00fc bir sembol<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub><\/strong> \u2013 <sup>i&#8217;inci<\/sup> veri de\u011feri<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"text-decoration: overline;\">x<\/span><\/strong> \u2013 ortalama de\u011fer<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n<\/strong> \u2013 \u00f6rneklem b\u00fcy\u00fckl\u00fc\u011f\u00fc<\/span><\/li>\n<\/ul>\n<h2> <span style=\"color: #000000;\"><strong>Excel&#8217;de Ortalama Mutlak Sapma Nas\u0131l Hesaplan\u0131r?<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Excel&#8217;de <strong>Ortalama Mutlak Sapmay\u0131<\/strong> hesaplamak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 uygulayabiliriz:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ad\u0131m 1: Verileri girin<\/strong> . Bu \u00f6rnekte A2:A16 h\u00fccrelerine 15 adet veri de\u011feri girece\u011fiz.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ad\u0131m 2: Ortalama de\u011feri bulun<\/strong> . D1 h\u00fccresine \u015fu form\u00fcl\u00fc yaz\u0131n: <strong>=ORTALAMA(A2:A16)<\/strong> . Bu, veri de\u011ferlerinin ortalama de\u011ferini hesaplar ve bu de\u011fer <strong>15,8<\/strong> olur.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ad\u0131m 3: Mutlak sapmalar\u0131 hesaplay\u0131n.<\/strong> B2 h\u00fccresine \u015fu form\u00fcl\u00fc yaz\u0131n: <strong>=ABS(A2-$D$1)<\/strong> . Bu, A2 h\u00fccresindeki de\u011ferin veri k\u00fcmesindeki ortalama de\u011ferden mutlak sapmas\u0131n\u0131 hesaplar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra B2 h\u00fccresine t\u0131klay\u0131n. Ard\u0131ndan, siyah <strong>+<\/strong> i\u015fareti g\u00f6r\u00fcnene kadar h\u00fccrenin sa\u011f alt k\u00f6\u015fesinin \u00fczerinde gezinin. B s\u00fctununda kalan de\u011ferleri doldurmak i\u00e7in <strong>+<\/strong> i\u015faretine \u00e7ift t\u0131klay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Ad\u0131m 4: Ortalama mutlak sapmay\u0131 hesaplay\u0131n<\/strong> . B17 h\u00fccresine \u015fu form\u00fcl\u00fc yaz\u0131n: <strong>=ORTALAMA(B2:B16)<\/strong> . Bu, veri de\u011ferlerinin ortalama mutlak sapmas\u0131n\u0131 hesaplar ve bu da <strong>6,1866<\/strong> olur.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Herhangi bir say\u0131da veri de\u011feri i\u00e7in ortalama mutlak sapmay\u0131 hesaplamak amac\u0131yla bu d\u00f6rt ad\u0131m\u0131 kullanabilece\u011finizi unutmay\u0131n. Bu \u00f6rnekte 15 veri de\u011feri kulland\u0131k ancak 5 veri de\u011feri veya 5.000 veri de\u011feri i\u00e7in ortalama mutlak sapmay\u0131 hesaplamak i\u00e7in bu ad\u0131mlar\u0131 tam olarak kullanabilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><em>Bir modelin tahminlerinin do\u011frulu\u011funu \u00f6l\u00e7menin di\u011fer bir yayg\u0131n yolu da MAPE&#8217;dir (ortalama mutlak y\u00fczde hata). MAPE&#8217;yi Excel&#8217;de nas\u0131l hesaplayaca\u011f\u0131n\u0131z\u0131 <a href=\"https:\/\/statorials.org\/tr\/excel-karti\/\" target=\"_blank\" rel=\"noopener\">buradan<\/a> \u00f6\u011frenin.<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ortalama mutlak sapma, bir dizi veri de\u011ferinin da\u011f\u0131l\u0131m\u0131n\u0131 \u00f6l\u00e7menin bir yoludur. Ortalama mutlak sapman\u0131n d\u00fc\u015f\u00fck bir de\u011feri, veri de\u011ferlerinin s\u0131k\u0131 bir \u015fekilde yo\u011funla\u015ft\u0131\u011f\u0131n\u0131 g\u00f6sterir. Ortalama mutlak sapman\u0131n daha y\u00fcksek bir de\u011feri, veri de\u011ferlerinin daha da\u011f\u0131n\u0131k oldu\u011funu g\u00f6sterir. Ortalama mutlak sapmay\u0131 hesaplama form\u00fcl\u00fc \u015f\u00f6yledir: Ortalama mutlak sapma = (\u03a3 |x i \u2013 x |) \/ n [&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-540","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 Ortalama Mutlak Sapma Kolayca Nas\u0131l Hesaplan\u0131r?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel&#039;deki bir dizi veri de\u011feri i\u00e7in ortalama mutlak sapman\u0131n nas\u0131l hesaplanaca\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\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Ortalama Mutlak Sapma Kolayca Nas\u0131l Hesaplan\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel&#039;deki bir dizi veri de\u011feri i\u00e7in ortalama mutlak sapman\u0131n nas\u0131l hesaplanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T14:03:46+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-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/\",\"url\":\"https:\/\/statorials.org\/tr\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/\",\"name\":\"Excel&#39;de Ortalama Mutlak Sapma Kolayca Nas\u0131l Hesaplan\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-29T14:03:46+00:00\",\"dateModified\":\"2023-07-29T14:03:46+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, Excel&#39;deki bir dizi veri de\u011feri i\u00e7in ortalama mutlak sapman\u0131n nas\u0131l hesaplanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de ortalama mutlak sapma kolayca nas\u0131l hesaplan\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 Ortalama Mutlak Sapma Kolayca Nas\u0131l Hesaplan\u0131r?","description":"Bu e\u011fitimde, Excel&#39;deki bir dizi veri de\u011feri i\u00e7in ortalama mutlak sapman\u0131n nas\u0131l hesaplanaca\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\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Ortalama Mutlak Sapma Kolayca Nas\u0131l Hesaplan\u0131r?","og_description":"Bu e\u011fitimde, Excel&#39;deki bir dizi veri de\u011feri i\u00e7in ortalama mutlak sapman\u0131n nas\u0131l hesaplanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/","og_site_name":"Statorials","article_published_time":"2023-07-29T14:03:46+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-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/","url":"https:\/\/statorials.org\/tr\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/","name":"Excel&#39;de Ortalama Mutlak Sapma Kolayca Nas\u0131l Hesaplan\u0131r?","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-29T14:03:46+00:00","dateModified":"2023-07-29T14:03:46+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, Excel&#39;deki bir dizi veri de\u011feri i\u00e7in ortalama mutlak sapman\u0131n nas\u0131l hesaplanaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excelde-ortalama-mutlak-sapmanin-kolayca-nasil-hesaplanacagi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de ortalama mutlak sapma kolayca nas\u0131l hesaplan\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\/540","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=540"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/540\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}