{"id":1279,"date":"2023-07-27T01:05:06","date_gmt":"2023-07-27T01:05:06","guid":{"rendered":"https:\/\/statorials.org\/tr\/excelde-ortalama-ve-standart-sapma\/"},"modified":"2023-07-27T01:05:06","modified_gmt":"2023-07-27T01:05:06","slug":"excelde-ortalama-ve-standart-sapma","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excelde-ortalama-ve-standart-sapma\/","title":{"rendered":"Excel&#39;de ortalama ve standart sapma nas\u0131l hesaplan\u0131r?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/tr\/merkezi-egilimi-olcer\/\" target=\"_blank\" rel=\"noopener\">Ortalama,<\/a> bir veri k\u00fcmesindeki ortalama de\u011feri temsil eder. Bu bize bir veri setinin merkezinin nerede oldu\u011funa dair iyi bir fikir verir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Standart sapma, bir veri setindeki de\u011ferlerin da\u011f\u0131l\u0131m\u0131n\u0131 temsil eder. Bu bize g\u00f6zlemlerin ortalama etraf\u0131nda ne kadar yak\u0131n k\u00fcmelendi\u011fine dair bir fikir verir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Yaln\u0131zca bu iki de\u011feri kullanarak bir veri k\u00fcmesindeki de\u011ferlerin da\u011f\u0131l\u0131m\u0131 hakk\u0131nda pek \u00e7ok \u015feyi anlayabiliriz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Excel&#8217;de bir veri k\u00fcmesinin <strong>ortalamas\u0131n\u0131<\/strong> hesaplamak i\u00e7in <strong>=ORTALAMA(Aral\u0131k)<\/strong> i\u015flevini kullanabiliriz; burada <em>Aral\u0131k<\/em> , de\u011ferlerin aral\u0131\u011f\u0131d\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bir veri k\u00fcmesinin <strong>standart sapmas\u0131n\u0131<\/strong> hesaplamak i\u00e7in <strong>=STDSAPMA.S(Aral\u0131k)<\/strong> i\u015flevini kullanabiliriz; burada <em>Aral\u0131k<\/em> , de\u011ferlerin aral\u0131\u011f\u0131d\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu e\u011fitimde bu i\u015flevlerin pratikte nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>Teknik notlar<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>STDSAPMA()<\/strong> ve <strong>STDEV.S()<\/strong> i\u015flevleri <em>\u00f6rnek<\/em> standart sapmas\u0131n\u0131 hesaplar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Veri k\u00fcmeniz de\u011fer pop\u00fclasyonunun tamam\u0131n\u0131 temsil ediyorsa <em>pop\u00fclasyon<\/em> standart sapmas\u0131n\u0131 hesaplamak i\u00e7in STDEV.P() i\u015flevini kullanabilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ancak \u00e7o\u011fu durumda pop\u00fclasyonun tamam\u0131 yerine veri \u00f6rnekleriyle \u00e7al\u0131\u015f\u0131yoruz, bu nedenle STDEV.S() i\u015flevini kullan\u0131yoruz.<\/span><\/p>\n<\/blockquote>\n<h3> <span style=\"color: #000000;\"><strong>\u00d6rnek 1: Tek bir veri setinin ortalamas\u0131 ve standart sapmas\u0131<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc,<\/span> <span style=\"color: #000000;\">Excel&#8217;de tek bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12564 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mean_sd_excel1.png\" alt=\"Excel'de ortalama ve standart sapma\" width=\"523\" height=\"484\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Veri setinin ortalamas\u0131 <strong>16,4<\/strong> , standart sapmas\u0131 ise <strong>9,13&#8217;t\u00fcr<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>\u00d6rnek 2: \u00c7oklu veri setlerinin ortalama ve standart sapmas\u0131<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Excel&#8217;de birden fazla veri k\u00fcmemiz oldu\u011funu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12566 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mean_sd_excel2.png\" alt=\"\" width=\"414\" height=\"477\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u0130lk veri setinin ortalamas\u0131n\u0131 ve standart sapmas\u0131n\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki iki form\u00fcl\u00fc kullanabiliriz:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Ortalama:<\/strong> = ORTALAMA (B2:B21)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Standart sapma:<\/strong> =STDEV.S(B2:B21)<\/span> <\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12567 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mean_sd_excel3.png\" alt=\"\" width=\"370\" height=\"512\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra B22:B23 h\u00fccrelerini vurgulayabilir ve k\u00fc\u00e7\u00fck bir <strong>+<\/strong> g\u00f6r\u00fcnene kadar B23 h\u00fccresinin sa\u011f alt k\u00f6\u015fesinin \u00fczerinde gezinebiliriz. Daha sonra form\u00fclleri t\u0131klay\u0131p a\u015fa\u011f\u0131daki iki s\u00fctuna s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12568 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mean_sd_excel4.png\" alt=\"Excel'deki birden fazla veri k\u00fcmesinin ortalamas\u0131 ve standart sapmas\u0131\" width=\"426\" height=\"501\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/tr\/bes-haneli-ozgecmis-excel\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de Be\u015f Say\u0131n\u0131n \u00d6zeti Nas\u0131l Hesaplan\u0131r<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/ceyrekler-arasi-aralik-excel\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de \u00c7eyrekler Aras\u0131 Aral\u0131k (IQR) Nas\u0131l Hesaplan\u0131r?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-standart-hatasi\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de Ortalaman\u0131n Standart Hatas\u0131 Nas\u0131l Hesaplan\u0131r?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ortalama, bir veri k\u00fcmesindeki ortalama de\u011feri temsil eder. Bu bize bir veri setinin merkezinin nerede oldu\u011funa dair iyi bir fikir verir. Standart sapma, bir veri setindeki de\u011ferlerin da\u011f\u0131l\u0131m\u0131n\u0131 temsil eder. Bu bize g\u00f6zlemlerin ortalama etraf\u0131nda ne kadar yak\u0131n k\u00fcmelendi\u011fine dair bir fikir verir. Yaln\u0131zca bu iki de\u011feri kullanarak bir veri k\u00fcmesindeki de\u011ferlerin da\u011f\u0131l\u0131m\u0131 hakk\u0131nda pek [&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-1279","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 ve Standart Sapma Nas\u0131l Hesaplan\u0131r - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel&#039;de bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 \u00f6rneklerle 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-ve-standart-sapma\/\" \/>\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 ve Standart Sapma Nas\u0131l Hesaplan\u0131r - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel&#039;de bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excelde-ortalama-ve-standart-sapma\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T01:05:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mean_sd_excel1.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\/excelde-ortalama-ve-standart-sapma\/\",\"url\":\"https:\/\/statorials.org\/tr\/excelde-ortalama-ve-standart-sapma\/\",\"name\":\"Excel&#39;de Ortalama ve Standart Sapma Nas\u0131l Hesaplan\u0131r - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-27T01:05:06+00:00\",\"dateModified\":\"2023-07-27T01:05:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, Excel&#39;de bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excelde-ortalama-ve-standart-sapma\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excelde-ortalama-ve-standart-sapma\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excelde-ortalama-ve-standart-sapma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de ortalama ve standart sapma 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 ve Standart Sapma Nas\u0131l Hesaplan\u0131r - Statorials","description":"Bu e\u011fitimde, Excel&#39;de bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 \u00f6rneklerle 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-ve-standart-sapma\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Ortalama ve Standart Sapma Nas\u0131l Hesaplan\u0131r - Statorials","og_description":"Bu e\u011fitimde, Excel&#39;de bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excelde-ortalama-ve-standart-sapma\/","og_site_name":"Statorials","article_published_time":"2023-07-27T01:05:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mean_sd_excel1.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\/excelde-ortalama-ve-standart-sapma\/","url":"https:\/\/statorials.org\/tr\/excelde-ortalama-ve-standart-sapma\/","name":"Excel&#39;de Ortalama ve Standart Sapma Nas\u0131l Hesaplan\u0131r - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-27T01:05:06+00:00","dateModified":"2023-07-27T01:05:06+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, Excel&#39;de bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 \u00f6rneklerle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excelde-ortalama-ve-standart-sapma\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excelde-ortalama-ve-standart-sapma\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excelde-ortalama-ve-standart-sapma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de ortalama ve standart sapma 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\/1279","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=1279"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/1279\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=1279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=1279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=1279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}