{"id":6432,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/khideux-inverse\/"},"modified":"2021-02-26T08:02:57","modified_gmt":"2021-02-26T08:02:57","slug":"chiinv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/chiinv\/","title":{"rendered":"KHIDEUX.INVERSE"},"content":{"rendered":"

Description et syntaxe de la fonction<\/h2>\n

La fonction KHIDEUX.INVERSE, anciennement nomm\u00e9e CHIINV dans les versions ant\u00e9rieures de MS Excel, calcule l’inverse de la distribution du Chi-deux. Elle est couramment utilis\u00e9e en statistique pour r\u00e9aliser des tests d’ind\u00e9pendance ou de conformit\u00e9. Cette fonction d\u00e9termine une valeur seuil bas\u00e9e sur une probabilit\u00e9 et un nombre sp\u00e9cifi\u00e9 de degr\u00e9s de libert\u00e9 associ\u00e9s \u00e0 la distribution du Chi-deux.<\/p>\n

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

KHIDEUX.INVERSE(probabilit\u00e9; degr\u00e9s_de_libert\u00e9)<\/code><\/pre>\n
o\u00f9 :<\/p>\n
    \n
  • probabilit\u00e9<\/b> : La probabilit\u00e9 correspondant \u00e0 la valeur critique de la distribution du Chi-deux.<\/li>\n
  • degr\u00e9s de libert\u00e9<\/b> : Le nombre de degr\u00e9s de libert\u00e9 de la distribution.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Voici des exemples illustrant l’utilisation de la fonction KHIDEUX.INVERSE dans des cas pratiques.<\/p>\n
    Exemple 1 :<\/b> Calcul de la valeur du Chi-deux pour une probabilit\u00e9 de 0.05 avec 10 degr\u00e9s de libert\u00e9.<\/p>\n
    =KHIDEUX.INVERSE(0.05; 10)<\/code><\/pre>\n
    Cette formule retourne la valeur seuil critique de la distribution du Chi-deux, permettant d’\u00e9valuer si une statistique de test observ\u00e9e est notablement extr\u00eame pour une distribution du Chi-deux comportant 10 degr\u00e9s de libert\u00e9.<\/p>\n
    Exemple 2 :<\/b> D\u00e9termination du seuil critique pour une probabilit\u00e9 de 0.01 avec 5 degr\u00e9s de libert\u00e9.<\/p>\n
    =KHIDEUX.INVERSE(0.01; 5)<\/code><\/pre>\n
    Le r\u00e9sultat indique la valeur critique du Chi-deux, repr\u00e9sentant l’extr\u00e9mit\u00e9 inf\u00e9rieure 1% de la distribution pour 5 degr\u00e9s de libert\u00e9.<\/p>\n
    Sc\u00e9narios pratiques<\/h2>\n
    L’utilisation de KHIDEUX.INVERSE est versatile et peut \u00eatre appliqu\u00e9e \u00e0 divers contextes statistiques. Voici quelques sc\u00e9narios o\u00f9 elle se r\u00e9v\u00e8le particuli\u00e8rement pr\u00e9cieuse :<\/p>\n
    Sc\u00e9nario 1 : Test d’ad\u00e9quation du Chi-deux<\/b><\/p>\n
    Consid\u00e9rons un sociologue testant si la r\u00e9partition des cat\u00e9gories d’emploi dans une r\u00e9gion respecte certaines proportions attendues. En utilisant KHIDEUX.INVERSE pour obtenir les valeurs seuils critiques du Chi-deux apr\u00e8s calcul des fr\u00e9quences, si le Chi-deux calcul\u00e9 exc\u00e8de cette valeur critique, cela indiquerait une diff\u00e9rence significative entre les observations et les attentes.<\/p>\n
    Sc\u00e9nario 2 : Test d’ind\u00e9pendance<\/b><\/p>\n
    Dans une \u00e9tude en biologie, l’ind\u00e9pendance de deux caract\u00e9ristiques g\u00e9n\u00e9tiques est analys\u00e9e. Suite \u00e0 la cr\u00e9ation d’un tableau de contingence et au calcul du Chi-deux observ\u00e9, KHIDEUX.INVERSE est utilis\u00e9 pour \u00e9tablir la valeur seuil critique. Cette derni\u00e8re aide \u00e0 d\u00e9terminer si les caract\u00e9ristiques \u00e9tudi\u00e9es sont ind\u00e9pendantes ou non.<\/p>\n
    En conclusion, KHIDEUX.INVERSE est indispensable pour l’interpr\u00e9tation des r\u00e9sultats de tests utilisant la distribution du Chi-deux, offrant des seuils pour \u00e9valuer la pertinence des observations statistiques.<\/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":[317],"tags":[],"class_list":["post-6432","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction CHIINV (KHIDEUX.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CHIINV (KHIDEUX.INVERSE) 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\/chiinv\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CHIINV (KHIDEUX.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CHIINV (KHIDEUX.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/chiinv\/\" \/>\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:02:57+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CHIINV (KHIDEUX.INVERSE) 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\/chiinv\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/chiinv\/\",\"name\":\"Fonction CHIINV (KHIDEUX.INVERSE) 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:02:57+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CHIINV (KHIDEUX.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/chiinv\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/chiinv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/chiinv\/#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\":\"KHIDEUX.INVERSE\"}]},{\"@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 CHIINV (KHIDEUX.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CHIINV (KHIDEUX.INVERSE) 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\/chiinv\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CHIINV (KHIDEUX.INVERSE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CHIINV (KHIDEUX.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/chiinv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:57+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CHIINV (KHIDEUX.INVERSE) 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\/chiinv\/","url":"https:\/\/functiontranslator.com\/fr\/chiinv\/","name":"Fonction CHIINV (KHIDEUX.INVERSE) 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:02:57+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CHIINV (KHIDEUX.INVERSE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/chiinv\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/chiinv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/chiinv\/#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":"KHIDEUX.INVERSE"}]},{"@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\/6432","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=6432"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6432\/revisions"}],"predecessor-version":[{"id":29444,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6432\/revisions\/29444"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}