Math homework 2-20-2015

profilevzedes
multiple_regression.xls
Home>Mathematics homework help>Math homework 2-20-2015

Data

Multiple Regression Exports R^2 0.6882010923 0.8132207464 0.8409854274 0.2783464026 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Y 1 X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 1 2 3 4 1 2 3 0 0 0 0 0 0 0 0 0 0 0 0
Sl.No. Exports Ones M1 Lend Price Exch. M1 Lend Price Exch. M1 Lend Price 0 0 0 0 0 0 0 0 0 0 0 0
1 2.6 1 5.1 7.8 114 2.16 5.1 7.8 114 2.16 5.1 7.8 114 0 0 0 0 0 0 0 0 0 0 0 0
2 2.6 1 4.9 8 116 2.17 4.9 8 116 2.17 4.9 8 116 0 0 0 0 0 0 0 0 0 0 0 0
3 2.7 1 5.1 8.1 117 2.18 5.1 8.1 117 2.18 5.1 8.1 117 0 0 0 0 0 0 0 0 0 0 0 0
4 3 1 5.1 8.1 122 2.2 5.1 8.1 122 2.2 5.1 8.1 122 0 0 0 0 0 0 0 0 0 0 0 0
5 2.9 1 5.1 8.1 124 2.21 5.1 8.1 124 2.21 5.1 8.1 124 0 0 0 0 0 0 0 0 0 0 0 0
6 3.1 1 5.2 8.1 128 2.17 5.2 8.1 128 2.17 5.2 8.1 128 0 0 0 0 0 0 0 0 0 0 0 0
7 3.2 1 5.1 8.3 132 2.14 5.1 8.3 132 2.14 5.1 8.3 132 0 0 0 0 0 0 0 0 0 0 0 0
8 3.7 1 5.2 8.8 133 2.16 5.2 8.8 133 2.16 5.2 8.8 133 0 0 0 0 0 0 0 0 0 0 0 0
9 3.6 1 5.3 8.9 133 2.15 5.3 8.9 133 2.15 5.3 8.9 133 0 0 0 0 0 0 0 0 0 0 0 0
10 3.4 1 5.4 9.1 134 2.16 5.4 9.1 134 2.16 5.4 9.1 134 0 0 0 0 0 0 0 0 0 0 0 0
11 3.7 1 5.7 9.2 135 2.18 5.7 9.2 135 2.18 5.7 9.2 135 0 0 0 0 0 0 0 0 0 0 0 0
12 3.6 1 5.7 9.5 136 2.17 5.7 9.5 136 2.17 5.7 9.5 136 0 0 0 0 0 0 0 0 0 0 0 0
13 4.1 1 5.9 10.3 140 2.15 5.9 10.3 140 2.15 5.9 10.3 140 0 0 0 0 0 0 0 0 0 0 0 0
14 3.5 1 5.8 10.6 147 2.16 5.8 10.6 147 2.16 5.8 10.6 147 0 0 0 0 0 0 0 0 0 0 0 0
15 4.2 1 5.7 11.3 150 2.21 5.7 11.3 150 2.21 5.7 11.3 150 0 0 0 0 0 0 0 0 0 0 0 0
16 4.3 1 5.8 12.1 151 2.24 5.8 12.1 151 2.24 5.8 12.1 151 0 0 0 0 0 0 0 0 0 0 0 0
17 4.2 1 6 12 151 2.16 6 12 151 2.16 6 12 151 0 0 0 0 0 0 0 0 0 0 0 0
18 4.1 1 6 11.4 151 2.12 6 11.4 151 2.12 6 11.4 151 0 0 0 0 0 0 0 0 0 0 0 0
19 4.6 1 6 11.1 153 2.11 6 11.1 153 2.11 6 11.1 153 0 0 0 0 0 0 0 0 0 0 0 0
20 4.4 1 6 11 154 2.13 6 11 154 2.13 6 11 154 0 0 0 0 0 0 0 0 0 0 0 0
21 4.5 1 6.1 11.3 154 2.11 6.1 11.3 154 2.11 6.1 11.3 154 0 0 0 0 0 0 0 0 0 0 0 0
22 4.6 1 6 12.6 154 2.09 6 12.6 154 2.09 6 12.6 154 0 0 0 0 0 0 0 0 0 0 0 0
23 4.6 1 6.1 13.6 155 2.09 6.1 13.6 155 2.09 6.1 13.6 155 0 0 0 0 0 0 0 0 0 0 0 0
24 4.2 1 6.7 13.6 155 2.1 6.7 13.6 155 2.1 6.7 13.6 155 0 0 0 0 0 0 0 0 0 0 0 0
25 5.5 1 6.2 14.3 156 2.08 6.2 14.3 156 2.08 6.2 14.3 156 0 0 0 0 0 0 0 0 0 0 0 0
26 3.7 1 6.3 14.3 156 2.09 6.3 14.3 156 2.09 6.3 14.3 156 0 0 0 0 0 0 0 0 0 0 0 0
27 4.9 1 7 13.7 159 2.1 7 13.7 159 2.1 7 13.7 159 0 0 0 0 0 0 0 0 0 0 0 0
28 5.2 1 7 12.7 161 2.11 7 12.7 161 2.11 7 12.7 161 0 0 0 0 0 0 0 0 0 0 0 0
29 4.9 1 6.6 12.6 161 2.15 6.6 12.6 161 2.15 6.6 12.6 161 0 0 0 0 0 0 0 0 0 0 0 0
30 4.6 1 6.4 13.4 161 2.14 6.4 13.4 161 2.14 6.4 13.4 161 0 0 0 0 0 0 0 0 0 0 0 0
31 5.4 1 6.3 14.3 162 2.16 6.3 14.3 162 2.16 6.3 14.3 162 0 0 0 0 0 0 0 0 0 0 0 0
32 5 1 6.5 13.9 160 2.17 6.5 13.9 160 2.17 6.5 13.9 160 0 0 0 0 0 0 0 0 0 0 0 0
33 4.8 1 6.6 14.5 159 2.15 6.6 14.5 159 2.15 6.6 14.5 159 0 0 0 0 0 0 0 0 0 0 0 0
34 5.1 1 6.8 15 159 2.1 6.8 15 159 2.1 6.8 15 159 0 0 0 0 0 0 0 0 0 0 0 0
35 4.4 1 7.2 13.2 158 2.06 7.2 13.2 158 2.06 7.2 13.2 158 0 0 0 0 0 0 0 0 0 0 0 0
36 5 1 7.6 11.8 155 2.05 7.6 11.8 155 2.05 7.6 11.8 155 0 0 0 0 0 0 0 0 0 0 0 0
37 5.1 1 7.2 11.2 155 2.06 7.2 11.2 155 2.06 7.2 11.2 155 0 0 0 0 0 0 0 0 0 0 0 0
38 4.8 1 7.1 10.1 154 2.11 7.1 10.1 154 2.11 7.1 10.1 154 0 0 0 0 0 0 0 0 0 0 0 0
39 5.4 1 7 10 154 2.12 7 10 154 2.12 7 10 154 0 0 0 0 0 0 0 0 0 0 0 0
40 5 1 7.5 10.2 154 2.13 7.5 10.2 154 2.13 7.5 10.2 154 0 0 0 0 0 0 0 0 0 0 0 0
41 5.2 1 7.4 11 153 2.04 7.4 11 153 2.04 7.4 11 153 0 0 0 0 0 0 0 0 0 0 0 0
42 4.7 1 7.4 11 152 2.14 7.4 11 152 2.14 7.4 11 152 0 0 0 0 0 0 0 0 0 0 0 0
43 5.1 1 7.3 10.7 152 2.15 7.3 10.7 152 2.15 7.3 10.7 152 0 0 0 0 0 0 0 0 0 0 0 0
44 4.9 1 7.6 10.2 152 2.16 7.6 10.2 152 2.16 7.6 10.2 152 0 0 0 0 0 0 0 0 0 0 0 0
45 4.9 1 7.8 10 151 2.17 7.8 10 151 2.17 7.8 10 151 0 0 0 0 0 0 0 0 0 0 0 0
46 5.3 1 7.8 9.8 152 2.2 7.8 9.8 152 2.2 7.8 9.8 152 0 0 0 0 0 0 0 0 0 0 0 0
47 4.8 1 8.2 9.3 152 2.21 8.2 9.3 152 2.21 8.2 9.3 152 0 0 0 0 0 0 0 0 0 0 0 0
48 4.9 1 8.2 9.3 152 2.15 8.2 9.3 152 2.15 8.2 9.3 152 0 0 0 0 0 0 0 0 0 0 0 0
49 5.1 1 8.3 9.5 152 2.08 8.3 9.5 152 2.08 8.3 9.5 152 0 0 0 0 0 0 0 0 0 0 0 0
50 4.3 1 8.3 9.2 150 2.08 8.3 9.2 150 2.08 8.3 9.2 150 0 0 0 0 0 0 0 0 0 0 0 0
51 4.9 1 8 9.1 147 2.09 8 9.1 147 2.09 8 9.1 147 0 0 0 0 0 0 0 0 0 0 0 0
52 5.3 1 8.2 9 147 2.1 8.2 9 147 2.1 8.2 9 147 0 0 0 0 0 0 0 0 0 0 0 0
53 4.8 1 8.2 9 146 2.09 8.2 9 146 2.09 8.2 9 146 0 0 0 0 0 0 0 0 0 0 0 0
54 5.3 1 8 8.9 145 2.12 8 8.9 145 2.12 8 8.9 145 0 0 0 0 0 0 0 0 0 0 0 0
55 5 1 8.1 9 145 2.13 8.1 9 145 2.13 8.1 9 145 0 0 0 0 0 0 0 0 0 0 0 0
56 5.1 1 8.1 9 146 2.14 8.1 9 146 2.14 8.1 9 146 0 0 0 0 0 0 0 0 0 0 0 0
57 4.8 1 8.1 9 147 2.14 8.1 9 147 2.14 8.1 9 147 0 0 0 0 0 0 0 0 0 0 0 0
58 4.8 1 8.1 8.9 147 2.13 8.1 8.9 147 2.13 8.1 8.9 147 0 0 0 0 0 0 0 0 0 0 0 0
59 5.2 1 8.6 8.9 147 2.13 8.6 8.9 147 2.13 8.6 8.9 147 0 0 0 0 0 0 0 0 0 0 0 0
60 4.9 1 8.8 9 146 2.13 8.8 9 146 2.13 8.8 9 146 0 0 0 0 0 0 0 0 0 0 0 0
61 5.5 1 8.4 9.1 147 2.13 8.4 9.1 147 2.13 8.4 9.1 147 0 0 0 0 0 0 0 0 0 0 0 0
62 4.3 1 8.2 9 146 2.13 8.2 9 146 2.13 8.2 9 146 0 0 0 0 0 0 0 0 0 0 0 0
63 5.2 1 8.3 9.2 146 2.09 8.3 9.2 146 2.09 8.3 9.2 146 0 0 0 0 0 0 0 0 0 0 0 0
64 4.7 1 8.3 9.6 146 2.09 8.3 9.6 146 2.09 8.3 9.6 146 0 0 0 0 0 0 0 0 0 0 0 0
65 5.4 1 8.4 10 146 2.1 8.4 10 146 2.1 8.4 10 146 0 0 0 0 0 0 0 0 0 0 0 0
66 5.2 1 8.3 10 147 2.11 8.3 10 147 2.11 8.3 10 147 0 0 0 0 0 0 0 0 0 0 0 0
67 5.6 1 8.2 10.1 146 2.15 8.2 10.1 146 2.15 8.2 10.1 146 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
&A
Page &P
Do not erase the 1's in this column.
Enter the dependent variable in this column. Up to 200 values can be entered.
Use these labels for sorting the columns as desired. For example. If you wish to interchange columns 1 and 2, interchange the name X1 and X2 at the top and use the sort command to sort the columns X1 and X2.
Use this row for entering names of columns.

