{"id":929,"date":"2023-07-28T07:03:04","date_gmt":"2023-07-28T07:03:04","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-standart-hatasi\/"},"modified":"2023-07-28T07:03:04","modified_gmt":"2023-07-28T07:03:04","slug":"excel-standart-hatasi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-standart-hatasi\/","title":{"rendered":"Excel&#39;de ortalaman\u0131n standart hatas\u0131 nas\u0131l hesaplan\u0131r?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Ortalaman\u0131n standart hatas\u0131,<\/strong> bir veri k\u00fcmesindeki de\u011ferlerin da\u011f\u0131l\u0131m\u0131n\u0131 \u00f6l\u00e7menin bir yoludur. A\u015fa\u011f\u0131daki \u015fekilde hesaplan\u0131r:<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">Standart hata = s \/ \u221an<\/span><\/strong><\/p>\n<p> <span style=\"color: #000000;\">Alt\u0131n:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>s<\/strong> : numune standart sapmas\u0131<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n<\/strong> : \u00f6rneklem b\u00fcy\u00fckl\u00fc\u011f\u00fc<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanarak Excel&#8217;deki herhangi bir veri k\u00fcmesinin ortalamas\u0131n\u0131n standart hatas\u0131n\u0131 hesaplayabilirsiniz:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>= <span style=\"color: #3366ff;\">STDSAPMA<\/span> (de\u011fer aral\u0131\u011f\u0131) \/ <span style=\"color: #3366ff;\">SQRT<\/span> ( <span style=\"color: #3366ff;\">COUNT<\/span> (de\u011fer aral\u0131\u011f\u0131))<\/strong><\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnek bu form\u00fcl\u00fcn nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>\u00d6rnek: Excel&#8217;de standart hata<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki veri setine sahip oldu\u011fumuzu varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9840 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreur_standard_excel1.png\" alt=\"\" width=\"451\" height=\"485\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu veri k\u00fcmesi i\u00e7in ortalaman\u0131n standart hatas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9841 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standard_error_excel2.png\" alt=\"Excel'de ortalaman\u0131n standart hatas\u0131\" width=\"480\" height=\"450\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Standart hatan\u0131n <strong>2,0014<\/strong> oldu\u011fu ortaya \u00e7\u0131kt\u0131.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>=STDEV()<\/strong> i\u015flevinin \u00f6rnek ortalamay\u0131 hesaplad\u0131\u011f\u0131n\u0131 unutmay\u0131n; bu, Excel&#8217;deki <strong>=STDEV.S()<\/strong> i\u015flevine e\u015fde\u011ferdir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dolay\u0131s\u0131yla ayn\u0131 sonu\u00e7lar\u0131 elde etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirdik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9843 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standard_error_excel3.png\" alt=\"\u00d6rnek standart sapma kullan\u0131larak Excel'de ortalaman\u0131n standart hatas\u0131\" width=\"501\" height=\"500\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bir kez daha standart hatan\u0131n <strong>2,0014<\/strong> oldu\u011fu ortaya \u00e7\u0131kt\u0131.<\/span><\/p>\n<h3> <strong>Ortalaman\u0131n standart hatas\u0131 nas\u0131l yorumlan\u0131r?<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Ortalaman\u0131n standart hatas\u0131 basit\u00e7e de\u011ferlerin ortalama etraf\u0131ndaki yay\u0131l\u0131m\u0131n\u0131n bir \u00f6l\u00e7\u00fcs\u00fcd\u00fcr. Ortalaman\u0131n standart hatas\u0131n\u0131 yorumlarken ak\u0131lda tutulmas\u0131 gereken iki \u015fey vard\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. Ortalaman\u0131n standart hatas\u0131 ne kadar b\u00fcy\u00fck olursa, bir veri setinde de\u011ferler ortalaman\u0131n etraf\u0131nda o kadar da\u011f\u0131n\u0131k olur.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunu g\u00f6stermek i\u00e7in, \u00f6nceki veri k\u00fcmesinin son de\u011ferini \u00e7ok daha b\u00fcy\u00fck bir say\u0131yla de\u011fi\u015ftirip de\u011fi\u015ftirmedi\u011fimizi d\u00fc\u015f\u00fcn\u00fcn:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9844 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standard_error_excel4.png\" alt=\"\" width=\"489\" height=\"499\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Standart hatan\u0131n <strong>2,0014&#8217;ten<\/strong> <strong>6,9783&#8217;e<\/strong> nas\u0131l y\u00fckseldi\u011fine dikkat edin. Bu durum, bu veri setindeki de\u011ferlerin \u00f6nceki veri setine g\u00f6re ortalama etraf\u0131nda daha fazla da\u011f\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6stermektedir.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2. \u00d6rneklem b\u00fcy\u00fckl\u00fc\u011f\u00fc artt\u0131k\u00e7a ortalaman\u0131n standart hatas\u0131 azalma e\u011filimindedir.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunu g\u00f6stermek i\u00e7in a\u015fa\u011f\u0131daki iki veri k\u00fcmesinin ortalaman\u0131n standart hatas\u0131n\u0131 d\u00fc\u015f\u00fcn\u00fcn:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9845 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/standard_error_excel5.png\" alt=\"\" width=\"427\" height=\"454\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u0130kinci veri seti basit\u00e7e iki kez tekrarlanan ilk veri setidir. Yani her iki veri seti de ayn\u0131 ortalamaya sahiptir ancak ikinci veri seti daha b\u00fcy\u00fck bir \u00f6rneklem boyutuna sahiptir ve dolay\u0131s\u0131yla standart hatas\u0131 daha k\u00fc\u00e7\u00fckt\u00fcr.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ortalaman\u0131n standart hatas\u0131, bir veri k\u00fcmesindeki de\u011ferlerin da\u011f\u0131l\u0131m\u0131n\u0131 \u00f6l\u00e7menin bir yoludur. A\u015fa\u011f\u0131daki \u015fekilde hesaplan\u0131r: Standart hata = s \/ \u221an Alt\u0131n: s : numune standart sapmas\u0131 n : \u00f6rneklem b\u00fcy\u00fckl\u00fc\u011f\u00fc A\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanarak Excel&#8217;deki herhangi bir veri k\u00fcmesinin ortalamas\u0131n\u0131n standart hatas\u0131n\u0131 hesaplayabilirsiniz: = STDSAPMA (de\u011fer aral\u0131\u011f\u0131) \/ SQRT ( COUNT (de\u011fer aral\u0131\u011f\u0131)) A\u015fa\u011f\u0131daki \u00f6rnek bu [&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-929","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 Ortalaman\u0131n Standart Hatas\u0131 Nas\u0131l Hesaplan\u0131r?<\/title>\n<meta name=\"description\" content=\"Ortalaman\u0131n standart hatas\u0131n\u0131n Excel&#039;de nas\u0131l hesaplanaca\u011f\u0131na dair bir \u00f6rnekle basit bir a\u00e7\u0131klama.\" \/>\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\/excel-standart-hatasi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Ortalaman\u0131n Standart Hatas\u0131 Nas\u0131l Hesaplan\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Ortalaman\u0131n standart hatas\u0131n\u0131n Excel&#039;de nas\u0131l hesaplanaca\u011f\u0131na dair bir \u00f6rnekle basit bir a\u00e7\u0131klama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-standart-hatasi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T07:03:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreur_standard_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\/excel-standart-hatasi\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-standart-hatasi\/\",\"name\":\"Excel&#39;de Ortalaman\u0131n Standart Hatas\u0131 Nas\u0131l Hesaplan\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-28T07:03:04+00:00\",\"dateModified\":\"2023-07-28T07:03:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Ortalaman\u0131n standart hatas\u0131n\u0131n Excel&#39;de nas\u0131l hesaplanaca\u011f\u0131na dair bir \u00f6rnekle basit bir a\u00e7\u0131klama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-standart-hatasi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-standart-hatasi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-standart-hatasi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de ortalaman\u0131n standart hatas\u0131 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 Ortalaman\u0131n Standart Hatas\u0131 Nas\u0131l Hesaplan\u0131r?","description":"Ortalaman\u0131n standart hatas\u0131n\u0131n Excel&#39;de nas\u0131l hesaplanaca\u011f\u0131na dair bir \u00f6rnekle basit bir a\u00e7\u0131klama.","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\/excel-standart-hatasi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Ortalaman\u0131n Standart Hatas\u0131 Nas\u0131l Hesaplan\u0131r?","og_description":"Ortalaman\u0131n standart hatas\u0131n\u0131n Excel&#39;de nas\u0131l hesaplanaca\u011f\u0131na dair bir \u00f6rnekle basit bir a\u00e7\u0131klama.","og_url":"https:\/\/statorials.org\/tr\/excel-standart-hatasi\/","og_site_name":"Statorials","article_published_time":"2023-07-28T07:03:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreur_standard_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\/excel-standart-hatasi\/","url":"https:\/\/statorials.org\/tr\/excel-standart-hatasi\/","name":"Excel&#39;de Ortalaman\u0131n Standart Hatas\u0131 Nas\u0131l Hesaplan\u0131r?","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-28T07:03:04+00:00","dateModified":"2023-07-28T07:03:04+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Ortalaman\u0131n standart hatas\u0131n\u0131n Excel&#39;de nas\u0131l hesaplanaca\u011f\u0131na dair bir \u00f6rnekle basit bir a\u00e7\u0131klama.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-standart-hatasi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-standart-hatasi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-standart-hatasi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de ortalaman\u0131n standart hatas\u0131 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\/929","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=929"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/929\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}