{"id":6565,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-gamma-inverse-n\/"},"modified":"2021-02-26T08:06:54","modified_gmt":"2021-02-26T08:06:54","slug":"gamma-inv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/gamma-inv\/","title":{"rendered":"LOI.GAMMA.INVERSE.N"},"content":{"rendered":"<h2>Description de la Fonction<\/h2>\n<p>La fonction <code>GAMMA.INV<\/code> dans Microsoft Excel et <code>LOI.GAMMA.INVERSE.N<\/code> dans Google Sheets est une fonction statistique qui calcule l&rsquo;inverse de la fonction de r\u00e9partition cumulative de la loi gamma. Elle est utilis\u00e9e pour analyser des distributions de variables continues positives et asym\u00e9triques.<\/p>\n<h2>Syntaxe et Exemples<\/h2>\n<p>La syntaxe de la fonction en Excel est :<\/p>\n<pre><code>GAMMA.INV(probabilit\u00e9, alpha, beta)<\/code><\/pre>\n<p>Et pour Google Sheets :<\/p>\n<pre><code>LOI.GAMMA.INVERSE.N(probabilit\u00e9, alpha, beta)<\/code><\/pre>\n<ul>\n<li><strong>probabilit\u00e9<\/strong> &#8211; La probabilit\u00e9 correspondante dans la distribution gamma.<\/li>\n<li><strong>alpha<\/strong> (param\u00e8tre de forme) &#8211; Un param\u00e8tre positif qui d\u00e9termine la forme de la distribution.<\/li>\n<li><strong>beta<\/strong> (param\u00e8tre d&rsquo;\u00e9chelle) &#8211; Un param\u00e8tre positif qui ajuste l&rsquo;\u00e9chelle de la distribution.<\/li>\n<\/ul>\n<p><strong>Exemple 1:<\/strong><\/p>\n<p>Pour trouver le 90\u00e8me percentile d&rsquo;une distribution gamma avec une valeur alpha de 2 et beta de 3 :<\/p>\n<pre><code>Excel : =GAMMA.INV(0.9, 2, 3) Google Sheets : =LOI.GAMMA.INVERSE.N(0.9, 2, 3)<\/code><\/pre>\n<h2>Applications Pratiques<\/h2>\n<h2>Sc\u00e9nario 1 : Gestion des Projets<\/h2>\n<p>Pour un chef de projet souhaitant estimer le temps n\u00e9cessaire \u00e0 l&rsquo;ach\u00e8vement d&rsquo;une \u00e9tape critique d&rsquo;un projet, supposant que les dur\u00e9es s&rsquo;alignent sur une distribution gamma en raison de leur asym\u00e9trie naturelle :<\/p>\n<pre><code>Excel : =GAMMA.INV(0.75, 5, 1) Google Sheets : =LOI.GAMMA.INVERSE.N(0.75, 5, 1)<\/code><\/pre>\n<p>Ce calcul repr\u00e9sente le 75e percentile de la distribution, permettant au chef de projet de pr\u00e9voir que le travail sera probablement termin\u00e9 dans ce d\u00e9lai ou moins, avec 75% de confiance.<\/p>\n<h2>Sc\u00e9nario 2 : Mod\u00e9lisation Financi\u00e8re<\/h2>\n<p>Pour un analyste financier mod\u00e9lisant le d\u00e9lai avant un prochain \u00e9v\u00e9nement de march\u00e9 majeur, comme une crise ou une r\u00e9cession, o\u00f9 ces \u00e9v\u00e9nements sont mod\u00e9lis\u00e9s par un processus gamma en raison de leur nature al\u00e9atoire :<\/p>\n<pre><code>Excel : =GAMMA.INV(0.95, 3, 2) Google Sheets : =LOI.GAMMA.INVERSE.N(0.95, 3, 2)<\/code><\/pre>\n<p>Ce calcul estime qu&rsquo;il y a 95% de chances que le prochain \u00e9v\u00e9nement de march\u00e9 significatif survienne avant ce d\u00e9lai. Cette information est cruciale pour \u00e9laborer des strat\u00e9gies de gestion des risques.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Renvoie, pouR une pRobabilit\u00e9 donn\u00e9e, la valeuR d\u2019une vaRiable al\u00e9atoiRe suivant une loi Gamma<\/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-6565","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction GAMMA.INV (LOI.GAMMA.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction GAMMA.INV (LOI.GAMMA.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;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\/gamma-inv\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction GAMMA.INV (LOI.GAMMA.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction GAMMA.INV (LOI.GAMMA.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/gamma-inv\/\" \/>\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:06:54+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction GAMMA.INV (LOI.GAMMA.INVERSE.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\/gamma-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/gamma-inv\/\",\"name\":\"Fonction GAMMA.INV (LOI.GAMMA.INVERSE.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:06:54+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction GAMMA.INV (LOI.GAMMA.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/gamma-inv\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/gamma-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/gamma-inv\/#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.GAMMA.INVERSE.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 GAMMA.INV (LOI.GAMMA.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction GAMMA.INV (LOI.GAMMA.INVERSE.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\/gamma-inv\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction GAMMA.INV (LOI.GAMMA.INVERSE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction GAMMA.INV (LOI.GAMMA.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/gamma-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:06:54+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction GAMMA.INV (LOI.GAMMA.INVERSE.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\/gamma-inv\/","url":"https:\/\/functiontranslator.com\/fr\/gamma-inv\/","name":"Fonction GAMMA.INV (LOI.GAMMA.INVERSE.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:06:54+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction GAMMA.INV (LOI.GAMMA.INVERSE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/gamma-inv\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/gamma-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/gamma-inv\/#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.GAMMA.INVERSE.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\/6565","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=6565"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6565\/revisions"}],"predecessor-version":[{"id":29576,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6565\/revisions\/29576"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}