{"id":6437,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-khideux-inverse-droite\/"},"modified":"2021-02-26T08:03:09","modified_gmt":"2021-02-26T08:03:09","slug":"chisq-inv-rt","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/chisq-inv-rt\/","title":{"rendered":"LOI.KHIDEUX.INVERSE.DROITE"},"content":{"rendered":"

Ce guide explique l’utilisation de la fonction CHISQ.INV.RT dans Microsoft Excel et LOI.KHIDEUX.INVERSE.DROITE dans Google Sheets. Ces fonctions permettent de calculer l’inverse de la probabilit\u00e9 de la distribution du chi-carr\u00e9 \u00e0 droite, ce qui est particuli\u00e8rement utile en statistique pour les tests d’hypoth\u00e8se sur la variance.<\/p>\n

Pr\u00e9sentation de la syntaxe et exemples d’utilisation<\/h2>\n

La syntaxe de la fonction dans Excel est :<\/p>\n

=CHISQ.INV.RT(probabilit\u00e9, degr\u00e9s_libert\u00e9)<\/code><\/pre>\n
O\u00f9 :<\/p>\n
    \n
  • probabilit\u00e9<\/strong> repr\u00e9sente la probabilit\u00e9 associ\u00e9e \u00e0 la distribution du chi-carr\u00e9.<\/li>\n
  • degr\u00e9s_libert\u00e9<\/strong> indique le nombre de degr\u00e9s de libert\u00e9 dans la distribution.<\/li>\n<\/ul>\n
    Exemple d’utilisation :<\/p>\n
    =CHISQ.INV.RT(0.05, 10)<\/code><\/pre>\n
    Cette formule calcule la valeur critique de la distribution du chi-carr\u00e9 pour une probabilit\u00e9 de 0.05 avec 10 degr\u00e9s de libert\u00e9.<\/p>\n
    Dans Google Sheets, la fonction s’\u00e9crit :<\/p>\n
    =LOI.KHIDEUX.INVERSE.DROITE(0.05, 10)<\/code><\/pre>\n
    Cette commande fournira un r\u00e9sultat identique \u00e0 celui d’Excel.<\/p>\n
    Applications pratiques de la fonction<\/h2>\n
    Test d’hypoth\u00e8se sur la variance<\/h2>\n
    Imaginons que vous souhaitiez v\u00e9rifier si la variance d’une population est \u00e9gale \u00e0 une valeur sp\u00e9cifique en utilisant un \u00e9chantillon de 20 avec une variance observ\u00e9e de 30 et un seuil de signification de 0.05.<\/p>\n
    1. Calculez la valeur du chi-carr\u00e9 pour l’\u00e9chantillon :<\/p>\n
    (n-1)*s^2 \/ \u03c3^2 = 19*30 \/ valeur_sp\u00e9cifi\u00e9e<\/code><\/pre>\n
    2. Utilisez CHISQ.INV.RT<\/code> pour obtenir la valeur critique du chi-carr\u00e9 avec 19 degr\u00e9s de libert\u00e9 :<\/p>\n
    =CHISQ.INV.RT(0.05, 19)<\/code><\/pre>\n
    3. Comparez la valeur obtenue \u00e0 l’\u00e9tape 1 avec la valeur critique de l’\u00e9tape 2. Si elle est sup\u00e9rieure, rejetez l’hypoth\u00e8se nulle.<\/p>\n
    D\u00e9termination des intervalles de confiance pour la variance<\/h2>\n
    Pour \u00e9tablir un intervalle de confiance de 95% pour la variance d’une population, proc\u00e9dez comme suit :<\/p>\n
    1. Calculez la borne inf\u00e9rieure :<\/p>\n
    A = (n-1) * s^2 \/ CHISQ.INV.RT(0.975, n-1)<\/code><\/pre>\n
    2. Calculez la borne sup\u00e9rieure :<\/p>\n
    B = (n-1) * s^2 \/ CHISQ.INV.RT(0.025, n-1)<\/code><\/pre>\n
    3. L’intervalle de confiance est donc [A, B].<\/p>\n
    Ces exemples d\u00e9montrent comment les fonctions CHISQ.INV.RT ou LOI.KHIDEUX.INVERSE.DROITE peuvent \u00eatre utilis\u00e9es efficacement pour analyser et tirer des conclusions sur les propri\u00e9t\u00e9s statistiques de la variance des populations \u00e0 partir d’\u00e9chantillons.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie l\u2019inveRse de la pRobabilit\u00e9 unilat\u00e9Rale de la distRibution khi-deux<\/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-6437","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) 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\/chisq-inv-rt\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/chisq-inv-rt\/\" \/>\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:03:09+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) 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\/chisq-inv-rt\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/chisq-inv-rt\/\",\"name\":\"Fonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) 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:03:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/chisq-inv-rt\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/chisq-inv-rt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/chisq-inv-rt\/#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.KHIDEUX.INVERSE.DROITE\"}]},{\"@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 CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) 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\/chisq-inv-rt\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/chisq-inv-rt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) 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\/chisq-inv-rt\/","url":"https:\/\/functiontranslator.com\/fr\/chisq-inv-rt\/","name":"Fonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) 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:03:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CHISQ.INV.RT (LOI.KHIDEUX.INVERSE.DROITE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/chisq-inv-rt\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/chisq-inv-rt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/chisq-inv-rt\/#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.KHIDEUX.INVERSE.DROITE"}]},{"@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\/6437","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=6437"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6437\/revisions"}],"predecessor-version":[{"id":29449,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6437\/revisions\/29449"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6437"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6437"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}