The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.11


Test Case AOOTest-362: Data-)Subtotals_Function StDevP(population). [Version : 1]
Author:undefined - 24/10/2012 14:22:30
Last edit by:undefined - 28/01/2014 02:47:37

1.Launch Application. 2.Create a new spreadsheet document. 3.Insert some data for Subtotals. Following data as a reference:

#:Step actions:Expected Results:

Expected Results


Select the cell range that you want to calculate subtotals for. (The contents in the first row will be regarded as column labels)


Click 'Data-) Subtotals'.

The 'Subtotal' dialog appears. The current tab page is '1st Group'. The combo box 'Group by' use the first column label as its default value.


In the 'Group by' combo box select label of a column which contains numbers or characters to group the data.


In the 'Calculate subtotals for' box, select a check box of the column labels that you want to subtotal.


In the 'Use function' box, select the function 'StDevP(population)'.


Click 'OK' button.

The subtotal result is displayed in hierarchy according to the 1st group option specified.


Click the cell that contains the result of subtotal.

There is a formula =SUBTOTAL(8,...) shown in formula bar.

Calculates standard deviation based on the entire population given as arguments. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

Using follow formula:

('n' is an integer and n)0)

The result is correct.

Execution type:Manual
Test Focus:
Feature first available at which release:
Automation script name:
Testsuite set:
Requirements None
Keywords: None

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.