A dialog box will appear. Select STDEVS for a sample from the the Statistical category. AVERAGE B2B7The average goes to any empty cell say B8.
N sample size.
I am trying to locate a statiscal symbol the mean of a sample -- x with a bar on top. For example to calculate the mean of numbers 1 2 2 3 4 6 you add them up and then divide the sum by 6 which yields 3. STDEVS STDEVA and STDEV. Excel makes calculating standard deviation more manageable.