{"id":6672,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/mode-simple\/"},"modified":"2021-02-26T08:10:36","modified_gmt":"2021-02-26T08:10:36","slug":"mode-sngl","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/mode-sngl\/","title":{"rendered":"MODE.SIMPLE"},"content":{"rendered":"

La fonction MODE.SNGL dans Excel et MODE.SIMPLE dans Google Sheets permet de d\u00e9terminer la valeur la plus r\u00e9currente dans un ensemble de donn\u00e9es num\u00e9riques. Ce calcul, fr\u00e9quemment utilis\u00e9 en statistique, aide \u00e0 identifier le mode d’une s\u00e9rie de valeurs.<\/p>\n

Syntaxe et exemples<\/h2>\n

La syntaxe de la fonction MODE.SNGL dans Excel est la suivante :<\/p>\n

=MODE.SNGL(nombre1, [nombre2], ...)<\/code><\/pre>\n
Les \u00e9l\u00e9ments nombre1<\/code>, nombre2<\/code>, etc., repr\u00e9sentent les arguments sous forme de nombres ou de r\u00e9f\u00e9rences \u00e0 des cellules contenant des nombres.<\/p>\n
Dans Google Sheets, la syntaxe est similaire :<\/p>\n
=MODE.SIMPLE(nombre1, [nombre2], ...)<\/code><\/pre>\n
Exemple :<\/strong> Consid\u00e9rons les donn\u00e9es suivantes :<\/p>\n
A1: 3 A2: 5 A3: 5 A4: 2 A5: 3<\/code><\/pre>\n
En appliquant la fonction MODE.SNGL ou MODE.SIMPLE sur ces donn\u00e9es :<\/p>\n
=MODE.SNGL(A1:A5)<\/code><\/pre>\n
Le r\u00e9sultat serait 5<\/code>, puisque c\u2019est la valeur qui appara\u00eet le plus souvent dans l’ensemble des donn\u00e9es.<\/p>\n
Applications pratiques<\/h2>\n
    \n
  • Analyse de donn\u00e9es de vente :<\/strong> Si vous disposez des ventes quotidiennes d\u2019un produit sur un mois, la fonction MODE.SNGL peut vous aider \u00e0 d\u00e9terminer le nombre d’unit\u00e9s le plus souvent vendu par jour, information crucial pour la gestion des stocks.<\/li>\n
  • Recherche en sciences sociales :<\/strong> Lors d’un sondage o\u00f9 les participants s\u00e9lectionnent une r\u00e9ponse parmi plusieurs, MODE.SNGL peut r\u00e9v\u00e9ler la r\u00e9ponse la plus fr\u00e9quemment choisie, fournissant une donn\u00e9e essentielle pour analyser les r\u00e9sultats de l’\u00e9tude.<\/li>\n<\/ul>\n
    Voici comment g\u00e9rer ces sc\u00e9narios :<\/p>\n
    Solution d\u00e9taill\u00e9e pour l’analyse de donn\u00e9es de vente<\/h2>\n
    Supposons que nous disposons des donn\u00e9es de vente suivantes :<\/p>\n\n\n\n\n\n\n\n
    Jour<\/th>\nVentes<\/th>\n<\/tr>\n
    1<\/td>\n120<\/td>\n<\/tr>\n
    2<\/td>\n150<\/td>\n<\/tr>\n
    3<\/td>\n150<\/td>\n<\/tr>\n
    4<\/td>\n90<\/td>\n<\/tr>\n
    5<\/td>\n150<\/td>\n<\/tr>\n<\/table>\n
    Appliquez la formule suivante :<\/p>\n
    =MODE.SNGL(B1:B5)<\/code><\/pre>\n
    Le r\u00e9sultat 150<\/code> indique que 150 unit\u00e9s est le nombre le plus fr\u00e9quemment vendu.<\/p>\n
    Solution pour la recherche en sciences sociales<\/h2>\n
    Consid\u00e9rez une enqu\u00eate avec la question : \u00ab\u00a0Quel est votre fruit pr\u00e9f\u00e9r\u00e9 ?\u00a0\u00bb, avec les r\u00e9ponses suivantes :<\/p>\n\n\n\n\n\n\n
    R\u00e9pondant<\/th>\nFruit choisi<\/th>\n<\/tr>\n
    1<\/td>\nPomme<\/td>\n<\/tr>\n
    2<\/td>\nBanane<\/td>\n<\/tr>\n
    3<\/td>\nPomme<\/td>\n<\/tr>\n
    4<\/td>\nPomme<\/td>\n<\/tr>\n<\/table>\n
    Utilisez la formule suivante pour trouver le fruit pr\u00e9f\u00e9r\u00e9 :<\/p>\n
    =MODE.SNGL(B1:B4)<\/code><\/pre>\n
    Cela r\u00e9v\u00e8le que le fruit favori parmi les r\u00e9pondants est la ‘Pomme’.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la valeuR la plus couRante 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-6672","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction MODE.SNGL (MODE.SIMPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction MODE.SNGL (MODE.SIMPLE) 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\/mode-sngl\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction MODE.SNGL (MODE.SIMPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction MODE.SNGL (MODE.SIMPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/mode-sngl\/\" \/>\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: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 MODE.SNGL (MODE.SIMPLE) 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\/mode-sngl\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/mode-sngl\/\",\"name\":\"Fonction MODE.SNGL (MODE.SIMPLE) 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:36+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction MODE.SNGL (MODE.SIMPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/mode-sngl\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/mode-sngl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/mode-sngl\/#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\":\"MODE.SIMPLE\"}]},{\"@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 MODE.SNGL (MODE.SIMPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction MODE.SNGL (MODE.SIMPLE) 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\/mode-sngl\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction MODE.SNGL (MODE.SIMPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction MODE.SNGL (MODE.SIMPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/mode-sngl\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:36+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction MODE.SNGL (MODE.SIMPLE) 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\/mode-sngl\/","url":"https:\/\/functiontranslator.com\/fr\/mode-sngl\/","name":"Fonction MODE.SNGL (MODE.SIMPLE) 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:36+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction MODE.SNGL (MODE.SIMPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/mode-sngl\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/mode-sngl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/mode-sngl\/#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":"MODE.SIMPLE"}]},{"@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\/6672","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=6672"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6672\/revisions"}],"predecessor-version":[{"id":29683,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6672\/revisions\/29683"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}