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

Introduction \u00e0 la fonction LOI.KHIDEUX dans Excel et Google Sheets<\/h2>\n

La fonction LOI.KHIDEUX<\/strong> est utilis\u00e9e pour calculer la probabilit\u00e9 dans la queue sup\u00e9rieure de la distribution du chi-deux. Elle est essentielle dans les analyses statistiques, notamment dans les tests d’ind\u00e9pendance ou d’ajustement des mod\u00e8les, o\u00f9 elle \u00e9value la probabilit\u00e9 qu’une valeur de statistique de test calcul\u00e9e soit sup\u00e9rieure \u00e0 une valeur observ\u00e9e.<\/p>\n

Syntaxe et param\u00e8tres<\/h2>\n

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

=LOI.KHIDEUX(X; Degr\u00e9s_de_libert\u00e9)<\/code><\/pre>\n
Voici une description des param\u00e8tres :<\/p>\n
    \n
  • X<\/strong> : Valeur pour laquelle la probabilit\u00e9 est calcul\u00e9e. Pour un test chi-deux, cela correspond \u00e0 la valeur de la statistique de test.<\/li>\n
  • Degr\u00e9s_de_libert\u00e9<\/strong> : Nombre de degr\u00e9s de libert\u00e9 de la distribution chi-deux, d\u00e9pendant g\u00e9n\u00e9ralement du nombre de cat\u00e9gories ind\u00e9pendantes dans le test, moins un.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n\n\n\n\n
    Formule<\/th>\nDescription<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    =LOI.KHIDEUX(10.5; 5)<\/code><\/td>\nCalcule la probabilit\u00e9 qu’une valeur d\u00e9passe 10.5 dans une distribution chi-deux avec 5 degr\u00e9s de libert\u00e9.<\/td>\n0.063<\/td>\n<\/tr>\n
    =LOI.KHIDEUX(3.84; 1)<\/code><\/td>\nProbabilit\u00e9 de d\u00e9passer 3.84 avec 1 degr\u00e9 de libert\u00e9, fr\u00e9quemment utilis\u00e9e dans les crit\u00e8res pour les tests chi-deux.<\/td>\n0.05<\/td>\n<\/tr>\n<\/table>\n
    Applications pratiques<\/h2>\n
    Explorons comment utiliser cette fonction \u00e0 travers les sc\u00e9narios suivants :<\/p>\n
    Cas d’\u00e9tude n\u00b01 : Test d’ind\u00e9pendance<\/h2>\n
    Consid\u00e9rons un test d’ind\u00e9pendance effectu\u00e9 sur une table de contingence 3×2 pour analyser les pr\u00e9f\u00e9rences produit entre deux groupes de clients. Avec une statistique chi-deux de 6.5 et 2 degr\u00e9s de libert\u00e9 (3-1)(2-1), vous voudriez d\u00e9terminer si cette valeur est significativement \u00e9lev\u00e9e.<\/p>\n
    =LOI.KHIDEUX(6.5; 2)<\/code><\/pre>\n
    Cette formule fournira la probabilit\u00e9 que la valeur de 6.5 soit d\u00e9pass\u00e9e avec 2 degr\u00e9s de libert\u00e9, aidant ainsi \u00e0 conclure sur l’ind\u00e9pendance des variables.<\/p>\n
    Cas d’\u00e9tude n\u00b02 : Ajustement d’un mod\u00e8le<\/h2>\n
    Imaginons un biologiste \u00e9valuant l’ajustement d’un mod\u00e8le pr\u00e9dictif de r\u00e9partitions de fr\u00e9quences de certains traits g\u00e9n\u00e9tiques. Avec une valeur chi-deux de 10 et 4 degr\u00e9s de libert\u00e9, il serait pertinent de v\u00e9rifier si les \u00e9carts observ\u00e9s sont suffisamment importants pour rejeter ou non le mod\u00e8le.<\/p>\n
    =LOI.KHIDEUX(10; 4)<\/code><\/pre>\n
    Cette entr\u00e9e permettra d’\u00e9valuer la validit\u00e9 du mod\u00e8le bas\u00e9 sur les \u00e9carts par rapport aux fr\u00e9quences attendues.<\/p>\n
     Cette approche d\u00e9taill\u00e9e, enrichie d’exemples pratiques, devrait aider les utilisateurs de Microsoft Excel et Google Sheets \u00e0 mieux comprendre et employer la fonction LOI.KHIDEUX dans leurs analyses statistiques.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie 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-6431","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction CHIDIST (LOI.KHIDEUX) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CHIDIST (LOI.KHIDEUX) 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\/chidist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CHIDIST (LOI.KHIDEUX) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CHIDIST (LOI.KHIDEUX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/chidist\/\" \/>\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:56+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CHIDIST (LOI.KHIDEUX) 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\/chidist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/chidist\/\",\"name\":\"Fonction CHIDIST (LOI.KHIDEUX) 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:56+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CHIDIST (LOI.KHIDEUX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/chidist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/chidist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/chidist\/#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.KHIDEUX\"}]},{\"@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 CHIDIST (LOI.KHIDEUX) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CHIDIST (LOI.KHIDEUX) 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\/chidist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CHIDIST (LOI.KHIDEUX) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CHIDIST (LOI.KHIDEUX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/chidist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:56+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CHIDIST (LOI.KHIDEUX) 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\/chidist\/","url":"https:\/\/functiontranslator.com\/fr\/chidist\/","name":"Fonction CHIDIST (LOI.KHIDEUX) 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:56+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CHIDIST (LOI.KHIDEUX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/chidist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/chidist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/chidist\/#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.KHIDEUX"}]},{"@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\/6431","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=6431"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6431\/revisions"}],"predecessor-version":[{"id":29443,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6431\/revisions\/29443"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}