# simple question: descriptives in excel

#### fffrost

##### New Member
Hi, I was just looking at descriptives in excel and I saw that I get different values when I do it manually, and I'm not sure why. If I have the following column (A1:A8) in excel:
[1
2
3
4
3
5
2
3]

The mean = 2.875. for each column I subtract the datapoint from the mean and get the following column of errors:

[1.875
0.875
-0.125
-1.125
-0.125
-2.125
0.875
-0.125]

Fine. I square these and then get the sum of squares:

[3.515625
0.765625
0.015625
1.265625
0.015625
4.515625
0.765625
0.015625
]

SS = 10.875. I then take SS/n-1 to get variance=0.359375. I understand that this is the sample variance. If I then take the function =VAR.S(A1:A8), the value returned is 1.553571429. This ultimately leads my standard deviation to turn out different to the excel formula as well. Why is this happening? Am I making a silly mistake?

Thanks