excel吧 关注：281,250贴子：1,548,987
- 10回复贴，共1页
=stdev(A1:A100)
这样就能算A1:A100这100个数。
没有限制数字的个数，限制的是参数的个数30个，难道你要计算的数据不是连续的？需要输入30多个参数？？
=stdev(A1,A3,A5,A7,A9,A11,A13,A15,A17,A19,A21,A23,A25,A27,A29,A31,A33,A35,A37,A39,A41,A43,A45,A47,A49,A51,A53,A55,A57,A59,A61,A63,A65,A67,A69,A71,A73,A75,A77,A79)全是断开的区域？？
还是说你是把这个函数当计算器？
=STDEV(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31)这样子输入很多很多参数？
如果当计算器的话，输入数组形式的，=STDEV({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33})这样的话就只相当于一个参数。
这样就能算A1:A100这100个数。
没有限制数字的个数，限制的是参数的个数30个，难道你要计算的数据不是连续的？需要输入30多个参数？？
=stdev(A1,A3,A5,A7,A9,A11,A13,A15,A17,A19,A21,A23,A25,A27,A29,A31,A33,A35,A37,A39,A41,A43,A45,A47,A49,A51,A53,A55,A57,A59,A61,A63,A65,A67,A69,A71,A73,A75,A77,A79)全是断开的区域？？
还是说你是把这个函数当计算器？
=STDEV(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31)这样子输入很多很多参数？
如果当计算器的话，输入数组形式的，=STDEV({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33})这样的话就只相当于一个参数。
