当前位置:高等教育资讯网  >  中国高校课件下载中心  >  大学文库  >  浏览文档

《EXCEL统计分析》统计用表与Excel计算公式

资源类别:文库,文档格式:XLS,文档页数:23,文件大小:84KB,团购合买
一、标准正态曲线下的面积
点击下载完整版文档(XLS)

标准正态曲线下的面积 ( 4.000.0000 -3.990.0000 3.980.0000 -3.970.0000 3.960.0000 3.950.0000 3.940.0000 3.930.0000 -3.920.0000 0.0000 3.900.0000 3.890.0001 -3.880.0001 3.870.0001 3.860.0001 3.850.0001 3.840.0001 3.830.0001 3.820.0001 -3.810.0001 3.800.0001 3.790.0001 -3.780.0001 3.770.0001 3.760.0001 3.750.0001 3.740.0001 3.730.0001 3.720.0001 3.710.0001 -3.700.0001 3.690.0001 -3.680.0001 3.670.0001 3.660.0001 -3.650.0001 3.640.0001 0.0001 3.620.0001 3.610.0002 3.600.0002 3.590.0002 3.580.0002 3.570.0002 3.560.0002 3.550.0002

标准正态曲线下的面积 z F(z) -4.00 0.0000 -3.99 0.0000 -3.98 0.0000 -3.97 0.0000 -3.96 0.0000 -3.95 0.0000 -3.94 0.0000 -3.93 0.0000 -3.92 0.0000 -3.91 0.0000 -3.90 0.0000 -3.89 0.0001 -3.88 0.0001 -3.87 0.0001 -3.86 0.0001 -3.85 0.0001 -3.84 0.0001 -3.83 0.0001 -3.82 0.0001 -3.81 0.0001 -3.80 0.0001 -3.79 0.0001 -3.78 0.0001 -3.77 0.0001 -3.76 0.0001 -3.75 0.0001 -3.74 0.0001 -3.73 0.0001 -3.72 0.0001 -3.71 0.0001 -3.70 0.0001 -3.69 0.0001 -3.68 0.0001 -3.67 0.0001 -3.66 0.0001 -3.65 0.0001 -3.64 0.0001 -3.63 0.0001 -3.62 0.0001 -3.61 0.0002 -3.60 0.0002 -3.59 0.0002 -3.58 0.0002 -3.57 0.0002 -3.56 0.0002 -3.55 0.0002

3.540.0002 -3.530.0002 3.520.0002 3.510.0002 3.500.0002 3.490.0002 3.480.0003 3.470.0003 -3.460.0003 3.450.000 3.440.0003 0.0003 -3.420.0003 3.410.0003 3.400.0003 -3.390.0003 -3.370.0004 3.360.0004 -3.350.0004 3.340.0004 3.330.0004 -3.320.0005 3.300.0005 -3.290.0005 3.280.0005 3.270.0005 3.260.0006 3.250.0006 3.240.0006 3.230.0006 -3.220.0006 3.210.0007 3.200.0007 -3.190.0007 -3.170.0008 3.160.0008 3.150.0008 3.140.0008 3.130.0009 120.0009 3.100.0010 -3.090.0010 3.080.0010 3.070.0011

-3.54 0.0002 -3.53 0.0002 -3.52 0.0002 -3.51 0.0002 -3.50 0.0002 -3.49 0.0002 -3.48 0.0003 -3.47 0.0003 -3.46 0.0003 -3.45 0.0003 -3.44 0.0003 -3.43 0.0003 -3.42 0.0003 -3.41 0.0003 -3.40 0.0003 -3.39 0.0003 -3.38 0.0004 -3.37 0.0004 -3.36 0.0004 -3.35 0.0004 -3.34 0.0004 -3.33 0.0004 -3.32 0.0005 -3.31 0.0005 -3.30 0.0005 -3.29 0.0005 -3.28 0.0005 -3.27 0.0005 -3.26 0.0006 -3.25 0.0006 -3.24 0.0006 -3.23 0.0006 -3.22 0.0006 -3.21 0.0007 -3.20 0.0007 -3.19 0.0007 -3.18 0.0007 -3.17 0.0008 -3.16 0.0008 -3.15 0.0008 -3.14 0.0008 -3.13 0.0009 -3.12 0.0009 -3.11 0.0009 -3.10 0.0010 -3.09 0.0010 -3.08 0.0010 -3.07 0.0011

3.060.0011 -3.050.0011 3.040.0012 0.0012 3.020.0013 3.010.0013 3.000.0013 2.990.0014 2.980.0014 2.970.0015 2.960.0015 2.950.0016 0.0016 2.930.0017 2.920.0018 2.910.0018 2.900.0019 -2.890.0019 2.880.0020 2.870.0021 0.0021 2.850.0022 2.840.0023 2.830.0023 -2.820.0024 2.810.0025 -2.790.0026 2.780.0027 2.770.0028 2.760.0029 0.0030 2.740.0031 2.730.0032 -2.720.0033 2.710.0034 2.700.0035 -2.690.0036 2.680.0037 2.670.0038 2.660.0039 2.650.0040 2.640.0041 2.630.0043 -2.620.0044 2.610.0045 2.600.0047 2.590.0048

-3.06 0.0011 -3.05 0.0011 -3.04 0.0012 -3.03 0.0012 -3.02 0.0013 -3.01 0.0013 -3.00 0.0013 -2.99 0.0014 -2.98 0.0014 -2.97 0.0015 -2.96 0.0015 -2.95 0.0016 -2.94 0.0016 -2.93 0.0017 -2.92 0.0018 -2.91 0.0018 -2.90 0.0019 -2.89 0.0019 -2.88 0.0020 -2.87 0.0021 -2.86 0.0021 -2.85 0.0022 -2.84 0.0023 -2.83 0.0023 -2.82 0.0024 -2.81 0.0025 -2.80 0.0026 -2.79 0.0026 -2.78 0.0027 -2.77 0.0028 -2.76 0.0029 -2.75 0.0030 -2.74 0.0031 -2.73 0.0032 -2.72 0.0033 -2.71 0.0034 -2.70 0.0035 -2.69 0.0036 -2.68 0.0037 -2.67 0.0038 -2.66 0.0039 -2.65 0.0040 -2.64 0.0041 -2.63 0.0043 -2.62 0.0044 -2.61 0.0045 -2.60 0.0047 -2.59 0.0048

2.580.0049 2.570.0051 2.560.0052 2.550.0054 2.540. 2.530.0057 2.520.0059 2.510.0060 2.500.0062 2.490.0064 2.480.0066 2.460.0069 2.450.0071 2.440.0073 -2.430.0075 2.420.0078 2.410.0080 2.400.0082 2.390.0084 2.380.0087 2.370.0089 -2.360.0091 2.350.0094 2.340.0096 -2.330.0099 2.320.0102 2.310.0104 2.300.0107 2.290.0110 2.280.0113 2.270.0116 2.260.0119 2.250.0122 2.240.0125 -2.230.0129 2.210.0136 2.200.0139 2.190.0143 2.180.0146 2.170.0150 -2.160.0154 2.140.0162 2.130.0166 2.120.0170 2.110.0174

-2.58 0.0049 -2.57 0.0051 -2.56 0.0052 -2.55 0.0054 -2.54 0.0055 -2.53 0.0057 -2.52 0.0059 -2.51 0.0060 -2.50 0.0062 -2.49 0.0064 -2.48 0.0066 -2.47 0.0068 -2.46 0.0069 -2.45 0.0071 -2.44 0.0073 -2.43 0.0075 -2.42 0.0078 -2.41 0.0080 -2.40 0.0082 -2.39 0.0084 -2.38 0.0087 -2.37 0.0089 -2.36 0.0091 -2.35 0.0094 -2.34 0.0096 -2.33 0.0099 -2.32 0.0102 -2.31 0.0104 -2.30 0.0107 -2.29 0.0110 -2.28 0.0113 -2.27 0.0116 -2.26 0.0119 -2.25 0.0122 -2.24 0.0125 -2.23 0.0129 -2.22 0.0132 -2.21 0.0136 -2.20 0.0139 -2.19 0.0143 -2.18 0.0146 -2.17 0.0150 -2.16 0.0154 -2.15 0.0158 -2.14 0.0162 -2.13 0.0166 -2.12 0.0170 -2.11 0.0174

2.100.0179 2.090.0183 2.080.0188 -2.070.0192 2.060.0197 2.040.0207 2.030.0212 2.020.0217 2.010.0222 2.000.0228 1.990.0233 1.980.0239 1.970.0244 1.960.0250 1.950.0256 1.940.0262 930.0268 1.920.0274 1.910.0281 1.900.0287 1.890.0294 1.880.0301 1.870.0307 1.860.0314 1.850.0322 1.840.0329 -1.830.0336 1.820.0344 1.800.0359 1.790.0367 1.780.0375 1.770.0384 1.760.0392 -1.750.0401 1.740.0409 1.730.0418 1.720.0427 1.710.0436 1.700.0446 1.690.0455 1.680.0465 1.660.0485 1.650.0495 1.640.0505 1630.0516

-2.10 0.0179 -2.09 0.0183 -2.08 0.0188 -2.07 0.0192 -2.06 0.0197 -2.05 0.0202 -2.04 0.0207 -2.03 0.0212 -2.02 0.0217 -2.01 0.0222 -2.00 0.0228 -1.99 0.0233 -1.98 0.0239 -1.97 0.0244 -1.96 0.0250 -1.95 0.0256 -1.94 0.0262 -1.93 0.0268 -1.92 0.0274 -1.91 0.0281 -1.90 0.0287 -1.89 0.0294 -1.88 0.0301 -1.87 0.0307 -1.86 0.0314 -1.85 0.0322 -1.84 0.0329 -1.83 0.0336 -1.82 0.0344 -1.81 0.0351 -1.80 0.0359 -1.79 0.0367 -1.78 0.0375 -1.77 0.0384 -1.76 0.0392 -1.75 0.0401 -1.74 0.0409 -1.73 0.0418 -1.72 0.0427 -1.71 0.0436 -1.70 0.0446 -1.69 0.0455 -1.68 0.0465 -1.67 0.0475 -1.66 0.0485 -1.65 0.0495 -1.64 0.0505 -1.63 0.0516

-1.620.0526 1.610.0537 1.600.0548 1.590.0559 1.580.0571 1.570.0582 1.560.0594 1.550.0606 1.540.0618 1.530.0630 -1.520.0643 1.510.0655 1.500.0668 -1.490.0681 1.480.0694 -1.470.0708 1.460.0721 1.450.0735 1.440.0749 1.430.0764 1.420.0778 1.410.0793 -1.400.0808 1.380.0838 1.370.0853 1.360.0869 1.350.0885 1.340.0901 0.0934 1.310.0951 1.300.0968 1.290.0985 1.280.1003 -1.270.1020 1.250.1056 1.240.1075 1.230.1093 1.220.1112 1.210.1131 -1.200.1151 1.180.1190 1.170.1210 1.160.1230 1.150.1251

-1.62 0.0526 -1.61 0.0537 -1.60 0.0548 -1.59 0.0559 -1.58 0.0571 -1.57 0.0582 -1.56 0.0594 -1.55 0.0606 -1.54 0.0618 -1.53 0.0630 -1.52 0.0643 -1.51 0.0655 -1.50 0.0668 -1.49 0.0681 -1.48 0.0694 -1.47 0.0708 -1.46 0.0721 -1.45 0.0735 -1.44 0.0749 -1.43 0.0764 -1.42 0.0778 -1.41 0.0793 -1.40 0.0808 -1.39 0.0823 -1.38 0.0838 -1.37 0.0853 -1.36 0.0869 -1.35 0.0885 -1.34 0.0901 -1.33 0.0918 -1.32 0.0934 -1.31 0.0951 -1.30 0.0968 -1.29 0.0985 -1.28 0.1003 -1.27 0.1020 -1.26 0.1038 -1.25 0.1056 -1.24 0.1075 -1.23 0.1093 -1.22 0.1112 -1.21 0.1131 -1.20 0.1151 -1.19 0.1170 -1.18 0.1190 -1.17 0.1210 -1.16 0.1230 -1.15 0.1251

1.140.1271 1.130.1292 1.120.1314 1.110.1335 1.100.1357 1.090.1379 1.080.1401 1.070.1423 1.060.1446 1.050.1469 0.1492 1.030.1515 1.020.1539 -1.010.1562 1.000.1587 0.990.1611 -0.970.1660 -0.960.1685 0.950.1711 -0.940.1736 -0.930.1762 0.920.1788 -0.900.184 0.890.1867 0.880.1894 0.870.1922 0.860.1949 0.850.1977 -0.840.2005 -0.830.2033 -0.820.2061 0.810.2090 -0.800.2119 0.790.2148 0.780.2177 0.770.2206 -0.760.2236 0.750.2266 -0.740.2296 0.730 0.720. -0.700.2420 -0.690.2451 0.680.2483 -0.670.2514

-1.14 0.1271 -1.13 0.1292 -1.12 0.1314 -1.11 0.1335 -1.10 0.1357 -1.09 0.1379 -1.08 0.1401 -1.07 0.1423 -1.06 0.1446 -1.05 0.1469 -1.04 0.1492 -1.03 0.1515 -1.02 0.1539 -1.01 0.1562 -1.00 0.1587 -0.99 0.1611 -0.98 0.1635 -0.97 0.1660 -0.96 0.1685 -0.95 0.1711 -0.94 0.1736 -0.93 0.1762 -0.92 0.1788 -0.91 0.1814 -0.90 0.1841 -0.89 0.1867 -0.88 0.1894 -0.87 0.1922 -0.86 0.1949 -0.85 0.1977 -0.84 0.2005 -0.83 0.2033 -0.82 0.2061 -0.81 0.2090 -0.80 0.2119 -0.79 0.2148 -0.78 0.2177 -0.77 0.2206 -0.76 0.2236 -0.75 0.2266 -0.74 0.2296 -0.73 0.2327 -0.72 0.2358 -0.71 0.2389 -0.70 0.2420 -0.69 0.2451 -0.68 0.2483 -0.67 0.2514

0.660.2546 -0.650.2578 0.640.2611 0.630.2643 620.2676 -0.610.2709 0.600.2743 -0.590.2776 -0.580.2810 0.570.2843 560.2877 912 0.540.2946 -0.530.2981 -0.520.3015 0.510.3050 -0.490.3121 -0.480.3156 0.470.3192 0.460.3228 0.450.3264 0.440.3300 -0.420.3372 -0.410.3409 0.400.3446 0.390.3483 0.380.3520 360.3594 -0.350.3632 0.340.3669 0.330.3707 0.320.3745 0.310.3783 -0.280.3897 0.270.3936 -0.260.3974 -0.250.4013 0.240.4052 -0.220.4129 0.210.4168 0.200.4207 -0.190.4247

-0.66 0.2546 -0.65 0.2578 -0.64 0.2611 -0.63 0.2643 -0.62 0.2676 -0.61 0.2709 -0.60 0.2743 -0.59 0.2776 -0.58 0.2810 -0.57 0.2843 -0.56 0.2877 -0.55 0.2912 -0.54 0.2946 -0.53 0.2981 -0.52 0.3015 -0.51 0.3050 -0.50 0.3085 -0.49 0.3121 -0.48 0.3156 -0.47 0.3192 -0.46 0.3228 -0.45 0.3264 -0.44 0.3300 -0.43 0.3336 -0.42 0.3372 -0.41 0.3409 -0.40 0.3446 -0.39 0.3483 -0.38 0.3520 -0.37 0.3557 -0.36 0.3594 -0.35 0.3632 -0.34 0.3669 -0.33 0.3707 -0.32 0.3745 -0.31 0.3783 -0.30 0.3821 -0.29 0.3859 -0.28 0.3897 -0.27 0.3936 -0.26 0.3974 -0.25 0.4013 -0.24 0.4052 -0.23 0.4090 -0.22 0.4129 -0.21 0.4168 -0.20 0.4207 -0.19 0.4247

0.180.4286 -0.170.4325 0.160.4364 0.150.4404 0.140.4443 -0.130.4483 0.120.4522 -0.110.4562 -0.100.4602 0.090.4641 0.080.4681 -0.070.4721 0.060.4761 -0.050.4801 -0.040.4840 0.030.4880 020.4920 -0.010.4960 0.000.5000 0.010.5040 0.020.5080 0.030.5120 0.040.5160 0.070.5279 0.080.5319 0.090.5359 0.100.5398 0.11 138 120.5478 0.130.5517 0.140.5557 0.150.5596 0.160.5636 0.170.5675 0.180.5714 0.190.5753 0.200.5793 0.210.5832 0.220.5871 0.230.5910 0.240.5948 0.250.5987 0.260.6026 0.270.6064 0.280.6103 0.290.6141

-0.18 0.4286 -0.17 0.4325 -0.16 0.4364 -0.15 0.4404 -0.14 0.4443 -0.13 0.4483 -0.12 0.4522 -0.11 0.4562 -0.10 0.4602 -0.09 0.4641 -0.08 0.4681 -0.07 0.4721 -0.06 0.4761 -0.05 0.4801 -0.04 0.4840 -0.03 0.4880 -0.02 0.4920 -0.01 0.4960 0.00 0.5000 0.01 0.5040 0.02 0.5080 0.03 0.5120 0.04 0.5160 0.05 0.5199 0.06 0.5239 0.07 0.5279 0.08 0.5319 0.09 0.5359 0.10 0.5398 0.11 0.5438 0.12 0.5478 0.13 0.5517 0.14 0.5557 0.15 0.5596 0.16 0.5636 0.17 0.5675 0.18 0.5714 0.19 0.5753 0.20 0.5793 0.21 0.5832 0.22 0.5871 0.23 0.5910 0.24 0.5948 0.25 0.5987 0.26 0.6026 0.27 0.6064 0.28 0.6103 0.29 0.6141

0.300.6179 0.310.6217 0.320.6255 0.330.6293 0.340.6331 0.350.6368 0.360.6406 0.370.6443 0.380.6480 0.390.6517 0.400.6554 10.6591 0.420.6628 0.430.6664 0.440.6700 0.450.6736 0.460.6772 470.6808 0.480.6844 0.490.6879 0.500.6915 0.510.6950 0.520.6985 0.7019 540.7054 0.550.7088 0.560.7123 0.570.7157 0.580.7190 0.590.7224 0.7257 0.610.7291 0.620.7324 0.630.7357 0.640.7389 0.650.7422 0.660.7454 670.7486 0.680.7517 0.690.7549 0.700.7580 0.710.7611 0.720.7642 0.730.7673 0.740.7704 0.750.7734 0.760.7764 0.770.7794

0.30 0.6179 0.31 0.6217 0.32 0.6255 0.33 0.6293 0.34 0.6331 0.35 0.6368 0.36 0.6406 0.37 0.6443 0.38 0.6480 0.39 0.6517 0.40 0.6554 0.41 0.6591 0.42 0.6628 0.43 0.6664 0.44 0.6700 0.45 0.6736 0.46 0.6772 0.47 0.6808 0.48 0.6844 0.49 0.6879 0.50 0.6915 0.51 0.6950 0.52 0.6985 0.53 0.7019 0.54 0.7054 0.55 0.7088 0.56 0.7123 0.57 0.7157 0.58 0.7190 0.59 0.7224 0.60 0.7257 0.61 0.7291 0.62 0.7324 0.63 0.7357 0.64 0.7389 0.65 0.7422 0.66 0.7454 0.67 0.7486 0.68 0.7517 0.69 0.7549 0.70 0.7580 0.71 0.7611 0.72 0.7642 0.73 0.7673 0.74 0.7704 0.75 0.7734 0.76 0.7764 0.77 0.7794

点击下载完整版文档(XLS)VIP每日下载上限内不扣除下载券和下载次数;
按次数下载不扣除下载券;
24小时内重复下载只扣除一次;
顺序:VIP每日次数-->可用次数-->下载券;
共23页,试读已结束,阅读完整版请下载
相关文档

关于我们|帮助中心|下载说明|相关软件|意见反馈|联系我们

Copyright © 2008-现在 cucdc.com 高等教育资讯网 版权所有