{"id":2518,"date":"2023-07-21T22:21:11","date_gmt":"2023-07-21T22:21:11","guid":{"rendered":"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/"},"modified":"2023-07-21T22:21:11","modified_gmt":"2023-07-21T22:21:11","slug":"codificacao-reversa-no-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/","title":{"rendered":"Como fazer codifica\u00e7\u00e3o reversa no excel (com exemplo)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Ao criar pesquisas, os pesquisadores \u00e0s vezes reformulam as perguntas \u201cpositivas\u201d de uma forma \u201cnegativa\u201d para garantir que os indiv\u00edduos d\u00eaem respostas consistentes.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dizemos que esses tipos de perguntas t\u00eam <strong>codifica\u00e7\u00e3o reversa<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ao usar uma pesquisa para atribuir uma pontua\u00e7\u00e3o composta a indiv\u00edduos, \u00e9 importante garantir que as perguntas com codifica\u00e7\u00e3o reversa tamb\u00e9m recebam uma pontua\u00e7\u00e3o reversa.<\/span><\/p>\n<p> <span style=\"color: #000000;\">O exemplo a seguir mostra como reverter pontua\u00e7\u00f5es em quest\u00f5es com c\u00f3digo reverso no Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Exemplo: codifica\u00e7\u00e3o reversa no Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Suponha que os pesquisadores apliquem uma pesquisa de 5 perguntas a 10 pessoas, na qual as respostas poss\u00edveis para cada pergunta sejam:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Totalmente de acordo<\/span><\/li>\n<li> <span style=\"color: #000000;\">Aceitar<\/span><\/li>\n<li> <span style=\"color: #000000;\">N\u00e3o concordo nem discordo<\/span><\/li>\n<li> <span style=\"color: #000000;\">Discordar<\/span><\/li>\n<li> <span style=\"color: #000000;\">Discordo fortemente<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">A captura de tela a seguir mostra os resultados da pesquisa em que \u201cConcordo totalmente\u201d recebe o valor 5, \u201cConcordo\u201d recebe o valor 4 e assim por diante:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22422 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inverseexcel1.jpg\" alt=\"\" width=\"491\" height=\"430\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Sup\u00f5e que as quest\u00f5es 2 e 5 tenham codifica\u00e7\u00e3o reversa, ent\u00e3o precisamos reverter suas pontua\u00e7\u00f5es.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Isso \u00e9 para dizer:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">1 deve se tornar 5.<\/span><\/li>\n<li> <span style=\"color: #000000;\">2 deveria se tornar 4.<\/span><\/li>\n<li> <span style=\"color: #000000;\">3 deveria se tornar 3.<\/span><\/li>\n<li> <span style=\"color: #000000;\">4 deve se tornar 2.<\/span><\/li>\n<li> <span style=\"color: #000000;\">5 deve se tornar 1.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">A maneira mais f\u00e1cil de fazer isso \u00e9 pegar a pontua\u00e7\u00e3o m\u00e1xima poss\u00edvel (5) e adicionar 1 para obter 6. Em seguida, subtrair as pontua\u00e7\u00f5es originais de 6 para obter o valor da pontua\u00e7\u00e3o invertida.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Por exemplo:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">5 torna-se: 6 \u2013 5 = <strong>1<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">4 torna-se: 6 \u2013 4 = <strong>2<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">3 torna-se: 6 \u2013 3 = <strong>3<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">2 torna-se: 6 \u2013 2 = <strong>4<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">1 torna-se: 6 \u2013 1 = <strong>5<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Para fazer isso no Excel, basta copiar e colar todas as respostas originais em uma nova \u00e1rea da planilha:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22424 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inverseexcel2.jpg\" alt=\"\" width=\"490\" height=\"525\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Na c\u00e9lula <strong>B17,<\/strong> digite: <strong>=6-B2<\/strong> . Em seguida, copie e cole esta f\u00f3rmula em todas as outras c\u00e9lulas da coluna B.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Na c\u00e9lula <strong>E17<\/strong> , digite: <strong>=6-E2<\/strong> . Em seguida, copie e cole esta f\u00f3rmula em todas as outras c\u00e9lulas da coluna E.<\/span><\/p>\n<p> <span style=\"color: #000000;\">As pontua\u00e7\u00f5es na coluna B e na coluna E ser\u00e3o agora codificadas reversamente:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22423 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inverseexcel3.jpg\" alt=\"\" width=\"490\" height=\"546\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Recursos adicionais<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Os tutoriais a seguir explicam outros termos comumente usados em question\u00e1rios e pesquisas:<\/span><\/p>\n<p> O que \u00e9 validade facial?<br \/> <a href=\"https:\/\/statorials.org\/pt\/validade-preditiva\/\" target=\"_blank\" rel=\"noopener\">O que \u00e9 validade preditiva?<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/validade-concorrente\/\" target=\"_blank\" rel=\"noopener\">O que \u00e9 validade concorrente?<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/validade-do-conteudo\/\" target=\"_blank\" rel=\"noopener\">O que \u00e9 validade de conte\u00fado?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ao criar pesquisas, os pesquisadores \u00e0s vezes reformulam as perguntas \u201cpositivas\u201d de uma forma \u201cnegativa\u201d para garantir que os indiv\u00edduos d\u00eaem respostas consistentes. Dizemos que esses tipos de perguntas t\u00eam codifica\u00e7\u00e3o reversa . Ao usar uma pesquisa para atribuir uma pontua\u00e7\u00e3o composta a indiv\u00edduos, \u00e9 importante garantir que as perguntas com codifica\u00e7\u00e3o reversa tamb\u00e9m recebam [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-2518","post","type-post","status-publish","format-standard","hentry","category-guia"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como fazer codifica\u00e7\u00e3o reversa no Excel (com exemplo) - Estatologia<\/title>\n<meta name=\"description\" content=\"Este tutorial explica como reverter itens de pesquisa de c\u00f3digo no Excel, com um exemplo.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como fazer codifica\u00e7\u00e3o reversa no Excel (com exemplo) - Estatologia\" \/>\n<meta property=\"og:description\" content=\"Este tutorial explica como reverter itens de pesquisa de c\u00f3digo no Excel, com um exemplo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T22:21:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inverseexcel1.jpg\" \/>\n<meta name=\"author\" content=\"Dr. benjamim anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr. benjamim anderson\" \/>\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:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/\",\"url\":\"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/\",\"name\":\"Como fazer codifica\u00e7\u00e3o reversa no Excel (com exemplo) - Estatologia\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-21T22:21:11+00:00\",\"dateModified\":\"2023-07-21T22:21:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Este tutorial explica como reverter itens de pesquisa de c\u00f3digo no Excel, com um exemplo.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como fazer codifica\u00e7\u00e3o reversa no excel (com exemplo)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/pt\/#website\",\"url\":\"https:\/\/statorials.org\/pt\/\",\"name\":\"Statorials\",\"description\":\"O seu guia para a literacia estat\u00edstica!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/pt\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\",\"name\":\"Dr. benjamim anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr. benjamim anderson\"},\"description\":\"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais\",\"sameAs\":[\"https:\/\/statorials.org\/pt\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como fazer codifica\u00e7\u00e3o reversa no Excel (com exemplo) - Estatologia","description":"Este tutorial explica como reverter itens de pesquisa de c\u00f3digo no Excel, com um exemplo.","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:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/","og_locale":"pt_PT","og_type":"article","og_title":"Como fazer codifica\u00e7\u00e3o reversa no Excel (com exemplo) - Estatologia","og_description":"Este tutorial explica como reverter itens de pesquisa de c\u00f3digo no Excel, com um exemplo.","og_url":"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-21T22:21:11+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inverseexcel1.jpg"}],"author":"Dr. benjamim anderson","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dr. benjamim anderson","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/","url":"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/","name":"Como fazer codifica\u00e7\u00e3o reversa no Excel (com exemplo) - Estatologia","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-21T22:21:11+00:00","dateModified":"2023-07-21T22:21:11+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Este tutorial explica como reverter itens de pesquisa de c\u00f3digo no Excel, com um exemplo.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/codificacao-reversa-no-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como fazer codifica\u00e7\u00e3o reversa no excel (com exemplo)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/pt\/#website","url":"https:\/\/statorials.org\/pt\/","name":"Statorials","description":"O seu guia para a literacia estat\u00edstica!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/pt\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666","name":"Dr. benjamim anderson","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr. benjamim anderson"},"description":"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais","sameAs":["https:\/\/statorials.org\/pt"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/2518","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/comments?post=2518"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/2518\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=2518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=2518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=2518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}