{"id":13937,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/bddesvestp\/"},"modified":"2021-02-26T08:45:59","modified_gmt":"2021-02-26T08:45:59","slug":"dstdevp","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/dstdevp\/","title":{"rendered":"BDDESVESTP"},"content":{"rendered":"<h2>Introducci\u00f3n a la Funci\u00f3n de Desviaci\u00f3n Est\u00e1ndar Poblacional<\/h2>\n<p>La funci\u00f3n <code>DSTDEVP<\/code> en Microsoft Excel y <code>BDDESVESTP<\/code> en Google Hojas de C\u00e1lculo se utiliza para calcular la desviaci\u00f3n est\u00e1ndar poblacional de un conjunto de valores. Esta m\u00e9trica es fundamental en estad\u00edsticas para entender la dispersi\u00f3n de un conjunto completo de datos, y no simplemente de muestras. La desviaci\u00f3n est\u00e1ndar mide la variabilidad de los datos en relaci\u00f3n con su media.<\/p>\n<h2>Sintaxis y Ejemplos<\/h2>\n<p>La sintaxis de la funci\u00f3n en Excel es:<\/p>\n<pre><code>=DSTDEVP(base_de_datos; campo; criterios)<\/code><\/pre>\n<p>En Google Hojas de C\u00e1lculo, la sintaxis es:<\/p>\n<pre><code>=BDDESVESTP(base_de_datos; campo; criterios)<\/code><\/pre>\n<ul>\n<li><strong>base_de_datos<\/strong>: El rango de celdas que constituyen la base de datos.<\/li>\n<li><strong>campo<\/strong>: Especifica la columna a evaluar. Puede ser un n\u00famero \u00edndice de la columna (comenzando desde 1) o el nombre de la columna entre comillas.<\/li>\n<li><strong>criterios<\/strong>: El rango de celdas que contiene los criterios que deben cumplirse.<\/li>\n<\/ul>\n<p><strong>Ejemplo 1:<\/strong> Supongamos que deseamos calcular la desviaci\u00f3n est\u00e1ndar de una lista de edades:<\/p>\n<pre><code> Nombres Edad Juan 23 Mar\u00eda 19 Ana 34 Jorge 45 <\/code><\/pre>\n<p>Si estos datos est\u00e1n en A1:B5, el c\u00e1lculo de la desviaci\u00f3n est\u00e1ndar se realizar\u00eda as\u00ed:<\/p>\n<pre><code>En Excel: =DSTDEVP(A1:B5, \"Edad\", A1:B5) En Google Sheets: =BDDESVESTP(A1:B5, \"Edad\", A1:B5) <\/code><\/pre>\n<h2>Aplicaci\u00f3n Pr\u00e1ctica de la Funci\u00f3n<\/h2>\n<h2>Estudio de Variabilidad Salarial<\/h2>\n<p>Consideremos una empresa que desea analizar la variabilidad de los salarios de sus empleados para detectar desigualdades o dise\u00f1ar planes de mejora salarial.<\/p>\n<pre><code> Empleado Salario Emilia 3000 Luis 4500 Sonja 3900 Marco 4100 <\/code><\/pre>\n<p>Para calcular la desviaci\u00f3n est\u00e1ndar de los salarios, utilizar\u00edamos:<\/p>\n<pre><code>En Excel: =DSTDEVP(A1:B5, \"Salario\", A1:B5) En Google Sheets: =BDDESVESTP(A1:B5, \"Salario\", A1:B5) <\/code><\/pre>\n<p>El resultado nos ayuda a comprender la dispersi\u00f3n salarial dentro de la empresa, facilitando la toma de decisiones en cuanto a ajustes salariales o pol\u00edticas de compensaci\u00f3n.<\/p>\n<h2>An\u00e1lisis de rendimiento acad\u00e9mico<\/h2>\n<p>Si un colegio desea evaluar la dispersi\u00f3n de las notas de un examen de matem\u00e1ticas para medir la efectividad de los m\u00e9todos educativos, podr\u00eda realizar el siguiente an\u00e1lisis:<\/p>\n<pre><code> Estudiante Calificaci\u00f3n Ana 85 Jorge 90 Luisa 78 Marco 88 <\/code><\/pre>\n<p>El c\u00e1lculo de la desviaci\u00f3n est\u00e1ndar poblacional ser\u00eda:<\/p>\n<pre><code>En Excel: =DSTDEVP(A1:B5, \"Calificaci\u00f3n\", A1:B5) En Google Sheets: =BDDESVESTP(A1:B5, \"Calificaci\u00f3n\", A1:B5) <\/code><\/pre>\n<p>Este an\u00e1lisis revela si las notas est\u00e1n muy dispersas o si, por el contrario, se concentran alrededor de un promedio, ofreciendo datos valiosos para posibles ajustes en las estrategias pedag\u00f3gicas.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Calcula la desviaci\u00f3n est\u00e1ndar a partir de la poblaci\u00f3n total de las entradas seleccionadas de la base de datos<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[547],"tags":[],"class_list":["post-13937","post","type-post","status-publish","format-standard","hentry","category-base-de-datos"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Funci\u00f3n DSTDEVP (BDDESVESTP) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n DSTDEVP (BDDESVESTP) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/dstdevp\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n DSTDEVP (BDDESVESTP) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n DSTDEVP (BDDESVESTP) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/dstdevp\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:45:59+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n DSTDEVP (BDDESVESTP) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\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\/es\/dstdevp\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/dstdevp\/\",\"name\":\"Funci\u00f3n DSTDEVP (BDDESVESTP) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:45:59+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n DSTDEVP (BDDESVESTP) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/dstdevp\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/dstdevp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/dstdevp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de datos\",\"item\":\"https:\/\/functiontranslator.com\/es\/base-de-datos\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BDDESVESTP\"}]},{\"@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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n DSTDEVP (BDDESVESTP) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n DSTDEVP (BDDESVESTP) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/dstdevp\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n DSTDEVP (BDDESVESTP) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n DSTDEVP (BDDESVESTP) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/dstdevp\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:45:59+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n DSTDEVP (BDDESVESTP) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/dstdevp\/","url":"https:\/\/functiontranslator.com\/es\/dstdevp\/","name":"Funci\u00f3n DSTDEVP (BDDESVESTP) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:45:59+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n DSTDEVP (BDDESVESTP) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/dstdevp\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/dstdevp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/dstdevp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Base de datos","item":"https:\/\/functiontranslator.com\/es\/base-de-datos\/"},{"@type":"ListItem","position":3,"name":"BDDESVESTP"}]},{"@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":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13937","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=13937"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13937\/revisions"}],"predecessor-version":[{"id":30000,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13937\/revisions\/30000"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13937"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13937"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}