DSTDEVP Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel has become one of the most used spreadsheet for homes, offices, and businesses. It allows he users to store, manipulate, and make representations of data. In addition, Excel has functions such as the Engineering Functions, Text Functions, Statistical Functions, Database Functions, and many others.

The Database Function of Excel makes database activities much easier and simpler. This function is divided into sub-groups, which includes DSTDEVP Function. This function computes standard deviation basing on the whole population. The population will be computed from a column which contains the files that matches the given categories.

Syntax of DSTDEVP Function includes

=DSTDEVP (database,field,criteria)

wherein the Database argument is the series of cells which contains the files or database. This database is composed of rows which as connected information and columns. The labels for the columns are inputted in first row. Field argument refers to what column is pertained in function. Field argument must also be enclosed in quotation marks or could be represented with numbers; 1 would refer to first columns, 2 refer to second column, so on. Criteria argument refers to the group of cell that has the specific conditions. Any cell or ranges of cell can be used just make sure it has a column labels and a condition you like to specify.

Equal signs are mostly used in indicating formulas and Excel will then evaluate what you have inputted but this may cause unplanned results of filter. For you to indicate that the inputted values are of equality comparison input it as a string expression in the given cell. Such as when =”=Davolio is inputted it will be read as =Davolio.

For complex data DSTDEVP Function also has sections for it. First, open a blank Excel worksheet or spreadsheet and input the following values and labels as follows; cell A1 input Type, cell B1 input Salesperson, cell C1 input Sales. Copy the labels and paste it on cell A6:C6 and input the following values and criteria as follows; in cell A7 input Beverages, in cell A8 input Meat, in cell A9 input Produce, and in cell A10 input Produce. In cell B7 input Suyama, in cell B8 input Davoli, in cell B9 input Buchanan, and in cell B10 input Davolio. For the values of the Sales input in cell C7 the value $5122, input in cell C8 the value $450, in cell C9 input the value $6328, and in cell C10 input the value $6544.

For the above data, you can have the multiple criteria in column with the Boolean logic of Salesperson = “Davolio” OR Salesperson = “Buchanan”. This is employed to find rows that have multiple criteria in column; to do this you can directly input the criteria below every column. Be sure that each criterion is inputted in individual cells or variety of cells. To do this, input =Davolio in cell B2 and input =Buchanan in cell B3.

With the same give values, you could find rowsas well that have multiple criteria thatr are in multiple columns. Just type the criteria in the similar row of where criteria ranges is. The Boolean logic for this is = “Produce” AND Sales > 1000 wherein input =Produce in cell A2 and input >1000 in cell C2.

Tolook for the similar multiple criteria in multiple columns jut input the criteria in separate rows of the given criteria range. For above given value the Boolean logic are Type = “Produce” OR Salesperson = “Davolio”. Input the =Produce in cell A2 and =Davolio in cell B3.

Also, with the given data above you can find multiple types of criteria that includes different criteria from variety of columns. The Boolean logic for the same data as Salesperson = “Davolio” AND Sales >3000 or can also be Salesperson = “Buchanan” AND Sales > 1500. Input the logic =Davolio in cell B2 and =Buchanan in cell B3 likewise, input the logic >3000 in cell C2 and >1500 in cell C3.

Included in complex DSTDEVP Function are the criteria in finding text values that has similar characters unlike others, the criteria which is created because of the formula, and to filter text which are case sensitive.

Post comment