Hi guys,
I am having a hard time calculating sample variance for a ordered array of data in Microsoft Excel 2010. I'm using the fomula: =var.s(cell ranges) and am getting huge integers, such as 93,300. If anybody is familiar with Excel 2010 could you let me know what I am doing wrong? I've checked youtube and couldn't find any good instruction videos....thanks!
I am having a hard time calculating sample variance for a ordered array of data in Microsoft Excel 2010. I'm using the fomula: =var.s(cell ranges) and am getting huge integers, such as 93,300. If anybody is familiar with Excel 2010 could you let me know what I am doing wrong? I've checked youtube and couldn't find any good instruction videos....thanks!