{"id":13936,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/bddesvest\/"},"modified":"2021-02-26T08:45:57","modified_gmt":"2021-02-26T08:45:57","slug":"dstdev","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/dstdev\/","title":{"rendered":"BDDESVEST"},"content":{"rendered":"

Descripci\u00f3n general y sintaxis de la funci\u00f3n BDDESVEST<\/h2>\n

La funci\u00f3n BDDESVEST en Microsoft Excel y la funci\u00f3n DSTDEV en Google Sheets se emplean para calcular la desviaci\u00f3n est\u00e1ndar de una muestra seleccionada de una base de datos que cumple con determinados criterios. Estas funciones son esenciales para realizar an\u00e1lisis estad\u00edsticos enfocados en la dispersi\u00f3n de subconjuntos de datos espec\u00edficos.<\/p>\n

Sintaxis en Excel: <\/p>\n

BDDESVEST(base_de_datos, campo, criterio)<\/code><\/pre>\n
 Sintaxis en Google Sheets: <\/p>\n
DSTDEV(base_de_datos, campo, criterio)<\/code><\/pre>\n
 Donde: <\/p>\n
    \n
  • base_de_datos<\/strong>: Rango de celdas que incluye al menos una columna de etiquetas, datos num\u00e9ricos y una celda que contiene el criterio de b\u00fasqueda.<\/li>\n
  • campo<\/strong>: Indica la columna de inter\u00e9s para evaluar la desviaci\u00f3n est\u00e1ndar. Puede ser el n\u00famero de la columna (comenzando desde 1) o el nombre de la columna entre comillas (por ejemplo, \u00abVentas\u00bb).<\/li>\n
  • criterio<\/strong>: Rango de celdas que especifican los criterios de selecci\u00f3n.<\/li>\n<\/ul>\n
    Ejemplos pr\u00e1cticos de uso<\/h2>\n
    A continuaci\u00f3n, se ofrecen ejemplos de c\u00f3mo aplicar la funci\u00f3n BDDESVEST en Excel y DSTDEV en Google Sheets para abordar situaciones comunes en el an\u00e1lisis de datos.<\/p>\n
    Ejemplo 1: Estimar la dispersi\u00f3n en ventas mensuales<\/h2>\n
    Consideremos una base de datos con las ventas mensuales de diversos representantes y queremos calcular la desviaci\u00f3n est\u00e1ndar de las ventas para aquellos cuyo volumen supera un cierto umbral.<\/p>\n\n\n\n\n\n\n
    Representante<\/th>\nVentas<\/th>\n<\/tr>\n
    Juan<\/td>\n1200<\/td>\n<\/tr>\n
    Ana<\/td>\n1500<\/td>\n<\/tr>\n
    Pedro<\/td>\n1100<\/td>\n<\/tr>\n
    Mar\u00eda<\/td>\n1800<\/td>\n<\/tr>\n<\/table>\n
    Para calcular la desviaci\u00f3n est\u00e1ndar de las ventas de los representantes con ventas superiores a 1300, establecemos los siguientes criterios:<\/p>\n
    A B 1 Ventas Criterio 2 >1300<\/code><\/pre>\n
    La f\u00f3rmula en Excel ser\u00eda: <\/p>\n
    =BDDESVEST(A1:B5, \"Ventas\", A1:B2)<\/code><\/pre>\n
     En Google Sheets ser\u00eda similar: <\/p>\n
    =DSTDEV(A1:B5, \"Ventas\", A1:B2)<\/code><\/pre>\n
     Ambas f\u00f3rmulas calcular\u00e1n la desviaci\u00f3n est\u00e1ndar de las ventas de Ana y Mar\u00eda, quienes cumplen con el criterio establecido.<\/p>\n
    Ejemplo 2: An\u00e1lisis de rendimiento acad\u00e9mico<\/h2>\n
    Supongamos que tenemos una base de datos de estudiantes con sus calificaciones en matem\u00e1ticas y queremos calcular la desviaci\u00f3n est\u00e1ndar de las notas de los estudiantes que pertenecen al grupo ‘A’.<\/p>\n\n\n\n\n\n\n
    Estudiante<\/th>\nGrupo<\/th>\nCalificaci\u00f3n<\/th>\n<\/tr>\n
    Luc\u00eda<\/td>\nA<\/td>\n8.5<\/td>\n<\/tr>\n
    Miguel<\/td>\nB<\/td>\n7.0<\/td>\n<\/tr>\n
    Sof\u00eda<\/td>\nA<\/td>\n9.0<\/td>\n<\/tr>\n
    Carlos<\/td>\nC<\/td>\n6.5<\/td>\n<\/tr>\n<\/table>\n
    Los criterios se definen de la siguiente manera:<\/p>\n
    A B 1 Grupo Criterio 2 A<\/code><\/pre>\n
    Utilizando Excel, la f\u00f3rmula ser\u00eda: <\/p>\n
    =BDDESVEST(A1:C5, \"Calificaci\u00f3n\", A1:B2)<\/code><\/pre>\n
     De manera similar, en Google Sheets: <\/p>\n
    =DSTDEV(A1:C5, \"Calificaci\u00f3n\", A1:B2)<\/code><\/pre>\n
     Esto calcular\u00eda la desviaci\u00f3n est\u00e1ndar de las calificaciones de Luc\u00eda y Sof\u00eda, que son los estudiantes que cumplen con el criterio.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Calcula la desviaci\u00f3n est\u00e1ndar a partir de una muestra de entradas seleccionadas en 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-13936","post","type-post","status-publish","format-standard","hentry","category-base-de-datos"],"acf":[],"yoast_head":"\nFunci\u00f3n DSTDEV (BDDESVEST) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n DSTDEV (BDDESVEST) 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\/dstdev\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n DSTDEV (BDDESVEST) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n DSTDEV (BDDESVEST) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/dstdev\/\" \/>\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:57+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 DSTDEV (BDDESVEST) 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\/dstdev\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/dstdev\/\",\"name\":\"Funci\u00f3n DSTDEV (BDDESVEST) 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:57+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n DSTDEV (BDDESVEST) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/dstdev\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/dstdev\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/dstdev\/#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\":\"BDDESVEST\"}]},{\"@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 DSTDEV (BDDESVEST) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n DSTDEV (BDDESVEST) 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\/dstdev\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n DSTDEV (BDDESVEST) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n DSTDEV (BDDESVEST) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/dstdev\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:45:57+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n DSTDEV (BDDESVEST) 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\/dstdev\/","url":"https:\/\/functiontranslator.com\/es\/dstdev\/","name":"Funci\u00f3n DSTDEV (BDDESVEST) 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:57+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n DSTDEV (BDDESVEST) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/dstdev\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/dstdev\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/dstdev\/#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":"BDDESVEST"}]},{"@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\/13936","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=13936"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13936\/revisions"}],"predecessor-version":[{"id":29999,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13936\/revisions\/29999"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}