{"id":6721,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-poisson-n\/"},"modified":"2021-02-26T08:12:03","modified_gmt":"2021-02-26T08:12:03","slug":"poisson-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/poisson-dist\/","title":{"rendered":"LOI.POISSON.N"},"content":{"rendered":"

Dans les environnements de Microsoft Excel et Google Sheets, la fonction LOI.POISSON.N (\u00e9quivalent anglaise : POISSON.DIST) est couramment utilis\u00e9e pour calculer les probabilit\u00e9s d’un nombre sp\u00e9cifi\u00e9 d’\u00e9v\u00e9nements survenant dans un intervalle de temps ou d’espace donn\u00e9, en se basant sur une moyenne d’\u00e9v\u00e9nements connue. Cette fonction est extr\u00eamement utile dans des domaines vari\u00e9s tels que la statistique, la gestion de projet ou encore les sciences naturelles.<\/p>\n

Syntaxe et exemples<\/h2>\n

La syntaxe de la fonction LOI.POISSON.N dans Excel est :<\/p>\n

LOI.POISSON.N(x, moyenne, cumulatif)<\/code><\/pre>\n
    \n
  • x<\/code> : Nombre d’\u00e9v\u00e9nements pour lesquels la probabilit\u00e9 est calcul\u00e9e.<\/li>\n
  • moyenne<\/code> : La moyenne des \u00e9v\u00e9nements survenant sur un intervalle sp\u00e9cifi\u00e9.<\/li>\n
  • cumulatif<\/code> : Valeur bool\u00e9enne sp\u00e9cifiant le type de fonction. Si vrai (TRUE), la fonction renvoie la probabilit\u00e9 cumul\u00e9e; si faux (FALSE), elle renvoie la probabilit\u00e9 de masse ponctuelle.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n
    =LOI.POISSON.N(3, 2, FAUX)<\/code><\/pre>\n
    Cet exemple d\u00e9montre comment calculer la probabilit\u00e9 qu’il y ait pr\u00e9cis\u00e9ment trois \u00e9v\u00e9nements, en consid\u00e9rant une moyenne de deux \u00e9v\u00e9nements dans cet intervalle de temps.<\/p>\n
    Cas pratiques d’utilisation<\/h2>\n
    Sc\u00e9nario 1 : Gestion d’un centre d’appels<\/strong><\/p>\n
    Imaginons un centre d\u2019appels recevant en moyenne 5 appels par heure. Nous pouvons \u00eatre int\u00e9ress\u00e9s \u00e0 conna\u00eetre la probabilit\u00e9 de recevoir exactement 7 appels pendant une heure particuli\u00e8re.<\/p>\n
    Solution :<\/strong><\/p>\n
    =LOI.POISSON.N(7, 5, FAUX)<\/code><\/pre>\n
    Cette formule renvoie la probabilit\u00e9 de recevoir pr\u00e9cis\u00e9ment 7 appels en une heure, en se basant sur une moyenne de 5. Elle est particuli\u00e8rement adapt\u00e9e pour la planification des besoins en ressources humaines et en \u00e9quipements.<\/p>\n
    Sc\u00e9nario 2 : \u00c9tude environnementale<\/strong><\/p>\n
    Consid\u00e9rons des \u00e9cologistes monitorant une aire foresti\u00e8re, o\u00f9 l’on observe en moyenne 2 ours par kilom\u00e8tre carr\u00e9. Quelle est la probabilit\u00e9 de ne rencontrer aucun ours sur une zone de 2 kilom\u00e8tres carr\u00e9s ?<\/p>\n
    Solution :<\/strong><\/p>\n
    =LOI.POISSON.N(0, 2*2, VRAI)<\/code><\/pre>\n
    En doublant la moyenne (la zone d’\u00e9tude \u00e9tant \u00e9galement doubl\u00e9e), la formule recherche la probabilit\u00e9 cumulative de ne rencontrer aucun ours, ce qui est crucial pour des \u00e9valuations de risques ou la pr\u00e9paration de mesures pr\u00e9ventives lors d’\u00e9tudes terrain.<\/p>\n
    En r\u00e9sum\u00e9, la fonction LOI.POISSON.N est un outil pr\u00e9cieux dans Excel et Google Sheets pour l’analyse de donn\u00e9es associ\u00e9es \u00e0 des processus stochastiques et des distributions d’\u00e9v\u00e9nements, permettant des pr\u00e9visions pratiques et des analyses statistiques fond\u00e9es sur des donn\u00e9es historiques ou observ\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la pRobabilit\u00e9 d\u2019une vaRiable al\u00e9atoiRe suivant une loi de Poisson<\/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-6721","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction POISSON.DIST (LOI.POISSON.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction POISSON.DIST (LOI.POISSON.N) 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\/poisson-dist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction POISSON.DIST (LOI.POISSON.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction POISSON.DIST (LOI.POISSON.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/poisson-dist\/\" \/>\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:12:03+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction POISSON.DIST (LOI.POISSON.N) 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\/poisson-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/poisson-dist\/\",\"name\":\"Fonction POISSON.DIST (LOI.POISSON.N) 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:12:03+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction POISSON.DIST (LOI.POISSON.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/poisson-dist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/poisson-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/poisson-dist\/#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\":\"LOI.POISSON.N\"}]},{\"@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 POISSON.DIST (LOI.POISSON.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction POISSON.DIST (LOI.POISSON.N) 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\/poisson-dist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction POISSON.DIST (LOI.POISSON.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction POISSON.DIST (LOI.POISSON.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/poisson-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:12:03+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction POISSON.DIST (LOI.POISSON.N) 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\/poisson-dist\/","url":"https:\/\/functiontranslator.com\/fr\/poisson-dist\/","name":"Fonction POISSON.DIST (LOI.POISSON.N) 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:12:03+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction POISSON.DIST (LOI.POISSON.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/poisson-dist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/poisson-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/poisson-dist\/#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":"LOI.POISSON.N"}]},{"@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\/6721","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=6721"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6721\/revisions"}],"predecessor-version":[{"id":29732,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6721\/revisions\/29732"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}