{"id":6433,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/test-khideux\/"},"modified":"2021-02-26T08:03:00","modified_gmt":"2021-02-26T08:03:00","slug":"chitest","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/chitest\/","title":{"rendered":"TEST.KHIDEUX"},"content":{"rendered":"

Le test du chi-deux, \u00e9galement connu sous le nom de chi-carr\u00e9, est couramment utilis\u00e9 en statistique pour \u00e9valuer la compatibilit\u00e9 entre les fr\u00e9quences observ\u00e9es d’un \u00e9chantillon et les fr\u00e9quences th\u00e9oriques attendues. Cette fonction est accessible aussi bien dans Microsoft Excel que dans Google Sheets, mais sous diff\u00e9rents noms. Dans Excel, elle est appel\u00e9e CHITEST<\/code>, tandis que dans Google Sheets, elle est r\u00e9f\u00e9renc\u00e9e sous TEST.KHIDEUX<\/code>.<\/p>\n

Description du Test<\/h2>\n

La fonction est id\u00e9ale pour tester l\u2019hypoth\u00e8se d’ind\u00e9pendance dans le cadre de l’analyse de donn\u00e9es cat\u00e9gorielles organis\u00e9es dans un tableau de contingence. Elle permet de comparer les fr\u00e9quences observ\u00e9es aux fr\u00e9quences attendues, fournissant une probabilit\u00e9 qui indique si les \u00e9carts observ\u00e9s pourraient \u00eatre d\u00fbs au hasard.<\/p>\n

Syntaxe de la Fonction<\/h2>\n

Pour Microsoft Excel :<\/p>\n

=CHITEST(plage_obs, plage_th\u00e9or)<\/code><\/pre>\n
Pour Google Sheets :<\/p>\n
=TEST.KHIDEUX(plage_obs, plage_th\u00e9or)<\/code><\/pre>\n
    \n
  • plage_obs<\/strong> : La plage de cellules contenant les fr\u00e9quences observ\u00e9es.<\/li>\n
  • plage_th\u00e9or<\/strong> : La plage de cellules contenant les fr\u00e9quences th\u00e9oriques pr\u00e9vues.<\/li>\n<\/ul>\n
    Exemple d’Utilisation<\/h2>\n
    Examinons une analyse de donn\u00e9es cat\u00e9gorielles o\u00f9 nous voulons v\u00e9rifier si la distribution des fr\u00e9quences observ\u00e9es correspond aux fr\u00e9quences attendues.<\/p>\n\n\n\n\n\n
    Cat\u00e9gorie<\/th>\nObserv\u00e9<\/th>\nTh\u00e9orique<\/th>\n<\/tr>\n
    A<\/td>\n40<\/td>\n30<\/td>\n<\/tr>\n
    B<\/td>\n30<\/td>\n30<\/td>\n<\/tr>\n
    C<\/td>\n30<\/td>\n40<\/td>\n<\/tr>\n<\/table>\n
      \n
    • Dans Excel : =CHITEST(A2:A4, B2:B4)<\/code><\/li>\n
    • Dans Google Sheets : =TEST.KHIDEUX(A2:A4, B2:B4)<\/code><\/li>\n<\/ul>\n
      Ces formules retourneront une valeur de p qui indique la probabilit\u00e9 que les diff\u00e9rences entre les donn\u00e9es observ\u00e9es et les donn\u00e9es th\u00e9oriques soient le r\u00e9sultat du hasard.<\/p>\n
      Cas Pratiques<\/h2>\n
      Sc\u00e9nario 1 : Analyse de l’efficacit\u00e9 d’une campagne publicitaire<\/strong><\/p>\n
      Supposons que vous ayez lanc\u00e9 trois types diff\u00e9rents de publicit\u00e9s et que vous souhaitiez d\u00e9terminer si la r\u00e9action des clients varie significativement par rapport \u00e0 une distribution uniforme attendue selon votre strat\u00e9gie marketing.<\/p>\n
      Sc\u00e9nario 2 : \u00c9tude de la distribution de produits<\/strong><\/p>\n
      Si vous \u00eates dans une entreprise de distribution et que vous voulez v\u00e9rifier si la distribution des produits est conforme aux pr\u00e9visions de la direction, cette fonction pourrait \u00eatre utilis\u00e9e pour identifier d\u2019\u00e9ventuels \u00e9carts significatifs.<\/p>\n
      Dans les deux sc\u00e9narios, l\u2019utilisation de CHITEST<\/code> ou TEST.KHIDEUX<\/code> peut vous aider \u00e0 confirmer ou r\u00e9futer les hypoth\u00e8ses bas\u00e9es sur les donn\u00e9es observ\u00e9es par rapport aux donn\u00e9es th\u00e9oriques, ce qui facilite les prises de d\u00e9cision strat\u00e9giques s’appuyant sur des analyses statistiques rigoureuses.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie le test d\u2019ind\u00e9pendance<\/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-6433","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction CHITEST (TEST.KHIDEUX) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CHITEST (TEST.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\/chitest\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CHITEST (TEST.KHIDEUX) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CHITEST (TEST.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\/chitest\/\" \/>\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:00+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CHITEST (TEST.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\/chitest\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/chitest\/\",\"name\":\"Fonction CHITEST (TEST.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:03:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CHITEST (TEST.KHIDEUX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/chitest\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/chitest\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/chitest\/#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\":\"TEST.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 CHITEST (TEST.KHIDEUX) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CHITEST (TEST.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\/chitest\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CHITEST (TEST.KHIDEUX) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CHITEST (TEST.KHIDEUX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/chitest\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CHITEST (TEST.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\/chitest\/","url":"https:\/\/functiontranslator.com\/fr\/chitest\/","name":"Fonction CHITEST (TEST.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:03:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CHITEST (TEST.KHIDEUX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/chitest\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/chitest\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/chitest\/#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":"TEST.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\/6433","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=6433"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6433\/revisions"}],"predecessor-version":[{"id":29445,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6433\/revisions\/29445"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}