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

Description de la fonction<\/h2>\n

La fonction LOI.KHIDEUX.N<\/strong> dans Microsoft Excel et CHISQ.DIST<\/strong> dans Google Sheets permet de calculer la probabilit\u00e9 associ\u00e9e \u00e0 la distribution du chi-deux. Cette distribution est fr\u00e9quemment utilis\u00e9e en statistiques pour r\u00e9aliser des tests d’ind\u00e9pendance et des ajustements de mod\u00e8les. La syntaxe de la fonction varie l\u00e9g\u00e8rement entre Excel et Google Sheets, comme expliqu\u00e9 dans les sections suivantes.<\/p>\n

Syntaxe dans Microsoft Excel<\/h2>\n

LOI.KHIDEUX.N(x, degr\u00e9s_libert\u00e9, cumulatif)<\/strong><\/p>\n

    \n
  • x<\/strong> : valeur pour laquelle la probabilit\u00e9 est \u00e9valu\u00e9e.<\/li>\n
  • degr\u00e9s_libert\u00e9<\/strong> : d\u00e9finit le nombre de degr\u00e9s de libert\u00e9 de la distribution.<\/li>\n
  • cumulatif<\/strong> : bool\u00e9en sp\u00e9cifiant la forme de la fonction. Si TRUE, la fonction retourne la distribution cumulative; si FALSE, elle retourne la densit\u00e9 de probabilit\u00e9.<\/li>\n<\/ul>\n

    Syntaxe dans Google Sheets<\/h2>\n

    CHISQ.DIST(x, degrees_freedom, cumulative)<\/strong><\/p>\n

      \n
    • x<\/strong> : valeur pour laquelle la probabilit\u00e9 est calcul\u00e9e.<\/li>\n
    • degrees_freedom<\/strong> : indique le nombre de degr\u00e9s de libert\u00e9 de la distribution.<\/li>\n
    • cumulative<\/strong> : bool\u00e9en qui, si TRUE, retourne la distribution cumulative, et si FALSE, renvoie la densit\u00e9 de probabilit\u00e9.<\/li>\n<\/ul>\n

      Exemples pratiques<\/h2>\n

      Voici deux exemples pratiques illustrant l’utilisation de cette fonction dans des sc\u00e9narios r\u00e9els.<\/p>\n

      T\u00e2che 1: Test d’ind\u00e9pendance<\/h2>\n

      Supposez que vous souhaitez d\u00e9terminer si deux cat\u00e9gories de donn\u00e9es sont ind\u00e9pendantes gr\u00e2ce au test du Chi-deux.<\/p>\n

       
       Cat\u00e9gorie<\/th> Observ\u00e9<\/th> Attendu<\/th> <\/tr> 
       A<\/td> 30<\/td> 25<\/td> <\/tr> 
       B<\/td> 20<\/td> 25<\/td> <\/tr> <\/table><\/code><\/pre>\n
       =pow((30-25),2)\/25 + pow((20-25),2)\/25 = 2<\/code> <\/p>\n
      En utilisant les fonctions mentionn\u00e9es pr\u00e9c\u00e9demment :<\/p>\n
       =LOI.KHIDEUX.N(2, 1, VRAI)<\/code> <\/pre>\n
      T\u00e2che 2: Ajustement de mod\u00e8le<\/h2>\n
      Consid\u00e9rez un mod\u00e8le bas\u00e9 sur des observations et vous souhaitez tester son ajustement en utilisant la distribution Chi-deux.<\/p>\n
       
       Mod\u00e8le<\/th> Observations<\/th> Attendu selon le mod\u00e8le<\/th> <\/tr> 
       1<\/td> 50<\/td> 40<\/td> <\/tr> 
       2<\/td> 30<\/td> 40<\/td> <\/tr> <\/table><\/code><\/pre>\n
       =pow((50-40),2)\/40 + pow((30-40),2)\/40 = 6.25<\/code> <\/p>\n
      Calcul du p-value avec la fonction LOI.KHIDEUX.N :<\/p>\n
       =LOI.KHIDEUX.N(6.25, 1, VRAI)<\/code> <\/pre>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la fonction de densit\u00e9 de distRibution de la pRobabilit\u00e9 suivant une loi b\u00eata cumul\u00e9e<\/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-6434","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction CHISQ.DIST (LOI.KHIDEUX.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CHISQ.DIST (LOI.KHIDEUX.N) 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-dist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CHISQ.DIST (LOI.KHIDEUX.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CHISQ.DIST (LOI.KHIDEUX.N) 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-dist\/\" \/>\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:01+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.DIST (LOI.KHIDEUX.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\/chisq-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/chisq-dist\/\",\"name\":\"Fonction CHISQ.DIST (LOI.KHIDEUX.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:03:01+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CHISQ.DIST (LOI.KHIDEUX.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/chisq-dist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/chisq-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/chisq-dist\/#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.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 CHISQ.DIST (LOI.KHIDEUX.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CHISQ.DIST (LOI.KHIDEUX.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\/chisq-dist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CHISQ.DIST (LOI.KHIDEUX.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CHISQ.DIST (LOI.KHIDEUX.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/chisq-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:01+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CHISQ.DIST (LOI.KHIDEUX.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\/chisq-dist\/","url":"https:\/\/functiontranslator.com\/fr\/chisq-dist\/","name":"Fonction CHISQ.DIST (LOI.KHIDEUX.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:03:01+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CHISQ.DIST (LOI.KHIDEUX.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/chisq-dist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/chisq-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/chisq-dist\/#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.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\/6434","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=6434"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6434\/revisions"}],"predecessor-version":[{"id":29446,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6434\/revisions\/29446"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}