Results

Multiple Regression Results Exports
0 1 2 3 4 5 6 7 8 9 10
Intercept M1 Lend Price Exch. 0 0 0 0 0 0
b -4.015461451 0.3684564006 0.0047022019 0.0365105241 0.2678962478 0 0 0 0 0 0 Press the F9 key before reading these results.
s(b) 2.7664005657 0.0638484093 0.0492218633 0.0093260088 1.1754401621 0 0 0 0 0 0
t -1.4515112167 5.7707999997 0.095530758 3.9149141767 0.2279114297 0 0 0 0 0 0
p-value 0.1517 0.0000 0.9242 0.0002 0.8205 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
VIF 3.2072 5.3539 6.2887 1.3857 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
ANOVA Table
Source SS df MS F FCritical p-value
Regn. 32.9463354221 4 8.2365838555 73.0592247829 2.5201014638 0.0000 s 0.3357654707
Error 6.9897839809 62 0.1127384513
Total 39.936119403 66 0.6050927182 R2 0.8250 Adjusted R2 0.8136840059
Prediction Interval
Given X M1 Lend Price Exch. 0 0 0 0 0 0
1 5 10 150 2
1-a (1-a) CI for Y for given X 1-a (1-a) CI for E[Y | X]
95% 3.8862136749 + or - 0.8508657484 95% 3.8862136749 + or - 0.5229554432
Press the F9 key before reading the results.
Do not delete this cell.
Enter the given values for all the independent varaibles in this row.
To change the title here, change it on the Data sheet.

