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

Description de la fonction LOI.POISSON<\/h2>\n

La fonction LOI.POISSON est utilis\u00e9e pour calculer la probabilit\u00e9 associ\u00e9e \u00e0 une variable al\u00e9atoire qui suit une distribution de Poisson. Cette fonction est essentielle en statistique pour repr\u00e9senter le nombre d’\u00e9v\u00e9nements qui se produisent dans un intervalle de temps ou d’espace d\u00e9fini, \u00e0 condition que ces \u00e9v\u00e9nements se manifestent \u00e0 une fr\u00e9quence moyenne connue et de fa\u00e7on ind\u00e9pendante les uns des autres.<\/p>\n

Syntaxe<\/h2>\n

Voici la syntaxe de la fonction POISSON dans Microsoft Excel :<\/p>\n

=LOI.POISSON(x; moyenne; cumul\u00e9)<\/code><\/pre>\n
    \n
  • x<\/strong> : le nombre d’\u00e9v\u00e9nements pour lesquels la probabilit\u00e9 est recherch\u00e9e.<\/li>\n
  • moyenne<\/strong> : la fr\u00e9quence moyenne des \u00e9v\u00e9nements.<\/li>\n
  • cumul\u00e9<\/strong> : un param\u00e8tre bool\u00e9en o\u00f9 FALSE calcule la probabilit\u00e9 de l’\u00e9v\u00e9nement x et TRUE calcule la probabilit\u00e9 cumul\u00e9e d’avoir de z\u00e9ro \u00e0 x \u00e9v\u00e9nements.<\/li>\n<\/ul>\n
    Dans Google Sheets, la syntaxe est tr\u00e8s similaire :<\/p>\n
    =LOI.POISSON(x, moyenne, cumul\u00e9)<\/code><\/pre>\n
    Exemples d’utilisation<\/h2>\n\n\n\n\n
    Formule<\/th>\nDescription<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    =LOI.POISSON(3; 5; FALSE)<\/code><\/td>\nCalcule la probabilit\u00e9 d’observer exactement 3 \u00e9v\u00e9nements.<\/td>\nValeur de probabilit\u00e9 pour 3 \u00e9v\u00e9nements<\/td>\n<\/tr>\n
    =LOI.POISSON(3; 5; TRUE)<\/code><\/td>\nCalcule la probabilit\u00e9 d’observer au moins 3 \u00e9v\u00e9nements.<\/td>\nValeur de probabilit\u00e9 cumul\u00e9e de 0 \u00e0 3 \u00e9v\u00e9nements<\/td>\n<\/tr>\n<\/table>\n
    Applications pratiques<\/h2>\n
    1. Mod\u00e9lisation du trafic de clients dans une banque<\/strong><\/p>\n
    Supposons qu’une banque accueille en moyenne 12 clients par heure. Pour d\u00e9terminer la probabilit\u00e9 d’accueillir 15 clients dans une heure donn\u00e9e, on peut utiliser la fonction LOI.POISSON :<\/p>\n
    =LOI.POISSON(15; 12; FALSE)<\/code><\/pre>\n
    Cette formule indique la probabilit\u00e9 d’avoir pr\u00e9cis\u00e9ment 15 clients en une heure, en se basant sur une moyenne de 12.<\/p>\n
    2. Planification des ressources pour un centre d’appel<\/strong><\/p>\n
    Si un centre d’appel re\u00e7oit en moyenne 30 appels par heure et cherche \u00e0 \u00e9valuer les risques d’une charge de travail consid\u00e9rablement accrue, il est utile de consid\u00e9rer la fonction cumul\u00e9e, par exemple, pour 40 appels ou plus :<\/p>\n
    =LOI.POISSON(40; 30; TRUE)<\/code><\/pre>\n
    Cette formule est utile pour calculer la probabilit\u00e9 de recevoir jusqu’\u00e0 40 appels ou plus dans une heure, facilitant ainsi la pr\u00e9paration et la planification des besoins en personnel ou en mat\u00e9riel suppl\u00e9mentaires.<\/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":[317],"tags":[],"class_list":["post-6722","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction POISSON (LOI.POISSON) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction POISSON (LOI.POISSON) 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\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction POISSON (LOI.POISSON) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction POISSON (LOI.POISSON) 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\/\" \/>\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:05+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 (LOI.POISSON) 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\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/poisson\/\",\"name\":\"Fonction POISSON (LOI.POISSON) 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:05+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction POISSON (LOI.POISSON) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/poisson\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/poisson\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/poisson\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compatibilit\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/fr\/compatibilite\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LOI.POISSON\"}]},{\"@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 (LOI.POISSON) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction POISSON (LOI.POISSON) 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\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction POISSON (LOI.POISSON) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction POISSON (LOI.POISSON) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/poisson\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:12:05+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction POISSON (LOI.POISSON) 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\/","url":"https:\/\/functiontranslator.com\/fr\/poisson\/","name":"Fonction POISSON (LOI.POISSON) 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:05+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction POISSON (LOI.POISSON) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/poisson\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/poisson\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/poisson\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Compatibilit\u00e9","item":"https:\/\/functiontranslator.com\/fr\/compatibilite\/"},{"@type":"ListItem","position":3,"name":"LOI.POISSON"}]},{"@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\/6722","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=6722"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6722\/revisions"}],"predecessor-version":[{"id":29733,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6722\/revisions\/29733"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}