å
¬å¼ï¼=NORMINV(æ¦çå¼,
ç®æ¯å¹³åå¼,æ ååå·®å¼)
NORMSINV( X ) è¿åæ åæ£æåå¸çåºé´ç¹ã
NORMINV( X, MEAN, STARDARD VARIANCE) è¿åéæ åæ£æåå¸çåºé´ç¹ã
æ£æåå¸ ï¼
æ£æåå¸ï¼Normal distributionï¼åå
é«æ¯åå¸ï¼Gaussian distributionï¼ï¼æ¯ä¸ä¸ªå¨æ°å¦ãç©çåå·¥ç¨çé¢åé½é常éè¦çæ¦çåå¸ï¼å¨ç»è®¡å¦ç许å¤æ¹é¢æçé大çå½±ååãè¥éæºåéXæä»ä¸ä¸ª
æ°å¦ææ为μãæ¹å·®ä¸ºÏ^2çé«æ¯åå¸ï¼è®°ä¸ºN(μï¼Ï^2)ãå
¶æ¦çå¯åº¦å½æ°ä¸ºæ£æåå¸çææå¼Î¼å³å®äºå
¶ä½ç½®ï¼å
¶
æ åå·®Ïå³å®äºåå¸çå¹
度ãå å
¶æ²çº¿åéå½¢ï¼å æ¤äººä»¬åç»å¸¸ç§°ä¹ä¸ºéå½¢æ²çº¿ãæ们é常æ说çæ åæ£æåå¸æ¯Î¼ = 0,Ï = 1çæ£æåå¸ã