这道题除了有超出给定表的数据，还有无法精准得出的，比如1.5，在表单中只有接近1.5的数据，这种情况怎么计算？-有问必答-品职教育专注CFA ESG FRM CPA 考研等财经培训课程

NO.PZ2020010303000009问题如下Either using a Z table or the Excel function NORM.S.ST, compute Pr(-1.5 Z 0), where Z ∼ N(0, 1) Pr(Z -1.5), where Z ∼ N(0, 1) Pr(-1.5 X 0), where X ∼ N(1, 2) Pr(X 2), where X ∼ N(1, 2) e. Pr(W 12), where W ∼ N(3, 9) 43.3%. In Excel, the commanto compute this value is NORM.S.ST(0,TRUE) – NORM.S.ST(-1.5,TRUE).6.7%. In Excel, the commanto compute this value is NORM.S.ST(-1.5,TRUE).20.1%. In Excel, the commanto compute this value is NORM.S.ST((0 – 1)/SQRT(2),TRUE) – NORM.S.ST((-1.5-1)/SQRT(2),TRUE). 24.0%. In Excel, the commanto compute this value is 1 – NORM.S.ST((2 – 1)/SQRT(2),TRUE).e. 0.13%. In Excel, the commanto compute this value is 1 – NORM.S.ST((12 – 3)/3,TRUE). -1·5 Z 0如何查表得出的结果

2024-04-16 13:08 1 · 回答

NO.PZ2020010303000009 问题如下 Either using a Z table or the Excel function NORM.S.ST, compute Pr(-1.5 Z 0), where Z ∼ N(0, 1) Pr(Z -1.5), where Z ∼ N(0, 1) Pr(-1.5 X 0), where X ∼ N(1, 2) Pr(X 2), where X ∼ N(1, 2) e. Pr(W 12), where W ∼ N(3, 9) 43.3%. In Excel, the commanto compute this value is NORM.S.ST(0,TRUE) – NORM.S.ST(-1.5,TRUE).6.7%. In Excel, the commanto compute this value is NORM.S.ST(-1.5,TRUE).20.1%. In Excel, the commanto compute this value is NORM.S.ST((0 – 1)/SQRT(2),TRUE) – NORM.S.ST((-1.5-1)/SQRT(2),TRUE). 24.0%. In Excel, the commanto compute this value is 1 – NORM.S.ST((2 – 1)/SQRT(2),TRUE).e. 0.13%. In Excel, the commanto compute this value is 1 – NORM.S.ST((12 – 3)/3,TRUE). excel function NORM.S.ST 这是Excel的计算公式吗？这个也需要掌握吗

2024-01-15 00:04 1 · 回答

NO.PZ2020010303000009 问题如下 Either using a Z table or the Excel function NORM.S.ST, compute Pr(-1.5 Z 0), where Z ∼ N(0, 1) Pr(Z -1.5), where Z ∼ N(0, 1) Pr(-1.5 X 0), where X ∼ N(1, 2) Pr(X 2), where X ∼ N(1, 2) e. Pr(W 12), where W ∼ N(3, 9) 43.3%. In Excel, the commanto compute this value is NORM.S.ST(0,TRUE) – NORM.S.ST(-1.5,TRUE).6.7%. In Excel, the commanto compute this value is NORM.S.ST(-1.5,TRUE).20.1%. In Excel, the commanto compute this value is NORM.S.ST((0 – 1)/SQRT(2),TRUE) – NORM.S.ST((-1.5-1)/SQRT(2),TRUE). 24.0%. In Excel, the commanto compute this value is 1 – NORM.S.ST((2 – 1)/SQRT(2),TRUE).e. 0.13%. In Excel, the commanto compute this value is 1 – NORM.S.ST((12 – 3)/3,TRUE). 是不是可以标准化到 P（-1.77 X -0.71)这个式子，在去查表但是-1.77超过了将以中给的表的范围

2023-02-26 15:41 1 · 回答

NO.PZ2020010303000009 问题如下 Either using a Z table or the Excel function NORM.S.ST, compute Pr(-1.5 Z 0), where Z ∼ N(0, 1) Pr(Z -1.5), where Z ∼ N(0, 1) Pr(-1.5 X 0), where X ∼ N(1, 2) Pr(X 2), where X ∼ N(1, 2) e. Pr(W 12), where W ∼ N(3, 9) 43.3%. In Excel, the commanto compute this value is NORM.S.ST(0,TRUE) – NORM.S.ST(-1.5,TRUE).6.7%. In Excel, the commanto compute this value is NORM.S.ST(-1.5,TRUE).20.1%. In Excel, the commanto compute this value is NORM.S.ST((0 – 1)/SQRT(2),TRUE) – NORM.S.ST((-1.5-1)/SQRT(2),TRUE). 24.0%. In Excel, the commanto compute this value is 1 – NORM.S.ST((2 – 1)/SQRT(2),TRUE).e. 0.13%. In Excel, the commanto compute this value is 1 – NORM.S.ST((12 – 3)/3,TRUE). 具体怎么做呢？请问能用算式一下吗

2023-01-31 10:24 2 · 回答

这道题除了有超出给定表的数据，还有无法精准得出的，比如1.5，在表单中只有接近1.5的数据，这种情况怎么计算？

2 个答案

2

0

175

相关问题