{"id":6819,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/moyenne-reduite\/"},"modified":"2021-02-26T08:15:36","modified_gmt":"2021-02-26T08:15:36","slug":"trimmean","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/trimmean\/","title":{"rendered":"MOYENNE.REDUITE"},"content":{"rendered":"

Introduction \u00e0 la fonction MOYENNE.REDUITE<\/strong><\/p>\n

En statistique, le calcul d’une moyenne robuste, exempt\u00e9e des valeurs extr\u00eames susceptibles de fausser le r\u00e9sultat, est souvent n\u00e9cessaire. La fonction MOYENNE.REDUITE, disponible dans Excel et Google Sheets, r\u00e9pond \u00e0 ce besoin en \u00e9liminant un pourcentage pr\u00e9d\u00e9fini de valeurs aux deux extr\u00e9mit\u00e9s d’un ensemble de donn\u00e9es avant de proc\u00e9der au calcul de la moyenne.<\/p>\n

Syntaxe et exemple d’utilisation<\/h2>\n

La syntaxe de la fonction MOYENNE.REDUITE est la suivante :<\/p>\n

=MOYENNE.REDUITE(plage; pourcentage)<\/code><\/pre>\n
    \n
  • plage<\/strong> : Correspond aux cellules dont on souhaite calculer la moyenne.<\/li>\n
  • pourcentage<\/strong> : D\u00e9signe le pourcentage de valeurs, r\u00e9parties \u00e9quitablement entre le haut et le bas de l’ensemble des donn\u00e9es, \u00e0 exclure du calcul.<\/li>\n<\/ul>\n
    Voici un exemple illustratif avec l’ensemble de donn\u00e9es suivant :<\/p>\n
    10, 15, 20, 25, 30, 35, 40<\/code><\/pre>\n
    Pour calculer une moyenne en \u00e9liminant 20% des donn\u00e9es extr\u00eames, la formule utilis\u00e9e sera :<\/p>\n
    =MOYENNE.REDUITE(A1:G1; 0.2)<\/code><\/pre>\n
    Dans cet exemple, la fonction exclura la valeur la plus haute et la plus basse (20% de 7 valeurs correspond environ \u00e0 1.4, arrondi \u00e0 1 de chaque c\u00f4t\u00e9).<\/p>\n
    Applications pratiques de la fonction<\/h2>\n
    La fonction MOYENNE.REDUITE peut \u00eatre pr\u00e9cieuse dans divers contextes, en voici quelques exemples :<\/p>\n
    Analyse des tendances centrales des salaires<\/h2>\n
    Consid\u00e9rons un ensemble de salaires dans une entreprise. Pour obtenir une estimation fid\u00e8le du salaire moyen, \u00e0 l’abri des salaires extr\u00eamement \u00e9lev\u00e9s ou bas, on peut organiser les donn\u00e9es ainsi :<\/p>\n
    25000, 28000, 30000, 32000, 35000, 38000, 40000, 45000, 48000, 50000<\/code><\/pre>\n
    En appliquant la fonction MOYENNE.REDUITE :<\/p>\n
    =MOYENNE.REDUITE(A1:J1; 0.1)<\/code><\/pre>\n
    Cela permet d’exclure 10% des valeurs, supprimant ainsi le salaire le plus bas et le plus \u00e9lev\u00e9, pour une repr\u00e9sentation plus juste des salaires typiques.<\/p>\n
    \u00c9valuation des performances sportives<\/h2>\n
    Prenons l’exemple de scores en gymnastique :<\/p>\n
    9.6, 9.7, 9.8, 9.7, 9.9, 9.5, 10, 9.6<\/code><\/pre>\n
    L’exclusion des scores extr\u00eames pourrait am\u00e9liorer l’objectivit\u00e9 de l’\u00e9valuation des performances :<\/p>\n
    =MOYENNE.REDUITE(A1:H1; 0.25)<\/code><\/pre>\n
    En retirant 25% des scores, les deux scores les plus bas et les deux plus \u00e9lev\u00e9s seront omis, laissant une moyenne des scores plus repr\u00e9sentative de la performance g\u00e9n\u00e9rale.<\/p>\n
    Conclusion :<\/strong> La fonction MOYENNE.REDUITE est un outil essentiel pour l’analyse de donn\u00e9es, particuli\u00e8rement lorsqu’il est crucial de minimiser l’influence des valeurs extr\u00eames. Cette m\u00e9thode offre une meilleure repr\u00e9sentation de la tendance centrale des donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la moyenne de l\u2019int\u00e9RieuR d\u2019une s\u00e9Rie de donn\u00e9es<\/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-6819","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction TRIMMEAN (MOYENNE.REDUITE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction TRIMMEAN (MOYENNE.REDUITE) 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\/trimmean\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction TRIMMEAN (MOYENNE.REDUITE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction TRIMMEAN (MOYENNE.REDUITE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/trimmean\/\" \/>\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:15:36+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction TRIMMEAN (MOYENNE.REDUITE) 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\/trimmean\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/trimmean\/\",\"name\":\"Fonction TRIMMEAN (MOYENNE.REDUITE) 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:15:36+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction TRIMMEAN (MOYENNE.REDUITE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/trimmean\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/trimmean\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/trimmean\/#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\":\"MOYENNE.REDUITE\"}]},{\"@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 TRIMMEAN (MOYENNE.REDUITE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction TRIMMEAN (MOYENNE.REDUITE) 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\/trimmean\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction TRIMMEAN (MOYENNE.REDUITE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction TRIMMEAN (MOYENNE.REDUITE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/trimmean\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:36+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction TRIMMEAN (MOYENNE.REDUITE) 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\/trimmean\/","url":"https:\/\/functiontranslator.com\/fr\/trimmean\/","name":"Fonction TRIMMEAN (MOYENNE.REDUITE) 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:15:36+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction TRIMMEAN (MOYENNE.REDUITE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/trimmean\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/trimmean\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/trimmean\/#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":"MOYENNE.REDUITE"}]},{"@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\/6819","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=6819"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6819\/revisions"}],"predecessor-version":[{"id":29828,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6819\/revisions\/29828"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}