Residuals

Residual Analysis Exports Exports 1 2.6 1.0072964121 3
M1 2.6 -1.0072964121 -3
Errors Q Z Lend 2.7
-0.0411990044 0.456 -0.111 Durbin-Watson d = 2.5832779372 Price 3
-0.0441481753 0.441 -0.148 Exch. 2.9
-0.0574991621 0.412 -0.223 0 3.1
0.0545902927 0.588 0.223 0 3.2
-0.1211097179 0.265 -0.629 0 3.7
-0.0932816043 0.338 -0.417 0 3.6
-0.0953816134 0.309 -0.499 0 3.4
0.3235531966 0.882 1.187 0 3.7
0.1889162988 0.750 0.674 3.6
-0.0880592682 0.353 -0.377 X Axis 4.1
0.0590651425 0.603 0.261 3.5 Select X Axis for the Residual Plot.
-0.0761770797 0.368 -0.338 4.2 Press the F9 key.
0.2056857074 0.794 0.821 4.3
-0.617131944 0.074 -1.450 4.2
-0.0065042298 0.515 0.037 4.1
0.0083409571 0.544 0.111 4.6
-0.143448403 0.235 -0.722 4.4
-0.2299112319 0.176 -0.929 4.5
0.201157343 0.779 0.770 4.6
-0.0402408858 0.471 -0.074 4.6
0.0268607385 0.574 0.185 4.2
0.162951441 0.691 0.499 5.5
0.084893075 0.632 0.338 3.7
-0.5388597278 0.088 -1.352 4.9
0.9109243321 0.985 2.178 5.2
-0.9286002705 0.015 -2.178 4.9
-0.0959089644 0.294 -0.541 4.6
0.1330932269 0.676 0.458 5.4
-0.0297698425 0.500 0.000 5
-0.2571613615 0.162 -0.987 4.8
0.5335838478 0.941 1.565 5.1
0.1321155341 0.662 0.417 4.4
-0.0656829781 0.382 -0.299 5
0.1716694532 0.706 0.541 5.1
-0.6200227696 0.059 -1.565 4.8
-0.0486117125 0.426 -0.185 5.4
0.1989132064 0.765 0.722 5
-0.0359530198 0.485 -0.037 5.2
0.598683878 0.956 1.705 4.7
0.0108362749 0.559 0.148 5.1
0.3045413398 0.853 1.049 4.9
-0.185737761 0.191 -0.874 4.9
0.2498395772 0.824 0.929 5.3
-0.0610252045 0.397 -0.261 4.8
-0.0999444827 0.279 -0.585 4.9
0.2564485462 0.838 0.987 5.1
-0.3912618755 0.103 -1.265 4.3
-0.2751881007 0.132 -1.115 4.9
-0.0942214438 0.324 -0.458 5.3
-0.8197897351 0.029 -1.890 4.8
-0.001929985 0.529 0.074 5.3
0.3221699926 0.868 1.115 5
-0.1386405209 0.250 -0.674 5.1
0.463994616 0.926 1.450 4.8
0.1239997933 0.647 0.377 4.8
0.1848103068 0.735 0.629 5.2
-0.1517002173 0.206 -0.821 4.9
-0.1485510346 0.221 -0.770 5.5
0.0672207651 0.618 0.299 4.3
-0.2704302112 0.147 -1.049 5.2
0.4399716048 0.912 1.352 4.7
-0.6493563708 0.044 -1.705 5.4
0.2235733987 0.809 0.874 5.2
-0.2783074821 0.118 -1.187 5.6
0.3802870346 0.897 1.265 0
0.1779431881 0.721 0.585 0
0.6401132821 0.971 1.890 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000 0
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000
0 0.000 0.000

