Znn3bq.jpeg
²é¿´: 986  |  »Ø¸´: 27
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£
¡¾ÐüÉͽð±Ò¡¿»Ø´ð±¾ÌûÎÊÌ⣬×÷Õßmimimama½«ÔùËÍÄú 207 ¸ö½ð±Ò

mimimama

½ð³æ (ÖøÃûдÊÖ)

[ÇóÖú] 217½ð±ÒÇóÖúÊýѧ¸ßÊÖ £¨ÓÐЧÆÚÖÁ21ÈÕÍíÉÏÊ®¶þµã£© лл

ÏÂÃæÌâĿ˭Äܰïæ½â´ð£¬

Â鷳д³öÏêϸ½â´ð¹ý³ÌÒÔ¼°´ð°¸£¬

лл£¬ÓÉÓÚÒªµÃ±È½Ï¼±£¬

ËùÒÔÂé·³ÂÛ̳µÄÅóÓÑÁË£¬

Ï£ÍûÓиßÊÖÕæ³Ï°ïæ½â¾ö£¬

·Ç³£¸Ð¼¤ÄãÃÇÌṩµÄ°ïÖú£¬

лл£¡

http://www.namipan.com/d/de043b1 ... 5ee87f54ab400600000

[ Last edited by mimimama on 2008-10-21 at 19:12 ]

» ²ÂÄãϲ»¶

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

4clover

½û³æ (ÎÄ̳¾«Ó¢)

emuch08Ë®Íõ

4µ±Äê¸ßÊý¿¼ÁË24·Ö
Ô­À´Èç´Ë... 4µÄÌÔ±¦Ð¡µê£ºhttp://shop58845015.taobao.com/
2Â¥2008-10-21 12:58:57
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

flybird6676

Ϊʲô»¹µÃ»¨°³µÄ±Ò±ÒÄØ£¿»¹ÊÇ·¢µ½ÎÒÐÅÏä°É£¬ÎÒ°ïÄã¿´¿´£ºwater_bluesky@sina.com
3Â¥2008-10-21 13:00:13
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

bwtren

ÈÙÓþ°æÖ÷ (ÖªÃû×÷¼Ò)

²»ÔÚ¹àË®£¬×¨ÐÄÊÔÑé

ÒýÓûØÌû:
Originally posted by 4clover at 2008-10-21 12:58:
4µ±Äê¸ßÊý¿¼ÁË24·Ö

4appleÒ²ÔÚ °¡
Èç¹û˵·¢½ð±ÒÊÇÒ»ÖÖÐÅÄÄÇô½Ó½ð±Ò¾ÍÊÇÒ»·Ý×ðÖØ¡£
4Â¥2008-10-21 13:01:00
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
5Â¥2008-10-21 13:02:07
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

huahua1216

ÖÁ×ðľ³æ (ÎÄ̳¾«Ó¢)

°³°ïæ´«µ½ÍøÅÌ

¡ï ¡ï ¡ï ¡ï ¡ï
mimimama(½ð±Ò+5,VIP+0):лл£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
6Â¥2008-10-21 13:02:21
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

mimimama

½ð³æ (ÖøÃûдÊÖ)

лл¸÷λÁË£¬ÒªµÃ±È½Ï¼±£¬£¬

ËùÒÔÎÒ¾¡ÎÒËùÓнð±Ò£¬

Ï£ÍûÄܵõ½¸÷λµÄ°ïÖú¡£¡£¡£

ÆäʵÎÒÒ²ÊÇÏë°ï±ðÈË£¬£¬

µ«ÊÇÎÒ×öÕâЩÌâÄ¿ºÜÄò»×¼£¬

´óѧ±ÏÒµºÜ¶àºÜ¶àÄêÁË
7Â¥2008-10-21 13:05:21
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

miney

ÈÙÓþ°æÖ÷ (ÎÄ̳¾«Ó¢)

¿ìÀÖ´Ï´ÏÀÏÓѼÇ

Question 1 ¨C Numerical Integration       
a)        Probabilities from the standard normal distribution N(0,1) function below are found in Excel using the normsdist(z) function.  Choose a numerical integration technique (i.e. Simpsons rule, trapezium rule etc) to approximate the integral used to find N(2.00).  How does your answer compare to the normsdist function?       


Question 2 ¨C Monte Carlo Simulation       
From http://office.microsoft.com/en-us/excel/HA011118931033.aspx read the entire page, which introduces the idea of doing Monte Carlo simulation in Excel.

On two separate worksheets, complete Problem 1 and Problem 2 at the bottom of that page.

The Question:
1.        A GMC dealer believes that demand for 2005 Envoys will be normally distributed with a mean of 200 and standard deviation of 30. His cost of receiving an Envoy is $25,000, and he sells an Envoy for $40,000. Half of all leftover Envoys can be sold for $30,000. He is considering ordering 200, 220, 240, 260, 280, or 300 Envoys. How many should he order?
2.        A small supermarket is trying to determine how many copies of People magazine they should order each week. They believe their demand for People is governed by the following discrete random variable.
Demand        Probability
15        .10
20        .20
25        .30
30        .25
35        .15
The supermarket pays $1.00 for each copy of People and sells each copy for $1.95. They can return each unsold copy of People for $0.50. How many copies of People should the store order?
ż¶û»ØÀ´¿´¿´Ë®..................
8Â¥2008-10-21 13:05:43
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

suetung8

ľ³æ (ÖªÃû×÷¼Ò)

ÀϹâ¹÷Ò»¸ö

ÒýÓûØÌû:
Originally posted by bwtren at 2008-10-21 13:01:

