{"id":6660,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/mediane\/"},"modified":"2021-02-26T08:10:17","modified_gmt":"2021-02-26T08:10:17","slug":"median","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/median\/","title":{"rendered":"MEDIANE"},"content":{"rendered":"

Introduction \u00e0 la fonction MEDIANE<\/h2>\n

La fonction MEDIANE, \u00e9galement appel\u00e9e MEDIAN en anglais, est employ\u00e9e \u00e0 la fois dans Microsoft Excel et Google Sheets pour d\u00e9terminer la valeur m\u00e9diane d’un ensemble de nombres. Cette valeur repr\u00e9sente le point central d’un ensemble ordonn\u00e9 croissant de chiffres. Lorsqu’il y a un nombre pair de valeurs dans l’ensemble, la m\u00e9diane correspond \u00e0 la moyenne des deux nombres centraux.<\/p>\n

Syntaxe et exemples d’application<\/h2>\n

Voici la syntaxe de la fonction :<\/p>\n

=MEDIANE(nombre1, [nombre2], ...)<\/code><\/pre>\n
Cette fonction peut accepter de multiples arguments, tels que des nombres sp\u00e9cifiques, des r\u00e9f\u00e9rences \u00e0 des cellules simples, des plages de cellules ou des combinaisons de ces \u00e9l\u00e9ments.<\/p>\n
Exemple 1 :<\/p>\n
    \n
  • Si vous avez les valeurs 3, 5, 7, 2, et 6 dans les cellules de A1 \u00e0 A5, la formule =MEDIANE(A1:A5)<\/code> renverra 5, la m\u00e9diane de cet ensemble.<\/li>\n<\/ul>\n
    Exemple 2 :<\/p>\n
      \n
    • Si les valeurs sont 4, 8, 9, 15, 16, r\u00e9parties dans les cellules de A1 \u00e0 A5, l’utilisation de =MEDIANE(A1:A5)<\/code> calculera une m\u00e9diane de 9.<\/li>\n<\/ul>\n
      Utilisations pratiques de la fonction MEDIANE<\/h2>\n
      La fonction MEDIANE s’av\u00e8re utile dans de nombreux contextes o\u00f9 une valeur centrale est pr\u00e9f\u00e9rable \u00e0 une moyenne arithm\u00e9tique, notamment quand les donn\u00e9es pr\u00e9sentent des valeurs extr\u00eames susceptibles de fausser les r\u00e9sultats.<\/p>\n
      Exemple pratique 1 : Analyse des d\u00e9penses courantes<\/h2>\n
      Imaginons que vous souhaitiez \u00e9valuer les d\u00e9penses mensuelles typiques par l’examen d’un \u00e9chantillon r\u00e9parti sur 12 mois. Les montants sont les suivants en euros : 1200, 1100, 1250, 900, 1180, 1220, 1300, 950, 1150, 1175, 1230, 910.<\/p>\n
      Formule \u00e0 utiliser :<\/p>\n
      =MEDIANE(A1:L1)<\/code><\/pre>\n
      En ins\u00e9rant les montants de chaque mois de A1 \u00e0 L1, la m\u00e9diane de ces donn\u00e9es indiquera la d\u00e9pense mensuelle \u00ab\u00a0typique\u00a0\u00bb, en minimisant l’impact des mois exceptionnellement co\u00fbteux ou \u00e9conomiques.<\/p>\n
      Exemple pratique 2 : \u00c9valuation acad\u00e9mique<\/h2>\n
      Lors de l’\u00e9valuation des performances des \u00e9l\u00e8ves \u00e0 partir de leurs notes, calculer la m\u00e9diane peut souvent offrir une perspective plus repr\u00e9sentative que la moyenne, affect\u00e9e par les notes extr\u00eamement \u00e9lev\u00e9es ou basses.<\/p>\n
      Exemple :<\/p>\n
      Notes des \u00e9l\u00e8ves \u00e0 un examen : 58, 76, 90, 65, 70, 85, 92. Pour d\u00e9terminer la m\u00e9diane de ces scores :<\/p>\n
      =MEDIANE(B1:B7)<\/code><\/pre>\n
      En listant les scores des \u00e9l\u00e8ves de B1 \u00e0 B7 et en appliquant la formule pr\u00e9c\u00e9dente, le r\u00e9sultat sera 76, refl\u00e9tant une performance m\u00e9diane de la classe.<\/p>\n
       Ce texte reformul\u00e9 garde le m\u00eame volume et toutes les informations techniques tout en corrigeant les erreurs et en utilisant un ton professionnel et adapt\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la valeuR m\u00e9diane des nombRes donn\u00e9s<\/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-6660","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction MEDIAN (MEDIANE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction MEDIAN (MEDIANE) 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\/median\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction MEDIAN (MEDIANE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction MEDIAN (MEDIANE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/median\/\" \/>\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:10:17+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction MEDIAN (MEDIANE) 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\/median\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/median\/\",\"name\":\"Fonction MEDIAN (MEDIANE) 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:10:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction MEDIAN (MEDIANE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/median\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/median\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/median\/#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\":\"MEDIANE\"}]},{\"@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 MEDIAN (MEDIANE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction MEDIAN (MEDIANE) 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\/median\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction MEDIAN (MEDIANE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction MEDIAN (MEDIANE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/median\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction MEDIAN (MEDIANE) 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\/median\/","url":"https:\/\/functiontranslator.com\/fr\/median\/","name":"Fonction MEDIAN (MEDIANE) 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:10:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction MEDIAN (MEDIANE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/median\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/median\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/median\/#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":"MEDIANE"}]},{"@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\/6660","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=6660"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6660\/revisions"}],"predecessor-version":[{"id":29671,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6660\/revisions\/29671"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}