Розрахункові дані
|
X1 |
X2 |
Y |
lnX1 |
lnX2 |
lnY |
lnX1*lnX1 |
lnX1*lnX2 |
lnX2*lnX2 |
lnY*lnX1 |
lnY*lnX2 |
X1^a1 |
X2^a2 |
Y^ |
(Y^-Yсер)^2 |
(Y-Y^)^2 |
Y-Y^ |
ut-ut-1 |
(ut-ut-1 )^2 |
1 |
30,1 |
50,2 |
78,2 |
3,405 |
3,916 |
4,359 |
11,591 |
13,332 |
15,335 |
14,841 |
17,071 |
3,083 |
14,384 |
77,638 |
194,005 |
0,316 |
0,562 |
|
|
2 |
30,7 |
53,5 |
82,5 |
3,424 |
3,980 |
4,413 |
11,726 |
13,627 |
15,838 |
15,111 |
17,562 |
3,103 |
15,021 |
81,609 |
99,168 |
0,795 |
0,891 |
0,330 |
0,109 |
3 |
33,7 |
53,1 |
83,9 |
3,517 |
3,972 |
4,430 |
12,373 |
13,972 |
15,778 |
15,581 |
17,595 |
3,201 |
14,945 |
83,735 |
61,335 |
0,027 |
0,165 |
-0,727 |
0,528 |
4 |
35,2 |
56,5 |
86,7 |
3,561 |
4,034 |
4,462 |
12,681 |
14,366 |
16,275 |
15,891 |
18,003 |
3,247 |
15,590 |
88,616 |
8,705 |
3,673 |
-1,916 |
-2,081 |
4,331 |
5 |
36,4 |
54,1 |
87,0 |
3,595 |
3,991 |
4,466 |
12,921 |
14,345 |
15,927 |
16,053 |
17,823 |
3,283 |
15,136 |
86,995 |
20,902 |
0,000 |
0,005 |
1,921 |
3,692 |
6 |
39,4 |
58,2 |
92,8 |
3,674 |
4,064 |
4,530 |
13,497 |
14,930 |
16,515 |
16,644 |
18,411 |
3,370 |
15,908 |
93,858 |
5,247 |
1,118 |
-1,058 |
-1,063 |
1,129 |
7 |
41,8 |
55,1 |
91,6 |
3,733 |
4,009 |
4,517 |
13,935 |
14,966 |
16,073 |
16,863 |
18,111 |
3,437 |
15,326 |
92,210 |
0,414 |
0,372 |
-0,610 |
0,448 |
0,200 |
8 |
40,4 |
57,2 |
95,3 |
3,699 |
4,047 |
4,557 |
13,681 |
14,968 |
16,375 |
16,856 |
18,440 |
3,398 |
15,721 |
93,529 |
3,849 |
3,138 |
1,771 |
2,381 |
5,671 |
9 |
44,2 |
56,1 |
94,7 |
3,789 |
4,027 |
4,551 |
14,354 |
15,258 |
16,218 |
17,241 |
18,326 |
3,501 |
15,515 |
95,086 |
12,382 |
0,149 |
-0,386 |
-2,157 |
4,652 |
10 |
46,0 |
55,2 |
92,8 |
3,829 |
4,011 |
4,530 |
14,658 |
15,357 |
16,088 |
17,345 |
18,171 |
3,547 |
15,345 |
95,294 |
13,893 |
6,221 |
-2,494 |
-2,108 |
4,446 |
11 |
47,8 |
57,1 |
99,5 |
3,867 |
4,045 |
4,600 |
14,954 |
15,641 |
16,360 |
17,789 |
18,607 |
3,593 |
15,702 |
98,761 |
51,756 |
0,546 |
0,739 |
3,233 |
10,453 |
12 |
49,5 |
58,7 |
102,9 |
3,902 |
4,072 |
4,634 |
15,225 |
15,891 |
16,585 |
18,081 |
18,871 |
3,634 |
16,001 |
101,807 |
104,854 |
1,195 |
1,093 |
0,354 |
0,126 |
13 |
49,7 |
58,1 |
102,6 |
3,906 |
4,062 |
4,631 |
15,257 |
15,867 |
16,501 |
18,088 |
18,811 |
3,639 |
15,889 |
101,232 |
93,414 |
1,872 |
1,368 |
0,275 |
0,075 |
14 |
50,0 |
58,1 |
|
3,912 |
4,062 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
∑ |
574,9 |
781,2 |
1190,5 |
47,900 |
52,230 |
58,681 |
176,853 |
192,519 |
209,868 |
216,384 |
235,802 |
|
|
|
669,922 |
19,421 |
0,131 |
0,806 |
35,412 |