{"id":15427,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/siklik\/"},"modified":"2021-02-25T16:27:23","modified_gmt":"2021-02-25T16:27:23","slug":"frequency","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/frequency\/","title":{"rendered":"SIKLIK"},"content":{"rendered":"

Excel ve Google E-Tablolar’da Veri Frekans Analizi<\/h2>\n

Veri setlerinde belirli de\u011ferlerin ne s\u0131kl\u0131kla ortaya \u00e7\u0131kt\u0131\u011f\u0131n\u0131 analiz etmek i\u00e7in, Microsoft Excel ve Google E-Tablolar’da kullan\u0131lan FREQUENCY<\/strong> (SIKLIK) i\u015flevi olduk\u00e7a yararl\u0131d\u0131r. Bu i\u015flev, bir veri dizilimi i\u00e7erisinde, belirli aral\u0131klar\u0131n ka\u00e7 kez tekrar edildi\u011fini belirlemenize olanak tan\u0131r. \u00d6zellikle istatistiksel veri analizi yaparken bu i\u015flev vazge\u00e7ilmezdir.<\/p>\n

S\u00f6zdizimi ve Parametreler<\/h2>\n

SIKLIK i\u015flevinin kullan\u0131m\u0131, hem Excel hem de Google E-Tablolar’da birbirine benzer. Ancak form\u00fcl\u00fc bir dizi olarak girme \u015fekli Excel’de biraz daha farkl\u0131d\u0131r.<\/p>\n

=SIKLIK(data_array, bins_array)<\/code><\/pre>\n
    \n
  • data_array:<\/strong> Frekans\u0131n\u0131 hesaplamak istedi\u011finiz say\u0131sal veriler dizisidir.<\/li>\n
  • bins_array:<\/strong> S\u0131n\u0131f aral\u0131klar\u0131n\u0131 belirten say\u0131sal veriler dizisidir. Bu dizide belirtilen her bir s\u0131n\u0131r de\u011fere kadar olan frekans hesaplan\u0131r.<\/li>\n<\/ul>\n
    Google E-Tablolar’da, formul\u00fc do\u011frudan h\u00fccreye yazarken, tam olarak sonucu g\u00f6rmek ad\u0131na CTRL + SHIFT + ENTER kullanarak matris form\u00fcl\u00fc olarak girmelisiniz. Excel\u2019de ise, form\u00fcl\u00fc girdikten sonra sadece ENTER tu\u015funa basman\u0131z yeterlidir.<\/p>\n
    Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
    \u00d6\u011frenci Not Da\u011f\u0131l\u0131m\u0131n\u0131n Analizi<\/h3>\n
    Bir s\u0131n\u0131ftaki \u00f6\u011frencilerin s\u0131nav sonu\u00e7lar\u0131n\u0131 de\u011ferlendirirken, notlar\u0131n da\u011f\u0131l\u0131m\u0131n\u0131 g\u00f6rmek ad\u0131na SIKLIK i\u015flevi kullan\u0131labilir. Diyelim ki verilerimiz A1:A30 aras\u0131nda ve s\u0131n\u0131f aral\u0131klar\u0131m\u0131z 0, 50, 60, 70, 85, 100 \u015feklinde B1:B5 h\u00fccrelerinde yer al\u0131yor. Form\u00fcl \u015fu \u015fekilde olacakt\u0131r:<\/p>\n
    =SIKLIK(A1:A30, B1:B5)<\/code><\/pre>\n
    Bu form\u00fcl, her bir not aral\u0131\u011f\u0131ndaki \u00f6\u011frenci say\u0131s\u0131n\u0131 verecektir. \u00d6rne\u011fin, 0-50 aras\u0131 ka\u00e7 \u00f6\u011frenci oldu\u011funu, 51-60 aras\u0131 ka\u00e7 \u00f6\u011frenci oldu\u011funu gibi.<\/p>\n
    \u00dcr\u00fcn Sat\u0131\u015f Adetlerinin Kategoriye G\u00f6re S\u0131n\u0131fland\u0131r\u0131lmas\u0131<\/h3>\n
    Bir ma\u011fazan\u0131n ayl\u0131k \u00fcr\u00fcn sat\u0131\u015f adetlerini analiz etmek i\u00e7in de SIKLIK i\u015flevi kullan\u0131labilir. E\u011fer sat\u0131\u015f adetleri C1:C50 h\u00fccrelerinde yer al\u0131yor ve adet aral\u0131klar\u0131 0, 10, 20, 50, 100 h\u00fccrelerinde D1:D4 olarak belirlenmi\u015fse, kullan\u0131lacak form\u00fcl \u015fu \u015fekilde olur:<\/p>\n
    =SIKLIK(C1:C50, D1:D4)<\/code><\/pre>\n
    Bu, her bir sat\u0131\u015f aral\u0131\u011f\u0131ndaki \u00fcr\u00fcn adedi say\u0131s\u0131n\u0131 hesaplayacakt\u0131r. Bu analiz, hangi \u00fcr\u00fcnlerin daha fazla veya az sat\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/p>\n
    Yorumlar<\/h2>\n
    SIKLIK i\u015flevi, hem Excel hem de Google E-Tablolar’da, veriler \u00fczerinde h\u0131zl\u0131 bir frekans da\u011f\u0131l\u0131m\u0131 analizi yapmak i\u00e7in olduk\u00e7a etkilidir. \u0130statistiksel veri analizinde, \u00f6\u011frenci performans de\u011ferlendirmelerinde veya herhangi bir say\u0131sal veri setindeki da\u011f\u0131l\u0131m\u0131 g\u00f6zlemlemek amac\u0131yla kullan\u0131labilir. Ayr\u0131ca, i\u015flevin otomatik olarak 0’dan ba\u015flayarak belirtilen s\u0131n\u0131rlara kadar olan frekanslar\u0131 hesaplad\u0131\u011f\u0131n\u0131 unutmamak \u00f6nemlidir.<\/p>\n
    Bu fonksiyonla ilgili pratik \u00f6rnekler, s\u0131n\u0131f i\u00e7inde veya i\u015f d\u00fcnyas\u0131nda veri analizi yaparken derinlemesine bilgiler sunar. Analiz sonucu elde edilen bilgiler, karar verme s\u00fcre\u00e7lerini destekler ve stratejik planlamaya katk\u0131da bulunur.<\/p>\n","protected":false},"excerpt":{"rendered":"
    S\u0131kl\u0131k da\u011f\u0131l\u0131m\u0131n\u0131, dikey bir dizi olarak 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-15427","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de FREQUENCY (SIKLIK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da FREQUENCY (SIKLIK) 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\/frequency\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de FREQUENCY (SIKLIK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da FREQUENCY (SIKLIK) 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\/frequency\/\" \/>\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:27:23+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 FREQUENCY (SIKLIK) 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\/frequency\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/frequency\/\",\"name\":\"Excel'de FREQUENCY (SIKLIK) 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:27:23+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da FREQUENCY (SIKLIK) 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\/frequency\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/frequency\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/frequency\/#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\":\"SIKLIK\"}]},{\"@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 FREQUENCY (SIKLIK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da FREQUENCY (SIKLIK) 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\/frequency\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de FREQUENCY (SIKLIK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da FREQUENCY (SIKLIK) 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\/frequency\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:27:23+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de FREQUENCY (SIKLIK) 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\/frequency\/","url":"https:\/\/functiontranslator.com\/tr\/frequency\/","name":"Excel'de FREQUENCY (SIKLIK) 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:27:23+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da FREQUENCY (SIKLIK) 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\/frequency\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/frequency\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/frequency\/#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":"SIKLIK"}]},{"@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\/15427","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=15427"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15427\/revisions"}],"predecessor-version":[{"id":26695,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15427\/revisions\/26695"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}