{"id":3212,"date":"2023-07-18T16:04:25","date_gmt":"2023-07-18T16:04:25","guid":{"rendered":"https:\/\/statorials.org\/tr\/google-e-tablolarda-ortalama-ve-standart-sapma\/"},"modified":"2023-07-18T16:04:25","modified_gmt":"2023-07-18T16:04:25","slug":"google-e-tablolarda-ortalama-ve-standart-sapma","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/google-e-tablolarda-ortalama-ve-standart-sapma\/","title":{"rendered":"Google e-tablolarda 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\/ortalamanin-onemi\/\" 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;\"><a href=\"https:\/\/statorials.org\/tr\/standart-sapma-neden-onemlidir\/\" target=\"_blank\" rel=\"noopener\">Standart sapma,<\/a> 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;\">Google E-Tablolar&#8217;daki 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\u011fer 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, Google E-Tablolar&#8217;da 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-27280\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/signifie-tdev1.jpg\" alt=\"Google E-Tablolarda ortalama ve standart sapma\" width=\"606\" height=\"502\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Veri setinin ortalamas\u0131 <strong>16,4<\/strong> , standart sapmas\u0131 ise <strong>9,127&#8217;dir<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">S\u00fctun <strong>E,<\/strong> veri setinin hem ortalamas\u0131n\u0131 hem de standart sapmas\u0131n\u0131 hesaplamak i\u00e7in kulland\u0131\u011f\u0131m\u0131z form\u00fclleri g\u00f6sterir.<\/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;\">Diyelim ki Google E-Tablolar&#8217;da birden fazla veri k\u00fcmemiz var<\/span> <span style=\"color: #000000;\">:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27281 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/signifie-tdev2.jpg\" alt=\"\" width=\"519\" height=\"486\" 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=\" wp-image-27282 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/signifie-tdev3.jpg\" alt=\"\" width=\"444\" height=\"522\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra B22:B23 h\u00fccrelerini vurgulayabilir ve form\u00fclleri sonraki iki s\u00fctuna s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27283 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/signifie-tdev4.jpg\" alt=\"\" width=\"460\" height=\"515\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Sonu\u00e7lar, \u00fc\u00e7 veri setinin her biri i\u00e7in ortalamay\u0131 ve standart sapmay\u0131 g\u00f6sterir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Google E-Tablolar&#8217;da di\u011fer yayg\u0131n g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/ceyrekler-arasi-aralik-google-sayfalari\/\" target=\"_blank\" rel=\"noopener\">Google E-Tablolarda \u00c7eyrekler Aras\u0131 Aral\u0131k Nas\u0131l Hesaplan\u0131r?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/bes-basamakli-ozgecmis-google-sayfalari\/\" target=\"_blank\" rel=\"noopener\">Google E-Tablolar&#8217;da be\u015f basamakl\u0131 bir \u00f6zet nas\u0131l hesaplan\u0131r?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/google-e-tablolar-ilk-yuzde-10da\/\" target=\"_blank\" rel=\"noopener\">Google E-Tablolar&#8217;da ilk %10&#8217;luk de\u011ferler nas\u0131l bulunur?<\/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-3212","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>Google E-Tablolarda Ortalama ve Standart Sapma Nas\u0131l Hesaplan\u0131r - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Google E-Tablolar&#039;daki bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 bir \u00f6rnekle 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\/google-e-tablolarda-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=\"Google E-Tablolarda Ortalama ve Standart Sapma Nas\u0131l Hesaplan\u0131r - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Google E-Tablolar&#039;daki bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/google-e-tablolarda-ortalama-ve-standart-sapma\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T16:04:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/signifie-tdev1.jpg\" \/>\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\/google-e-tablolarda-ortalama-ve-standart-sapma\/\",\"url\":\"https:\/\/statorials.org\/tr\/google-e-tablolarda-ortalama-ve-standart-sapma\/\",\"name\":\"Google E-Tablolarda Ortalama ve Standart Sapma Nas\u0131l Hesaplan\u0131r - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-18T16:04:25+00:00\",\"dateModified\":\"2023-07-18T16:04:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, Google E-Tablolar&#39;daki bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/google-e-tablolarda-ortalama-ve-standart-sapma\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/google-e-tablolarda-ortalama-ve-standart-sapma\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/google-e-tablolarda-ortalama-ve-standart-sapma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google e-tablolarda 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":"Google E-Tablolarda Ortalama ve Standart Sapma Nas\u0131l Hesaplan\u0131r - Statorials","description":"Bu e\u011fitimde, Google E-Tablolar&#39;daki bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 bir \u00f6rnekle 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\/google-e-tablolarda-ortalama-ve-standart-sapma\/","og_locale":"tr_TR","og_type":"article","og_title":"Google E-Tablolarda Ortalama ve Standart Sapma Nas\u0131l Hesaplan\u0131r - Statorials","og_description":"Bu e\u011fitimde, Google E-Tablolar&#39;daki bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/google-e-tablolarda-ortalama-ve-standart-sapma\/","og_site_name":"Statorials","article_published_time":"2023-07-18T16:04:25+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/signifie-tdev1.jpg"}],"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\/google-e-tablolarda-ortalama-ve-standart-sapma\/","url":"https:\/\/statorials.org\/tr\/google-e-tablolarda-ortalama-ve-standart-sapma\/","name":"Google E-Tablolarda Ortalama ve Standart Sapma Nas\u0131l Hesaplan\u0131r - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-18T16:04:25+00:00","dateModified":"2023-07-18T16:04:25+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, Google E-Tablolar&#39;daki bir veri k\u00fcmesinin ortalama ve standart sapmas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/google-e-tablolarda-ortalama-ve-standart-sapma\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/google-e-tablolarda-ortalama-ve-standart-sapma\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/google-e-tablolarda-ortalama-ve-standart-sapma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Google e-tablolarda 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\/3212","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=3212"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3212\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=3212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=3212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=3212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}