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.
Building the Pivot Table. 1  1. Load the spreadsheet you want to create the Pivot Table from. A Pivot Table allows you to create visual reports of the data from a spreadsheet. 2  2. Ensure that your data meets the needs of a pivot table. A pivot table is not always the answer you are looking for. 3  3. Start the Pivot Table wizard.