{"id":6857,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/test-z\/"},"modified":"2021-02-26T08:16:48","modified_gmt":"2021-02-26T08:16:48","slug":"ztest","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/ztest\/","title":{"rendered":"TEST.Z"},"content":{"rendered":"

La fonction ZTEST, \u00e9galement connue sous le nom de TEST.Z, est utilis\u00e9e dans Microsoft Excel et Google Sheets pour tester si la moyenne d’un \u00e9chantillon diff\u00e8re significativement d’une valeur sp\u00e9cifique de la population moyenne, en assumant une distribution normale des donn\u00e9es. Cette fonction est fr\u00e9quemment utilis\u00e9e pour effectuer des tests d’hypoth\u00e8ses sur la moyenne d’une population bas\u00e9s sur un \u00e9chantillon.<\/p>\n

Description du Syst\u00e8me<\/h2>\n

Voici la syntaxe de la fonction ZTEST dans Excel :<\/p>\n

=ZTEST(array, x, [std_dev])<\/code><\/pre>\n
    \n
  • array<\/strong> : La plage de donn\u00e9es qui constitue l’\u00e9chantillon.<\/li>\n
  • x<\/strong> : La moyenne de la population que vous souhaitez tester contre l’\u00e9chantillon.<\/li>\n
  • std_dev (optionnel)<\/strong> : L’\u00e9cart type de la population. Si cet argument n’est pas sp\u00e9cifi\u00e9, l’\u00e9cart type est estim\u00e9 \u00e0 partir des donn\u00e9es de l’\u00e9chantillon.<\/li>\n<\/ul>\n
    La fonction renvoie la probabilit\u00e9 bilat\u00e9rale d’obtenir une valeur plus extr\u00eame que la moyenne observ\u00e9e de l’\u00e9chantillon par rapport \u00e0 la moyenne de la population \u00ab x \u00bb, sous l’hypoth\u00e8se d’une distribution normale.<\/p>\n
    Exemple d’utilisation<\/h2>\n
    Imaginons que vous ayez les scores de satisfaction client de 30 clients d’un nouveau produit, et vous voulez v\u00e9rifier si la moyenne de ces scores est statistiquement diff\u00e9rente de 75, une cible fix\u00e9e par l’entreprise.<\/p>\n
    =ZTEST(A2:A31, 75)<\/code><\/pre>\n
    Dans cet exemple, la plage A2:A31<\/code> contient les scores de satisfaction et 75 repr\u00e9sente la valeur moyenne cible de la population. La fonction retourne la p-value qui aide \u00e0 \u00e9valuer statistiquement cette diff\u00e9rence.<\/p>\n
    Sc\u00e9narios Pratiques<\/h2>\n
      \n
    • Comparaison de la moyenne de production :<\/strong> Une entreprise souhaite v\u00e9rifier si la moyenne de production hebdomadaire de 500 unit\u00e9s r\u00e9pond aux attentes de production de 520 unit\u00e9s. Les enregistrements hebdomadaires sont dans la plage B2:B53.<\/li>\n
    • \u00c9valuation de la performance des ventes :<\/strong> Un responsable des ventes utilise ZTEST pour v\u00e9rifier si la moyenne des ventes mensuelles de son \u00e9quipe se distingue significativement de l’objectif mensuel de 10 000 unit\u00e9s. Les donn\u00e9es des ventes sur 12 mois sont dans la plage C2:C13.<\/li>\n<\/ul>\n
      Voici comment mettre en \u0153uvre ces sc\u00e9narios dans Excel :<\/p>\n
      Solution pour la comparaison de la moyenne de production :<\/strong><\/p>\n
      =ZTEST(B2:B53, 520)<\/code><\/pre>\n
      Cette formule permet d’\u00e9valuer si les donn\u00e9es de production diff\u00e8rent significativement de l’objectif. Une p-value faible indique un \u00e9cart significatif.<\/p>\n
      Solution pour l’\u00e9valuation de la performance des ventes :<\/strong><\/p>\n
      =ZTEST(C2:C13, 10000)<\/code><\/pre>\n
      De m\u00eame, cette formule permet au responsable de d\u00e9terminer si les ventes diff\u00e8rent statistiquement de l’objectif pr\u00e9\u00e9tabli.<\/p>\n
      La fonction ZTEST offre aux d\u00e9cideurs un outil fond\u00e9 sur les donn\u00e9es pour \u00e9valuer les performances face aux normes ou objectifs d\u00e9finis, facilitant ainsi la prise de d\u00e9cisions \u00e9clair\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la valeuR de pRobabilit\u00e9 unilat\u00e9Rale d\u2019un test Z<\/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-6857","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction ZTEST (TEST.Z) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ZTEST (TEST.Z) 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\/ztest\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ZTEST (TEST.Z) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ZTEST (TEST.Z) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/ztest\/\" \/>\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:16:48+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ZTEST (TEST.Z) 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\/ztest\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/ztest\/\",\"name\":\"Fonction ZTEST (TEST.Z) 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:16:48+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ZTEST (TEST.Z) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/ztest\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/ztest\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/ztest\/#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.Z\"}]},{\"@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 ZTEST (TEST.Z) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ZTEST (TEST.Z) 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\/ztest\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ZTEST (TEST.Z) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ZTEST (TEST.Z) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/ztest\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:16:48+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ZTEST (TEST.Z) 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\/ztest\/","url":"https:\/\/functiontranslator.com\/fr\/ztest\/","name":"Fonction ZTEST (TEST.Z) 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:16:48+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ZTEST (TEST.Z) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/ztest\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/ztest\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/ztest\/#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.Z"}]},{"@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\/6857","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=6857"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6857\/revisions"}],"predecessor-version":[{"id":29866,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6857\/revisions\/29866"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}