{"id":10785,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/teste-chiq\/"},"modified":"2021-02-25T17:15:24","modified_gmt":"2021-02-25T17:15:24","slug":"chisq-test","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/","title":{"rendered":"TESTE.CHIQ"},"content":{"rendered":"

Introdu\u00e7\u00e3o ao Teste de Qui-Quadrado<\/h2>\n

O Teste de Qui-Quadrado, conhecido como CHISQ.TEST no Microsoft Excel e TESTE.CHIQ no Google Sheets, \u00e9 frequentemente empregado para averiguar a exist\u00eancia de uma associa\u00e7\u00e3o significativa entre as frequ\u00eancias observadas e as esperadas em uma ou v\u00e1rias categorias. Essencial em diversos campos, esta fun\u00e7\u00e3o \u00e9 amplamente utilizada na pesquisa de mercado, an\u00e1lise de satisfa\u00e7\u00e3o de clientes, testes de hip\u00f3teses em gen\u00e9tica, entre outros.<\/p>\n

Sintaxe e Exemplos<\/h2>\n

A sintaxe b\u00e1sica para essa fun\u00e7\u00e3o \u00e9 a seguinte:<\/p>\n

=TESTE.CHIQ(intervalo_dados_obs, intervalo_dados_esp)<\/code><\/pre>\n
Onde:<\/p>\n
    \n
  • intervalo_dados_obs<\/strong> representa o intervalo de c\u00e9lulas contendo os dados observados.<\/li>\n
  • intervalo_dados_esp<\/strong> indica o intervalo de c\u00e9lulas com os dados esperados, baseados na hip\u00f3tese nula.<\/li>\n<\/ul>\n
    Exemplo:<\/strong> Imagine que voc\u00ea deseja verificar se a cor de um dado influencia quantas vezes cada lado \u00e9 lan\u00e7ado em 100 jogadas. As frequ\u00eancias observadas e esperadas s\u00e3o apresentadas a seguir:<\/p>\n\n\n\n\n\n\n\n\n
    Cor<\/th>\nObservado<\/th>\nEsperado<\/th>\n<\/tr>\n
    Vermelho<\/td>\n18<\/td>\n16.67<\/td>\n<\/tr>\n
    Azul<\/td>\n17<\/td>\n16.67<\/td>\n<\/tr>\n
    Verde<\/td>\n15<\/td>\n16.67<\/td>\n<\/tr>\n
    Amarelo<\/td>\n20<\/td>\n16.67<\/td>\n<\/tr>\n
    Preto<\/td>\n17<\/td>\n16.67<\/td>\n<\/tr>\n
    Branco<\/td>\n13<\/td>\n16.67<\/td>\n<\/tr>\n<\/table>\n
    Para realizar o teste, use a fun\u00e7\u00e3o:<\/p>\n
    =TESTE.CHIQ(A2:A7, B2:B7)<\/code><\/pre>\n
    Este exemplo retorna um p-valor, que ajuda a determinar se as diferen\u00e7as observadas s\u00e3o estatisticamente significativas ou meramente ao acaso.<\/p>\n
    Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n
    Caso 1: An\u00e1lise de prefer\u00eancia de produto<\/h2>\n
    Uma empresa investiga se existe uma prefer\u00eancia significativa entre quatro sabores diferentes de um produto alimentar. Os resultados da frequ\u00eancia observada versus a esperada (todos os sabores com igual prefer\u00eancia) s\u00e3o:<\/p>\n\n\n\n\n\n\n
    Sabor<\/th>\nObservado<\/th>\nEsperado<\/th>\n<\/tr>\n
    Chocolate<\/td>\n300<\/td>\n250<\/td>\n<\/tr>\n
    Baunilha<\/td>\n270<\/td>\n250<\/td>\n<\/tr>\n
    Morango<\/td>\n220<\/td>\n250<\/td>\n<\/tr>\n
    Caramelo<\/td>\n210<\/td>\n250<\/td>\n<\/tr>\n<\/table>\n
    Aplicando a fun\u00e7\u00e3o, a an\u00e1lise resultar\u00e1 em um p-valor:<\/p>\n
    =TESTE.CHIQ(C2:C5, D2:D5)<\/code><\/pre>\n
    Um p-valor abaixo do n\u00edvel de signific\u00e2ncia estabelecido (geralmente 0,05) indica uma prefer\u00eancia significativa entre os sabores.<\/p>\n
    Caso 2: Testando equipamento<\/h2>\n
    Uma f\u00e1brica necessita verificar se cinco m\u00e1quinas distintas apresentam a mesma efic\u00e1cia na produ\u00e7\u00e3o de pe\u00e7as. Os registros de pe\u00e7as boas e defeituosas de cada m\u00e1quina s\u00e3o:<\/p>\n\n\n\n\n\n\n\n
    M\u00e1quina<\/th>\nPe\u00e7as Boas<\/th>\nPe\u00e7as Defeituosas<\/th>\nTotal<\/th>\nEsperado Boas<\/th>\nEsperado Defeituosas<\/th>\n<\/tr>\n
    A<\/td>\n400<\/td>\n100<\/td>\n500<\/td>\n410<\/td>\n90<\/td>\n<\/tr>\n
    B<\/td>\n380<\/td>\n120<\/td>\n500<\/td>\n410<\/td>\n90<\/td>\n<\/tr>\n
    C<\/td>\n390<\/td>\n110<\/td>\n500<\/td>\n410<\/td>\n90<\/td>\n<\/tr>\n
    D<\/td>\n370<\/td>\n130<\/td>\n500<\/td>\n410<\/td>\n90<\/td>\n<\/tr>\n
    E<\/td>\n450<\/td>\n50<\/td>\n500<\/td>\n410<\/td>\n90<\/td>\n<\/tr>\n<\/table>\n
    A fun\u00e7\u00e3o \u00e9 aplicada da seguinte forma para testar se existe diferen\u00e7a significativa entre as m\u00e1quinas:<\/p>\n
    =TESTE.CHIQ(C2:C6, E2:E6)<\/code><\/pre>\n
    Um p-valor baixo sugere que as m\u00e1quinas diferem significativamente na propor\u00e7\u00e3o de pe\u00e7as boas produzidas em rela\u00e7\u00e3o ao esperado, poss\u00edvel indicativo da necessidade de manuten\u00e7\u00e3o ou recalibra\u00e7\u00e3o em m\u00e1quinas espec\u00edficas.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devolve o teste para independ\u00eancia<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[442],"tags":[],"class_list":["post-10785","post","type-post","status-publish","format-standard","hentry","category-estatistica"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\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\/pt-pt\/chisq-test\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:15:24+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/\",\"name\":\"Fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:51+00:00\",\"dateModified\":\"2021-02-25T17:15:24+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estat\u00edstica\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/estatistica\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TESTE.CHIQ\"}]},{\"@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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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\/pt-pt\/chisq-test\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:15:24+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/","url":"https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/","name":"Fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:51+00:00","dateModified":"2021-02-25T17:15:24+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o CHISQ.TEST (TESTE.CHIQ) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/chisq-test\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Estat\u00edstica","item":"https:\/\/functiontranslator.com\/pt-pt\/estatistica\/"},{"@type":"ListItem","position":3,"name":"TESTE.CHIQ"}]},{"@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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=10785"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10785\/revisions"}],"predecessor-version":[{"id":25614,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10785\/revisions\/25614"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}