什么是显著性矩阵，用excel怎么求？

来源：百度知道 编辑：UC知道 时间：2024/06/21 08:23:35
谁能根据这些数据，求出其显著性矩阵，急用！
17.34 192 36.5 301.4 301.1 255.2
27.12 153.8 50.5 309.5 298 426.6
14.88 64.2 16.4 304.5 298.7 1067.9
20.54 257.5 42.1 307.5 303.8 529.3
21.03 366.3 49.1 310.7 305.9 212.2
27.25 248.6 55 302.3 314.4 291.9
19.25 123.1 28.4 304.3 1314.7 1187.5
21.37 467.7 62.8 307.2 320.5 444.1
23.32 514.2 74.8 308.5 332.1 320.3
27.19 298.2 57.8 307.3 325.1 410.8
19.52 188 38.9 305.74 320.37 1464.2
21.16 624.7 78.5 303.2 315 484.9
14.92 620.5 93.5 300.3 306.1 376.2
71.64 52.4 46.1 301.3 306.7 455.8
21.25 212.2 46.4 306.5 306.8 1932.8
42.97 538.7 91.1 311.1 306.8 570.8
32.96 539 97.2 318.4 308.5 415.1
43.93 345.5 87.7 318.5 309.4 305
21.45 254.8 57.3 318.7 311.2 2507.9
47.86 661 100.4 317.4 312.6 661.2
33.59 662.5 112.2 312.5 311.9 270
47.47 440.7 103.2 308.5 308 265.6

可以根据相关系数矩阵来求。 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
1 1
2 0.077658 1
3 0.412173 0.878639 1
4 0.247468 0.344822 0.482262 1
5 -0.15764 -0.24952 -0.29254 -0.15792 1
6 -0.27091 -0.36798 -0.37705 0.163749 0.189561 1
7 -0.27555 -0.39155 -0.4034 0.146526 0.190862 0.998628 1
8 0.347856 0.323443 0.30238 0.346358 -0.06441 -0.03691 -0.0426 1
9 0.412276 -0.23815 0.032495 -0.04318 -0.17004 -0.29637 -0.29496 -0.0357 1
10 0.62995 -0.00471 0.318954 0.156733 -0.20959 -0.28637 -0.29085 0.194367 0.879769 1
11 0.651491 0.007254 0.340859 0.183206 -0.21105 -0.28438 -0.28936 0.192835 0.87004 0.998054 1
12 0.703021 0.250126 0.584034 0.395846 -0.22706 -0.2014 -0.20949 0.265294 0.616879 0.874152 0.889012 1
13 0.70311 0.255756 0.591814 0.428833 -0.22843 -0.2023 -0.21078 0.255945 0.599782 0.855175 0.874782 0.995936 1
14 0.490865 0.370813