Standard Deviation

I have downloaded data of a particular share for the period 01/01/2005 to 30/06/09 and have calculated the mean and SD for this range.

Now I need to calculate the following to see how many times the share price during the perid 01/07/09 to 30/08/09 (new range) moved up and down using the SD calculated for the sample data (previous range)

1. > 3SDs
2. 3SDs<>2SDs
3. 2SDs<>1SD
4. <1SDs

I have attached my excel worksheet which contains the sample data and the data for the period in question.

I would be greatfule if someone could help me do this using excel formulae. I need to know the correct excel formula.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.