4appleÒ²ÔÚ °¡

ÎÒÏëÈ¢Ëý4appleÔõô°ì
ʪ³ö¸öδÀ´!³å¶¯ÊÇħ¹í,µ«ÊÇûÓг嶯Á¬È˶¼²»ÊÇ!·¹ÒªÒ»¿Ú¿Ú³Ô£¬°®ÒªÒ»´Î´Î×ö!
9Â¥2008-10-21 13:20:44
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

suding

Ìú¸Ëľ³æ (ÖªÃû×÷¼Ò)

ÒýÓûØÌû:
Originally posted by miney at 2008-10-21 13:05:
Question 1 ¨C Numerical Integration       
a)        Probabilities from the standard normal distribution N(0,1) function below are found in Excel using the normsdist(z) function.  Choose a numerical integratio ...

¿´ÉÏÈ¥Õý½â
ÈËÔÚ½­ºþ£¬ÒÔÈÊžéÈË£¬ÒÔígžéÊ£¬¾«Õ\ËùÖÁ£¬½ðʯžéé_¡£
10Â¥2008-10-21 13:33:33
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ mimimama µÄÖ÷Ìâ¸üÐÂ
²»Ó¦Öú È·¶¨»ØÌûÓ¦Öú (×¢Ò⣺ӦÖú²Å¿ÉÄܱ»½±Àø£¬µ«²»ÔÊÐí¹àË®£¬±ØÐëÌîд15¸ö×Ö·ûÒÔÉÏ)
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 327Çóµ÷¼Á +5 ʰ¹âÈÎȾ 2026-04-06 5/250 2026-04-12 02:29 by Çï¶¹²ËÑ¿
[¿¼ÑÐ] 085404 293Çóµ÷¼Á +9 ÓÂÔ¶¿â°®314 2026-04-08 9/450 2026-04-12 02:24 by Çï¶¹²ËÑ¿
[¿¼ÑÐ] 296Çóµ÷¼Á +8 Íô£¡£¿£¡ 2026-04-09 8/400 2026-04-11 21:02 by ÄæË®³Ë·ç
[¿¼ÑÐ] µç×ÓÐÅÏ¢279Çóµ÷¼Á£¬ÓÐÊé¶Á¾ÍÐÐ +8 wwwooden 2026-04-08 11/550 2026-04-11 20:22 by cq2548
[¿¼ÑÐ] 285Çóµ÷¼Á +8 ¶ñ·¨´ó¶þµÄÆøÎ¶ß 2026-04-05 11/550 2026-04-11 11:28 by ×ÏêØ×ÏÆå
[˶²©¼ÒÔ°] ÐÂÒ»´úµç×ÓÐÅÏ¢294Çóµ÷¼Á ²»ÌôѧУ +6 Ytyt11 2026-04-09 7/350 2026-04-11 10:52 by AAССľ³æ
[¿¼ÑÐ] ÖÐҩѧµ÷¼Á ³õÊÔ324 +4 Ñó¸Ê¾Õ¡¢ 2026-04-10 6/300 2026-04-11 09:41 by gong120082
[¿¼ÑÐ] µ÷¼Á +12 ¾í¾í¾íÐIJË_ 2026-04-09 13/650 2026-04-10 22:36 by Ftglcn90
[¿¼ÑÐ] 263ÄÜÔ´¶¯Á¦×¨Ë¶Çóµ÷¼Á +4 ¼Ó´óºÅ·¹ºÐ´ü 2026-04-10 4/200 2026-04-10 20:52 by gong120082
[¿¼ÑÐ] ½­ËÕ´óѧ ¹¤¿Æµ÷¼Á ¼ñ© +3 Evan_Liu 2026-04-09 5/250 2026-04-10 10:22 by Evan_Liu
[¿¼ÑÐ] 277Çóµ÷¼Á +19 Äß½¨Éè 2026-04-06 19/950 2026-04-10 09:24 by guosr9609
[¿¼²©] ²©Ê¿×Ô¼ö +7 ¿É¿ÉСÅÖ 2026-04-08 7/350 2026-04-10 08:28 by kimhero
[¿¼ÑÐ] 278Çóµ÷¼Á +27 ·¶æÃÄÈ 2026-04-07 31/1550 2026-04-09 20:49 by zhouxiaoyu
[¿¼ÑÐ] ²ÄÁÏר˶(0856) 339·ÖÇóµ÷¼Á +9 ¹þ¹þ¹þ¶ì¹þ¹þ¹þ 2026-04-09 10/500 2026-04-09 20:01 by Orcid
[¿¼ÑÐ] 275 Çóµ÷¼Á +8 Lei812514 2026-04-07 8/400 2026-04-08 12:46 by chemisry
[¿¼ÑÐ] 313Çóµ÷¼Á +3 Ê®Áùʰ½ 2026-04-07 3/150 2026-04-07 23:20 by lbsjt
[¿¼ÑÐ] 333Çóµ÷¼Á +6 ºÏ³ËÑîϰϦ 2026-04-06 6/300 2026-04-07 09:44 by Öí»á·É
[¿¼ÑÐ] 319·Ö085702°²È«¹¤³ÌÇóµ÷¼Á +6 rious 2026-04-05 6/300 2026-04-07 09:42 by jp9609
[¿¼ÑÐ] ¿¼Ñе÷¼Á +3 WwwwwwwÍÛ 2026-04-06 3/150 2026-04-06 20:55 by lbsjt
[¿¼ÑÐ] 332Çóµ÷¼Á +17 ССÃÏ... 2026-04-05 18/900 2026-04-06 09:51 by À¶ÔÆË¼Óê
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û