{"id":15640,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/carpiklik-p\/"},"modified":"2021-02-25T16:36:03","modified_gmt":"2021-02-25T16:36:03","slug":"skew-p","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/skew-p\/","title":{"rendered":"\u00c7ARPIKLIK.P"},"content":{"rendered":"

Excel ve Google E-Tablolar’da Da\u011f\u0131l\u0131m Analizi: \u00c7arp\u0131kl\u0131k Testi<\/h1>\n

Data analizi ve istatistiksel hesaplamalar, Excel ve Google E-Tablolar kullan\u0131larak kolayca ger\u00e7ekle\u015ftirilebilir. Bu yaz\u0131da, veri setlerinin da\u011f\u0131l\u0131m\u0131n\u0131n simetri durumunu anlamak i\u00e7in kullan\u0131lan bir i\u015flev olan \u00c7ARPIKLIK.P (SKEW.P) i\u015flevinin nas\u0131l kullan\u0131ld\u0131\u011f\u0131n\u0131 \u00f6rneklerle birlikte inceleyece\u011fiz. Bu i\u015flev, bir veri dizisi \u00fczerindeki \u00e7arp\u0131kl\u0131\u011f\u0131 \u00f6l\u00e7er. \u00c7arp\u0131kl\u0131k, veri setinin simetrik olup olmad\u0131\u011f\u0131n\u0131 veya pozitif\/negatif y\u00f6nde \u00e7arp\u0131k olup olmad\u0131\u011f\u0131n\u0131 belirler.<\/p>\n

\u00c7arp\u0131kl\u0131k Testi Nedir ve Nas\u0131l Hesaplan\u0131r?<\/h2>\n

\u00c7arp\u0131kl\u0131k, bir veri da\u011f\u0131l\u0131m\u0131n\u0131n simetrisini de\u011ferlendirir. E\u011fer bir da\u011f\u0131l\u0131m simetrik ise \u00e7arp\u0131kl\u0131k de\u011feri s\u0131f\u0131ra yak\u0131n olur. Pozitif \u00e7arp\u0131kl\u0131k, veri setinin sa\u011fa (yani ortalamadan daha b\u00fcy\u00fck de\u011ferlere do\u011fru) uzand\u0131\u011f\u0131n\u0131 g\u00f6sterirken, negatif \u00e7arp\u0131kl\u0131k sol tarafa (ortalaman\u0131n alt\u0131ndaki de\u011ferlere) uzanma e\u011filimindedir.<\/p>\n

SKEW.P<\/code> fonksiyonu Excel ve Google E-Tablolar\u2019da s\u00f6z konusu \u00e7arp\u0131kl\u0131\u011f\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, pop\u00fclasyona ait t\u00fcm verileri dikkate al\u0131r ve \u00f6rneklem \u00e7arp\u0131kl\u0131\u011f\u0131na g\u00f6re daha az yanl\u0131 sonu\u00e7lar \u00fcretir. \u0130\u015flevin genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

 SKEW.P(number1, [number2], ...) <\/code><\/pre>\n
Burada number1, number2, ...<\/code> hesaplama yap\u0131lacak say\u0131sal de\u011ferlerdir. Excel ve Google E-Tablolar’da bu de\u011ferler do\u011frudan say\u0131lar, h\u00fccre referanslar\u0131 veya aral\u0131klar olabilir.<\/p>\n
Pratik Uygulamalar ve \u00d6rnek Senaryolar<\/h2>\n
\u00c7ARPIKLIK.P fonksiyonunun kullan\u0131m\u0131n\u0131 iki farkl\u0131 senaryo \u00fczerinden g\u00f6sterelim:<\/p>\n
1. Yat\u0131r\u0131m Getirilerinin Analizi<\/h3>\n
Yat\u0131r\u0131m getirileri genellikle normal da\u011f\u0131l\u0131ma uymaz ve risk de\u011ferlendirmesi i\u00e7in \u00e7arp\u0131kl\u0131k \u00f6nemli bir metriktir. \u00d6rnek olarak, son 12 aydaki % olarak getiri:<\/p>\n
 5, 7, 7, 8, 10, -2, 0, 15, 20, 5, 3, -1<\/code> <\/pre>\n
Excel veya Google E-Tablolar’da bu de\u011ferleri A1:A12 h\u00fccrelerine girerek, A13 h\u00fccresinde \u015fu form\u00fcl\u00fc kullanabiliriz:<\/p>\n
 =SKEW.P(A1:A12)<\/code> <\/pre>\n
G\u00f6r\u00fcld\u00fc\u011f\u00fc gibi \u00e7arp\u0131kl\u0131k de\u011feri pozitif \u00e7\u0131karsa, getirilerin b\u00fcy\u00fck kazan\u00e7lar y\u00f6n\u00fcnde \u00e7arp\u0131k oldu\u011funu s\u00f6yleyebiliriz. Bu durumda yat\u0131r\u0131mc\u0131 daha y\u00fcksek getirileri olan yat\u0131r\u0131mlara y\u00f6nelebilir.<\/p>\n
2. M\u00fc\u015fteri Memnuniyeti Anket Sonu\u00e7lar\u0131n\u0131n De\u011ferlendirilmesi<\/h3>\n
Bir \u015firket, m\u00fc\u015fteri memnuniyeti anketi yaparak, 1’den 5’e kadar puanlar al\u0131r. Al\u0131nan puanlar:<\/p>\n
 3, 3, 4, 5, 3, 4, 2, 5, 3, 5, 4, 5<\/code> <\/pre>\n
Bu veriyi B1:B12 h\u00fccrelerine girdikten sonra B13 h\u00fccre i\u00e7in:<\/p>\n
 =SKEW.P(B1:B12)<\/code> <\/pre>\n
Bu \u00f6rnekte de \u00e7arp\u0131kl\u0131k de\u011feri hesaplan\u0131r ve negatif \u00e7\u0131kt\u0131\u011f\u0131 durumda, m\u00fc\u015fterilerin b\u00fcy\u00fck bir k\u0131sm\u0131n\u0131n d\u00fc\u015f\u00fck puan verdi\u011fini, dolay\u0131s\u0131yla memnuniyetin d\u00fc\u015f\u00fck oldu\u011funu ifade eder.<\/p>\n
Sonu\u00e7 ve Yorumlar<\/h2>\n
\u00c7ARPIKLIK.P fonksiyonu, \u00f6zellikle finansal verilerde veya m\u00fc\u015fteri davran\u0131\u015f analizlerinde veri setlerinin da\u011f\u0131l\u0131m\u0131n\u0131 anlamak i\u00e7in olduk\u00e7a yararl\u0131d\u0131r. Bu fonksiyon sayesinde analistler, risk y\u00f6netimi, \u00fcr\u00fcn geli\u015ftirme ve m\u00fc\u015fteri ili\u015fkileri gibi alanlarda daha bilin\u00e7li kararlar verebilirler.<\/p>\n
Yukar\u0131da verilen \u00f6rnekler ve a\u00e7\u0131klamalar, fonksiyonun pratik uygulamalar\u0131na \u0131\u015f\u0131k tutmaktad\u0131r. Ancak her durumun kendi kontekstine g\u00f6re de\u011ferlendirilmesi gerekti\u011fini unutmamak \u00f6nemlidir. Hangi senaryoda veri setinizin \u00e7arp\u0131kl\u0131\u011f\u0131n\u0131n y\u00fcksek veya d\u00fc\u015f\u00fck olmas\u0131n\u0131n beklenen veya istenen bir sonu\u00e7 oldu\u011funu analiz ederek, stratejik planlar\u0131n\u0131z\u0131 bu y\u00f6nde \u015fekillendirebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
Pop\u00fclasyona dayal\u0131 olarak bir da\u011f\u0131l\u0131m\u0131n e\u011frili\u011fini verir: Bir da\u011f\u0131l\u0131m\u0131n ortalamas\u0131 etraf\u0131nda asimetri derecesinin karakterizasyonu<\/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-15640","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de SKEW.P (\u00c7ARPIKLIK.P) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da SKEW.P (\u00c7ARPIKLIK.P) 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\/skew-p\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de SKEW.P (\u00c7ARPIKLIK.P) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da SKEW.P (\u00c7ARPIKLIK.P) 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\/skew-p\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:36:03+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 SKEW.P (\u00c7ARPIKLIK.P) 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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/skew-p\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/skew-p\/\",\"name\":\"Excel'de SKEW.P (\u00c7ARPIKLIK.P) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:36:03+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da SKEW.P (\u00c7ARPIKLIK.P) 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\/skew-p\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/skew-p\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/skew-p\/#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\":\"\u00c7ARPIKLIK.P\"}]},{\"@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 SKEW.P (\u00c7ARPIKLIK.P) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da SKEW.P (\u00c7ARPIKLIK.P) 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\/skew-p\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de SKEW.P (\u00c7ARPIKLIK.P) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da SKEW.P (\u00c7ARPIKLIK.P) 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\/skew-p\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:36:03+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de SKEW.P (\u00c7ARPIKLIK.P) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/skew-p\/","url":"https:\/\/functiontranslator.com\/tr\/skew-p\/","name":"Excel'de SKEW.P (\u00c7ARPIKLIK.P) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:36:03+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da SKEW.P (\u00c7ARPIKLIK.P) 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\/skew-p\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/skew-p\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/skew-p\/#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":"\u00c7ARPIKLIK.P"}]},{"@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\/15640","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=15640"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15640\/revisions"}],"predecessor-version":[{"id":26908,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15640\/revisions\/26908"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}