Следовательно наше уравнение будет выглядеть следующим образом:
ВАШБП= 42.1283 – 0.1015 Hb + 0.2908 СОЭ + 0.0326 СРБ +0.7105 Фибриноген
R2=0.1569 - 15.69% от исходной изменчивости могут быть объяснены. а 84.31% остаточной изменчивости остаются необъясненными.
F=8.2341
p= 0
F>p следовательно полученному уравнению можно верить с вероятностью в 99%
Далее произведем анализ остатков и исключим из выборки экстремальные наблюдения. а затем заново рассчитаем уравнение множественной регрессии.
После вычислений получаем новые переменные и новое уравнение:
| b | bint | r | rint | ||
| 68.6128 | 42.6275 | 94.5981 | -9.0527 | -37.3058 | 19.2004 |
| -0.3179 | -0.4996 | -0.1362 | 12.6863 | -14.9838 | 40.3564 |
| 0.2660 | 0.0000 | 0.5319 | 4.7180 | -23.6375 | 33.0735 |
| 0.0363 | 0.0073 | 0.0653 | -7.8665 | -35.8002 | 20.0673 |
| 0.5753 | -1.9305 | 3.0812 | 8.4230 | -19.8230 | 36.6691 |
| -3.9845 | -32.2508 | 24.2819 | |||
| 6.5985 | -21.2655 | 34.4624 | |||
| 9.6122 | -18.6033 | 37.8276 | |||
| -10.2044 | -35.0328 | 14.6240 | |||
| 2.7871 | -24.8193 | 30.3934 | |||
| 17.2257 | -10.7195 | 45.1709 | |||
| 5.4367 | -22.5254 | 33.3988 | |||
| 9.2325 | -19.0964 | 37.5614 | |||
| -7.7024 | -35.9560 | 20.5512 | |||
| -1.2661 | -28.9378 | 26.4056 | |||
| 14.4948 | -13.4018 | 42.3914 | |||
| 7.5633 | -20.5114 | 35.6379 | |||
| -17.4951 | -44.6647 | 9.6746 | |||
| 17.8317 | -9.9962 | 45.6596 | |||
| 5.8425 | -22.4781 | 34.1631 | |||
| 9.3237 | -18.9007 | 37.5480 | |||
| 3.3445 | -24.6908 | 31.3798 | |||
| -0.8088 | -21.5731 | 19.9554 | |||
| 8.6299 | -18.5165 | 35.7762 | |||
| 9.9962 | -18.2684 | 38.2609 | |||
| -6.5170 | -34.7503 | 21.7163 | |||
| 17.5223 | -10.5451 | 45.5896 | |||
| -2.6598 | -31.0639 | 25.7443 | |||
| -4.7289 | -32.6182 | 23.1603 | |||
| 1.1007 | -27.2539 | 29.4553 | |||
| -15.4184 | -42.9371 | 12.1002 | |||
| 1.9826 | -26.2594 | 30.2246 | |||
| 14.9612 | -12.9779 | 42.9002 | |||
| 0.3910 | -27.7965 | 28.5784 | |||
| -11.5190 | -38.0908 | 15.0528 | |||
| 4.1080 | -23.9282 | 32.1441 | |||
| -2.3669 | -30.6874 | 25.9536 | |||
| 5.7176 | -16.0196 | 27.4548 | |||
| -11.7715 | -40.0204 | 16.4775 | |||
| -11.6867 | -39.7871 | 16.4137 | |||
| -11.2514 | -38.7594 | 16.2566 | |||
| 14.1006 | -14.0387 | 42.2399 | |||
| -7.9019 | -36.2419 | 20.4382 | |||
| 18.4706 | -9.5140 | 46.4553 | |||
| -13.1757 | -41.2401 | 14.8888 | |||
| -5.9183 | -34.1797 | 22.3430 | |||
| 1.5930 | -26.5748 | 29.7608 | |||
| -6.1504 | -34.3885 | 22.0877 | |||
| -11.9710 | -40.0136 | 16.0715 | |||
| 4.7517 | -23.5772 | 33.0805 | |||
| -7.6354 | -35.6957 | 20.4249 | |||
| -2.5114 | -30.1466 | 25.1238 | |||
| -17.8750 | -45.7099 | 9.9598 | |||
| 4.9776 | -22.4033 | 32.3584 | |||
| -9.2707 | -37.5638 | 19.0224 | |||
| -15.6411 | -43.5795 | 12.2973 | |||
| -2.0349 | -30.2891 | 26.2193 | |||
| -7.5352 | -35.9057 | 20.8354 | |||
| -12.8750 | -40.8787 | 15.1286 | |||
| -9.0399 | -37.2915 | 19.2118 | |||
| -14.1604 | -41.7111 | 13.3903 | |||
| 13.3652 | -14.6783 | 41.4087 | |||
| -17.2193 | -45.0403 | 10.6016 | |||
| 19.0244 | -8.6055 | 46.6542 | |||
| -11.5693 | -39.3592 | 16.2207 | |||
| -19.6532 | -47.3414 | 8.0351 | |||
| -0.6843 | -28.9330 | 27.5644 | |||
| 4.5464 | -23.3429 | 32.4356 | |||
| 16.7275 | -10.8084 | 44.2634 | |||
| 10.5922 | -17.7215 | 38.9060 | |||
| -14.8775 | -42.1330 | 12.3780 | |||
| 6.5270 | -21.7825 | 34.8365 | |||
| 2.7666 | -25.1568 | 30.6900 | |||
| 8.5476 | -18.2907 | 35.3860 | |||
| -13.1649 | -41.3581 | 15.0284 | |||
| -1.8218 | -29.9553 | 26.3117 | |||
| -6.6755 | -34.9033 | 21.5523 | |||
| -9.8041 | -38.0180 | 18.4097 | |||
| 4.9947 | -23.1450 | 33.1345 | |||
| -12.3110 | -40.5921 | 15.9700 | |||
| 12.6185 | -15.6296 | 40.8666 | |||
| 0.0386 | -27.2984 | 27.3755 | |||
| 6.3388 | -21.8537 | 34.5312 | |||
| -10.6292 | -38.7183 | 17.4599 | |||
| -13.4573 | -41.1993 | 14.2847 | |||
| 14.4516 | -13.5325 | 42.4357 | |||
| 4.6315 | -23.6516 | 32.9145 | |||
| 14.3512 | -12.5735 | 41.2759 | |||
| 12.0414 | -16.1382 | 40.2210 | |||
| 0.5380 | -27.7541 | 28.8300 | |||
| 20.0878 | -7.0899 | 47.2654 | |||
| 19.1331 | -8.6111 | 46.8774 | |||
| 8.7274 | -19.4685 | 36.9234 | |||
| 5.4167 | -22.8281 | 33.6615 | |||
| 0.3107 | -27.8741 | 28.4954 | |||
| 3.1306 | -24.9738 | 31.2350 | |||
| -8.6352 | -36.9898 | 19.7193 | |||
| -2.6414 | -30.7999 | 25.5171 | |||
| -2.4350 | -30.6568 | 25.7869 | |||
| -14.3378 | -42.3473 | 13.6717 | |||
| -1.8313 | -30.1660 | 26.5034 | |||
| 18.7274 | -9.1685 | 46.6234 | |||
| 14.9255 | -13.1336 | 42.9846 | |||
| -11.4913 | -39.6756 | 16.6930 | |||
| -4.2104 | -32.0433 | 23.6225 | |||
| -18.6544 | -45.9305 | 8.6218 | |||
| 15.6565 | -12.4643 | 43.7773 | |||
| 1.5669 | -26.8071 | 29.9410 | |||
| -11.1319 | -39.3470 | 17.0832 | |||
| -7.9681 | -35.8440 | 19.9077 | |||
| 3.3454 | -24.8477 | 31.5384 | |||
| -6.2493 | -33.6830 | 21.1844 | |||
| 14.9947 | -12.9265 | 42.9160 | |||
| -8.0405 | -36.2726 | 20.1915 | |||
| 16.5496 | -10.9807 | 44.0799 | |||
| -4.8517 | -32.7475 | 23.0440 | |||
| -9.6016 | -37.5465 | 18.3433 | |||
| -14.1529 | -41.6157 | 13.3098 | |||
stats = 0.5231; 30.9919; 0; 118.0091;
ВАШБП= 68.6128 – 0.3179 Hb + 0.2660 СОЭ + 0.0363 СРБ +0.5753 Фибриноген
R2=0.5231 - 52.31% от исходной изменчивости могут быть объяснены. а 47.69% остаточной изменчивости остаются необъясненными.
F=30.9919
p= 0
F>p следовательно полученному уравнению можно верить.
Исключая и далее экстремальные наблюдения. возможно построить уравнение объясняющее еще больший процент изменчивости переменной Y (ВАШБП).
Построенное уравнение показывает что наилучшим предсказывающим фактором (предиктором) для ВАШБП является Фибриноген.
II) рассчитаем уравнение множественной линейной регрессии для ВАШСП
После выполнения расчетов для ВАШСП получаем:
| b | bint | r | rint | |||
| 34.4446 | -5.3696 | 74.2588 | -22.0047 | -73.0438 | 29.0343 | |
| -0.0248 | -0.3063 | 0.2567 | 9.4034 | -41.7566 | 60.5635 | |
| 0.4860 | 0.0556 | 0.9164 | 11.0867 | -39.4013 | 61.5746 | |
| 0.0269 | -0.0230 | 0.0768 | -18.9427 | -68.5986 | 30.7132 | |
| 0.6296 | -3.0822 | 4.3415 | -2.8132 | -54.0347 | 48.4083 | |
| 36.8501 | -13.8945 | 87.5948 | ||||
| -28.5283 | -79.0411 | 21.9845 | ||||
| -7.5443 | -58.6841 | 43.5956 | ||||
| 32.6494 | -18.1678 | 83.4666 | ||||
| -9.1522 | -60.2423 | 41.9378 | ||||
| 30.8460 | -19.4622 | 81.1541 | ||||
| 27.5125 | -22.9630 | 77.9879 | ||||
| -6.6522 | -57.7655 | 44.4612 | ||||
| 32.0518 | -18.6502 | 82.7538 | ||||
| -22.7943 | -70.0647 | 24.4762 | ||||
| -14.5034 | -64.4720 | 35.4653 | ||||
| -1.6638 | -52.7402 | 49.4126 | ||||
| 7.6126 | -43.4318 | 58.6569 | ||||
| -15.1416 | -65.8714 | 35.5883 | ||||
| -20.8158 | -71.3764 | 29.7448 | ||||
| 12.0866 | -39.1543 | 63.3276 | ||||
| 40.4712 | -10.1110 | 91.0534 | ||||
| 13.5493 | -37.5432 | 64.6418 | ||||
| -12.5814 | -62.9502 | 37.7874 | ||||
| 31.2113 | -19.5904 | 82.0130 | ||||
| 3.8039 | -47.0594 | 54.6671 | ||||
| 16.1928 | -34.6959 | 67.0816 | ||||
| -6.6698 | -56.6177 | 43.2782 | ||||
| 7.4368 | -43.2022 | 58.0757 | ||||
| 21.2822 | -29.5356 | 72.1001 | ||||
| 19.1169 | -32.0283 | 70.2620 | ||||
| 2.5209 | -48.7140 | 53.7558 | ||||
| -1.4753 | -52.6685 | 49.7179 | ||||
| -8.3178 | -59.3686 | 42.7330 | ||||
| 20.6240 | -30.3657 | 71.6137 | ||||
| 11.7056 | -39.0037 | 62.4150 | ||||
| 2.6396 | -36.0613 | 41.3405 | ||||
| 12.9805 | -36.6568 | 62.6177 | ||||
| 31.1705 | -19.3079 | 81.6490 | ||||
| 11.0245 | -40.1560 | 62.2050 | ||||
| 27.6597 | -22.9260 | 78.2454 | ||||
| -10.3585 | -61.4439 | 40.7269 | ||||
| 6.4906 | -44.7533 | 57.7345 | ||||
| 10.9088 | -40.3295 | 62.1471 | ||||
| -6.3570 | -57.4778 | 44.7639 | ||||
| 27.4574 | -23.0693 | 77.9842 | ||||
| -17.5149 | -68.1171 | 33.0872 | ||||
| 33.0984 | -17.5583 | 83.7551 | ||||
| 26.4393 | -24.5970 | 77.4755 | ||||
| 0.3345 | -50.8698 | 51.5388 | ||||
| -6.0534 | -56.4208 | 44.3141 | ||||
| 3.7625 | -47.3066 | 54.8317 | ||||
| -25.3221 | -76.1620 | 25.5178 | ||||
| 19.5298 | -31.3220 | 70.3816 | ||||
| -20.8371 | -71.6505 | 29.9762 | ||||
| -12.9534 | -63.9315 | 38.0246 | ||||
| -20.4564 | -69.7872 | 28.8745 | ||||
| -7.2787 | -58.1104 | 43.5530 | ||||
| 3.6446 | -47.5376 | 54.8268 | ||||
| -30.3284 | -80.6854 | 20.0286 | ||||
| 28.0814 | -22.4730 | 78.6359 | ||||
| 3.9765 | -37.0488 | 45.0017 | ||||
| -11.0738 | -62.2851 | 40.1374 | ||||
| -14.0776 | -65.1176 | 36.9624 | ||||
| -17.3640 | -67.3964 | 32.6683 | ||||
| 3.6203 | -47.6074 | 54.8481 | ||||
| 13.6091 | -37.5453 | 64.7636 | ||||
| -17.4134 | -68.5347 | 33.7079 | ||||
| -14.4674 | -65.4316 | 36.4968 | ||||
| 4.9588 | -46.2466 | 56.1643 | ||||
| 25.0177 | -25.7733 | 75.8087 | ||||
| -25.8147 | -76.5983 | 24.9690 | ||||
| -15.9546 | -67.0693 | 35.1600 | ||||
| -22.5584 | -73.2294 | 28.1126 | ||||
| -25.9105 | -76.7866 | 24.9657 | ||||
| 10.7575 | -39.4114 | 60.9264 | ||||
| -37.3978 | -88.1530 | 13.3575 | ||||
| -34.2591 | -85.0080 | 16.4898 | ||||
| -28.4395 | -79.1662 | 22.2873 | ||||
| 7.1019 | -43.8000 | 58.0038 | ||||
| -1.1487 | -51.1280 | 48.8305 | ||||
| -25.1404 | -76.1545 | 25.8736 | ||||
| -33.8536 | -84.6079 | 16.9008 | ||||
| 35.4639 | -15.3332 | 86.2611 | ||||
| -23.3846 | -74.2392 | 27.4701 | ||||
| -3.8124 | -54.9315 | 47.3066 | ||||
| -18.0134 | -69.2128 | 33.1859 | ||||
| -30.1234 | -80.9801 | 20.7333 | ||||
| -24.4395 | -75.2474 | 26.3685 | ||||
| -25.1041 | -76.0837 | 25.8755 | ||||
| -0.6512 | -51.4711 | 50.1687 | ||||
| -16.2161 | -66.5045 | 34.0724 | ||||
| -1.5388 | -52.6389 | 49.5613 | ||||
| -29.2822 | -79.9380 | 21.3737 | ||||
| -20.0506 | -71.2057 | 31.1045 | ||||
| 7.1426 | -43.6939 | 57.9791 | ||||
| -19.7381 | -70.3403 | 30.8641 | ||||
| -16.6074 | -67.4100 | 34.1953 | ||||
| -2.1240 | -53.2381 | 48.9901 | ||||
| -19.1491 | -69.7304 | 31.4321 | ||||
| 7.7141 | -42.8786 | 58.3068 | ||||
| 12.8733 | -37.9695 | 63.7160 | ||||
| -16.4096 | -67.6248 | 34.8056 | ||||
| 37.0681 | -13.3471 | 87.4834 | ||||
| -15.4789 | -65.6088 | 34.6509 | ||||
| 7.4797 | -43.7139 | 58.6732 | ||||
| -9.8804 | -60.4900 | 40.7292 | ||||
| 34.3137 | -15.6535 | 84.2810 | ||||
| 6.7098 | -44.2910 | 57.7105 | ||||
| 9.9425 | -41.0808 | 60.9658 | ||||
| 9.2656 | -40.0972 | 58.6285 | ||||
| -32.9906 | -83.4306 | 17.4494 | ||||
| 0.1865 | -51.0727 | 51.4458 | ||||
| -0.4577 | -51.3953 | 50.4799 | ||||
| -10.3484 | -61.4071 | 40.7103 | ||||
| -3.4172 | -54.6044 | 47.7701 | ||||
| 1.6651 | -49.3512 | 52.6814 | ||||
| -10.0063 | -61.3041 | 41.2914 | ||||
| 15.1540 | -35.5594 | 65.8675 | ||||
| 3.0794 | -48.2116 | 54.3703 | ||||
| 5.5574 | -44.2786 | 55.3934 | ||||
| 11.1460 | -39.8436 | 62.1357 | ||||
| -30.2489 | -81.1894 | 20.6917 | ||||
| -13.1520 | -64.1954 | 37.8915 | ||||
| -3.4228 | -54.4306 | 47.5849 | ||||
| -17.7521 | -68.8004 | 33.2962 | ||||
| -35.8769 | -86.7118 | 14.9581 | ||||
| -14.4932 | -65.1229 | 36.1365 | ||||
| -0.1188 | -51.1060 | 50.8683 | ||||
| 3.7897 | -47.3559 | 54.9354 | ||||
| 21.9194 | -27.6652 | 71.5039 | ||||
| 26.7776 | -23.9676 | 77.5227 | ||||
| 5.5205 | -45.6555 | 56.6965 | ||||
| 13.3664 | -37.6893 | 64.4221 | ||||
| 13.7147 | -36.6026 | 64.0320 | ||||
| 9.4851 | -41.3890 | 60.3592 | ||||
| 29.1797 | -21.6240 | 79.9835 | ||||
| -15.7831 | -66.8133 | 35.2470 | ||||
| -22.7078 | -73.6132 | 28.1977 | ||||
| -4.3393 | -55.4381 | 46.7594 | ||||
| 37.4241 | -12.6945 | 87.5427 | ||||
| 16.4062 | -34.4985 | 67.3108 | ||||
| 0.1738 | -50.7715 | 51.1190 | ||||
| -7.8769 | -59.1793 | 43.4256 | ||||
| -13.8921 | -64.7886 | 37.0044 | ||||
| -8.0860 | -59.1509 | 42.9788 | ||||
| -17.1031 | -68.0762 | 33.8699 | ||||
| -4.4151 | -55.6334 | 46.8032 | ||||
| -30.9607 | -81.7690 | 19.8475 | ||||
| 32.0094 | -18.7677 | 82.7865 | ||||
| 31.7837 | -19.0185 | 82.5860 | ||||
| 5.2169 | -45.8980 | 56.3317 | ||||
| -5.0515 | -56.1756 | 46.0727 | ||||
| 18.5197 | -32.4990 | 69.5385 | ||||
| -5.7714 | -56.9352 | 45.3925 | ||||
| 25.2208 | -25.5482 | 75.9898 | ||||
| -12.6104 | -63.1297 | 37.9090 | ||||
| 21.7828 | -28.2603 | 71.8259 | ||||
| 10.2245 | -40.9908 | 61.4398 | ||||
| -9.4350 | -55.3153 | 36.4453 | ||||
| -5.0919 | -55.8748 | 45.6909 | ||||
| 32.6112 | -17.5312 | 82.7536 | ||||
| 44.5121 | -5.9272 | 94.9515 | ||||
| 35.8486 | -14.8237 | 86.5210 | ||||
| 43.8482 | -6.2251 | 93.9214 | ||||
| 35.3981 | -15.1079 | 85.9040 | ||||
| -5.3886 | -56.6237 | 45.8465 | ||||
| -19.5086 | -70.3569 | 31.3398 | ||||
| -28.7582 | -79.6589 | 22.1426 | ||||
| -8.0440 | -58.6477 | 42.5597 | ||||
| 9.2664 | -41.7655 | 60.2984 | ||||
| -2.1800 | -53.1386 | 48.7786 | ||||
| -8.6818 | -58.6147 | 41.2510 | ||||
| 5.6651 | -45.3400 | 56.6702 | ||||
| -18.4257 | -69.4724 | 32.6210 | ||||
| 12.4336 | -38.0096 | 62.8769 | ||||
| -15.3049 | -65.8878 | 35.2780 | ||||
| -17.3295 | -68.1602 | 33.5013 | ||||
| -2.4444 | -53.5238 | 48.6351 | ||||
| -13.7255 | -64.1018 | 36.6508 | ||||
stats = 0.2171 12.1355 0.0000 388.8866