{"id":15382,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/vsecstdsapmas\/"},"modified":"2021-02-25T16:26:07","modified_gmt":"2021-02-25T16:26:07","slug":"dstdevp","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/dstdevp\/","title":{"rendered":"VSE\u00c7STDSAPMAS"},"content":{"rendered":"

Microsoft Excel ve Google Tablolar, veri analizi konusunda g\u00fc\u00e7l\u00fc ara\u00e7lar sunar. Bu ara\u00e7larda bulunan \u00e7ok say\u0131da fonksiyon, i\u015f verileri \u00fczerinde \u00e7e\u015fitli hesaplamalar yapmam\u0131za olanak sa\u011flar. Bu makalede, “VSE\u00c7STDSAPMAS” fonksiyonunun nas\u0131l kullan\u0131ld\u0131\u011f\u0131n\u0131 ve bu fonksiyonun pratikte nas\u0131l uygulanabilece\u011fini \u00f6rneklerle inceleyece\u011fiz.<\/p>\n

Fonksiyonun Genel Tan\u0131m\u0131 ve S\u00f6z Dizimi<\/h2>\n

“VSE\u00c7STDSAPMAS” ya da bilinen di\u011fer ad\u0131yla “DSTDEVP” fonksiyonu, verilen bir kriteri kar\u015f\u0131layan de\u011ferler i\u00e7in \u00f6rneklem n\u00fcfus sapmas\u0131n\u0131 hesaplar. \u00d6zellikle b\u00fcy\u00fck veri setleri \u00fczerinde \u00f6zel ko\u015fullara g\u00f6re istatistiksel analiz yapmak isteyenler i\u00e7in olduk\u00e7a faydal\u0131 bir fonksiyondur.<\/p>\n

S\u00f6z Dizimi: 
VSE\u00c7STDSAPMAS(veri_alan\u0131, alan_ad\u0131, kriterler)<\/code><\/pre>\n
    \n
  • veri_alan\u0131<\/code>: \u0130\u015flenmek \u00fczere olan veri aral\u0131\u011f\u0131n\u0131 belirtir.<\/li>\n
  • alan_ad\u0131<\/code>: Hesaplaman\u0131n yap\u0131laca\u011f\u0131 s\u00fctunun ad\u0131 ya da s\u00fctun index'inin belirtildi\u011fi b\u00f6l\u00fcm.<\/li>\n
  • kriterler<\/code>: Hesaplama yap\u0131lmadan \u00f6nce uygulanmas\u0131 gereken kriterlerin belirtildi\u011fi aral\u0131k.<\/li>\n<\/ul>\n
    \u00d6rnek Uygulamalar<\/h2>\n
    A\u015fa\u011f\u0131da, \"VSE\u00c7STDSAPMAS\" fonksiyonunun \u00e7e\u015fitli durumlarda nas\u0131l kullan\u0131laca\u011f\u0131 ile ilgili \u00f6rnekler verilmi\u015ftir.<\/p>\n
    \u00d6rnek 1: Sat\u0131\u015f Verileri \u00dczerinde Analiz<\/h3>\n
    Bir perakende ma\u011fazas\u0131n\u0131n y\u0131ll\u0131k sat\u0131\u015f verileri \u00fczerinde, belirli bir \u00fcr\u00fcn kategorisi i\u00e7in standart sapma hesaplamak istiyoruz. \u00dcr\u00fcn kategorisi olarak \"Elektronik\" se\u00e7ildi\u011finde, bu kategorideki \u00fcr\u00fcnlerin sat\u0131\u015f adetlerinin standart sapmas\u0131n\u0131 bulal\u0131m.<\/p>\n
    =VSE\u00c7STDSAPMAS(A1:C100, \"Sat\u0131\u015f Adedi\", E1:E2)<\/code><\/pre>\n
      \n
    • A1:C100 aral\u0131\u011f\u0131 t\u00fcm veri setini temsil eder.<\/li>\n
    • \"Sat\u0131\u015f Adedi\" s\u00fctunu hesaplamalar i\u00e7in kullan\u0131lacak olan s\u00fctun.<\/li>\n
    • E1:E2 aral\u0131\u011f\u0131nda \"Kategori\" s\u00fctununda \"Elektronik\" olarak belirlenen kriter bulunmaktad\u0131r. Bu kriter sayesinde sadece \"Elektronik\" kategorisine ait sat\u0131\u015flar dikkate al\u0131nacak.<\/li>\n<\/ul>\n
      \u00d6rnek 2: \u00d6\u011frenci Performans Analizi<\/h3>\n
      Bir okulun s\u0131nav sonu\u00e7lar\u0131 \u00fczerinden, belirli bir s\u0131n\u0131f seviyesindeki \u00f6\u011frencilerin performans standart sapmas\u0131n\u0131 hesaplamak istiyoruz. S\u0131n\u0131f seviyesi olarak \"10. S\u0131n\u0131f\" al\u0131nd\u0131\u011f\u0131nda, bu s\u0131n\u0131fa ait \u00f6\u011frencilerin matematik notlar\u0131n\u0131n standart sapmas\u0131n\u0131 hesaplayal\u0131m.<\/p>\n
      =VSE\u00c7STDSAPMAS(A1:D500, \"Matematik Notu\", G1:G2)<\/code><\/pre>\n
        \n
      • A1:D500 aral\u0131\u011f\u0131 t\u00fcm \u00f6\u011frenci verilerini i\u00e7erir.<\/li>\n
      • \"Mathematik Notu\" s\u00fctunu, hesaplama i\u00e7in kullan\u0131lacak olan s\u00fctundur.<\/li>\n
      • G1:G2 aral\u0131\u011f\u0131nda \"S\u0131n\u0131f\" s\u00fctununda \"10. S\u0131n\u0131f\" olarak belirlenen kriterler bulunmaktad\u0131r. Bu kriterler sayesinde sadece 10. S\u0131n\u0131f \u00f6\u011frencilerinin notlar\u0131 dikkate al\u0131nacakt\u0131r.<\/li>\n<\/ul>\n
        G\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere \"VSE\u00c7STDSAPMAS\" fonksiyonu, veri setleri \u00fczerinde belirli ko\u015fullar alt\u0131nda istatistiksel de\u011ferlendirme yap\u0131lmas\u0131nda olduk\u00e7a etkilidir. Bu fonksiyon sayesinde, daha detayl\u0131 ve ko\u015fullu analizler m\u00fcmk\u00fcn hale gelmektedir.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Standart sapmay\u0131, se\u00e7ili veritaban\u0131 giri\u015flerinin t\u00fcm pop\u00fclasyonunu esas alarak hesaplar<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[589],"tags":[],"class_list":["post-15382","post","type-post","status-publish","format-standard","hentry","category-veritabani"],"acf":[],"yoast_head":"\nExcel'de DSTDEVP (VSE\u00c7STDSAPMAS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DSTDEVP (VSE\u00c7STDSAPMAS) 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\/dstdevp\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DSTDEVP (VSE\u00c7STDSAPMAS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DSTDEVP (VSE\u00c7STDSAPMAS) 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\/dstdevp\/\" \/>\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:26:07+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 DSTDEVP (VSE\u00c7STDSAPMAS) 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\/dstdevp\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/dstdevp\/\",\"name\":\"Excel'de DSTDEVP (VSE\u00c7STDSAPMAS) 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:26:07+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DSTDEVP (VSE\u00c7STDSAPMAS) 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\/dstdevp\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/dstdevp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/dstdevp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Veritaban\u0131\",\"item\":\"https:\/\/functiontranslator.com\/tr\/veritabani\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VSE\u00c7STDSAPMAS\"}]},{\"@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 DSTDEVP (VSE\u00c7STDSAPMAS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DSTDEVP (VSE\u00c7STDSAPMAS) 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\/dstdevp\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DSTDEVP (VSE\u00c7STDSAPMAS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DSTDEVP (VSE\u00c7STDSAPMAS) 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\/dstdevp\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:26:07+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DSTDEVP (VSE\u00c7STDSAPMAS) 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\/dstdevp\/","url":"https:\/\/functiontranslator.com\/tr\/dstdevp\/","name":"Excel'de DSTDEVP (VSE\u00c7STDSAPMAS) 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:26:07+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DSTDEVP (VSE\u00c7STDSAPMAS) 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\/dstdevp\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/dstdevp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/dstdevp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Veritaban\u0131","item":"https:\/\/functiontranslator.com\/tr\/veritabani\/"},{"@type":"ListItem","position":3,"name":"VSE\u00c7STDSAPMAS"}]},{"@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\/15382","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=15382"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15382\/revisions"}],"predecessor-version":[{"id":26650,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15382\/revisions\/26650"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}