Historians believe that the Shang dynasty was founded by a rebel, now known as King Tang, who in 1766 BC overthrew the leader of the Xia Dynasty, Jie.
The first step is gather the data you want to base the confidence calculation into an excel spread sheet. Put them all in a column and use the COUNT function to determine the number of data points you want to base you calculation on.In this case, there are 20 data points and the value of the count calculation is 20. Calculate the standard deviation of the data.The standard deviation is used to measure the variability of a data set and it is a key value of the confidence calculation. In Excel, this is done with the STDEV function.he first step is gather the data you want to base the confidence calculation into an excel spread sheet. Put them all in a column and use the COUNT function to determine the number of data points you want to base you calculation on.
As long as you have a start time and an end time, Excel will be able to count the hours between them. 1  1. Open your Excel spreadsheet. 2  2. Enter the title Total Hours in cell C1. 3  3. Enter the formula =B2-A2 and press the Enter key to display the time difference between two cells.