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.
Based on http://www.gifted.uconn.edu/siegle/research/Normal/stdexcel.htm Calculating the Standard Deviation 1. Enter scores into a column in a spreadsheet. All scores must be entered, including any zeroes. A blank space will not be read as zero, but will instead be skipped over by Excel. Based on http://www.gifted.uconn.edu/siegle/research/Normal/stdexcel.htm 2. Once all of the scores have been entered, place the cursor in the cell where you would like the standard deviation to appear and click the mouse button. 3. Now look at the top of the Excel screen.