{"id":15372,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/sapkare\/"},"modified":"2021-02-25T16:25:51","modified_gmt":"2021-02-25T16:25:51","slug":"devsq","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/devsq\/","title":{"rendered":"SAPKARE"},"content":{"rendered":"

Microsoft Excel ve Google Sheets’te DEVSQ<\/code> (T\u00fcrk\u00e7e’de SAPKARE<\/code> olarak bilinir) fonksiyonu, bir say\u0131 dizisinin her bir de\u011ferinin ortalamadan sapmalar\u0131n\u0131n karelerinin toplam\u0131n\u0131 hesaplayan bir istatistiksel fonksiyondur. Bu fonksiyon, veri da\u011f\u0131l\u0131m\u0131n\u0131n analizinde kullan\u0131l\u0131r ve veri setinin varyans\u0131n\u0131n hesaplanmas\u0131nda kritik bir \u00f6neme sahiptir.<\/p>\n

SAPKARE<\/code> Fonksiyonunun S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

SAPKARE<\/code> fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

 SAPKARE(num1; [num2]; ...)<\/code> <\/pre>\n
    \n
  • num1, num2, ...<\/code> – Fonksiyonun karelerini hesaplayaca\u011f\u0131 bir veya daha fazla say\u0131 veya h\u00fccre aral\u0131\u011f\u0131. H\u00fccre aral\u0131klar\u0131 (\u00f6rne\u011fin, A1:A10) kullan\u0131labilir ve virg\u00fclle ayr\u0131lan birden fazla say\u0131 veya aral\u0131k belirtilebilir.<\/li>\n<\/ul>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    SAPKARE<\/code> fonksiyonu, \u00f6zellikle istatistik ve veri analizlerinde de\u011ferlidir. \u0130\u015fte bu fonksiyonun uygulanabilece\u011fi iki pratik senaryo:<\/p>\n
    \u00d6rnek 1: \u00d6\u011frenci S\u0131nav Puanlar\u0131n\u0131n Sapma Karelerinin Hesaplanmas\u0131<\/h2>\n
    Bir \u00f6\u011fretmen, s\u0131n\u0131f\u0131ndaki \u00f6\u011frencilerin matematik s\u0131nav sonu\u00e7lar\u0131n\u0131n da\u011f\u0131l\u0131m\u0131n\u0131 analiz etmek istiyor. \u00d6\u011frencilerin puanlar\u0131 A2:A11 h\u00fccrelerinde listelenmi\u015ftir ve \u00f6\u011fretmen bu puanlar\u0131n ortalama de\u011ferden sapmalar\u0131n\u0131n karelerini hesaplamak istiyor.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
    A<\/th>\n<\/tr>\n
    65<\/td>\n<\/tr>\n
    70<\/td>\n<\/tr>\n
    85<\/td>\n<\/tr>\n
    90<\/td>\n<\/tr>\n
    75<\/td>\n<\/tr>\n
    60<\/td>\n<\/tr>\n
    95<\/td>\n<\/tr>\n
    80<\/td>\n<\/tr>\n
    90<\/td>\n<\/tr>\n
    85<\/td>\n<\/tr>\n<\/table>\n
    =SAPKARE(A2:A11)<\/code><\/pre>\n
    Bu form\u00fcl, \u00f6\u011frencilerin puanlar\u0131n\u0131n ortalamadan her bir sapman\u0131n karesini hesaplar, ve bu karelerin toplam\u0131n\u0131 verir. Bu de\u011fer, puan da\u011f\u0131l\u0131m\u0131n\u0131n genelini anlamak i\u00e7in kullan\u0131labilir.<\/p>\n
    \u00d6rnek 2: \u00dcr\u00fcn Sat\u0131\u015f Miktarlar\u0131n\u0131n De\u011fi\u015fkenli\u011finin Analizi<\/h2>\n
    Bir \u015firket, \u00e7e\u015fitli \u00fcr\u00fcnlerin ayl\u0131k sat\u0131\u015f miktarlar\u0131n\u0131 incelemek ve bu veriler \u00fczerinden sat\u0131\u015flar\u0131n de\u011fi\u015fkenli\u011fine dair bilgi sahibi olmak istiyor. Sat\u0131\u015f verileri B2:B13 h\u00fccrelerinde yer al\u0131yor.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    B<\/th>\n<\/tr>\n
    120<\/td>\n<\/tr>\n
    130<\/td>\n<\/tr>\n
    125<\/td>\n<\/tr>\n
    140<\/td>\n<\/tr>\n
    135<\/td>\n<\/tr>\n
    150<\/td>\n<\/tr>\n
    145<\/td>\n<\/tr>\n
    155<\/td>\n<\/tr>\n
    160<\/td>\n<\/tr>\n
    165<\/td>\n<\/tr>\n
    170<\/td>\n<\/tr>\n
    175<\/td>\n<\/tr>\n<\/table>\n
    =SAPKARE(B2:B13)<\/code><\/pre>\n
    Bu form\u00fcl, sat\u0131\u015f miktarlar\u0131n\u0131n ortalamadan her bir sapman\u0131n karesini hesaplar ve bu de\u011ferlerin toplam\u0131n\u0131 sunar. Elde edilen toplam de\u011fer, sat\u0131\u015f miktarlar\u0131n\u0131n ayl\u0131k de\u011fi\u015fkenli\u011fini g\u00f6sterir ve stratejik kararlar i\u00e7in \u00f6nemli bir referans olabilir.<\/p>\n
    G\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere, SAPKARE<\/code> fonksiyonu veri setlerinin yay\u0131l\u0131m\u0131n\u0131 \u00f6l\u00e7mekte ve risk de\u011ferlendirmeleri, performans analizleri gibi \u00e7e\u015fitli analizlerde kullan\u0131lmak \u00fczere b\u00fcy\u00fck fayda sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Sapmalar\u0131n karelerinin toplam\u0131n\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[582],"tags":[],"class_list":["post-15372","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de DEVSQ (SAPKARE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DEVSQ (SAPKARE) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/devsq\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DEVSQ (SAPKARE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DEVSQ (SAPKARE) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/devsq\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:25:51+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de DEVSQ (SAPKARE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\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:\/\/functiontranslator.com\/tr\/devsq\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/devsq\/\",\"name\":\"Excel'de DEVSQ (SAPKARE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:25:51+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DEVSQ (SAPKARE) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/devsq\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/devsq\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/devsq\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0130statistik\",\"item\":\"https:\/\/functiontranslator.com\/tr\/istatistik\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SAPKARE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de DEVSQ (SAPKARE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DEVSQ (SAPKARE) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/devsq\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DEVSQ (SAPKARE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DEVSQ (SAPKARE) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/devsq\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:25:51+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DEVSQ (SAPKARE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/devsq\/","url":"https:\/\/functiontranslator.com\/tr\/devsq\/","name":"Excel'de DEVSQ (SAPKARE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:25:51+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DEVSQ (SAPKARE) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/devsq\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/devsq\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/devsq\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"\u0130statistik","item":"https:\/\/functiontranslator.com\/tr\/istatistik\/"},{"@type":"ListItem","position":3,"name":"SAPKARE"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15372","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15372"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15372\/revisions"}],"predecessor-version":[{"id":26640,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15372\/revisions\/26640"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}