《EXCEL统计分析》19.2 P-P与Q-Q图

红细胞计数 正态累积概率观察累积概率正态分位数 0.00 4.54 均数4.7266150.377668 0.423076 4.610416 3.97 标准差0.5988730.103223 0.107692 3.984674 4.85 0.581615 0.584615 4.854603 5.45 0.886459 0.884615 5.444291 5.41 0.873090 0.869230 0.951418 0.946153 5.689989 0.015841 0.015384 3.433013 4.57 0.396847 0.430769 4.622162 5.35 0.851046 0.846153 5.337509 4.08 0.140133 0.138461 4.075485 4.31 0.243319 0.238461 4.300660 0.048041 0.061538 3.803159 4805 0.030769 3.606956 4.14 0.163659 0.161538 4.134835 4.26 0.217944 0.215384 4.254776 3.48 0.018689 0.023076 3.532462 4.38 0.281369 4.39923′ 0.3402430.3461 4.489625 0.5421450.538461 4.78441 4.50 0.3525660.3615384.514404 5.31 0.835006 0.830769 5.299862 4.79 0.542145 0.538461 4.784441 5.37 0.858662 0.861538 5.377743 4.62 0.429351 4.657176 4.26 0.2179440.215384 4.254776 5.33 0.843161 0.838461 5.318393 4.37 0.275762 0.284615 4.385745 4.98 0.663890 0.638461 4.938825 5.03 0.693780 0.669230 4.988795 4.53 0.371339 0.407692 4.586787 0.384615 4.550917 4.50 352566 361538 4.514404 5.49 0.898793 0.907692 5.521126 4.66 0.455715 0.469230 4.680379 4.60 0.416279 0.446153 4.645536 4.41 0.298512 0.307692 5.85 0.969661 5920758 0.800000 5.230640 6. 988594 1.000000 4.33 0.253899 0.246153 4.315402 5.67 0.942403 0.938461 5.650067 3.77 0.055093 0.069230 3.839355 4.88 0.6010720.592307 4.866442 0.799701 0.823076 28186 0.966055 9692305.846266 4.66 0.455715 0.469230 4.680379

红细胞计数 正态累积概率 观察累积概率 正态分位数 0.00 4.54 均数 4.726615 0.377668 0.423076 4.610416 3.97 标准差 0.598873 0.103223 0.107692 3.984674 4.85 0.581615 0.584615 4.854603 5.45 0.886459 0.884615 5.444291 5.41 0.873090 0.869230 5.399005 5.72 0.951418 0.946153 5.689989 3.44 0.015841 0.015384 3.433013 4.57 0.396847 0.430769 4.622162 5.35 0.851046 0.846153 5.337509 4.08 0.140133 0.138461 4.075485 4.31 0.243319 0.238461 4.300660 3.73 0.048041 0.061538 3.803159 3.64 0.034805 0.030769 3.606956 4.14 0.163659 0.161538 4.134835 4.26 0.217944 0.215384 4.254776 3.48 0.018689 0.023076 3.532462 4.38 0.281369 0.292307 4.399237 4.48 0.340243 0.346153 4.489625 4.79 0.542145 0.538461 4.784441 4.50 0.352566 0.361538 4.514404 5.31 0.835006 0.830769 5.299862 4.79 0.542145 0.538461 4.784441 5.37 0.858662 0.861538 5.377743 4.62 0.429351 0.453846 4.657176 4.26 0.217944 0.215384 4.254776 5.33 0.843161 0.838461 5.318393 4.37 0.275762 0.284615 4.385745 4.98 0.663890 0.638461 4.938825 5.03 0.693780 0.669230 4.988795 4.53 0.371339 0.407692 4.586787 4.52 0.365045 0.384615 4.550917 4.50 0.352566 0.361538 4.514404 5.49 0.898793 0.907692 5.521126 4.66 0.455715 0.469230 4.680379 4.60 0.416279 0.446153 4.645536 4.41 0.298512 0.307692 4.425740 5.85 0.969661 0.976923 5.920758 5.21 0.790212 0.800000 5.230640 6.09 0.988594 1.000000 4.33 0.253899 0.246153 4.315402 5.67 0.942403 0.938461 5.650067 3.77 0.055093 0.069230 3.839355 4.88 0.601072 0.592307 4.866442 5.23 0.799701 0.823076 5.281861 5.82 0.966055 0.969230 5.846266 4.66 0.455715 0.469230 4.680379