Residuals

-0.0411990044
-0.0441481753
-0.0574991621
0.0545902927
-0.1211097179
-0.0932816043
-0.0953816134
0.3235531966
0.1889162988
-0.0880592682
0.0590651425
-0.0761770797
0.2056857074
-0.617131944
-0.0065042298
0.0083409571
-0.143448403
-0.2299112319
0.201157343
-0.0402408858
0.0268607385
0.162951441
0.084893075
-0.5388597278
0.9109243321
-0.9286002705
-0.0959089644
0.1330932269
-0.0297698425
-0.2571613615
0.5335838478
0.1321155341
-0.0656829781
0.1716694532
-0.6200227696
-0.0486117125
0.1989132064
-0.0359530198
0.598683878
0.0108362749
0.3045413398
-0.185737761
0.2498395772
-0.0610252045
-0.0999444827
0.2564485462
-0.3912618755
-0.2751881007
-0.0942214438
-0.8197897351
-0.001929985
0.3221699926
-0.1386405209
0.463994616
0.1239997933
0.1848103068
-0.1517002173
-0.1485510346
0.0672207651
-0.2704302112
0.4399716048
-0.6493563708
0.2235733987
-0.2783074821
0.3802870346
0.1779431881
0.6401132821
Residual
Residual Plot

