{"id":126,"date":"2025-07-21T23:30:38","date_gmt":"2025-07-22T02:30:38","guid":{"rendered":"https:\/\/editoraplantasdobrasil.com.br\/fitossociologia-no-excel\/?page_id=126"},"modified":"2025-07-25T17:49:17","modified_gmt":"2025-07-25T20:49:17","slug":"frequencia","status":"publish","type":"page","link":"https:\/\/editoraplantasdobrasil.com.br\/fitossociologia-no-excel\/frequencia\/","title":{"rendered":"Frequ\u00eancia"},"content":{"rendered":"<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/5Eq0ObSlmE4?si=PNCgen58HLOaXLeS?autoplay=1&amp;hd=1&amp;showsearch=0&amp;showinfo=0\" width=\"100%\" height=\"400px\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" data-mce-type=\"bookmark\" class=\"mce_SELRES_start\">\ufeff<\/span><span style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" data-mce-type=\"bookmark\" class=\"mce_SELRES_start\">\ufeff<\/span><span style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" data-mce-type=\"bookmark\" class=\"mce_SELRES_start\"><\/span><span style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" data-mce-type=\"bookmark\" class=\"mce_SELRES_start\"><\/span><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Frequ\u00eancia Absoluta<\/strong><\/h3>\n<p>A Frequ\u00eancia Absoluta mostra em quantos % das parcelas a esp\u00e9cie est\u00e1 presente. F\u00f3rmula no Excel:<\/p>\n<pre id=\"formula1\">=CONT.N\u00daM(B2:D2)\/3*100<\/pre>\n<p><button onclick=\"copiar('formula1')\">Copiar F\u00f3rmula 1<\/button><\/p>\n<p><script>\n  function copiar(id) {\n    var texto = document.getElementById(id).innerText;\n    navigator.clipboard.writeText(texto)\n      .then(function() {\n        alert(\"F\u00f3rmula copiada!\");\n      })\n      .catch(function(err) {\n        alert(\"Erro ao copiar: \" + err);\n      });\n  }\n<\/script><\/p>\n<p>&nbsp;<\/p>\n<p>\u2705 <strong>Por que ela funciona:<\/strong><\/p>\n<ul>\n<li>B2:D2 = intervalo onde voc\u00ea registrou <strong>presen\u00e7a ou aus\u00eancia da esp\u00e9cie<\/strong> em cada parcela.<\/li>\n<li>N\u00daM(B2:D2) = conta <strong>em quantas parcelas a esp\u00e9cie est\u00e1 presente<\/strong> (ou seja, quantas c\u00e9lulas com n\u00famero existem).<\/li>\n<li>3 = total de parcelas da amostra.<\/li>\n<li>* 100 = converte o valor em <strong>porcentagem (%)<\/strong>.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Formula geral da Frequ\u00eancia Absoluta:<\/strong><\/p>\n<p><center><br \/>\n<img decoding=\"async\" src=\"http:\/\/editoraplantasdobrasil.com.br\/fitossociologia-no-excel\/wp-content\/uploads\/2025\/07\/frequencia_absoluta.jpg\" alt=\"FFrequ\u00eancia Absoluta\" \/><br \/>\n<\/center><br \/>\n&nbsp;<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<h3><strong>Frequ\u00eancia Relativa<\/strong><\/h3>\n<p>A Frequ\u00eancia Relativa mostra a import\u00e2ncia da frequ\u00eancia relativa da esp\u00e9cie em rela\u00e7\u00e3o a todas as outras. F\u00f3rmula no Excel:<\/p>\n<pre id=\"formula2\">=F2\/$F$17*100<\/pre>\n<p><button onclick=\"copiar('formula2')\">Copiar F\u00f3rmula 2<\/button><\/p>\n<p>&nbsp;<\/p>\n<p>\u2705 <strong>Por que ela funciona:<\/strong><\/p>\n<ul>\n<li>F2 = <strong>frequ\u00eancia absoluta<\/strong> da esp\u00e9cie que est\u00e1 na c\u00e9lula F2 (geralmente em % ou n\u00famero de parcelas).<\/li>\n<li>$F$17 = c\u00e9lula fixa com a <strong>soma das frequ\u00eancias absolutas<\/strong> de todas as esp\u00e9cies que est\u00e1 na c\u00e9lula F17.<\/li>\n<li>* 100 = converte o valor em <strong>porcentagem (%)<\/strong>.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Formula geral da Frequ\u00eancia Relativa:<\/strong><\/p>\n<p><center><br \/>\n<img decoding=\"async\" src=\"http:\/\/editoraplantasdobrasil.com.br\/fitossociologia-no-excel\/wp-content\/uploads\/2025\/07\/frequencia_relativa.jpg\" alt=\"Frequencia Relativa\" \/><br \/>\n<\/center><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ufeff\ufeff &nbsp; Frequ\u00eancia Absoluta A Frequ\u00eancia Absoluta mostra em quantos % das parcelas a esp\u00e9cie est\u00e1 presente. F\u00f3rmula no Excel: =CONT.N\u00daM(B2:D2)\/3*100 Copiar F\u00f3rmula 1 &nbsp; \u2705 Por que ela funciona: B2:D2 = intervalo onde voc\u00ea registrou presen\u00e7a ou aus\u00eancia da esp\u00e9cie em cada parcela. N\u00daM(B2:D2) = conta em quantas parcelas a esp\u00e9cie est\u00e1 presente (ou [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-126","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/editoraplantasdobrasil.com.br\/fitossociologia-no-excel\/wp-json\/wp\/v2\/pages\/126","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/editoraplantasdobrasil.com.br\/fitossociologia-no-excel\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/editoraplantasdobrasil.com.br\/fitossociologia-no-excel\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/editoraplantasdobrasil.com.br\/fitossociologia-no-excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/editoraplantasdobrasil.com.br\/fitossociologia-no-excel\/wp-json\/wp\/v2\/comments?post=126"}],"version-history":[{"count":6,"href":"https:\/\/editoraplantasdobrasil.com.br\/fitossociologia-no-excel\/wp-json\/wp\/v2\/pages\/126\/revisions"}],"predecessor-version":[{"id":337,"href":"https:\/\/editoraplantasdobrasil.com.br\/fitossociologia-no-excel\/wp-json\/wp\/v2\/pages\/126\/revisions\/337"}],"wp:attachment":[{"href":"https:\/\/editoraplantasdobrasil.com.br\/fitossociologia-no-excel\/wp-json\/wp\/v2\/media?parent=126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}