4.41 0.298512 0.307692 4.425740 5.10 0.733515 0.715384 5.067484 4.49 0.346384 0.353846 4.502063 5.15 0.760207 0.746153 123328 0.076304 0.0923073932101 4.22 98791 0.1923074205939 3.83 0.067174 0.084615 3.903355 4.50 0.352566 0.361538 4.514404 4.70 0.482276 0.484615 4.703514 4.73 0.502255 0.507692 4.738163 0.365045 0.384615 4.550917 981821 984615 6.020202 3.70 0.043242 0.053846 3.763236 4.28 0.227906 0.230769 4.285655 3.22 0.005939 0.007692 3.275420 5.55 0.9154170.9153845.549872 3.984674 253899 4.315402 5.15 0.760207 0.746153 5.123328 4.98 0.663890 0.638461 4.938825 5.22 0.794989 0.815384 5.264351 5. 0.711129 0.692307 5.027489 0.0863490.100000 3.959129 4.06 0.1328290.1307694.054223 738971 0.723076 5081151 4.90 0.613908 0.607692 4.890293 4.16 0.172040 0.169230 4.153367 4.57 0.396847 0.430769 4.622162 4.79 0.542145 0.538461 0.693780 0.669230 4.988795 4.78441 4.18 0.180690 0.184615 4.188877 5.80 0.963461 0.961538 5.785914 4.99 0.669959 0.653846 4.963604 4.75 0.515574 0.523076 4.761275 5.19 0.780464 0.769230 5.167574 5.21 0.7902120.800000 5.230640 259278 269230 4.358223 4.17 0.176331 0.176923 4.171367 5.35 0.851046 0.846153 5.337509 4.01 0.115730 0.123076 4.032074 3.81 0.062938 0.076923 3.872576 0.744369 0.738461 5.109060 0.722432 5.053992 0.982554 0.992307 6.177783 5.55 0.915417 0.915384 5.549872 5.47 0.892754 0.892307 5.468554 4.78 0.535515 0.530769 4.772850

4.41 0.298512 0.307692 4.425740 5.10 0.733515 0.715384 5.067484 4.49 0.346384 0.353846 4.502063 5.15 0.760207 0.746153 5.123328 3.87 0.076304 0.092307 3.932101 4.22 0.198791 0.192307 4.205939 3.83 0.067174 0.084615 3.903355 4.50 0.352566 0.361538 4.514404 4.70 0.482276 0.484615 4.703514 4.73 0.502255 0.507692 4.738163 4.52 0.365045 0.384615 4.550917 5.98 0.981821 0.984615 6.020202 3.70 0.043242 0.053846 3.763236 4.28 0.227906 0.230769 4.285655 3.22 0.005939 0.007692 3.275420 5.55 0.915417 0.915384 5.549872 3.97 0.103223 0.107692 3.984674 4.33 0.253899 0.246153 4.315402 5.15 0.760207 0.746153 5.123328 4.98 0.663890 0.638461 4.938825 5.22 0.794989 0.815384 5.264351 5.06 0.711129 0.692307 5.027489 3.91 0.086349 0.100000 3.959129 4.06 0.132829 0.130769 4.054223 5.11 0.738971 0.723076 5.081151 4.90 0.613908 0.607692 4.890293 4.16 0.172040 0.169230 4.153367 4.57 0.396847 0.430769 4.622162 4.79 0.542145 0.538461 4.784441 5.03 0.693780 0.669230 4.988795 4.79 0.542145 0.538461 4.784441 4.18 0.180690 0.184615 4.188877 5.80 0.963461 0.961538 5.785914 4.99 0.669959 0.653846 4.963604 4.75 0.515574 0.523076 4.761275 5.19 0.780464 0.769230 5.167574 5.21 0.790212 0.800000 5.230640 4.34 0.259278 0.269230 4.358223 4.17 0.176331 0.176923 4.171367 5.35 0.851046 0.846153 5.337509 4.01 0.115730 0.123076 4.032074 3.81 0.062938 0.076923 3.872576 5.12 0.744369 0.738461 5.109060 5.08 0.722432 0.707692 5.053992 5.99 0.982554 0.992307 6.177783 5.55 0.915417 0.915384 5.549872 5.47 0.892754 0.892307 5.468554 4.78 0.535515 0.530769 4.772850

