计算下列各组数据的方差和标准差.

问题描述:

计算下列各组数据的方差和标准差.
(1)10,11,12,12,9,10,8,7,10,9
(2)60,80,70,80,90,60,50,60,80,90
(3)1.60,1.62,1.53,1.69,1.58,1.57,1.56,1.61,1.62
(4)-2,-3,5,-1,0,4,3,-4,8,6

=VAR(A11:J11) =STDEV(A11:J11)=VAR(A12:J12) =STDEV(A12:J12)=VAR(A13:I13) =STDEV(A13:I13)=VAR(A14:J14) =STDEV(A14:J14)2.622222222 1.619327707195.5555556 13.984117980.002094444 0.04576510117.15555556 4.1...