{"id":15705,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/vars\/"},"modified":"2021-02-25T16:38:47","modified_gmt":"2021-02-25T16:38:47","slug":"varp","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/varp\/","title":{"rendered":"VARS"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, i\u015f d\u00fcnyas\u0131 ve e\u011fitim sekt\u00f6r\u00fcnde yayg\u0131n olarak kullan\u0131lan iki \u00f6nde gelen elektronik tablo uygulamas\u0131d\u0131r. Bu platformlar, veri analizi, hesaplama ve raporlama i\u00e7in geni\u015f bir fonksiyon yelpazesi sunar. Bu fonksiyonlardan biri olan VARP (Excel’de) ve VARS (Google Sheets’te), bir veri k\u00fcmesinin varyans\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu yaz\u0131da, bu fonksiyonlar\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 detayl\u0131 bir \u015fekilde anlatarak \u00f6rnekler sunaca\u011f\u0131z.<\/p>\n

S\u00f6zdizimi ve Genel Kullan\u0131m<\/h2>\n

VARP ve VARS fonksiyonlar\u0131, bir pop\u00fclasyonun t\u00fcm\u00fc i\u00e7in varyans hesaplar. Bu fonksiyonlar\u0131n kullan\u0131m s\u00f6zdizimleri a\u015fa\u011f\u0131daki gibidir:<\/p>\n

VARP(number1, [number2], ...) VARS(number1, [number2], ...)<\/code><\/pre>\n
Bu yap\u0131lar\u0131n a\u00e7\u0131klamas\u0131 \u015fu \u015fekildedir:<\/p>\n
    \n
  • number1, number2, ...<\/code> – Veri setini olu\u015fturan say\u0131lar, sabit de\u011ferler, h\u00fccre referanslar\u0131 ya da h\u00fccre aral\u0131klar\u0131 olabilir.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m:<\/p>\n
    =VARP(4, 5, 7, 9) \/\/ Excel =VARS(4, 5, 7, 9) \/\/ Google Sheets<\/code><\/pre>\n
    Pratik Uygulamalar<\/h2>\n
    1. \u0130\u015fletme Performans De\u011ferlendirmesi<\/h2>\n
    Bir i\u015fletmenin ayl\u0131k sat\u0131\u015f performans\u0131ndaki dalgalanmalar\u0131 de\u011ferlendirmek i\u00e7in Excel’deki VARP veya Google Sheets’teki VARS fonksiyonlar\u0131 kullan\u0131labilir. \u00d6rnek olarak, bir i\u015fletmenin son alt\u0131 aydaki sat\u0131\u015f verileri \u015f\u00f6yledir:<\/p>\n\n\n\n\n\n\n\n\n
    Ay<\/th>\nSat\u0131\u015flar (Bin TL)<\/th>\n<\/tr>\n
    Ocak<\/td>\n120<\/td>\n<\/tr>\n
    \u015eubat<\/td>\n150<\/td>\n<\/tr>\n
    Mart<\/td>\n130<\/td>\n<\/tr>\n
    Nisan<\/td>\n160<\/td>\n<\/tr>\n
    May\u0131s<\/td>\n140<\/td>\n<\/tr>\n
    Haziran<\/td>\n190<\/td>\n<\/tr>\n<\/table>\n
    Excel’de varyans hesaplama form\u00fcl\u00fc:<\/p>\n
    =VARP(B2:B7)<\/code><\/pre>\n
    Google Sheets’te varyans hesaplama form\u00fcl\u00fc:<\/p>\n
    =VARS(B2:B7)<\/code><\/pre>\n
    Bu hesaplama, ayl\u0131k sat\u0131\u015flar\u0131n ne kadar dalgal\u0131 oldu\u011funu g\u00f6sterir ve bu bilgiler finansal planlamada kullan\u0131labilir.<\/p>\n
    2. E\u011fitim Kurumlar\u0131nda Notlar\u0131n Analizi<\/h2>\n
    E\u011fitim kurumlar\u0131, \u00f6\u011frencilerin not da\u011f\u0131l\u0131mlar\u0131n\u0131 analiz etmek i\u00e7in VARP veya VARS fonksiyonunu kullanabilir. A\u015fa\u011f\u0131da bir s\u0131n\u0131f\u0131n matematik notlar\u0131 verilmi\u015ftir:<\/p>\n\n\n\n\n\n\n\n
    \u00d6\u011frenci<\/th>\nNot<\/th>\n<\/tr>\n
    \u00d6\u011frenci 1<\/td>\n70<\/td>\n<\/tr>\n
    \u00d6\u011frenci 2<\/td>\n82<\/td>\n<\/tr>\n
    \u00d6\u011frenci 3<\/td>\n75<\/td>\n<\/tr>\n
    \u00d6\u011frenci 4<\/td>\n90<\/td>\n<\/tr>\n
    \u00d6\u011frenci 5<\/td>\n65<\/td>\n<\/tr>\n<\/table>\n
    Excel’de varyans hesaplama form\u00fcl\u00fc:<\/p>\n
    =VARP(B2:B6)<\/code><\/pre>\n
    Google Sheets’te varyans hesaplama form\u00fcl\u00fc:<\/p>\n
    =VARS(B2:B6)<\/code><\/pre>\n
    Bu analiz y\u00f6ntemi, \u00f6\u011frenciler aras\u0131ndaki ba\u015far\u0131 farklar\u0131 hakk\u0131nda fikir vererek e\u011fitim stratejilerinin geli\u015ftirilmesine katk\u0131da bulunabilir.<\/p>\n
    Bu bilgiler, Excel ve Google Sheets kullanarak derinlemesine analiz yapman\u0131z\u0131 sa\u011flar ve kritik kararlar alman\u0131zda rehberlik eder.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Varyans\u0131 t\u00fcm pop\u00fclasyona dayanarak hesaplar<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[584],"tags":[],"class_list":["post-15705","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de VARP (VARS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da VARP (VARS) 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\/varp\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de VARP (VARS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da VARP (VARS) 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\/varp\/\" \/>\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:38:47+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 VARP (VARS) 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\/varp\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/varp\/\",\"name\":\"Excel'de VARP (VARS) 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:38:47+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da VARP (VARS) 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\/varp\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/varp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/varp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uyumluluk\",\"item\":\"https:\/\/functiontranslator.com\/tr\/uyumluluk\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VARS\"}]},{\"@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 VARP (VARS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da VARP (VARS) 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\/varp\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de VARP (VARS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da VARP (VARS) 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\/varp\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:38:47+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de VARP (VARS) 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\/varp\/","url":"https:\/\/functiontranslator.com\/tr\/varp\/","name":"Excel'de VARP (VARS) 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:38:47+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da VARP (VARS) 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\/varp\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/varp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/varp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Uyumluluk","item":"https:\/\/functiontranslator.com\/tr\/uyumluluk\/"},{"@type":"ListItem","position":3,"name":"VARS"}]},{"@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\/15705","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=15705"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15705\/revisions"}],"predecessor-version":[{"id":26973,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15705\/revisions\/26973"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}