{"id":10922,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/media-harmonica\/"},"modified":"2021-02-25T17:20:39","modified_gmt":"2021-02-25T17:20:39","slug":"harmean","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/harmean\/","title":{"rendered":"M\u00c9DIA.HARM\u00d3NICA"},"content":{"rendered":"

A fun\u00e7\u00e3o M\u00c9DIA.HARM\u00d4NICA \u00e9 empregada tanto no Microsoft Excel quanto no Google Planilhas para calcular a m\u00e9dia harm\u00f4nica de um conjunto de n\u00fameros. Diferente da m\u00e9dia aritm\u00e9tica, a m\u00e9dia harm\u00f4nica \u00e9 particularmente adequada para conjuntos de dados que incluem n\u00fameros extremamente baixos ou quando esses valores precisam ser adequadamente ponderados. Ela \u00e9 frequentemente utilizada em an\u00e1lises estat\u00edsticas relacionadas a velocidades, raz\u00f5es ou propor\u00e7\u00f5es.<\/p>\n

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

A sintaxe para a fun\u00e7\u00e3o M\u00c9DIA.HARM\u00d4NICA \u00e9:<\/p>\n

=M\u00c9DIA.HARM\u00d4NICA(n\u00famero1; [n\u00famero2]; ...)<\/code><\/pre>\n
    \n
  • n\u00famero1, n\u00famero2, …<\/strong> – Representam os valores dos quais se deseja calcular a m\u00e9dia harm\u00f4nica. A fun\u00e7\u00e3o pode receber at\u00e9 255 argumentos num\u00e9ricos.<\/li>\n<\/ul>\n
    Por exemplo, para calcular a m\u00e9dia harm\u00f4nica dos n\u00fameros 3, 4 e 5 em uma c\u00e9lula do Excel ou Google Planilhas, utilize:<\/p>\n
    =M\u00c9DIA.HARM\u00d4NICA(3; 4; 5)<\/code><\/pre>\n
    O resultado ser\u00e1 aproximadamente 3,9.<\/p>\n
    Aplica\u00e7\u00e3o Pr\u00e1tica<\/h2>\n
    An\u00e1lise de Velocidades<\/h2>\n
    Considere o caso de um atleta que correu tr\u00eas trechos de uma prova com velocidades distintas. Para calcular a m\u00e9dia harm\u00f4nica das velocidades de 10 km\/h, 15 km\/h e 20 km\/h durante toda a corrida, a f\u00f3rmula seria:<\/p>\n
    =M\u00c9DIA.HARM\u00d4NICA(10; 15; 20)<\/code><\/pre>\n
    A m\u00e9dia harm\u00f4nica proporciona uma estimativa da velocidade m\u00e9dia que reflete mais acuradamente o tempo gasto em cada trecho, em contraposi\u00e7\u00e3o \u00e0 m\u00e9dia aritm\u00e9tica simples.<\/p>\n
    Compara\u00e7\u00e3o de Raz\u00f5es Financeiras<\/h2>\n
    Na \u00e1rea financeira, se um investidor possui a\u00e7\u00f5es de v\u00e1rias empresas, cada uma com diferentes Price-Earnings Ratios (PERs), e deseja calcular uma m\u00e9dia desses valores, a m\u00e9dia harm\u00f4nica oferece uma m\u00e9trica mais representativa para dados com discrep\u00e2ncias significativas. Se os PERs forem 15, 15 e 30, o c\u00e1lculo da m\u00e9dia harm\u00f4nica seria:<\/p>\n
    =M\u00c9DIA.HARM\u00d4NICA(15; 15; 30)<\/code><\/pre>\n
    O resultado, 18,75, fornece uma perspectiva mais realista dos PERs combinados em compara\u00e7\u00e3o \u00e0 m\u00e9dia aritm\u00e9tica simples.<\/p>\n
    Conclus\u00f5es<\/h2>\n
    A utiliza\u00e7\u00e3o da fun\u00e7\u00e3o M\u00c9DIA.HARM\u00d4NICA permite que analistas e cientistas de dados realizem c\u00e1lculos de m\u00e9dias que s\u00e3o mais representativos para cen\u00e1rios espec\u00edficos onde as m\u00e9dias aritm\u00e9ticas convencionais podem falhar. Esta fun\u00e7\u00e3o \u00e9 particularmente valiosa ao lidar com conjuntos de dados que envolvem velocidades, raz\u00f5es ou propor\u00e7\u00f5es, proporcionando insights mais precisos em an\u00e1lises complexas.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devolve a m\u00e9dia harm\u00f3nica<\/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-10922","post","type-post","status-publish","format-standard","hentry","category-estatistica"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o HARMEAN (M\u00c9DIA.HARM\u00d3NICA) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HARMEAN (M\u00c9DIA.HARM\u00d3NICA) 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\/harmean\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o HARMEAN (M\u00c9DIA.HARM\u00d3NICA) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HARMEAN (M\u00c9DIA.HARM\u00d3NICA) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/harmean\/\" \/>\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:20:39+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 HARMEAN (M\u00c9DIA.HARM\u00d3NICA) 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\/harmean\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/harmean\/\",\"name\":\"Fun\u00e7\u00e3o HARMEAN (M\u00c9DIA.HARM\u00d3NICA) 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:20:39+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HARMEAN (M\u00c9DIA.HARM\u00d3NICA) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/harmean\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/harmean\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/harmean\/#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\":\"M\u00c9DIA.HARM\u00d3NICA\"}]},{\"@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 HARMEAN (M\u00c9DIA.HARM\u00d3NICA) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HARMEAN (M\u00c9DIA.HARM\u00d3NICA) 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\/harmean\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o HARMEAN (M\u00c9DIA.HARM\u00d3NICA) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HARMEAN (M\u00c9DIA.HARM\u00d3NICA) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/harmean\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:20:39+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o HARMEAN (M\u00c9DIA.HARM\u00d3NICA) 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\/harmean\/","url":"https:\/\/functiontranslator.com\/pt-pt\/harmean\/","name":"Fun\u00e7\u00e3o HARMEAN (M\u00c9DIA.HARM\u00d3NICA) 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:20:39+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HARMEAN (M\u00c9DIA.HARM\u00d3NICA) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/harmean\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/harmean\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/harmean\/#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":"M\u00c9DIA.HARM\u00d3NICA"}]},{"@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\/10922","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=10922"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10922\/revisions"}],"predecessor-version":[{"id":25751,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10922\/revisions\/25751"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}