My Math Forum Sample Variance
 User Name Remember Me? Password

 Probability and Statistics Basic Probability and Statistics Math Forum

 February 16th, 2018, 11:58 AM #1 Newbie   Joined: Feb 2018 From: UK Posts: 4 Thanks: 0 Sample Variance Just realised that I have posted a question in the wrong place, so here goes again with a 2nd post which hopefully now is in the right area. I know that to find the variance of a sample, we can use the formula sigma^2/n. I realise that this means that with big samples, the sample variance gets very small and with small samples, it is much closer to the population variance. I thought I'd test this on random samples of discrete data. When I picked a small sample (say n=10) I then worked out the mean and variance using the formulas. I then picked a bigger sample, (say n=50) and expected the variance to be smaller. It wasn't and in fact it tends always to be bigger, allowing for the random nature of the samples. Even when say 10 samples of each are completed, the bigger sample is invariably the one with the bigger variance. What is going on? Where is my misinterpretation of what is going on here (I'm clearly doing something wrong!) Thanks JJ
 February 16th, 2018, 02:05 PM #2 Global Moderator   Joined: May 2007 Posts: 6,641 Thanks: 625 It would be helpful if you would write the formulas you are using.
 February 17th, 2018, 04:40 AM #3 Newbie   Joined: Feb 2018 From: UK Posts: 4 Thanks: 0 Sorry This is what I used mean=sigma x / n var = sigma x^2/n - mean^2 but I also did them using the stdeva( ) function in Excel
 February 17th, 2018, 05:54 PM #4 Global Moderator   Joined: May 2007 Posts: 6,641 Thanks: 625 The formulas you are using give you estimates of the mean and variance of the underlying distribution. For large n these will converge to true mean and variance. I am not familiar with what Excel is doing. However if the variance gets smaller, I presume it is calculating the variance of the sample mean. This is the variance you have divided by n.
 February 18th, 2018, 10:52 AM #5 Newbie   Joined: Feb 2018 From: UK Posts: 4 Thanks: 0 Thanks for the explanation

 Tags sample, variance

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post jj314d New Users 1 February 16th, 2018 02:06 PM RyanPowers Advanced Statistics 3 October 12th, 2015 08:54 PM blabla Advanced Statistics 1 May 9th, 2012 01:20 PM club24 Advanced Statistics 1 May 3rd, 2012 02:39 PM tsl182forever8 Advanced Statistics 3 April 5th, 2012 11:21 PM

 Contact - Home - Forums - Cryptocurrency Forum - Top