If you were to calculate the standard deviation on the worksheet, without the STDEV.P function, hereâs how you would do it. 1  Find the average of the numbers in the pivot table data. 2  From each number, subtract the average. 3  Square the calculated difference for each number. 4  Find the average of the squared difference. 5  Find the square root of the average.
A pivot table is a tool that you can use to summarize data when you have a lot of it in a worksheet. A pivot table can count totals, give an average of the data, or sort data â in addition to other things. In this article, we are going to go in-depth as we learn to create and work with pivot tables.
1 In a pivot table, the data is grouped and then arranged by the row and column fields. 2  The data can then be filtered by a Filter Report field. 3  Add a field to your pivot table to provide another method by which the data is organized. 4  9 Edit step.ecide how you would like your data to be arranged by that field. 1  In a pivot table, the data is grouped and then arranged by the row and column fields. 2  Add a field to your pivot table to provide another method by which the data is organized. 3  9 Edit step.