Have a Question?
Phone: +1 (888) 4279486
+1 (312) 2573777
Contact Us
TEST_STDEV
Calculates the pvalue of the statistical test for the population standard deviation.
Syntax
TEST_STDEV^{i}(X, sigma)
X
is the data sample (a one dimensional array of cells (e.g. rows or columns)).
sigma
is the assumed population standard deviation. If missing, the default value of one is assumed.
Remarks
 The data sample may include missing values (e.g. #N/A).

The test hypothesis for the population standard deviation:
Where:
 is the null hypothesis^{i}.
 is the alternate hypothesis.
 is the assumed population standard deviation.
 is the actual (real) population standard deviation.

For the case in which the underlying population distribution is normal, the sample standard deviation has a Chisquare sampling distribution:
Where:
 is the sample variance.
 is the Chisquare probability distribution function.
 is the degrees of freedom for the Chisquare distribution.
 is the number of nonmissing values in the sample data.
 Using a given data sample, the sample data standard deviation is computed as:
Where:
 is the sample standard deviation.
 is the sample average.
 is the number of nonmissing values in the data sample.
 The underlying population distribution is assumed normal (Gaussian).
 This is a twosides (i.e. twotails) test, so the computed pvalue should be compared with half of the significance level ().
Examples
Example 1:
A  B  

1  Date  Data 
2  1/1/2008  #N/A 
3  1/2/2008  2.83 
4  1/3/2008  0.95 
5  1/4/2008  0.88 
6  1/5/2008  1.21 
7  1/6/2008  1.67 
8  1/7/2008  0.83 
9  1/8/2008  0.27 
10  1/9/2008  1.36 
11  1/10/2008  0.34 
12  1/11/2008  0.48 
13  1/12/2008  2.83 
14  1/13/2008  0.95 
15  1/14/2008  0.88 
16  1/15/2008  1.21 
17  1/16/2008  1.67 
Formula  Description (Result)  

=STDEV($B$2:$B$17)  Sample standard deviation (1.3725)  
=TEST_STDEV($B$2:$B$17,1)  pvalue of the test when standard deviation = 1 (0.0232) 