Correl

-0.0411990044
-0.0441481753
-0.0574991621
0.0545902927
-0.1211097179
-0.0932816043
-0.0953816134
0.3235531966
0.1889162988
-0.0880592682
0.0590651425
-0.0761770797
0.2056857074
-0.617131944
-0.0065042298
0.0083409571
-0.143448403
-0.2299112319
0.201157343
-0.0402408858
0.0268607385
0.162951441
0.084893075
-0.5388597278
0.9109243321
-0.9286002705
-0.0959089644
0.1330932269
-0.0297698425
-0.2571613615
0.5335838478
0.1321155341
-0.0656829781
0.1716694532
-0.6200227696
-0.0486117125
0.1989132064
-0.0359530198
0.598683878
0.0108362749
0.3045413398
-0.185737761
0.2498395772
-0.0610252045
-0.0999444827
0.2564485462
-0.3912618755
-0.2751881007
-0.0942214438
-0.8197897351
-0.001929985
0.3221699926
-0.1386405209
0.463994616
0.1239997933
0.1848103068
-0.1517002173
-0.1485510346
0.0672207651
-0.2704302112
0.4399716048
-0.6493563708
0.2235733987
-0.2783074821
0.3802870346
0.1779431881
0.6401132821
Residual
Corresponding Normal Z
Normal Probability Plot

Partial F

Correlation matrix Exports
1 2 3 4 5 6 7 8 9 10 Press the F9 key before reading the results.
M1 Lend Price Exch. 0 0 0 0 0 0
1 M1 1.0000
2 Lend -0.1120 1.0000
3 Price 0.4471 0.7451 1.0000
4 Exch. -0.4097 -0.2786 -0.4196 1.0000
5 0 0.0000 0.0000 0.0000 0.0000 0.0000
6 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
7 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
8 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
9 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
10 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
Y Exports 0.7751 0.3350 0.7699 -0.4329 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
Partial F Calculations Exports
#Independent variables in full model 4 k
#Independent variables dropped from the model 2 r Press the F9 key after entering r.
SSEF 6.9897839809
SSER 8.7475725066
Partial F 7.7958695784
p-value 0.0010
This must be between 0 and k. If Partial F is not needed, let r = 0. Note that the last r variables are dropped.