{"id":6770,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/coefficient-asymetrie-p\/"},"modified":"2021-02-26T08:13:45","modified_gmt":"2021-02-26T08:13:45","slug":"skew-p","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/skew-p\/","title":{"rendered":"COEFFICIENT.ASYMETRIE.P"},"content":{"rendered":"

Description de la Fonction<\/h2>\n

La fonction SKEW.P<\/code> (appel\u00e9e COEFFICIENT.ASYMETRIE.P<\/code> dans la version fran\u00e7aise de Microsoft Excel) est utilis\u00e9e pour calculer l’asym\u00e9trie d’une distribution de probabilit\u00e9 d’un ensemble de donn\u00e9es. L’asym\u00e9trie est un indicateur de la sym\u00e9trie, ou de son absence, dans une distribution. Une distribution peut \u00eatre sym\u00e9trique, asym\u00e9trique \u00e0 droite, ou asym\u00e9trique \u00e0 gauche.<\/p>\n

Syntaxe:<\/b><\/p>\n

SKEW.P(number1, [number2], ...) COEFFICIENT.ASYMETRIE.P(num\u00e9ro1, [num\u00e9ro2], ...)<\/code><\/pre>\n
Param\u00e8tres:<\/u><\/p>\n
    \n
  • number1, number2, ...<\/code> : Ces arguments sont des valeurs de l’ensemble de donn\u00e9es pour lequel l’asym\u00e9trie est calcul\u00e9e. Ils peuvent inclure jusqu’\u00e0 254 valeurs.<\/li>\n<\/ul>\n
    Exemple:<\/b><\/p>\n
    =SKEW.P(3, 4, 5, 5, 6) =COEFFICIENT.ASYMETRIE.P(3; 4; 5; 5; 6)<\/code><\/pre>\n
    Utilisations Pratiques de la Fonction<\/h2>\n
    Voici des exemples illustrant l’application de cette fonction dans des situations concr\u00e8tes.<\/p>\n
    T\u00e2che 1: Analyse de la Satisfaction Client<\/h2>\n
    Supposons que vous travaillez pour une entreprise ayant lanc\u00e9 un nouveau produit et que vous collectez des \u00e9valuations de satisfaction client sur une \u00e9chelle de 1 \u00e0 10. Vous analysez les notes suivantes de l’ensemble des clients :<\/p>\n
    2, 5, 7, 7, 8, 9, 9, 9, 10<\/code><\/pre>\n
    Vous souhaitez examiner l’asym\u00e9trie de ces \u00e9valuations pour voir si les opinions sont polaris\u00e9es.<\/p>\n
    =COEFFICIENT.ASYMETRIE.P(2; 5; 7; 7; 8; 9; 9; 9; 10)<\/code><\/pre>\n
    Commentaires:<\/b> Un r\u00e9sultat n\u00e9gatif indiquerait une concentration des notes vers le bas de l’\u00e9chelle. Un r\u00e9sultat proche de z\u00e9ro sugg\u00e9rerait une distribution sym\u00e9trique, indiquant des avis g\u00e9n\u00e9ralement positifs et peu de critiques tr\u00e8s n\u00e9gatives.<\/p>\n
    T\u00e2che 2: \u00c9valuation de la Distribution des Salaires<\/h2>\n
    En tant qu’analyste RH, vous examinez la distribution des salaires au sein de votre entreprise. Les salaires (en milliers) sont les suivants :<\/p>\n
    20, 22, 22, 25, 28, 28, 30, 35, 40<\/code><\/pre>\n
    \u00c9valuer l’asym\u00e9trie de cette distribution vous aidera \u00e0 comprendre s’il existe des d\u00e9s\u00e9quilibres dans la r\u00e9partition des revenus parmi les employ\u00e9s.<\/p>\n
    =COEFFICIENT.ASYMETRIE.P(20; 22; 22; 25; 28; 28; 30; 35; 40)<\/code><\/pre>\n
    Commentaires:<\/b> Une asym\u00e9trie positive sugg\u00e9rerait la pr\u00e9sence de quelques salaires tr\u00e8s \u00e9lev\u00e9s influen\u00e7ant la moyenne, tandis qu’une asym\u00e9trie n\u00e9gative indiquerait une pr\u00e9dominance de salaires bas. Une valeur proche de z\u00e9ro montrerait une distribution \u00e9quilibr\u00e9e relativement \u00e0 la moyenne et \u00e0 la m\u00e9diane.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie l\u2019asym\u00e9trie d\u2019une distribution\u00a0: la caract\u00e9risation du degr\u00e9 d\u2019asym\u00e9trie d\u2019une distribution par rapport \u00e0 sa moyenne<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[315],"tags":[],"class_list":["post-6770","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction SKEW.P (COEFFICIENT.ASYMETRIE.P) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/skew-p\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/skew-p\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:13:45+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/skew-p\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/skew-p\/\",\"name\":\"Fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:13:45+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/skew-p\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/skew-p\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/skew-p\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistiques\",\"item\":\"https:\/\/functiontranslator.com\/fr\/statistiques\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"COEFFICIENT.ASYMETRIE.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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/skew-p\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/skew-p\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:45+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/skew-p\/","url":"https:\/\/functiontranslator.com\/fr\/skew-p\/","name":"Fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:13:45+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SKEW.P (COEFFICIENT.ASYMETRIE.P) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/skew-p\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/skew-p\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/skew-p\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Statistiques","item":"https:\/\/functiontranslator.com\/fr\/statistiques\/"},{"@type":"ListItem","position":3,"name":"COEFFICIENT.ASYMETRIE.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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6770"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6770\/revisions"}],"predecessor-version":[{"id":29780,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6770\/revisions\/29780"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}