【单选题】利用Excel下列函数可快速完成判别函数的计算工作
A. mmult(),transpose(), MINVERSE() B. mmult(),transpose(), finv() C. mmult(),finv(), MINVERSE() D. finv(),transpose(), MINVERSE()
A. mmult(),transpose(), MINVERSE() B. mmult(),transpose(), finv() C. mmult(),finv(), MINVERSE() D. finv(),transpose(), MINVERSE()
举一反三
- Excel的MMULT函数的作用是
- 假设取α=0.05,n1=10,n2=15,检验统计量为F,双侧检验时的临界值为F A: =FINV(0.025,9,14)=FINV(0.975,9,14) B: =FINV(0.05,9,14)=FINV(0.95,9,14) C: =FINV(0.05,9,14)=FINV(0.95,9,14) D: =FDIST(0.025,9,14)=FDIST(0.975,9,14)
- 如果要计算[img=82x25]1803c479eb7ea11.png[/img]的值,如下命令正确的是: A: tinv(0.95,2,10) B: chi2inv(0.05,2,10) C: finv(0.05,2,10) D: finv(0.95,2,10)
- Excel中矩阵的乘法使用mmult函数来实现。
- Which of the following statement is true regarding TRANSPOSE and FAST_TRANSPOSE algorithms.( ) A: None of the above B: Time complexities of TRANSPOSE and FAST_TRANSPOSE are same C: The TRANSPOSE algorithm is faster than FAST_TRANSPOSE D: The TRANSPOSE algorithm is slower than FAST_TRANSPOSE