Ex Econometria 2222
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Ex Econometria 2222 as PDF for free.
More details
- Words: 1,256
- Pages: 19
HAV x 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990
463 464 459 459 454 454 446 447 437 433 431 433 431 428 430 431 430 433 437 437 435 435 434 429 10570
HAM y
HAV*HAM HAV^2 HAM^2 CONT NUM MED HAV 514 237982 214369 264196 24 440.42 512 237568 215296 262144 513 235467 210681 263169 509 233631 210681 259081 507 230178 206116 257049 505 229270 206116 255025 502 223892 198916 252004 501 223947 199809 251001 495 216315 190969 245025 497 215201 187489 247009 497 214207 185761 247009 494 213902 187489 244036 493 212483 185761 243049 491 210148 183184 241081 492 211560 184900 242064 493 212483 185761 243049 493 211990 184900 243049 495 214335 187489 245025 499 218063 190969 249001 501 218937 190969 251001 500 217500 189225 250000 498 216630 189225 248004 500 217000 188356 250000 499 214071 184041 249001 12000 5286760 4658472 6001072
24 10570 12000 5286760
10570 4658472
59.4 -0.13
-0.13 0
intercepto declividade
262.8 0.54
262.8 0.54
MED HAM (HAM-MED HAM) (HAV-MED HAV) (HAM-MED HAM)^2 (HAV-MED HAV)^2 500 14 22.58 196 510.01 12 23.58 144 556.17 13 18.58 169 345.34 9 18.58 81 345.34 7 13.58 49 184.51 5 13.58 25 184.51 2 5.58 4 31.17 1 6.58 1 43.34 -5 -3.42 25 11.67 -3 -7.42 9 55.01 -3 -9.42 9 88.67 -6 -7.42 36 55.01 -7 -9.42 49 88.67 -9 -12.42 81 154.17 -8 -10.42 64 108.51 -7 -9.42 49 88.67 -7 -10.42 49 108.51 -5 -7.42 25 55.01 -1 -3.42 1 11.67 1 -3.42 1 11.67 0 -5.42 0 29.34 -2 -5.42 4 29.34 0 -6.42 0 41.17 -1 -11.42 1 130.34 0 0 1072 3267.83
24 12000
12000 6001072
233.25 -0.47
-0.47 0
10570 5286760
-380.48 1.64
(HAM-MED HAM)*(HAV-MED HAV) HAM-estimado HAV-estimado 316.17 512.16 463.4 283 512.7 460.12 241.58 510.01 461.76 167.25 510.01 455.19 95.08 507.32 451.91 67.92 507.32 448.63 11.17 503.01 443.7 6.58 503.55 442.06 17.08 498.16 432.21 22.25 496.01 435.49 28.25 494.93 435.49 44.5 496.01 430.57 65.92 494.93 428.92 111.75 493.31 425.64 83.33 494.39 427.28 65.92 494.93 428.92 72.92 494.39 428.92 37.08 496.01 432.21 3.42 498.16 438.77 -3.42 498.16 442.06 0 497.08 440.42 10.83 497.08 437.13 0 496.54 440.42 11.42 493.85 438.77
intercepto declividade
-380.48 1.64
Hav ( X) Ham (Y) Cont Num X^2 X^3 X^4 XY 463 514 24 214369 99252847 45954068161 237982 464 512 215296 99897344 46352367616 237568 459 513 210681 96702579 44386483761 235467 459 509 210681 96702579 44386483761 233631 454 507 206116 93576664 42483805456 230178 454 505 206116 93576664 42483805456 229270 446 502 198916 88716536 39567575056 223892 447 501 199809 89314623 39923636481 223947 437 495 190969 83453453 36469158961 216315 433 497 187489 81182737 35152125121 215201 431 497 185761 80062991 34507149121 214207 433 494 187489 81182737 35152125121 213902 431 493 185761 80062991 34507149121 212483 428 491 183184 78402752 33556377856 210148 430 492 184900 79507000 34188010000 211560 431 493 185761 80062991 34507149121 212483 430 493 184900 79507000 34188010000 211990 433 495 187489 81182737 35152125121 214335 437 499 190969 83453453 36469158961 218063 437 501 190969 83453453 36469158961 218937 435 500 189225 82312875 35806100625 217500 435 498 189225 82312875 35806100625 216630 434 500 188356 81746504 35477982736 217000 429 499 184041 78953589 33871089681 214071 Somatório 10570 12000 4658472 2054579974 ### 5286760
X^2Y Y estu]imado 110185666 512.52 110231552 513.15 108079353 510.06 107236629 510.06 104500812 507.1 104088580 507.1 99855832 502.61 100104309 503.16 94529655 497.94 93182033 495.99 92323217 495.04 92619566 495.99 91580173 495.04 89943344 493.66 90970800 494.58 91580173 495.04 91155700 494.58 92807055 495.99 95293531 497.94 95675469 497.94 94612500 496.95 94234050 496.95 94178000 496.47 91836459 494.12 2330804458
Matriz 24 10570 10570 4658472 4658472 2054579974
192201.95 -863.54 0.97
Matriz Inversa -863.54 3.88 0
4658472 2054579974 ###
0.97 0 0
Vetor 12000 5286760 2330804458
Resultado 747.61 -1.64 0
X
Somatório
Y 514 512 513 509 507 505 502 501 495 497 497 494 493 491 492 493 493 495 499 501 500 498 500 499 12000
Cont Num 24
X^2 X^3 X^4 XY X^2Y 463 264196 135796744 69799526416 237982 122322748 464 262144 134217728 68719476736 237568 121634816 459 263169 135005697 69257922561 235467 120794571 459 259081 131872229 67122964561 233631 118918179 454 257049 130323843 66074188401 230178 116700246 454 255025 128787625 65037750625 229270 115781350 446 252004 126506008 63506016016 223892 112393784 447 251001 125751501 63001502001 223947 112197447 437 245025 121287375 60037250625 216315 107075925 433 247009 122763473 61013446081 215201 106954897 431 247009 122763473 61013446081 214207 106460879 433 244036 120553784 59553569296 213902 105667588 431 243049 119823157 59072816401 212483 104754119 428 241081 118370771 58120048561 210148 103182668 430 242064 119095488 58594980096 211560 104087520 431 243049 119823157 59072816401 212483 104754119 430 243049 119823157 59072816401 211990 104511070 433 245025 121287375 60037250625 214335 106095825 437 249001 124251499 62001498001 218063 108813437 437 251001 125751501 63001502001 218937 109687437 435 250000 125000000 62500000000 217500 108750000 435 248004 123505992 61505984016 216630 107881740 434 250000 125000000 62500000000 217000 108500000 429 249001 124251499 62001498001 214071 106821429 10570 6001072 3001613076 ### 5286760 2644741794
Y ESTIMADO ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
24 12000 6001072
MATRIZ 12000 6001072 3001613076
MATRIZ INVERSA 1384713.32 -5513.39 -5513.39 21.95 5.49 -0.02
6001072 3001613076 ###
5.49 -0.02 0
VETOR 10570 5286760 2644741794
RESULTADO DE BETA 6936.91 -27.5 0.03
HAV x
SOMATORIO
HAM y Ln X 463 514 464 512 459 513 459 509 454 507 454 505 446 502 447 501 437 495 433 497 431 497 433 494 431 493 428 491 430 492 431 493 430 493 433 495 437 499 437 501 435 500 435 498 434 500 429 499 10570 12000
Cont Num 24
Ln Y 6.14 6.14 6.13 6.13 6.12 6.12 6.1 6.1 6.08 6.07 6.07 6.07 6.07 6.06 6.06 6.07 6.06 6.07 6.08 6.08 6.08 6.08 6.07 6.06 146.1
(Ln X)^2 6.24 6.24 6.24 6.23 6.23 6.22 6.22 6.22 6.2 6.21 6.21 6.2 6.2 6.2 6.2 6.2 6.2 6.2 6.21 6.22 6.21 6.21 6.21 6.21 149.15
(Ln X * Ln Y) 37.67 38.31 37.7 38.3 37.57 38.25 37.57 38.2 37.43 38.11 37.43 38.08 37.21 37.94 37.24 37.94 36.97 37.72 36.85 37.69 36.8 37.66 36.85 37.65 36.8 37.61 36.71 37.55 36.77 37.59 36.8 37.61 36.77 37.6 36.85 37.67 36.97 37.77 36.97 37.8 36.91 37.76 36.91 37.73 36.88 37.74 36.74 37.66 889.36 907.93
Y estimado 512.11 512.63 509.99 509.99 507.33 507.33 503.05 503.59 498.18 496 494.91 496 494.91 493.26 494.36 494.91 494.36 496 498.18 498.18 497.1 497.1 496.55 493.81 11999.88
Mat. 24 146.1
146.1 889.36
Mat. Invers 2248.18 -369.31 -369.31 60.67
149.15 907.93
Alfa 27.42
Beta 1 e beta 2 3.31 0.48
514 513 512 511 510 509 508 507 506 505 504 503 502 501 500 499 498 497 496 495 494 493 492 491 427.5
430
432.5
435
437.5
440
442.5
445
447.5
Column D
450
452.5
455
457.5
460
462.5
465
2.5
465
514 513 512 511 510 509 508 507 506 505 504 503 502 501 500 499 498 497 496 495 494 493 492 491 427.5
430
432.5
435
437.5
440
442.5
445
Column D
447.5 Column K
450
452.5
455
457.5
460
462.5
465
2.5
465
465 462.5 460 457.5 455 452.5 450 447.5 445 442.5 440 437.5 435 432.5 430 427.5 490
492.5
495
497.5
500
502.5 Column D
505
507.5
510
512.5
515
515
514 513 512 511 510 509 508 507 506 505 504 503 502 501 500 499 498 497 496 495 494 493 492 491 427.5
430
432.5
435
437.5
440
Column D
442.5
445
447.5
450
452.5
Power regression, Column D
455
457.5
460
462.5
465
2.5
465
463 464 459 459 454 454 446 447 437 433 431 433 431 428 430 431 430 433 437 437 435 435 434 429 10570
HAM y
HAV*HAM HAV^2 HAM^2 CONT NUM MED HAV 514 237982 214369 264196 24 440.42 512 237568 215296 262144 513 235467 210681 263169 509 233631 210681 259081 507 230178 206116 257049 505 229270 206116 255025 502 223892 198916 252004 501 223947 199809 251001 495 216315 190969 245025 497 215201 187489 247009 497 214207 185761 247009 494 213902 187489 244036 493 212483 185761 243049 491 210148 183184 241081 492 211560 184900 242064 493 212483 185761 243049 493 211990 184900 243049 495 214335 187489 245025 499 218063 190969 249001 501 218937 190969 251001 500 217500 189225 250000 498 216630 189225 248004 500 217000 188356 250000 499 214071 184041 249001 12000 5286760 4658472 6001072
24 10570 12000 5286760
10570 4658472
59.4 -0.13
-0.13 0
intercepto declividade
262.8 0.54
262.8 0.54
MED HAM (HAM-MED HAM) (HAV-MED HAV) (HAM-MED HAM)^2 (HAV-MED HAV)^2 500 14 22.58 196 510.01 12 23.58 144 556.17 13 18.58 169 345.34 9 18.58 81 345.34 7 13.58 49 184.51 5 13.58 25 184.51 2 5.58 4 31.17 1 6.58 1 43.34 -5 -3.42 25 11.67 -3 -7.42 9 55.01 -3 -9.42 9 88.67 -6 -7.42 36 55.01 -7 -9.42 49 88.67 -9 -12.42 81 154.17 -8 -10.42 64 108.51 -7 -9.42 49 88.67 -7 -10.42 49 108.51 -5 -7.42 25 55.01 -1 -3.42 1 11.67 1 -3.42 1 11.67 0 -5.42 0 29.34 -2 -5.42 4 29.34 0 -6.42 0 41.17 -1 -11.42 1 130.34 0 0 1072 3267.83
24 12000
12000 6001072
233.25 -0.47
-0.47 0
10570 5286760
-380.48 1.64
(HAM-MED HAM)*(HAV-MED HAV) HAM-estimado HAV-estimado 316.17 512.16 463.4 283 512.7 460.12 241.58 510.01 461.76 167.25 510.01 455.19 95.08 507.32 451.91 67.92 507.32 448.63 11.17 503.01 443.7 6.58 503.55 442.06 17.08 498.16 432.21 22.25 496.01 435.49 28.25 494.93 435.49 44.5 496.01 430.57 65.92 494.93 428.92 111.75 493.31 425.64 83.33 494.39 427.28 65.92 494.93 428.92 72.92 494.39 428.92 37.08 496.01 432.21 3.42 498.16 438.77 -3.42 498.16 442.06 0 497.08 440.42 10.83 497.08 437.13 0 496.54 440.42 11.42 493.85 438.77
intercepto declividade
-380.48 1.64
Hav ( X) Ham (Y) Cont Num X^2 X^3 X^4 XY 463 514 24 214369 99252847 45954068161 237982 464 512 215296 99897344 46352367616 237568 459 513 210681 96702579 44386483761 235467 459 509 210681 96702579 44386483761 233631 454 507 206116 93576664 42483805456 230178 454 505 206116 93576664 42483805456 229270 446 502 198916 88716536 39567575056 223892 447 501 199809 89314623 39923636481 223947 437 495 190969 83453453 36469158961 216315 433 497 187489 81182737 35152125121 215201 431 497 185761 80062991 34507149121 214207 433 494 187489 81182737 35152125121 213902 431 493 185761 80062991 34507149121 212483 428 491 183184 78402752 33556377856 210148 430 492 184900 79507000 34188010000 211560 431 493 185761 80062991 34507149121 212483 430 493 184900 79507000 34188010000 211990 433 495 187489 81182737 35152125121 214335 437 499 190969 83453453 36469158961 218063 437 501 190969 83453453 36469158961 218937 435 500 189225 82312875 35806100625 217500 435 498 189225 82312875 35806100625 216630 434 500 188356 81746504 35477982736 217000 429 499 184041 78953589 33871089681 214071 Somatório 10570 12000 4658472 2054579974 ### 5286760
X^2Y Y estu]imado 110185666 512.52 110231552 513.15 108079353 510.06 107236629 510.06 104500812 507.1 104088580 507.1 99855832 502.61 100104309 503.16 94529655 497.94 93182033 495.99 92323217 495.04 92619566 495.99 91580173 495.04 89943344 493.66 90970800 494.58 91580173 495.04 91155700 494.58 92807055 495.99 95293531 497.94 95675469 497.94 94612500 496.95 94234050 496.95 94178000 496.47 91836459 494.12 2330804458
Matriz 24 10570 10570 4658472 4658472 2054579974
192201.95 -863.54 0.97
Matriz Inversa -863.54 3.88 0
4658472 2054579974 ###
0.97 0 0
Vetor 12000 5286760 2330804458
Resultado 747.61 -1.64 0
X
Somatório
Y 514 512 513 509 507 505 502 501 495 497 497 494 493 491 492 493 493 495 499 501 500 498 500 499 12000
Cont Num 24
X^2 X^3 X^4 XY X^2Y 463 264196 135796744 69799526416 237982 122322748 464 262144 134217728 68719476736 237568 121634816 459 263169 135005697 69257922561 235467 120794571 459 259081 131872229 67122964561 233631 118918179 454 257049 130323843 66074188401 230178 116700246 454 255025 128787625 65037750625 229270 115781350 446 252004 126506008 63506016016 223892 112393784 447 251001 125751501 63001502001 223947 112197447 437 245025 121287375 60037250625 216315 107075925 433 247009 122763473 61013446081 215201 106954897 431 247009 122763473 61013446081 214207 106460879 433 244036 120553784 59553569296 213902 105667588 431 243049 119823157 59072816401 212483 104754119 428 241081 118370771 58120048561 210148 103182668 430 242064 119095488 58594980096 211560 104087520 431 243049 119823157 59072816401 212483 104754119 430 243049 119823157 59072816401 211990 104511070 433 245025 121287375 60037250625 214335 106095825 437 249001 124251499 62001498001 218063 108813437 437 251001 125751501 63001502001 218937 109687437 435 250000 125000000 62500000000 217500 108750000 435 248004 123505992 61505984016 216630 107881740 434 250000 125000000 62500000000 217000 108500000 429 249001 124251499 62001498001 214071 106821429 10570 6001072 3001613076 ### 5286760 2644741794
Y ESTIMADO ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
24 12000 6001072
MATRIZ 12000 6001072 3001613076
MATRIZ INVERSA 1384713.32 -5513.39 -5513.39 21.95 5.49 -0.02
6001072 3001613076 ###
5.49 -0.02 0
VETOR 10570 5286760 2644741794
RESULTADO DE BETA 6936.91 -27.5 0.03
HAV x
SOMATORIO
HAM y Ln X 463 514 464 512 459 513 459 509 454 507 454 505 446 502 447 501 437 495 433 497 431 497 433 494 431 493 428 491 430 492 431 493 430 493 433 495 437 499 437 501 435 500 435 498 434 500 429 499 10570 12000
Cont Num 24
Ln Y 6.14 6.14 6.13 6.13 6.12 6.12 6.1 6.1 6.08 6.07 6.07 6.07 6.07 6.06 6.06 6.07 6.06 6.07 6.08 6.08 6.08 6.08 6.07 6.06 146.1
(Ln X)^2 6.24 6.24 6.24 6.23 6.23 6.22 6.22 6.22 6.2 6.21 6.21 6.2 6.2 6.2 6.2 6.2 6.2 6.2 6.21 6.22 6.21 6.21 6.21 6.21 149.15
(Ln X * Ln Y) 37.67 38.31 37.7 38.3 37.57 38.25 37.57 38.2 37.43 38.11 37.43 38.08 37.21 37.94 37.24 37.94 36.97 37.72 36.85 37.69 36.8 37.66 36.85 37.65 36.8 37.61 36.71 37.55 36.77 37.59 36.8 37.61 36.77 37.6 36.85 37.67 36.97 37.77 36.97 37.8 36.91 37.76 36.91 37.73 36.88 37.74 36.74 37.66 889.36 907.93
Y estimado 512.11 512.63 509.99 509.99 507.33 507.33 503.05 503.59 498.18 496 494.91 496 494.91 493.26 494.36 494.91 494.36 496 498.18 498.18 497.1 497.1 496.55 493.81 11999.88
Mat. 24 146.1
146.1 889.36
Mat. Invers 2248.18 -369.31 -369.31 60.67
149.15 907.93
Alfa 27.42
Beta 1 e beta 2 3.31 0.48
514 513 512 511 510 509 508 507 506 505 504 503 502 501 500 499 498 497 496 495 494 493 492 491 427.5
430
432.5
435
437.5
440
442.5
445
447.5
Column D
450
452.5
455
457.5
460
462.5
465
2.5
465
514 513 512 511 510 509 508 507 506 505 504 503 502 501 500 499 498 497 496 495 494 493 492 491 427.5
430
432.5
435
437.5
440
442.5
445
Column D
447.5 Column K
450
452.5
455
457.5
460
462.5
465
2.5
465
465 462.5 460 457.5 455 452.5 450 447.5 445 442.5 440 437.5 435 432.5 430 427.5 490
492.5
495
497.5
500
502.5 Column D
505
507.5
510
512.5
515
515
514 513 512 511 510 509 508 507 506 505 504 503 502 501 500 499 498 497 496 495 494 493 492 491 427.5
430
432.5
435
437.5
440
Column D
442.5
445
447.5
450
452.5
Power regression, Column D
455
457.5
460
462.5
465
2.5
465
