Answer: a) The average of this set of numbers is 1.98 s. b) the standard deviation is 0.02 s.
Step-by-step explanation: The average is calculated by adding all numbers found in the experiment divided by the number of values. [tex]average = \frac{Sumxi}{n}[/tex]
The standard deviation is given by the square root of the squared sum of the difference between each number and the average divided by the total number of values. For instance, std deviation = [tex]\frac{sqrt{(1.94-1.98)^{2}+(1.96-1.98)^2+(2.01-1.98)^2...}}{11}[/tex] and that is done with all 11 terms of data minus the average to find the standard deviation.
In excel, the average of a certain set of numbers (displayed in cells A1 to A5) can be found by the commands =average(A1:A5). The standard deviation can be found by the commands =stdedv.p(A1:A5) in which p is the population. You can decrease decimals by clicking on the icon displayed in the Ribbon.
