《炒黄金分析表.xls》由会员分享,可在线阅读,更多相关《炒黄金分析表.xls(9页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、z1-z/y 1/y1/n1/kx1/yn 1/ykB2+G2B2-H2x次方结果0.05 0.980.50.10.11 0.05 0.051.025 0.9251.0250.9481250.05 0.980.50.10.12 0.05 0.051.025 0.9251.050620.97182810.05 0.980.50.10.13 0.05 0.051.025 0.9251.076890.99612380.05 0.980.50.10.14 0.05 0.051.025 0.9251.103811.02102690.05 0.980.50.10.15 0.05 0.051.025 0.9
2、251.131411.04655260.05 0.980.50.10.16 0.05 0.051.025 0.9251.159691.07271640.05 0.980.50.10.17 0.05 0.051.025 0.9251.188691.09953430.05 0.980.50.10.18 0.05 0.051.025 0.9251.21841.12702270.05 0.980.50.10.19 0.05 0.051.025 0.9251.248861.15519820.05 0.980.50.10.110 0.05 0.051.025 0.9251.280081.18407820.
3、05 0.980.50.20.210.10.11.075 0.8751.0750.9406250.05 0.980.50.20.220.10.11.075 0.8751.155621.01117190.05 0.980.50.20.230.10.11.075 0.8751.24231.08700980.05 0.980.50.20.240.10.11.075 0.8751.335471.16853550.05 0.980.50.20.250.10.11.075 0.8751.435631.25617570.05 0.980.50.20.260.10.11.075 0.8751.54331.35
4、038880.05 0.980.50.20.270.10.11.075 0.8751.659051.4516680.05 0.980.50.20.280.10.11.075 0.8751.783481.56054310.05 0.980.50.20.290.10.11.075 0.8751.917241.67758380.05 0.980.50.20.2100.10.11.075 0.8752.061031.80340260.05 0.980.50.30.31 0.15 0.151.125 0.8251.1250.9281250.05 0.980.50.30.32 0.15 0.151.125
5、 0.8251.265631.04414060.05 0.980.50.30.33 0.15 0.151.125 0.8251.423831.17465820.05 0.980.50.30.34 0.15 0.151.125 0.8251.601811.32149050.05 0.980.50.30.35 0.15 0.151.125 0.8251.802031.48667680.05 0.980.50.30.36 0.15 0.151.125 0.8252.027291.67251140.05 0.980.50.30.37 0.15 0.151.125 0.8252.28071.881575
6、30.05 0.980.50.30.38 0.15 0.151.125 0.8252.565782.11677220.05 0.980.50.30.39 0.15 0.151.125 0.8252.886512.38136880.05 0.980.50.30.310 0.15 0.151.125 0.8253.247322.67903980.05 0.980.50.40.410.20.21.175 0.7751.1750.9106250.05 0.980.50.40.420.20.21.175 0.7751.380631.06998440.05 0.980.50.40.430.20.21.17
7、5 0.7751.622231.25723160.05 0.980.50.40.440.20.21.175 0.7751.906131.47724720.05 0.980.50.40.450.20.21.175 0.7752.23971.73576540.05 0.980.50.40.460.20.21.175 0.7752.631642.03952440.05 0.980.50.40.470.20.21.175 0.7753.092182.39644120.05 0.980.50.40.480.20.21.175 0.7753.633312.81581840.05 0.980.50.40.4
8、90.20.21.175 0.7754.269143.30858660.05 0.980.50.40.4100.20.21.175 0.7755.016243.88758920.05 0.980.50.50.51 0.25 0.251.225 0.7251.2250.8881250.05 0.980.50.50.52 0.25 0.251.225 0.7251.500631.08795310.05 0.980.50.50.53 0.25 0.251.225 0.7251.838271.33274260.05 0.980.50.50.54 0.25 0.251.225 0.7252.251881
9、.63260970.05 0.980.50.50.55 0.25 0.251.225 0.7252.758551.99994680.05 0.980.50.50.56 0.25 0.251.225 0.7253.379222.44993490.05 0.980.50.50.57 0.25 0.251.225 0.7254.139553.00117020.05 0.980.50.50.58 0.25 0.251.225 0.7255.070943.67643350.05 0.980.50.50.59 0.25 0.251.225 0.7256.21194.50363110.05 0.980.50
10、.50.510 0.25 0.251.225 0.7257.609585.5169480.05 0.980.50.60.610.30.31.275 0.6751.2750.8606250.05 0.980.50.60.620.30.31.275 0.6751.625631.09729690.05 0.980.50.60.630.30.31.275 0.6752.072671.39905350.05 0.980.50.60.640.30.31.275 0.6752.642661.78379320.05 0.980.50.60.650.30.31.275 0.6753.369392.2743364
11、0.05 0.980.50.60.660.30.31.275 0.6754.295972.89977890.05 0.980.50.60.670.30.31.275 0.6755.477363.69721810.05 0.980.50.60.680.30.31.275 0.6756.983634.7139530.05 0.980.50.60.690.30.31.275 0.6758.904136.01029010.05 0.980.50.60.6100.30.31.275 0.67511.35287.66311990.05 0.980.50.70.71 0.35 0.351.325 0.625
12、1.3250.8281250.05 0.980.50.70.72 0.35 0.351.325 0.6251.755631.09726560.05 0.980.50.70.73 0.35 0.351.325 0.6252.32621.4538770.05 0.980.50.70.74 0.35 0.351.325 0.6253.082221.9263870.05 0.980.50.70.75 0.35 0.351.325 0.6254.083942.55246270.05 0.980.50.70.76 0.35 0.351.325 0.6255.411223.38201310.05 0.980
13、.50.70.77 0.35 0.351.325 0.6257.169874.48116740.05 0.980.50.70.78 0.35 0.351.325 0.6259.500075.93754680.05 0.980.50.70.79 0.35 0.351.325 0.62512.58767.86724950.05 0.980.50.70.710 0.35 0.351.325 0.62516.678610.4241060.05 0.980.50.80.810.40.41.375 0.5751.3750.7906250.05 0.980.50.80.820.40.41.375 0.575
14、1.890631.08710940.05 0.980.50.80.830.40.41.375 0.5752.599611.49477540.05 0.980.50.80.840.40.41.375 0.5753.574462.05531620.05 0.980.50.80.850.40.41.375 0.5754.914892.82605970.05 0.980.50.80.860.40.41.375 0.5756.757973.88583210.05 0.980.50.80.870.40.41.375 0.5759.292215.34301920.05 0.980.50.80.880.40.
15、41.375 0.57512.77687.34665130.05 0.980.50.80.890.40.41.375 0.57517.568110.1016460.05 0.980.50.80.8100.40.41.375 0.57524.156113.8897630.05 0.980.50.90.91 0.45 0.451.425 0.5251.4250.7481250.05 0.980.50.90.92 0.45 0.451.425 0.5252.030631.06607810.05 0.980.50.90.93 0.45 0.451.425 0.5252.893641.51916130.
16、05 0.980.50.90.94 0.45 0.451.425 0.5254.123442.16480490.05 0.980.50.90.95 0.45 0.451.425 0.5255.87593.0848470.05 0.980.50.90.96 0.45 0.451.425 0.5258.373164.39590690.05 0.980.50.90.97 0.45 0.451.425 0.52511.93176.26416740.05 0.980.50.90.98 0.45 0.451.425 0.52517.00278.92643850.05 0.980.50.90.99 0.45
17、 0.451.425 0.52524.228912.7201750.05 0.980.50.90.910 0.45 0.451.425 0.52534.526218.1262490.05 0.980.51110.50.51.475 0.4751.4750.7006250.05 0.980.51120.50.51.475 0.4752.175631.03342190.05 0.980.51130.50.51.475 0.4753.209051.52429730.05 0.980.51140.50.51.475 0.4754.733342.24833850.05 0.980.51150.50.51
18、.475 0.4756.981683.31629920.05 0.980.51160.50.51.475 0.47510.2984.89154140.05 0.980.51170.50.51.475 0.47515.18957.21502350.05 0.980.51180.50.51.475 0.47522.404510.642160.05 0.980.51190.50.51.475 0.47533.046715.6971860.05 0.980.511100.50.51.475 0.47548.743923.1533490.05 0.980.51.51.51 0.75 0.751.725
19、0.2251.7250.3881250.05 0.980.51.51.52 0.75 0.751.725 0.2252.975630.66951560.05 0.980.51.51.53 0.75 0.751.725 0.2255.132951.15491450.05 0.980.51.51.54 0.75 0.751.725 0.2258.854341.99222740.05 0.980.51.51.55 0.75 0.751.725 0.22515.27373.43659230.05 0.980.51.51.56 0.75 0.751.725 0.22526.34725.92812180.
20、05 0.980.51.51.57 0.75 0.751.725 0.22545.448910.226010.05 0.980.51.51.58 0.75 0.751.725 0.22578.399417.6398670.05 0.980.51.51.59 0.75 0.751.725 0.225135.23930.4287710.05 0.980.51.51.510 0.75 0.751.725 0.225233.28752.489630.05 0.980.5221111.975-0.0251.975-0.0493750.05 0.980.5222111.975-0.0253.90063-0
21、.0975160.05 0.980.5223111.975-0.0257.70373-0.1925930.05 0.980.5224111.975-0.02515.2149-0.3803720.05 0.980.5225111.975-0.02530.0494-0.7512340.05 0.980.5226111.975-0.02559.3475-1.4836880.05 0.980.5227111.975-0.025117.211-2.9302840.05 0.980.5228111.975-0.025231.492-5.7873110.05 0.980.5229111.975-0.0254
22、57.198-11.429940.05 0.980.52210111.975-0.025902.965-22.5741310/(x+1)操作10次利益,1/y=1/101/y=1/51/y=3/101/y=2/51/y=1/250.9506298810.902538091 0.855750318 0.8102893430.7661750243.333330.9830173430.965416994 0.947221442 0.9284545680.9091416312.50.9996225380.998480618 0.996560676 0.9938501830.99033772321.00
23、97199921.018859874 1.027389401 1.0352782291.0424959791.666671.0165082291.0326766061.04846991 1.0638519341.0787854981.428571.0213848931.042660267 1.063791724 1.0847433031.1054774621.251.0250577381.050211304 1.0754298441.100680621.1259289561.111111.0279235241.0561221191.08456967 1.1132380211.142096895
24、11.030221921.060874715 1.091937427 1.1233870151.1551982470.909091.0321062481.064779105 1.098002804 1.1317595181.16602924350.9491902960.89702418 0.843898308 0.7902088210.736347113.333331.0149757531.02642412 1.034144069 1.0379604361.0377273712.51.0495589981.097964247 1.144791801 1.1895981031.231923144
25、21.0708720151.143259998 1.2167848371.291016941.365475211.666671.0853205971.174490607 1.267278232 1.3633888131.4624598681.428571.0957602141.197319164 1.304622802 1.4175538731.5359241511.251.1036557731.214731302 1.333351664 1.4595852231.5934341791.111111.1098360751.228448953 1.356133002 1.4931360061.6
26、3964886311.1148052261.239534525 1.374638005 1.5205310631.677583830.909091.1188874391.248678905 1.389966123 1.5433186411.70927342950.9467948650.887894239 0.824437045 0.7576274160.6887036033.333331.0469279971.08693896 1.118922171 1.1418596821.1548616992.51.1008984841.202616379 1.3035301191.401816821.4
27、9547373421.1346072381.277851213 1.428610325 1.5853982841.7463370851.666671.157651221.330604761 1.518596033 1.7209561121.9365450361.428571.1743972031.369614055 1.586321362 1.8248232392.0849646231.251.1871154681.3996197191.63909021 1.9068171932.2036976431.111111.1971025991.423411201 1.681343263 1.9731
28、290042.30070079411.2051527661.442735241 1.715928603 2.0278350142.3813687520.909091.2117795151.458740788 1.744754201 2.0737207592.44946915850.9434493880.875237365 0.7977961340.71382790.6261780583.333331.078814821.1464712251.19987373 1.2361709031.2529241662.51.153615421.31214495 1.471490131 1.62675075
29、11.77230415621.2009627621.422829976 1.6631462431.918079112.1822592241.666671.2336023871.5017597771.80459256 2.1407379852.5069849451.428571.2574581181.560805026 1.912932648 2.3154361032.768115111.251.2756521791.606607519 1.9984351832.455753462.9816623471.111111.289984921.643158928 2.067570697 2.57074
30、21283.15908059611.3015669721.672997883 2.124597224 2.6665977873.3085865660.909091.3111205021.69781417 2.172423256 2.7476776873.43615750350.9391619630.859176763 0.764560197 0.6605155560.5525485923.333331.1105751841.204508886 1.275246074 1.3168270051.3244450562.51.2076795151.42617806 1.646967959 1.859
31、3089572.05052789521.26997141.578308868 1.920170721 2.2868899392.6654142961.666671.3132742671.688641639 2.127043174 2.6252725573.1746614381.428571.3451059751.772142183 2.288319362 2.8972163253.5969554211.251.369485071.837466226 2.417251747 3.1195059433.9501472431.111111.388751661.889934077 2.52253427
32、13.304123644.24865930411.4043599081.932985019 2.6100524173.459654014.5036310520.909091.4172606821.968936933 2.683911952 3.5923362274.72358485550.9339429590.839868237 0.725452578 0.5997327320.4721389053.333331.1421463791.260522786 1.343256973 1.3798692511.3627425232.51.2630556171.544260178 1.82782301
33、4 2.0930424152.31518562821.3416613191.744304638 2.1988680232.687460473.1819182961.666671.3967644781.891865442 2.487191235 3.1748127943.9333068441.428571.437504122.004848722.71600533 3.5761464124.5763713621.251.4688367682.09399254 2.901327119 3.9101027335.1267699821.111111.4936780072.166058053 3.0541
34、65289 4.1912623895.60022962211.5138531462.225492124 3.182212729 4.4306780726.0102901150.909091.5305626022.275330992 3.290961859 4.6367012556.3680301350.9278049870.817498277 0.681315139 0.5337561910.3894749033.333331.1734641541.3139717931.40214107 1.4216644411.3626131622.51.3197035661.66584903 2.0114
35、69936 2.3201934072.54870241521.4160556711.920725929 2.497736655 3.1128661083.7109667311.666671.4841676212.111957812 2.8855950323.786616094.7672253431.428571.5348157822.260101694 3.1989912264.355424045.7011792481.251.5739329742.377990075 3.456179575 4.8374314056.5198703031.111111.6050454242.473916121
36、 3.670427121 5.2489125167.23708013811.6303776112.553435647 3.851348778 5.6031589947.8672494690.909091.6514010452.620394574 4.005989232 5.9107084438.4234464350.9207628570.792281771 0.633084684 0.4649823190.3089247573.333331.2044628481.364308475 1.450200889 1.4391369831.3210242912.51.3775780591.790313
37、2822.19488286 2.5318325632.73174305721.4931722232.10736085 2.814500014 3.5533230214.2243245261.666671.5755747982.349337929 3.321960981 4.4541806665.6489651121.428571.6372035782.539010389 3.739540945 5.2343520356.9521646351.251.6850020352.691247991 4.086825712 5.9079151888.1233172541.111111.723141325
38、2.815938256 4.379084381 6.4911711489.16899189711.7542733762.9198373224.62786915 6.99896958610.101645610.909091.7801629613.007690736 4.841897593 7.44385131110.9348663350.9128335360.764459361 0.5817666720.395806060.2343531733.333331.2350755341.410985253 1.485861437 1.4300052131.237741942.51.4366285221
39、.916931131 2.374614132 2.7180986292.84452490921.5730229682.303864494 3.1460229773.995965834.6863802231.666671.6710731082.604297212 3.794965087 5.1664567986.5371639221.428571.7448289932.842592175 4.338937794 6.2070665188.2916449881.251.802274483.035516262 4.797501875 7.1228959059.9101263651.111111.84
40、82587073.194576088 5.187414392 7.92765111811.3843733811.8858894153.3278042695.52204033 8.63644227912.720174890.909091.9172473513.4409315485.81181914 9.26324902113.928883850.9040360990.73429448 0.5284069190.328500020.1688216543.333331.265234171.453460991 1.507727153 1.3930088891.1158149282.51.4967989
41、922.044889941 2.546829585 2.8685546742.86862762521.6556137482.509746595 3.488238445 4.4247493935.0550258611.666671.7707451132.87697771 4.302065481 5.9070735177.374900841.428571.8578518193.171745782 4.997210283 7.2611195729.6587844351.251.9259825013.412477341 5.591335876 8.47670360511.824892191.11111
42、1.980695733.612275532 6.101853407 9.56118831313.8402581712.02558333.780504365 6.54362978410.52785215.697185570.909092.0630651063.923957342 6.928771283 11.3910195617.4003511150.8478342920.558719727 0.266703316 0.0780195460.008807613.333331.4067781291.585240057 1.380994494 0.8388015710.2625441772.51.8
43、12103182.670210837 3.142488616 2.7503448041.43342356822.1093920813.651033887 5.146627931 5.6082051113.9689701391.666672.3342116774.497757852 7.150813954 9.0181001147.8261234091.428572.5093232635.220309089 9.044380826 12.6609380412.710636721.252.6492253045.837425199 10.7868927816.329730118.286591671.
44、111112.7634086576.367413901 12.37114763 19.9036927124.2658099912.8582886786.825845963 13.80450669 23.3183265130.428771070.909092.938335847.225371407 15.09994155 26.5435255336.6187228150.7738827560.370965959 0.084615511 0.003376467-2.93451E-073.333331.5264284931.54740991 0.894810096 0.153830233#NUM!2
45、.52.143764683.1603925622.90985483 1.038320145#NUM!22.628315524.8509011565.90412565 3.2651642190.1446827711.666673.0107712376.454709306 9.462628071 7.008431954#NUM!1.428573.3175753887.915655338 13.25371454 12.09374317#NUM!1.253.5680265899.224535717 17.06404526 18.20814284#NUM!1.111113.77582209310.390
46、43651 20.77010708 25.03113726#NUM!13.95073842411.42839425 24.30659521 32.28884617-11.429938890.909094.09986216212.35430147 27.6435615139.7667849#NUM!1/y=3/51/y=7/101/y=4/51/y=9/101/y=10.723424287 0.682051119 0.6420665680.603478760.56629291 0.762104540.8893092420.86898534 0.848199156 0.826981183 0.80
47、53631350.986013057 0.980867199 0.974892491 0.968082673 0.9604329641.049012304 1.054796959 1.059819873 1.064051231 1.0674615581.093232481 1.107153848 1.120509684 1.1332592331.145360941.125955063 1.146135345 1.1659759241.185432771.204460211.151138175 1.176269551 1.201282247 1.226133267 1.2507773961.17
48、1113804 1.200253963 1.229480204 1.258752885 1.2880297951.187343597 1.219793131 1.252514395 1.285472296 1.3186289841.200789675 1.236016081 1.271681171 1.307754956 1.3442046040.682695623 0.629623795 0.577484123 0.526608446 0.4773044891.0333316671.02469594 1.0117815940.99459152 0.9731724681.271294151 1
49、.3072298511.339245321.36685743 1.3895908991.439626509 1.512885712 1.5846164331.654132511.720700361.564056218 1.667665321 1.772692881 1.878458841 1.9841938931.65946634 1.787825662 1.920551202 2.057087067 2.1967634471.734824369 1.883594304 2.039483434 2.2021196722.371006161.795794205 1.961613877 2.137
50、055212 2.321956045 2.5160284071.846109288 2.026349953 2.2184630062.42250374 2.6384072191.888322976 2.080901732 2.2873707222.50800017 2.7429499240.618905950.54944483 0.481469424 0.416038288 0.3540925981.157202172 1.148353547 1.128019555 1.096164744 1.0530393711.582346282 1.660165477 1.726595427 1.779