4.71 0.488933 0.500000 4.726615 4.97 0.657777 0.615384 4.902313 4.70 0.482276 0.484615 4.703514 4.10 0.147706 0.146153 4.095956 0.040263 0.038461 3.667310 5.19 80464 0.769230 5.167574 4.97 0.657777 0.615384 4.902313 5.07 0.716808 0.700000 5.040665 4.83 0.568530 0.576923 4.842813 4.11 0.151593 0.153846 115719 0.879905 421153 4.53 3713390.407692 4.586787 4.22 0.198791 0.192307 4.205939 4.23 0.203482 0.207692 4.238860 4.46 0.328089 0.338461 4.477085 4.45 0.322079 0.330769 4464434 4.41 0.298512 4.425740 85370 784615 5.198452 4.79 0.542145 0.538461 4.784441 4.36 0.270211 0.276923 4.372078 5.47 0.892754 0.892307 5.468554 3.69 0.041731 0.046153 3.71849 4.99 0.669959 0.653846 4.64 0.442501 0.461538 4.668788 0.502255 0.50769 4.738163 4.33 0.253899 0.246153 4.315402 4.40 0.292745 0.300000 4.412566 5.20 0.785370 0.784615 5.198452 5.18 0.775494 0.761538 5.152569 4.97 0.657777 0.615384 4.902313 38971 723076 5081151 0.940451 0.930769 5.613871 4.89 0.607504 0.600000 4.878338 5.05 0.705398 0.684615 5.014460 0.960707 0.953846 5.734726 4.52 0.365045 0.384615 4.550917

4.71 0.488933 0.500000 4.726615 4.97 0.657777 0.615384 4.902313 4.70 0.482276 0.484615 4.703514 4.10 0.147706 0.146153 4.095956 3.68 0.040263 0.038461 3.667310 5.19 0.780464 0.769230 5.167574 4.97 0.657777 0.615384 4.902313 5.07 0.716808 0.700000 5.040665 4.83 0.568530 0.576923 4.842813 4.11 0.151593 0.153846 4.115719 5.43 0.879905 0.876923 5.421153 4.53 0.371339 0.407692 4.586787 4.22 0.198791 0.192307 4.205939 4.23 0.203482 0.207692 4.238860 4.46 0.328089 0.338461 4.477085 4.45 0.322079 0.330769 4.464434 4.41 0.298512 0.307692 4.425740 5.20 0.785370 0.784615 5.198452 4.79 0.542145 0.538461 4.784441 4.36 0.270211 0.276923 4.372078 5.47 0.892754 0.892307 5.468554 3.69 0.041731 0.046153 3.718498 4.99 0.669959 0.653846 4.963604 4.64 0.442501 0.461538 4.668788 4.73 0.502255 0.507692 4.738163 4.33 0.253899 0.246153 4.315402 4.40 0.292745 0.300000 4.412566 5.20 0.785370 0.784615 5.198452 5.18 0.775494 0.761538 5.152569 4.97 0.657777 0.615384 4.902313 5.11 0.738971 0.723076 5.081151 5.66 0.940451 0.930769 5.613871 4.89 0.607504 0.600000 4.878338 5.05 0.705398 0.684615 5.014460 5.78 0.960707 0.953846 5.734726 4.52 0.365045 0.384615 4.550917

1.0 6.5 6.0F 0.8 0.6 5.0 均0.4 4.5 4.0 0.0 3.0 0.00.20.40.60.81.0 3.03.54.04.55. 观察累积概率 观察值

0