{"id":11023,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/unidm\/"},"modified":"2021-02-25T17:24:58","modified_gmt":"2021-02-25T17:24:58","slug":"munit","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/munit\/","title":{"rendered":"UNIDM"},"content":{"rendered":"

Introdu\u00e7\u00e3o \u00e0 Matriz Unit\u00e1ria<\/h2>\n

No Microsoft Excel e no Google Planilhas, a fun\u00e7\u00e3o MUNIT()<\/strong> (nomeada UNIDM()<\/strong> nas vers\u00f5es em portugu\u00eas) \u00e9 empregada para gerar uma matriz identidade de ordem n<\/em>. Uma matriz identidade \u00e9 um tipo de matriz quadrada em que todos os elementos da diagonal principal s\u00e3o 1 e todos os outros elementos s\u00e3o 0. <\/p>\n

Sintaxe e Exemplo de Uso<\/h2>\n

A sintaxe para a fun\u00e7\u00e3o \u00e9 simples:<\/p>\n

    \n
  • Excel:<\/strong> =MUNIT(n\u00famero_de_linhas)<\/code><\/li>\n
  • Google Planilhas:<\/strong> =UNIDM(n\u00famero_de_linhas)<\/code><\/li>\n<\/ul>\n

    O par\u00e2metro n\u00famero_de_linhas<\/em> refere-se \u00e0 ordem da matriz identidade, determinando tanto o n\u00famero de linhas quanto o de colunas da matriz. <\/p>\n

    Exemplo:<\/strong><\/p>\n

    =MUNIT(3)<\/code><\/pre>\n
     O exemplo acima retorna a seguinte matriz identidade de ordem 3: <\/p>\n\n\n\n\n
    1<\/td>\n0<\/td>\n0<\/td>\n<\/tr>\n
    0<\/td>\n1<\/td>\n0<\/td>\n<\/tr>\n
    0<\/td>\n0<\/td>\n1<\/td>\n<\/tr>\n<\/table>\n
    Aplica\u00e7\u00f5es Pr\u00e1ticas da Fun\u00e7\u00e3o<\/h2>\n
    Conhecer e utilizar a matriz identidade \u00e9 extremamente \u00fatil em v\u00e1rias aplica\u00e7\u00f5es matem\u00e1ticas e na an\u00e1lise de dados. Aqui est\u00e3o duas aplica\u00e7\u00f5es pr\u00e1ticas:<\/p>\n
    1. Resolvendo sistemas de equa\u00e7\u00f5es lineares<\/h2>\n
     A matriz identidade pode ser usada para resolver sistemas de equa\u00e7\u00f5es lineares atrav\u00e9s do m\u00e9todo da matriz inversa. Considere o seguinte sistema de equa\u00e7\u00f5es: <\/p>\n
    3x + 4y = 5 2x + 5y = 6<\/code><\/pre>\n
    Primeiro, represente o sistema na forma matricial Ax = B<\/strong>, onde A<\/strong> \u00e9 a matriz dos coeficientes, x<\/strong> \u00e9 o vetor de vari\u00e1veis e B<\/strong> \u00e9 o vetor de constantes. Aqui, A<\/strong> seria:<\/p>\n\n\n\n
    3<\/td>\n4<\/td>\n<\/tr>\n
    2<\/td>\n5<\/td>\n<\/tr>\n<\/table>\n
    e B<\/strong> seria:<\/p>\n\n\n\n
    5<\/td>\n<\/tr>\n
    6<\/td>\n<\/tr>\n<\/table>\n
     Use a matriz identidade para encontrar a inversa de A<\/strong>, se existir, e ent\u00e3o multiplique essa matriz inversa pelo vetor B<\/strong> para solucionar x<\/strong>. <\/p>\n
    2. An\u00e1lise de transforma\u00e7\u00f5es lineares<\/h2>\n
     Outra aplica\u00e7\u00e3o essencial da matriz identidade ocorre na an\u00e1lise de transforma\u00e7\u00f5es lineares, tanto em matem\u00e1tica quanto em computa\u00e7\u00e3o gr\u00e1fica. Matrizes identidade s\u00e3o frequentemente usadas em opera\u00e7\u00f5es que preservam as propriedades dos objetos, como rota\u00e7\u00f5es ou transla\u00e7\u00f5es no espa\u00e7o. No contexto das transforma\u00e7\u00f5es lineares, a matriz identidade representa a matriz de uma transforma\u00e7\u00e3o que n\u00e3o altera um objeto. <\/p>\n
     Por exemplo, uma transforma\u00e7\u00e3o representada pela matriz identidade em tr\u00eas dimens\u00f5es mant\u00e9m todos os pontos no espa\u00e7o em suas coordenadas originais, indicando que n\u00e3o ocorreu nenhuma altera\u00e7\u00e3o na posi\u00e7\u00e3o ou orienta\u00e7\u00e3o do objeto. <\/p>\n","protected":false},"excerpt":{"rendered":"
    Devolte a matriz da unidade ou a dimens\u00e3o especificada<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[437],"tags":[],"class_list":["post-11023","post","type-post","status-publish","format-standard","hentry","category-matematica-e-trigonometria"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o MUNIT (UNIDM) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o MUNIT (UNIDM) 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\/munit\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o MUNIT (UNIDM) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o MUNIT (UNIDM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/munit\/\" \/>\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:24:58+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 MUNIT (UNIDM) 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\/munit\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/munit\/\",\"name\":\"Fun\u00e7\u00e3o MUNIT (UNIDM) 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:24:58+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o MUNIT (UNIDM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/munit\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/munit\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/munit\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matem\u00e1tica e trigonometria\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/matematica-e-trigonometria\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"UNIDM\"}]},{\"@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 MUNIT (UNIDM) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o MUNIT (UNIDM) 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\/munit\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o MUNIT (UNIDM) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o MUNIT (UNIDM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/munit\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:24:58+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o MUNIT (UNIDM) 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\/munit\/","url":"https:\/\/functiontranslator.com\/pt-pt\/munit\/","name":"Fun\u00e7\u00e3o MUNIT (UNIDM) 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:24:58+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o MUNIT (UNIDM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/munit\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/munit\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/munit\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Matem\u00e1tica e trigonometria","item":"https:\/\/functiontranslator.com\/pt-pt\/matematica-e-trigonometria\/"},{"@type":"ListItem","position":3,"name":"UNIDM"}]},{"@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\/11023","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=11023"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11023\/revisions"}],"predecessor-version":[{"id":25852,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11023\/revisions\/25852"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=11023"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=11023"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=11023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}