《第4章 概率与概率分布计算结果.xls》由会员分享，可在线阅读，更多相关《第4章 概率与概率分布计算结果.xls（40页珍藏版）》请在三一办公上搜索。
1、0品牌得分概率得分乘概率离差平方乘积n=10n=100240.100.400.4209130.200.600.22116220.350.700.00437210.250.250.23424200.10-0.381141合计1.001.95001.24751010031均值1.951方差1.2512频率分布3品牌得分n=10n=100n=1000概率040.000.090.100.10030.100.160.180.20120.400.370.350.35310.400.240.250.25100.100.140.110.104合计1.001.001.001.0004均值1.50001.8200
2、1.90602方差0.72221.30061.28043302132-2.916494850-0.82865426521.3996259442-0.048863742-0.9990753822122241221223120013112203222011424133033214101410222242321413320222221422112111132304131123241111210424234424413232312331211022203122111041411220014423412122403022332212321012211421032211111222232124132211
3、223113011003302321010011331212043432331222221223422033231212142113421102412143240212322331133130021131223343232032020221440333211232213022313331233424331214230021302441320233211121121312321012132232121042122313304222242210212231214312012001122242022113222410222111043111233422423110122222243232232124
4、211320314220232033222142212320012211320122413033011342331140230400232122320002213103122143410234122213031241321222402242314421134131131124111212314322223222222343210424322023210322222322024322411432222113022222142021223230132330112212014212322121101401024224241134320312121221312232420023401314212021
5、141102202221221432211223113102223022310112133231132402143212424402021124233201212242220422313332011202341220103230423101120332213321114032342013433122121221223211n=10001011813542511131000 x一般正态分布标准正态分布均值1-5 6.07588E-09 1.48672E-06 标准差1-4.9 1.10158E-08 2.43896E-06-4.8 1.97732E-083.9613E-06-4.7 3.5139
6、6E-08 6.36983E-06-4.6 6.18262E-08 1.01409E-05-4.5 1.07698E-07 1.59837E-05-4.4 1.85736E-07 2.49425E-05-4.3 3.17135E-07 3.85352E-05-4.2 5.36104E-07 5.89431E-05-4.1 8.97244E-07 8.92617E-05-4 1.48672E-060.00013383-3.9 2.43896E-06 0.000198655-3.83.9613E-06 0.000291947-3.7 6.36983E-060.00042478-3.6 1.0140
7、9E-05 0.000611902-3.5 1.59837E-05 0.000872683-3.4 2.49425E-05 0.001232219-3.3 3.85352E-05 0.001722569-3.2 5.89431E-05 0.002384088-3.1 8.92617E-05 0.003266819-30.00013383 0.004431848-2.9 0.000198655 0.005952532-2.8 0.000291947 0.007915452-2.70.00042478 0.010420935-2.6 0.000611902 0.013582969-2.5 0.00
8、08726830.0175283-2.4 0.0012322190.02239453-2.3 0.001722569 0.028327038-2.2 0.002384088 0.035474593-2.1 0.003266819 0.043983596-2 0.004431848 0.053990967-1.9 0.005952532 0.065615815-1.8 0.007915452 0.078950158-1.7 0.010420935 0.094049077-1.6 0.013582969 0.110920835-1.50.0175283 0.129517596-1.40.02239
9、453 0.149727466-1.3 0.028327038 0.171368592-1.2 0.035474593 0.194186055-1.1 0.043983596 0.217852177-1 0.053990967 0.241970725-0.9 0.0656158150.26608525-0.8 0.078950158 0.289691553-0.7 0.094049077 0.312253933-0.6 0.110920835 0.333224603-0.5 0.129517596 0.352065327-0.4 0.1497274660.36827014-0.3 0.1713
10、68592 0.381387815-0.2 0.194186055 0.391042694-0.1 0.217852177 0.3969525470 0.2419707250.398942280.10.26608525 0.3969525470.2 0.289691553 0.3910426940.3 0.312253933 0.3813878150.4 0.3332246030.368270140.5 0.352065327 0.3520653276543210-1-2-3-4-5-60.00 0.05 0.10 0.15 0.20 0.25 0.30 0.35 0.40 0.45 一般正态
11、分布标准正态分布0.60.36827014 0.3332246030.7 0.381387815 0.3122539330.8 0.391042694 0.2896915530.9 0.3969525470.2660852510.39894228 0.2419707251.1 0.396952547 0.2178521771.2 0.391042694 0.1941860551.3 0.381387815 0.1713685921.40.36827014 0.1497274661.5 0.352065327 0.1295175961.6 0.333224603 0.1109208351.7 0
12、.312253933 0.0940490771.8 0.289691553 0.0789501581.90.26608525 0.0656158152 0.241970725 0.0539909672.1 0.217852177 0.0439835962.2 0.194186055 0.0354745932.3 0.171368592 0.0283270382.4 0.1497274660.022394532.5 0.1295175960.01752832.6 0.110920835 0.0135829692.7 0.094049077 0.0104209352.8 0.078950158 0
13、.0079154522.9 0.065615815 0.0059525323 0.053990967 0.0044318483.1 0.043983596 0.0032668193.2 0.035474593 0.0023840883.3 0.028327038 0.0017225693.40.02239453 0.0012322193.50.0175283 0.0008726833.6 0.013582969 0.0006119023.7 0.0104209350.000424783.8 0.007915452 0.0002919473.9 0.005952532 0.0001986554
14、0.0044318480.000133834.1 0.003266819 8.92617E-054.2 0.002384088 5.89431E-054.3 0.001722569 3.85352E-054.4 0.001232219 2.49425E-054.5 0.000872683 1.59837E-054.6 0.000611902 1.01409E-054.70.00042478 6.36983E-064.8 0.0002919473.9613E-064.9 0.000198655 2.43896E-0650.00013383 1.48672E-06x二项分布正态分布n10000 1
15、.23023E-970 p 0.21 3.07558E-950 均值200=E1*E22 3.84063E-930 标准差12.649111=SQRT(E3*(1-E2)3 3.19412E-9104 1.99034E-8905 9.91189E-88064.1093E-86071.4588E-8408 4.52685E-83091.2474E-81010 3.09043E-80011 6.95346E-790121.4327E-77013 2.72214E-76014 4.79776E-75015 7.88433E-74016 1.21345E-72017 1.75593E-71018 2.
16、39733E-700193.0976E-69020 3.79844E-68021 4.43151E-67022 4.93006E-66023 5.24086E-65024 5.33367E-64025 5.20566E-63026 4.88031E-62027 4.40131E-61028 3.82364E-60029 3.20395E-59030 2.59253E-58031 2.02803E-57032 1.53528E-56033 1.12587E-55034 8.00528E-55035 5.52364E-54036 3.70161E-53037 2.41105E-52038 1.52
17、752E-51039 9.41974E-51040 5.65773E-50041 3.31184E-49042 1.89051E-48043 1.05297E-47044 5.72552E-47045 3.04089E-46046 1.57829E-45047 8.00897E-45048 3.97529E-44049 1.93085E-43050 9.18121E-43051 4.27556E-42052 1.95072E-41053 8.72305E-41054 3.82441E-400551.6445E-3901200100080060040020000.0000 0.0050 0.01
18、00 0.0150 0.0200 0.0250 0.0300 0.0350 二项分布正态分布56 6.93772E-39057 2.87246E-38058 1.16756E-37059 4.66033E-37060 1.82724E-36061 7.03936E-36062 2.66531E-35063 9.92086E-35064 3.63119E-34065 1.30723E-33066 4.62977E-33067 1.61351E-32068 5.53457E-32069 1.86892E-31070 6.21416E-31071 2.03492E-30072 6.56403E-30
19、0732.0861E-29074 6.53316E-29075 2.01657E-28076 6.13594E-28077 1.84078E-27078 5.44565E-27079 1.58889E-26080 4.57302E-26081 1.29851E-25082 3.63821E-25083 1.00599E-24084 2.74551E-24085 7.39672E-24086 1.96744E-23087 5.16736E-23088 1.34028E-22089 3.43353E-22090 8.68875E-22091 2.17219E-21092 5.36554E-2109
20、3 1.30965E-20094 3.15919E-20095 7.53217E-20096 1.77516E-191.11022E-1697 4.13594E-191.11022E-1698 9.52744E-191.11022E-1699 2.17014E-183.33067E-16100 4.88824E-186.66134E-16101 1.08896E-171.22125E-15102 2.39946E-172.22045E-15103 5.22988E-173.9968E-15104 1.12769E-167.43849E-15105 2.40575E-161.35447E-141
21、06 5.07817E-162.44249E-14107 1.06072E-154.39648E-14108 2.19265E-157.86038E-14109 4.48587E-151.39666E-13110 9.08389E-152.4647E-13111 1.82087E-144.32321E-13112 3.61329E-147.5373E-13113 7.09867E-141.30551E-12114 1.38082E-132.24754E-12115 2.65957E-133.84504E-12116 5.07268E-136.53744E-12117 9.58172E-131.
22、10456E-11118 1.79251E-121.85467E-11119 3.32142E-123.09477E-11120 6.09619E-125.13195E-111211.1084E-118.45717E-11122 1.99648E-111.38503E-10123 3.56282E-112.25413E-10124 6.29959E-113.64579E-10125 1.10369E-105.85994E-10126 1.91613E-109.36018E-10127 3.29664E-101.48582E-09128 5.62103E-102.34388E-09129 9.4
23、9911E-103.67447E-091301.5911E-095.72459E-09131 2.64171E-098.86306E-09132 4.34782E-091.36368E-08133 7.09381E-092.08512E-08134 1.14745E-083.1684E-08135 1.84017E-084.78451E-081362.926E-087.18E-08137 4.61326E-081.07078E-071387.2124E-081.58697E-07139 1.11818E-072.33735E-071401.7192E-073.42113E-07141 2.62
24、148E-074.97628E-07142 3.96453E-077.19332E-071435.9468E-071.03334E-06144 8.84792E-071.47519E-06145 1.30583E-062.09286E-06146 1.91179E-062.95068E-06147 2.77665E-064.13421E-06148 4.00081E-065.75643E-06149 5.71928E-067.9653E-06150 8.11185E-061.09532E-05151 1.14157E-051.49682E-05152 1.59406E-052.03275E-0
25、5153 2.20877E-050.000027434154 3.03706E-053.67946E-05155 4.14411E-054.90418E-05156 5.61182E-056.49587E-051570.000075428.55061E-051580.00010060.000111852159 0.0001331840.000145406160 0.0001750120.000187848161 0.0002282770.000241168162 0.0002955620.000307694163 0.0003798790.000390129164 0.0004846930.0
26、00491569165 0.0006139440.000615529166 0.0007720530.00076595167 0.0009639110.000947196168 0.0011948480.001164037169 0.0014705820.001421611170 0.0017971380.00172537171 0.0021807380.002080994172 0.0026276620.002494288173 0.0031440810.002971046174 0.0037358550.003516894175 0.0044083090.004137101176 0.00
27、51659870.004836375177 0.0060123920.005618633178 0.0069497170.006486767179 0.0079785850.007442398180 0.0090978040.008485635181 0.0103041420.0096148551820.011592160.0108265011830.012954080.012114919184 0.0143797330.013472243185 0.0158565710.014888345186 0.0173697650.01635084187 0.0189023910.0178451771
28、88 0.0204356970.019354808189 0.0219494520.020861429190 0.0234223760.022345313191 0.0248326240.023785704192 0.0261583240.025161278193 0.0273781420.026450653194 0.0284718570.027632937195 0.0294209190.028688283196 0.0302089790.029598443197 0.0308223590.030347298198 0.0312504480.030921338199 0.031486004
29、0.03131008200 0.0315253610.031506402201 0.0313685190.031506402202 0.0310191170.03131008203 0.0304843040.030921338204 0.0297744980.0303472982050.028903050.029598443206 0.0278858310.0286882832070.026740760.027632937208 0.0254872870.026450653209 0.0241458510.025161278210 0.0227373430.023785704211 0.021
30、2825840.022345313212 0.0198018380.020861429213 0.0183143760.019354808214 0.0168381010.017845177215 0.0153892410.01635084216 0.0139821230.014888345217 0.0126290140.013472243218 0.0113400440.0121149192190.010123190.010826501220 0.0089843310.009614855221 0.0079273510.008485635222 0.0069542860.007442398
31、2230.006065510.006486767224 0.0052599340.005618633225 0.0045352320.004836375226 0.0038880590.0041371012270.003314270.003516894228 0.0028091350.002971046229 0.0023675240.002494288230 0.0019840880.002080994231 0.0016534070.00172537232 0.0013701180.001421611233 0.0011290250.001164037234 0.0009251730.00
32、0947196235 0.0007539170.00076595236 0.0006109610.000615529237 0.0004923780.000491569238 0.0003946260.000390129239 0.0003145450.000307694240 0.0002493430.000241168241 0.0001965770.000187848242 0.0001541340.000145406243 0.0001201990.000111852244 9.32284E-058.55061E-05245 7.19191E-056.49587E-05246 5.51
33、818E-054.90418E-05247 4.21124E-053.67946E-05248 3.19664E-050.000027434249 2.41353E-052.03275E-05250 1.81256E-051.49682E-052510.000013541.09532E-05252 0.0000100617.9653E-06253 7.43639E-065.75643E-062545.4675E-064.13421E-06255 3.99878E-062.95068E-06256 2.90927E-062.09286E-06257 2.10554E-061.47519E-062
34、58 1.51591E-061.03334E-06259 1.08572E-067.19332E-07260 7.73574E-074.97628E-07261 5.48319E-073.42113E-07262 3.86648E-072.33735E-07263 2.71242E-071.58697E-07264 1.89304E-071.07078E-07265 1.31441E-077.18E-08266 9.07984E-084.78451E-08267 6.24026E-083.1684E-082684.2669E-082.08512E-08269 2.90276E-081.3636
35、8E-08270 1.96474E-088.86306E-09271 1.32312E-085.72459E-09272 8.86537E-093.67447E-09273 5.91024E-092.34388E-09274 3.92039E-091.48582E-09275 2.58746E-099.36018E-10276 1.69919E-095.85994E-102771.1103E-093.64579E-10278 7.21896E-102.25413E-10279 4.67033E-101.38503E-10280 3.00652E-108.45717E-11281 1.92589
36、E-105.13195E-11282 1.22758E-103.09477E-11283 7.78626E-111.85467E-11284 4.91439E-111.10456E-11285 3.08658E-116.53744E-12286 1.92911E-113.84504E-12287 1.19981E-112.24754E-12288 7.42593E-121.30551E-12289 4.57376E-127.5373E-132902.8034E-124.32321E-13291 1.70998E-122.4647E-13292 1.03799E-121.39666E-13293
37、 6.27046E-137.86038E-14294 3.76974E-134.39648E-14295 2.25545E-132.44249E-14296 1.34299E-131.35447E-14297 7.95843E-147.43849E-15298 4.69361E-143.9968E-15299 2.75494E-142.22045E-15300 1.60935E-141.22125E-15301 9.35666E-156.66134E-16302 5.41416E-153.33067E-16303 3.11806E-151.11022E-16304 1.78724E-151.1
38、1022E-16305 1.01961E-151.11022E-16306 5.78943E-160307 3.27188E-160308 1.84043E-1603091.0304E-160310 5.74201E-170311 3.18487E-170312 1.75832E-170313 9.66231E-180314 5.28504E-180315 2.87741E-180316 1.55936E-180317 8.41167E-190318 4.51664E-190319 2.41407E-190320 1.28436E-1903216.8019E-200322 3.58579E-2
39、003231.8817E-200324 9.82959E-210325 5.11138E-210326 2.64585E-210327 1.36338E-210328 6.99356E-220329 3.57118E-220330 1.81535E-220331 9.18643E-2303324.6278E-230333 2.32085E-230334 1.15869E-230335 5.75885E-240336 2.84943E-240337 1.40358E-240338 6.88293E-250339 3.36025E-250340 1.63318E-250341 7.90249E-2
40、60342 3.80683E-260343 1.82572E-2603448.7173E-270345 4.14387E-270346 1.96115E-2703479.2406E-280348 4.33485E-280349 2.02459E-280350 9.41432E-290351 4.35848E-290352 2.00899E-290353 9.21972E-300354 4.21268E-300355 1.91647E-300356 8.68066E-310357 3.91481E-310358 1.75784E-310359 7.85885E-320360 3.49828E-3
41、20361 1.55048E-320362 6.84226E-330363 3.00645E-330364 1.31532E-330365 5.72975E-340366 2.48524E-340367 1.07333E-340368 4.61559E-350369 1.97632E-350370 8.42609E-360371 3.57711E-3603721.5121E-3603736.3646E-370374 2.66752E-370375 1.11324E-370376 4.62618E-380377 1.91428E-380378 7.88755E-390379 3.23618E-3
42、90380 1.32215E-390381 5.37883E-400382 2.17899E-400383 8.78992E-410384 3.53085E-410385 1.41234E-410386 5.62557E-420387 2.23133E-420388 8.81318E-430389 3.46637E-430390 1.35766E-430391 5.29522E-440392 2.05663E-440393 7.95438E-450394 3.06365E-450395 1.17505E-450396 4.48802E-460397 1.70703E-4603986.4657E
43、-470399 2.43882E-4704009.1608E-480401 3.42673E-4804021.2765E-480403 4.73541E-4904041.7494E-490405 6.43608E-500406 2.35805E-500407 8.60369E-510408 3.12622E-510409 1.13125E-510410 4.07663E-520411 1.46302E-520412 5.22889E-530413 1.86113E-530414 6.59712E-540415 2.32886E-540416 8.18741E-550417 2.86658E-5
44、504189.9953E-560419 3.47092E-560420 1.20036E-560421 4.13426E-570422 1.41809E-5704234.8443E-580424 1.64809E-580425 5.58412E-590426 1.88431E-590427 6.33252E-600428 2.11947E-600429 7.06491E-610430 2.34538E-610431 7.75446E-620432 2.55341E-620433 8.37376E-630434 2.73498E-630435 8.89654E-640436 2.88219E-6
45、40437 9.29952E-650438 2.98837E-650439 9.56416E-660440 3.04858E-660441 9.67802E-670442 3.05996E-670443 9.63577E-680444 3.02203E-6804459.4396E-690446 2.93665E-690447 9.09901E-7004482.8079E-700449 8.63006E-710450 2.64176E-710451 8.05414E-720452 2.44564E-720453 7.39631E-730454 2.22785E-730455 6.68358E-7
46、404561.997E-740457 5.94278E-750458 1.76096E-750459 5.19501E-760460 1.52237E-760461 4.45814E-770462 1.08358E-770463004640046500466004670046800469004700047100472004730047400475004760047700478004790048000481004820048300484004850048600487004880048900490004910049200493004940049500496004970049800499005000
47、050100502005030050400505005060050700508005090051000511005120051300514005150051600517005180051900520005210052200523005240052500526005270052800529005300053100532005330053400535005360053700538005390054000541005420054300544005450054600547005480054900550005510055200553005540055500556005570055800559005600
48、056100562005630056400565005660056700568005690057000571005720057300574005750057600577005780057900580005810058200583005840058500586005870058800589005900059100592005930059400595005960059700598005990060000601006020060300604006050060600607006080060900610006110061200613006140061500616006170061800619006200
49、062100622006230062400625006260062700628006290063000631006320063300634006350063600637006380063900640006410064200643006440064500646006470064800649006500065100652006530065400655006560065700658006590066000661006620066300664006650066600667006680066900670006710067200673006740067500676006770067800679006800
50、068100682006830068400685006860068700688006890069000691006920069300694006950069600697006980069900700007010070200703007040070500706007070070800709007100071100712007130071400715007160071700718007190072000721007220072300724007250072600727007280072900730007310073200733007340073500736007370073800739007400
