Scribd
Upload
19 views8 pages

Regression Analysis

The document contains a matrix of numerical data with multiple variables (X1 to X9) and their respective values. It also includes calculations related to matrix operations, such as X'X and its inverse, which are likely part of a statistical analysis or regression model. Additionally, there are references to errors in calculations, indicated by #REF! and #VALUE! placeholders.

Uploaded by

Srijani Patra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
19 views8 pages

Regression Analysis

The document contains a matrix of numerical data with multiple variables (X1 to X9) and their respective values. It also includes calculations related to matrix operations, such as X'X and its inverse, which are likely part of a statistical analysis or regression model. Additionally, there are references to errors in calculations, indicated by #REF! and #VALUE! placeholders.

Uploaded by

Srijani Patra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 8

X1 X2 X3 X4 X5 X6 X7 X8 X9

500 0.67 3 12 0 0 0 1.25 1.25


450 0.67 2 1 46 0 0 50 50
1500 0.67 2 12 0 0 0 10 10
900 0.67 2 12 0 0 0 2.5 2.5
4000 0.67 3 12 0 0 0 10 10
4480 0.67 2 12 10 26 26 1.4 1.4
5000 0.67 2 12 0 0 0 5 5
550 0.67 4 3 0 0 0 500 500
450 0.67 3 2 46 0 0 50 50
400 0.67 3 12 46 0 0 50 50
350 0.67 3 12 0 0 0 500 500
450 0.67 3 1 0 0 0 250 250
450 0.67 1 2 0 0 0 250 250
450 0.67 4 11 0 0 0 1 1
1000 0.67 4 11 0 0 0 4 4
5000 0.67 3 11 0 0 0 5 5
3200 0.67 3 11 10 26 26 1 1
1500 0.67 3 11 0 0 0 10 10
900 0.67 3 11 0 0 0 2.5 2.5
270 0.66 1 8 46 0 0 30 30
1300 0.66 2 8 0 0 0 6.5 6.5
225 0.66 1 9 46 0 0 25 25
350 0.66 3 9 0 0 0 500 500
1200 0.66 1 7 0 0 0 10 10
300 0.66 2 7 0 0 0 500 500
630 0.66 1 7 0 0 60 30 30
1200 0.67 1 7 0 0 0 10 10
750 0.67 1 7 0 0 0 5 5
300 0.67 2 7 0 0 0 500 500
630 0.67 1 7 0 0 60 30 30
270 0.67 1 8 46 0 0 30 30
1300 0.67 2 8 0 0 0 6.5 6.5
225 0.67 1 9 46 0 0 25 25

b=(X'X)-1(X'X1)

x'x= 14.7206 48.8 186.38 228.22 34.84 114.64 2274.791 2274.791


48.8 193 641 602 130 250 8768.05 8768.05
186.38 641 2739 2484 598 1438 22749.3 22749.3
228.22 602 2484 15012 520 520 11984 11984
34.84 130 598 520 1352 1352 62.4 62.4
114.64 250 1438 520 1352 8552 3662.4 3662.4
2274.791 8768.05 22749.3 11984 62.4 3662.4 1388044 1388044
2274.791 8768.05 22749.3 11984 62.4 3662.4 1388044 1388044

x'x-1= #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!


#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
0.67 0.67 0.67 0.67 0.67 0.67 0.67
3 2 2 2 3 2 2
12 1 12 12 12 12 12
X'= 0 46 0 0 0 10 0
0 0 0 0 0 26 0
0 0 0 0 0 26 0
1.25 50 10 2.5 10 1.4 5
1.25 50 10 2.5 10 1.4 5

X'X= 156.5739 143.4489 175.4489 156.6989 178.4489 153.9489 162.9489


143.4489 7121.449 1016.4489 266.4489 1018.4489 616.4489 516.4489
175.4489 1016.449 348.4489 198.4489 350.4489 176.4489 248.4489
156.6989 266.4489 198.4489 160.9489 200.4489 155.4489 173.4489
178.4489 1018.449 350.4489 200.4489 353.4489 178.4489 250.4489
153.9489 616.4489 176.4489 155.4489 178.4489 1604.3689 162.4489
162.9489 516.4489 248.4489 173.4489 250.4489 162.4489 198.4489
1298.449 50011.45 10044.4489 2544.4489 10048.449 1444.4489 5044.4489

X'X1= 27078.85
96210 (X'X)-1= 4.235432E+12 -0.058779 5.505042E+12 -3.813929E+12
409850 0.0447514054 0.0005075 0.0822199764 -0.1054620929
182140 1.926793E+13 -0.187708 1.998843E+13 -2.746091E+13
199680 2.371185E+13 -0.280666 2.07092E+13 -4.157307E+13
275280 -4.235432E+12 0.0600199 -5.505042E+12 3.813929E+12
1463947 -0.0136747986 -0.000161 -0.0251776939 0.0316727165
1463947 -4.297978E+13 0.4674064 -4.069763E+13 6.903398E+13
-321.62467945 -0.00062 -575.54507292 739.48429543

b= -1.645169E+18
37457.315099
1.080418E+19
2.736645E+19
1.645169E+18
-11860.644274
-3.817063E+19
-263776964.62

#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!


#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67
4 3 3 3 3 1 4 4 3
3 2 12 12 1 2 11 11 11
0 46 46 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
500 50 50 500 250 250 1 4 5
500 50 50 500 250 250 1 4 5

1298.4489
50011.4489
10044.4489
2544.4489
10048.4489
1444.4489
5044.4489
500025.4489

-4.235432E+12 0.0188103 -1.691114E+12 345.54616


-0.0440463329 -0.000161 0.0214866005 -0.00062
-1.926793E+13 0.0633407 7.472484E+12 994.71661
-2.371185E+13 0.0950115 2.086387E+13 1544.9097
4.235432E+12 -0.019203 1.691114E+12 -359.4334
0.0132817506 0.0007396 -0.0068773511 0.0001965
4.297978E+13 -0.158735 -2.833635E+13 -2526.742
307.73742877 0.0001965 -151.05472638 3.9734019
#VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
0.67 0.67 0.67 0.66 0.66 0.66 0.66 0.66 0.66 0.66
3 3 3 1 2 1 3 1 2 1
11 11 11 8 8 9 9 7 7 7
10 0 0 46 0 46 0 0 0 0
26 0 0 0 0 0 0 0 0 0
26 0 0 0 0 0 0 0 0 60
1 10 2.5 30 6.5 25 500 10 500 30
1 10 2.5 30 6.5 25 500 10 500 30
0.67 0.67 0.67 0.67 0.67 0.67 0.67
1 1 2 1 1 2 1
7 7 7 7 8 8 9
0 0 0 0 46 0 46
0 0 0 0 0 0 0
0 0 0 60 0 0 0
10 5 500 30 30 6.5 25
10 5 500 30 30 6.5 25

You might also like