CEOSAL1.

RAW
Source: I took a random sample of data reported in the May 6, 1991 issue of Businessweek.
Notes: This kind of data collection is very easy for students just learning data analysis, and the
findings are sometimes interesting. A good term project is to have students collect a similar
data
set using a more recent issue of Businessweek.
salary roe
1095 20 27595 14.1 106.4 191 1 0 0
1001 32 9958 10.9 -30.6 13 1 0 0
1122 9 6125.9 23.5 -16.3 14 1 0 0
578 -9 16246 5.9 -25.7 -21 1 0 0
1368 7 21783.2 13.8 -3 56 1 0 0
1145 5 6021.4 20 1 55 1 0 0
1078 10 2266.7 16.4 -5.9 62 1 0 0
1094 7 2966.8 16.3 -1.6 44 1 0 0
1237 16 4570.2 10.5 -70.2 37 1 0 0
833 5 2830 26.3 -23.9 37 1 0 0
567 7 596.8 25.9 39.5 109 1 0 0
933 -3 19773 26.8 -26.8 -10 1 0 0
1339 -9 40047 14.8 12.1 41 1 0 0
937 9 2513.8 22.3 9.8 44 1 0 0
2011 49 1580.6 56.3 62.2 63 1 0 0
1585 4 6754 12.6 9.3 17 1 0 0
905 12 1066.3 20.4 33.8 141 1 0 0
1058 94 3199.9 1.9 -86.8 -15 1 0 0
922 48 1452.7 19.9 97.3 56 1 0 0
1220 -7 8995 15.4 19.5 28 1 0 0
1022 16 1212.3 38.7 162.9 83 1 0 0
759 12 2824.2 16.4 -9.4 21 1 0 0
1414 0 7621 24.4 -30.2 -10 1 0 0
1041 -11 4418.3 15.6 -7.5 74 1 0 0
1688 1 12343 14.4 -16.8 15 1 0 0
2983 13 57662 19 9.9 42 1 0 0
1160 0 4319.7 16.1 -23.3 -2 1 0 0
3844 61 20604 12.1 -5.9 18 1 0 0
476 6 611.3 16.2 -15.7 40 1 0 0
1492 10 12431.7 18.4 -23.3 58 1 0 0
1024 -3 8169 14.2 -36.2 -10 1 0 0
1593 18 20659 14.9 410.3 16 1 0 0
427 27 3072.1 12.4 -17.7 61 1 0 0
829 5 1669.1 17.1 -39.3 64 1 0 0
797 -3 2401.2 16.9 6 39 1 0 0
577 23 3043.6 18.1 -13.5 1 1 0 0
1342 7 6222.2 10.9 -6 59 1 0 0
1774 0 7727.9 19.3 15.3 19 1 0 0
709 11 719.5 18.3 4.6 65 1 0 0
860 28 3921.3 18.4 34.7 45 1 0 0
1336 20 5155.1 13.8 1.7 7 1 0 0
516 -2 649.2 13.7 -10.3 27 1 0 0
931 20 10885 12.7 14.5 10 1 0 0
815 12 1651.9 15.1 -2.4 33 1 0 0
1681 20 12915 16.5 -66.7 29 1 0 0
568 -36 11436 10.2 -48.3 -19 1 0 0
775 7 2210.3 19.6 18.9 34 1 0 0
1188 9 3737.8 12.8 32.5 15 1 0 0
782 -1 1976.7 15.9 -0.6 24 1 0 0
1170 0 2576 17.3 -39.1 93 1 0 0
1469 8 6309.1 8.5 93.9 79 1 0 0
916 -1 2940.5 16.4 25.8 105 1 0 0
1070 -9 1072.6 19.5 34.8 269 1 0 0
894 1 1534 19.2 -3.7 74 1 0 0
829 -4 2158.8 15.9 -27.6 -18 1 0 0
780 17 1736 19.9 50.7 23 1 0 0
2327 10 3598.8 28.1 -28.3 104 1 0 0
717 20 1413.6 25 -15.8 56 1 0 0
1368 9 13538 15 -8.8 -43 1 0 0
2028 185 69018 12.6 2.3 10 1 0 0
1195 2 6285 20.3 6.3 49 1 0 0
256 19 526.3 22.7 24.7 175 1 0 0
775 -10 3195.6 14.8 -32.6 12 1 0 0
1407 80 2762.8 13.2 -17.4 28 1 0 0
543 14 1873.1 10.3 -45 -58 1 0 0
874 -10 4648.1 17.7 -13.9 -6 1 0 0
1287 -3 16951 10 -1 -21 1 0 0
1248 16 3506.9 15.6 5 54 0 1 0
875 -19 5333.1 6.8 27.6 -8 0 1 0
925 -3 3296.2 12.4 -56.9 -21 0 1 0
798 -6 2584 13.1 -50.5 10 0 1 0
760 14 834.4 15.8 3 55 0 1 0
600 -41 4068.7 12.8 -32 -6 0 1 0
991 18 2518.6 15.3 13.3 65 0 1 0
1570 14 10465 0.5 977 36 0 1 0
911 1 2682.4 16.5 31.5 23 0 1 0
1360 12 2688.2 15.1 23 67 0 1 0
700 -53 6682.3 13 5.8 53 0 1 0
741 -50 4879.9 11.1 -77.7 -26 0 1 0
1097 143 2772.1 8.9 595.6 20 0 1 0
953 15 1320.4 17.5 -4.3 83 0 1 0
441 -7 3408.5 15.9 -10 37 0 1 0
595 18 1919.7 14.2 31.4 61 0 1 0
1067 1 19020.5 9.3 -37.8 4 0 1 0
1298 3 4778.3 9.5 -26.7 -2 0 1 0
1798 -31 24332 15.5 -59.5 2 0 1 0
4143 -10 2678.4 14.4 -12.8 42 0 1 0
1336 8 4481 11.1 10.8 15 0 1 0
1750 11 14932.1 15.9 -7.8 62 0 1 0
912 15 2626.4 16.4 0.3 70 0 1 0
1892 -16 2659.5 8.6 -1.4 126 0 1 0
833 19 1073.2 24.6 14.4 51 0 1 0
1142 -12 2577.3 15.4 -22.4 56 0 1 0
1159 13 4293.8 16.9 2.6 107 0 1 0
1283 16 18164 7.2 -47.3 14 0 1 0
2109 42 9944.4 11.6 -42.2 23 0 1 0
1039 -21 12719 26.4 43.4 264 0 1 0
992 42 1931.6 21.4 -9.2 52 0 1 0
1253 4 2993.2 19.2 1.9 74 0 1 0
 721 9 2127.2 15.1 -22.3 101 0 1 0
1351 4 4211.9 9 -18 -4 0 1 0
1391 25 8489.6 9.4 -27.3 26 0 1 0
1245 25 12222.8 19 -20.9 52 0 1 0
1550 0 11213.4 3.5 -55.4 6 0 1 0
2150 -61 5869.6 22.1 -38 68 0 1 0
1846 20 6193.8 10.9 -14.7 6 0 1 0
573 8 3053.2 15.1 -3.8 31 0 1 0
6640 4 8946 10.2 87.6 34 0 1 0
959 49 4045.2 17.3 -7.8 51 0 1 0
612 39 3618.9 33.3 -10.5 68 0 1 0
1820 69 1796.1 22.8 12.7 115 0 1 0
1411 2 6703.1 11.1 -37.2 28 0 1 0
1026 6 2170.3 12.4 134.6 162 0 1 0
1287 -12 4674 20.9 84.2 -47 0 0 0
800 162 3372 6.7 29 60 0 0 0
1115 -9 8205 7.1 13.9 23 0 0 0
1631 33 4617 11.8 227 75 0 0 0
1910 23 6964 14 2.7 43 0 0 0
996 -3 6623 10.1 -63.6 10 0 0 1
918 -35 29797 6.4 -95 -28 0 0 1
1261 21 5225.5 12.4 -54.9 1 0 0 1
1053 -8 3639 17.6 -22.3 5 0 0 1
1221 -43 97649.9 15.1 -85.2 -7 0 0 1
1738 19 10743.6 23.6 11.5 36 0 0 1
3142 15 10236.3 35.7 27.2 155 0 0 1
1900 26 17802.7 23.2 -7.8 142 0 0 1
427 21 6158.7 12.4 -17.7 95 0 0 1
1700 8 6775.2 44.4 37.7 61 0 0 1
360 103 298.7 2.1 23.1 302 0 0 1
459 9 785.3 18.4 -43.1 5 0 0 1
1340 5 1368.6 16.1 12.6 115 0 0 1
729 25 2066.1 15.1 -8.4 52 0 0 1
223 -6 181.5 22.7 32.6 295 0 0 1
2101 25 10300 23.4 46.9 76 0 0 1
1082 28 11232 25.7 -2.4 101 0 0 1
1781 31 5191.6 27 141 98 0 0 1
791 18 976.7 19.9 -13.2 89 0 0 1
2092 -11 7671.5 43.7 8.5 80 0 0 1
1573 10 6406 16.4 -11.5 87 0 0 1
1045 9 2917.4 11.6 -98.9 203 0 0 1
1694 12 3322.9 24.8 23.9 100 0 0 1
453 20 175.2 26.2 35.6 418 0 0 1
1130 1 1686.3 44.5 3.4 99 0 0 1
1334 13 514.1 22.3 62.4 358 0 0 1
1344 13 3032.7 22.3 62.4 36 0 0 1
1585 5 4686.9 35.1 2.2 111 0 0 1
1946 45 8388.1 13.1 5.9 88 0 0 1
1619 9 7632.8 11 22.6 32 0 0 1
1620 12 17453.8 19.4 -12.8 128 0 0 1
 967 -27 5781.1 28.5 -11 119 0 0 1
1431 0 6896.2 43.9 3.5 110 0 0 1
1231 9 6503.1 26.8 19.8 84 0 0 1
770 -4 2715.6 15.7 -2.5 63 0 0 1
1594 53 2761.9 15 27.8 85 0 0 1
1568 47 5181.4 28.2 -19.1 55 0 0 1
995 15 1323 15.4 74.6 195 0 0 1
1077 -16 5296 20 27.5 36 0 0 1
1161 9 7177 42.2 -2.8 68 0 0 1
1401 1 12183.5 19.6 -2.1 93 0 0 1
1127 4 7863.5 16.2 26 152 0 0 1
3068 -14 3825.6 21.5 -27.6 142 0 0 1
730 7 1110.6 29.5 20.5 60 0 0 1
729 -10 1391.3 22.6 -17.2 32 0 0 1
11233 17 6047.9 22.9 9.9 74 0 0 1
949 -11 18908 13 -46.7 -3 0 0 1
3646 -11 3921.5 7.8 -64.2 29 0 0 1
1502 212 3453.8 48.1 35.1 28 0 0 1
807 10 1558.5 18 -1 49 0 0 1
713 8 962.8 18 7.6 81 0 0 1
1489 0 25848 21.7 380.6 114 0 0 1
736 73 631.5 21.3 60.8 71 0 0 1
1226 53 1728.9 26.9 -7.1 84 0 0 1
543 112 2669.3 30.5 24.9 323 0 0 1
14822 1 2159.2 19.4 -37.3 17 0 0 1
890 -18 2612.6 15.6 -49 -14 0 0 1
1627 6 8270.3 19.4 -3.7 104 0 0 1
2408 28 44323 29.1 9.8 160 0 0 1
2248 6 764.7 40.8 44.4 191 0 0 1
787 20 5167.5 13.7 -4 34 0 0 0
474 -5 2159.3 11.1 -58.2 16 0 0 0
439 7 2617.1 10.8 -16.1 65 0 0 0
465 11 2367.7 5.1 -25 43 0 0 0
594 33 2744 12.3 -12.2 76 0 0 0
688 -6 2357.9 7.4 -9.7 33 0 0 0
607 12 5262 6.2 -94.8 59 0 0 0
634 44 5738.9 12.7 -7 38 0 0 0
532 2 2714.9 10.6 -21.2 35 0 0 0
441 39 3306.7 7.4 13 150 0 0 0
694 18 3532.5 12.6 -13.8 37 0 0 0
520 -6 3681.5 12.8 -7.7 64 0 0 0
757 12 3982.1 2.9 45.4 197 0 0 0
668 30 2996 13.5 -3.3 81 0 0 0
803 18 4178.6 10.7 -29.9 52 0 0 0
500 3 2616.3 11.9 -1.3 25 0 0 0
552 -5 2064.5 12.9 -16.8 37 0 0 0
412 -5 2225.5 10.1 -27.4 13 0 0 0
1100 58 9470.1 7.3 76.6 82 0 0 0
959 26 3783.2 14.6 5 65 0 0 0
333 34 2388.7 13.8 6.5 59 0 0 0
503 -19 3705.2 8.9 -96.8 29 0 0 0
448 -8 1411.7 14 -33.5 14 0 0 0
732 7 4800.1 12.9 -11.2 36 0 0 0
720 8 1771.9 14.5 13.6 78 0 0 0
808 -16 7198.5 14.7 7.4 49 0 0 0
930 10 1509.1 9 20.5 131 0 0 0
525 3 1097.1 15.5 20.1 72 0 0 0
658 32 4542.6 12.1 -7.8 68 0 0 0
555 6 2023 13.7 -14.6 60 0 0 0
626 0 1442.5 14.4 -10.2 62 0 0 0
0 6.998509 10.22539
0 6.908755 9.206132
0 7.022868 8.720281
0 6.359574 9.695602
0 7.221105 9.988894
0 7.04316 8.703075
0 6.982863 7.72608
0 6.997596 7.995239
0 7.120444 8.427312
0 6.725034 7.948032
0 6.340359 6.391582
0 6.838405 9.892073
0 7.199678 10.59781
0 6.842683 7.829551
0 7.606388 7.36556
0 7.36834 8.81789
0 6.807935 6.97195
0 6.964136 8.070875
0 6.826545 7.281179
0 7.106606 9.104424
0 6.929517 7.100275
0 6.632002 7.945981
0 7.254178 8.938663
0 6.947937 8.39351
0 7.4313 9.420844
0 8.000685 10.96235
0 7.056175 8.370941
0 8.254269 9.933241
0 6.165418 6.415588
0 7.307873 9.428005
0 6.931472 9.008101
0 7.373374 9.935906
0 6.056784 8.030117
0 6.72022 7.42004
0 6.680855 7.783724
0 6.357842 8.020797
0 7.201916 8.735879
0 7.480992 8.952593
0 6.563856 6.578557
0 6.756932 8.274179
0 7.197435 8.547742
0 6.246107 6.475741
0 6.836259 9.295141
0 6.703188 7.409681
0 7.427144 9.466145
0 6.342122 9.344522
0 6.652863 7.700883
0 7.080027 8.226253
0 6.661855 7.589184
0 7.064759 7.853993
0 7.292337 8.749748
0 6.820016 7.986335
0 6.975414 6.977841
0 6.795706 7.335634
0 6.72022 7.677308
0 6.659294 7.459339
0 7.752335 8.188355
0 6.575076 7.253895
0 7.221105 9.513256
0 7.614805 11.14212
0 7.085901 8.745921
0 5.545177 6.265872
0 6.652863 8.06953
0 7.249215 7.924
0 6.297109 7.53535
0 6.77308 8.444214
0 7.160069 9.738082
0 7.129298 8.162488
0 6.774224 8.581688
0 6.829794 8.100526
0 6.682108 7.857094
0 6.633318 6.726713
0 6.39693 8.311079
0 6.898715 7.831459
0 7.358831 9.255792
0 6.814543 7.894467
0 7.21524 7.896627
0 6.55108 8.807218
0 6.608001 8.49288
0 7.000334 7.927361
0 6.859615 7.18569
0 6.089045 8.134027
0 6.388561 7.559924
0 6.972606 9.853272
0 7.16858 8.47184
0 7.49443 10.09955
0 8.329175 7.892975
0 7.197435 8.407601
0 7.467371 9.611268
0 6.81564 7.873369
0 7.54539 7.885893
0 6.725034 6.9784
0 7.040536 7.854497
0 7.055313 8.364927
0 7.156956 9.807197
0 7.653969 9.204765
0 6.946014 9.450852
0 6.899723 7.566104
0 7.133296 8.004098
0 6.580639 7.662562
0 7.208601 8.345669
0 7.237778 9.046597
0 7.126891 9.411058
0 7.34601 9.324864
0 7.673223 8.677542
0 7.520776 8.731304
0 6.350886 8.023946
0 8.800867 9.098962
0 6.865891 8.305286
0 6.416732 8.193925
0 7.506592 7.493373
0 7.252054 8.810326
0 6.933423 7.682621
1 7.160069 8.449771
1 6.684612 8.123261
1 7.01661 9.012499
1 7.396949 8.4375
1 7.554859 8.848509
0 6.903747 8.798304
0 6.822197 10.30216
0 7.13966 8.561306
0 6.959399 8.199464
0 7.107426 11.48914
0 7.46049 9.282065
0 8.052615 9.233695
0 7.549609 9.787106
0 6.056784 8.725621
0 7.438384 8.821024
0 5.886104 5.69944
0 6.12905 6.666066
0 7.200425 7.221544
0 6.591674 7.633418
0 5.407172 5.201256
0 7.650169 9.2399
0 6.986567 9.326522
0 7.484931 8.554797
0 6.673298 6.88418
0 7.645876 8.945268
0 7.36074 8.764991
0 6.951772 7.978448
0 7.434848 8.108593
0 6.115892 5.165928
0 7.029973 7.430292
0 7.195937 6.242418
0 7.203405 8.017208
0 7.36834 8.452527
0 7.573531 9.03457
0 7.389564 8.94021
0 7.390182 9.767313
0 6.874198 8.66235
0 7.266129 8.838726
0 7.115582 8.780034
0 6.64639 7.906768
0 7.374002 7.923674
0 7.357556 8.552831
0 6.902743 7.187657
0 6.981935 8.574707
0 7.057037 8.878636
0 7.244942 9.407838
0 7.027315 8.969987
0 8.028781 8.249471
0 6.593045 7.012656
0 6.591674 7.237994
0 9.326612 8.707466
0 6.855409 9.847341
0 8.201385 8.274229
0 7.314553 8.14723
0 6.693324 7.351479
0 6.569481 6.869846
0 7.30586 10.15999
0 6.60123 6.448098
0 7.111512 7.455241
0 6.297109 7.889572
0 9.603868 7.677493
0 6.791222 7.868101
0 7.394493 9.020426
0 7.786552 10.69926
0 7.717796 6.639483
1 6.668228 8.550144
1 6.161207 7.677539
1 6.084499 7.869822
1 6.142037 7.769674
1 6.386879 7.917172
1 6.533789 7.765527
1 6.408529 8.568267
1 6.452049 8.655023
1 6.276643 7.90651
1 6.089045 8.103706
1 6.542472 8.169761
1 6.253829 8.211076
1 6.629363 8.289565
1 6.504288 8.005033
1 6.688354 8.337731
1 6.214608 7.869516
1 6.313548 7.632643
1 6.021023 7.707737
1 7.003066 9.155894
1 6.865891 8.238325
1 5.808143 7.778504
1 6.22059 8.217492
1 6.104793 7.25255
1 6.59578 8.476392
1 6.579251 7.479808
1 6.694562 8.881628
1 6.835185 7.319269
1 6.263398 7.000426
1 6.489205 8.421255
1 6.318968 7.612337
1 6.439351 7.274133
Observ salary roe x^2 x y xy x^2
1 1095 14.1 198.81 -3.08421053 -186.119617 574.032083 9.51235457
2 1001 10.9 118.81 -6.28421053 -280.119617 1760.33065 39.4913019
3 1122 23.5 552.25 6.31578947 -159.119617 -1004.966 39.8891967
4 578 5.9 34.81 -11.2842105 -703.119617 7934.14979 127.333407
5 1368 13.8 190.44 -3.38421053 86.8803828 -294.021506 11.4528809
6 1145 20 400 2.81578947 -136.119617 -383.284185 7.92867036
7 1078 16.4 268.96 -0.78421053 -203.119617 159.288542 0.61498615
8 1094 16.3 265.69 -0.88421053 -187.119617 165.453135 0.78182825
9 1237 10.5 110.25 -6.68421053 -44.1196172 294.90481 44.6786704
10 833 26.3 691.69 9.11578947 -448.119617 -4084.96409 83.0976177
11 567 25.9 670.81 8.71578947 -714.119617 -6224.11624 75.9649861
12 933 26.8 718.24 9.61578947 -348.119617 -3347.44495 92.4634072
13 1339 14.8 219.04 -2.38421053 57.8803828 -137.999018 5.68445983
14 937 22.3 497.29 5.11578947 -344.119617 -1760.44352 26.1713019
15 2011 56.3 3169.69 39.1157895 729.880383 28549.8474 1530.04499
16 1585 12.6 158.76 -4.58421053 303.880383 -1393.05165 21.0149861
17 905 20.4 416.16 3.21578947 -376.119617 -1209.52151 10.3413019
18 1058 1.9 3.61 -15.2842105 -223.119617 3410.2072 233.607091
19 922 19.9 396.01 2.71578947 -359.119617 -975.293276 7.37551247
20 1220 15.4 237.16 -1.78421053 -61.1196172 109.050264 3.1834072
21 1022 38.7 1497.69 21.5157895 -259.119617 -5575.16313 462.929197
22 759 16.4 268.96 -0.78421053 -522.119617 409.4517 0.61498615
23 1414 24.4 595.36 7.21578947 132.880383 958.836867 52.0676177
24 1041 15.6 243.36 -1.58421053 -240.119617 380.400025 2.50972299
25 1688 14.4 207.36 -2.78421053 406.880383 -1132.84064 7.75182825
26 2983 19 361 1.81578947 1701.88038 3090.25648 3.29709141
27 1160 16.1 259.21 -1.08421053 -121.119617 131.319164 1.17551247
28 3844 12.1 146.41 -5.08421053 2562.88038 -13030.2234 25.8491967
29 476 16.2 262.44 -0.98421053 -805.119617 792.407202 0.96867036
30 1492 18.4 338.56 1.21578947 210.880383 256.38615 1.47814404
31 1024 14.2 201.64 -2.98421053 -257.119617 767.299068 8.90551247
32 1593 14.9 222.01 -2.28421053 311.880383 -712.400453 5.21761773
33 427 12.4 153.76 -4.78421053 -854.119617 4086.28806 22.8886704
34 829 17.1 292.41 -0.08421053 -452.119617 38.0732309 0.00709141
35 797 16.9 285.61 -0.28421053 -484.119617 137.591891 0.08077562
36 577 18.1 327.61 0.91578947 -704.119617 -644.825334 0.83867036
37 1342 10.9 118.81 -6.28421053 60.8803828 -382.585142 39.4913019
38 1774 19.3 372.49 2.11578947 492.880383 1042.83113 4.4765651
39 709 18.3 334.89 1.11578947 -572.119617 -638.365047 1.24498615
40 860 18.4 338.56 1.21578947 -421.119617 -511.992798 1.47814404
41 1336 13.8 190.44 -3.38421053 54.8803828 -185.726769 11.4528809
42 516 13.7 187.69 -3.48421053 -765.119617 2665.83782 12.139723
43 931 12.7 161.29 -4.48421053 -350.119617 1570.01007 20.108144
44 815 15.1 228.01 -2.08421053 -466.119617 971.491413 4.34393352
45 1681 16.5 272.25 -0.68421053 399.880383 -273.602367 0.46814404
46 568 10.2 104.04 -6.98421053 -713.119617 4980.57754 48.7791967
47 775 19.6 384.16 2.41578947 -506.119617 -1222.67844 5.83603878
48 1188 12.8 163.84 -4.38421053 -93.1196172 408.256006 19.2213019
49 782 15.9 252.81 -1.28421053 -499.119617 640.974666 1.64919668
50 1170 17.3 299.29 0.11578947 -111.119617 -12.866482 0.0134072
51 1469 8.5 72.25 -8.68421053 187.880383 -1631.5928 75.4155125
 52 916 16.4 268.96 -0.78421053 -365.119617 286.330647 0.61498615
53 1070 19.5 380.25 2.31578947 -211.119617 -488.908587 5.36288089
54 894 19.2 368.64 2.01578947 -387.119617 -780.351649 4.0634072
55 829 15.9 252.81 -1.28421053 -452.119617 580.616772 1.64919668
56 780 19.9 396.01 2.71578947 -501.119617 -1360.93538 7.37551247
57 2327 28.1 789.61 10.9157895 1045.88038 11416.6101 119.15446
58 717 25 625 7.81578947 -564.119617 -4409.04017 61.0865651
59 1368 15 225 -2.18421053 86.8803828 -189.765047 4.77077562
60 2028 12.6 158.76 -4.58421053 746.880383 -3423.85691 21.0149861
61 1195 20.3 412.09 3.11578947 -86.1196172 -268.330597 9.70814404
62 256 22.7 515.29 5.51578947 -1025.11962 -5654.34399 30.4239335
63 775 14.8 219.04 -2.38421053 -506.119617 1206.69572 5.68445983
64 1407 13.2 174.24 -3.98421053 125.880383 -501.533946 15.8739335
65 543 10.3 106.09 -6.88421053 -738.119617 5081.37084 47.3923546
66 874 17.7 313.29 0.51578947 -407.119617 -209.988013 0.26603878
67 1287 10 100 -7.18421053 5.88038278 -42.2459078 51.6128809
68 1248 15.6 243.36 -1.58421053 -33.1196172 52.4684462 2.50972299
69 875 6.8 46.24 -10.3842105 -406.119617 4217.2316 107.831828
70 925 12.4 153.76 -4.78421053 -356.119617 1703.75122 22.8886704
71 798 13.1 171.61 -4.08421053 -483.119617 1973.16223 16.6807756
72 760 15.8 249.64 -1.38421053 -521.119617 721.33926 1.91603878
73 600 12.8 163.84 -4.38421053 -681.119617 2986.1718 19.2213019
74 991 15.3 234.09 -1.88421053 -290.119617 546.646437 3.55024931
75 1570 0.5 0.25 -16.6842105 288.880383 -4819.74112 278.362881
76 911 16.5 272.25 -0.68421053 -370.119617 253.239738 0.46814404
77 1360 15.1 228.01 -2.08421053 78.8803828 -164.403324 4.34393352
78 700 13 169 -4.18421053 -581.119617 2431.52682 17.5076177
79 741 11.1 123.21 -6.08421053 -540.119617 3286.20146 37.0176177
80 1097 8.9 79.21 -8.28421053 -184.119617 1525.28567 68.628144
81 953 17.5 306.25 0.31578947 -328.119617 -103.616721 0.09972299
82 441 15.9 252.81 -1.28421053 -840.119617 1078.89046 1.64919668
83 595 14.2 201.64 -2.98421053 -686.119617 2047.52538 8.90551247
84 1067 9.3 86.49 -7.88421053 -214.119617 1688.16414 62.1607756
85 1298 9.5 90.25 -7.68421053 16.8803828 -129.712415 59.0470914
86 1798 15.5 240.25 -1.68421053 516.880383 -870.535382 2.8365651
87 4143 14.4 207.36 -2.78421053 2861.88038 -7968.07749 7.75182825
88 1336 11.1 123.21 -6.08421053 54.8803828 -333.903803 37.0176177
89 1750 15.9 252.81 -1.28421053 468.880383 -602.141123 1.64919668
90 912 16.4 268.96 -0.78421053 -369.119617 289.467489 0.61498615
91 1892 8.6 73.96 -8.58421053 610.880383 -5243.92581 73.6886704
92 833 24.6 605.16 7.41578947 -448.119617 -3323.16074 54.9939335
93 1142 15.4 237.16 -1.78421053 -139.119617 248.218685 3.1834072
94 1159 16.9 285.61 -0.28421053 -122.119617 34.7076807 0.08077562
95 1283 7.2 51.84 -9.98421053 1.88038278 -18.7741375 99.6844598
96 2109 11.6 134.56 -5.58421053 827.880383 -4623.05835 31.1834072
97 1039 26.4 696.96 9.21578947 -242.119617 -2231.32342 84.9307756
98 992 21.4 457.96 4.21578947 -289.119617 -1218.86744 17.7728809
99 1253 19.2 368.64 2.01578947 -28.1196172 -56.6832284 4.0634072
100 721 15.1 228.01 -2.08421053 -560.119617 1167.4072 4.34393352
101 1351 9 81 -8.18421053 69.8803828 -571.915764 66.9813019
102 1391 9.4 88.36 -7.78421053 109.880383 -855.332032 60.5939335
103 1245 19 361 1.81578947 -36.1196172 -65.5856208 3.29709141
104 1550 3.5 12.25 -13.6842105 268.880383 -3679.41576 187.257618
105 2150 22.1 488.41 4.91578947 868.880383 4271.23304 24.1649861
106 1846 10.9 118.81 -6.28421053 564.880383 -3549.82725 39.4913019
107 573 15.1 228.01 -2.08421053 -708.119617 1475.87036 4.34393352
108 6640 10.2 104.04 -6.98421053 5358.88038 -37427.5488 48.7791967
109 959 17.3 299.29 0.11578947 -322.119617 -37.2980609 0.0134072
110 612 33.3 1108.89 16.1157895 -669.119617 -10783.3909 259.71867
111 1820 22.8 519.84 5.61578947 538.880383 3026.23878 31.5370914
112 1411 11.1 123.21 -6.08421053 129.880383 -790.219592 37.0176177
113 1026 12.4 153.76 -4.78421053 -255.119617 1220.54596 22.8886704
114 1287 20.9 436.81 3.71578947 5.88038278 21.8502644 13.8070914
115 800 6.7 44.89 -10.4842105 -481.119617 5044.15936 109.91867
116 1115 7.1 50.41 -10.0842105 -166.119617 1675.18519 101.691302
117 1631 11.8 139.24 -5.38421053 349.880383 -1883.82964 28.989723
118 1910 14 196 -3.18421053 628.880383 -2002.48753 10.1391967
119 996 10.1 102.01 -7.08421053 -285.119617 2019.84739 50.1860388
120 918 6.4 40.96 -10.7842105 -363.119617 3915.9584 116.299197
121 1261 12.4 153.76 -4.78421053 -20.1196172 96.2564845 22.8886704
122 1053 17.6 309.76 0.41578947 -228.119617 -94.8497356 0.17288089
123 1221 15.1 228.01 -2.08421053 -60.1196172 125.301939 4.34393352
124 1738 23.6 556.96 6.41578947 456.880383 2931.24835 41.1623546
125 3142 35.7 1274.49 18.5157895 1860.88038 34455.6694 342.83446
126 1900 23.2 538.24 6.01578947 618.880383 3723.05409 36.189723
127 427 12.4 153.76 -4.78421053 -854.119617 4086.28806 22.8886704
128 1700 44.4 1971.36 27.2157895 418.880383 11400.1603 740.699197
129 360 2.1 4.41 -15.0842105 -921.119617 13894.3622 227.533407
130 459 18.4 338.56 1.21578947 -822.119617 -999.524377 1.47814404
131 1340 16.1 259.21 -1.08421053 58.8803828 -63.8387308 1.17551247
132 729 15.1 228.01 -2.08421053 -552.119617 1150.73352 4.34393352
133 223 22.7 515.29 5.51578947 -1058.11962 -5836.36505 30.4239335
134 2101 23.4 547.56 6.21578947 819.880383 5096.20385 38.6360388
135 1082 25.7 660.49 8.51578947 -199.119617 -1695.66074 72.5186704
136 1781 27 729 9.81578947 499.880383 4906.7206 96.349723
137 791 19.9 396.01 2.71578947 -490.119617 -1331.0617 7.37551247
138 2092 43.7 1909.69 26.5157895 810.880383 21501.1335 703.087091
139 1573 16.4 268.96 -0.78421053 291.880383 -228.895669 0.61498615
140 1045 11.6 134.56 -5.58421053 -236.119617 1318.54165 31.1834072
141 1694 24.8 615.04 7.61578947 412.880383 3144.41007 58.0002493
142 453 26.2 686.44 9.01578947 -828.119617 -7466.15213 81.2844598
143 1130 44.5 1980.25 27.3157895 -151.119617 -4127.95165 746.152355
144 1334 22.3 497.29 5.11578947 52.8803828 270.524906 26.1713019
145 1344 22.3 497.29 5.11578947 62.8803828 321.6828 26.1713019
146 1585 35.1 1232.01 17.9157895 303.880383 5444.25696 320.975512
147 1946 13.1 171.61 -4.08421053 664.880383 -2715.51146 16.6807756
148 1619 11 121 -6.18421053 337.880383 -2089.52342 38.2444598
149 1620 19.4 376.36 2.21578947 338.880383 750.887585 4.90972299
150 967 28.5 812.25 11.3157895 -314.119617 -3554.51146 128.047091
151 1431 43.9 1927.21 26.7157895 149.880383 4004.17275 713.733407
152 1231 26.8 718.24 9.61578947 -50.1196172 -481.939688 92.4634072
153 770 15.7 246.49 -1.48421053 -511.119617 758.609116 2.20288089
154 1594 15 225 -2.18421053 312.880383 -683.396626 4.77077562
155 1568 28.2 795.24 11.0157895 286.880383 3160.2139 121.347618
156 995 15.4 237.16 -1.78421053 -286.119617 510.497633 3.1834072
157 1077 20 400 2.81578947 -204.119617 -574.75787 7.92867036
158 1161 42.2 1780.84 25.0157895 -120.119617 -3004.88706 625.789723
159 1401 19.6 384.16 2.41578947 119.880383 289.605767 5.83603878
160 1127 16.2 262.44 -0.98421053 -154.119617 151.68615 0.96867036
161 3068 21.5 462.25 4.31578947 1786.88038 7711.79955 18.6260388
162 730 29.5 870.25 12.3157895 -551.119617 -6787.47318 151.67867
163 729 22.6 510.76 5.41578947 -552.119617 -2990.16361 29.3307756
164 11233 22.9 524.41 5.71578947 9951.88038 56882.8531 32.6702493
165 949 13 169 -4.18421053 -332.119617 1389.6584 17.5076177
166 3646 7.8 60.84 -9.38421053 2364.88038 -22192.5354 88.0634072
167 1502 48.1 2313.61 30.9157895 220.880383 6828.69141 955.786039
168 807 18 324 0.81578947 -474.119617 -386.781793 0.66551247
169 713 18 324 0.81578947 -568.119617 -463.466004 0.66551247
170 1489 21.7 470.89 4.51578947 207.880383 938.744044 20.3923546
171 736 21.3 453.69 4.11578947 -545.119617 -2243.59758 16.939723
172 1226 26.9 723.61 9.71578947 -55.1196172 -535.530597 94.3965651
173 543 30.5 930.25 13.3157895 -738.119617 -9828.64543 177.310249
174 14822 19.4 376.36 2.21578947 13540.8804 30003.7402 4.90972299
175 890 15.6 243.36 -1.58421053 -391.119617 619.615815 2.50972299
176 1627 19.4 376.36 2.21578947 345.880383 766.398111 4.90972299
177 2408 29.1 846.81 11.9157895 1126.88038 13427.6694 141.986039
178 2248 40.8 1664.64 23.6157895 966.880383 22833.6436 557.705512
179 787 13.7 187.69 -3.48421053 -494.119617 1721.61677 12.139723
180 474 11.1 123.21 -6.08421053 -807.119617 4910.68567 37.0176177
181 439 10.8 116.64 -6.38421053 -842.119617 5376.26892 40.758144
182 465 5.1 26.01 -12.0842105 -816.119617 9862.16127 146.028144
183 594 12.3 151.29 -4.88421053 -687.119617 3356.03687 23.8555125
184 688 7.4 54.76 -9.78421053 -593.119617 5803.2072 95.7307756
185 607 6.2 38.44 -10.9842105 -674.119617 7404.6718 120.652881
186 634 12.7 161.29 -4.48421053 -647.119617 2901.8206 20.108144
187 532 10.6 112.36 -6.58421053 -749.119617 4932.36127 43.3518283
188 441 7.4 54.76 -9.78421053 -840.119617 8219.9072 95.7307756
189 694 12.6 158.76 -4.58421053 -587.119617 2691.47993 21.0149861
190 520 12.8 163.84 -4.38421053 -761.119617 3336.90864 19.2213019
191 757 2.9 8.41 -14.2842105 -524.119617 7486.63495 204.03867
192 668 13.5 182.25 -3.68421053 -613.119617 2258.86175 13.5734072
193 803 10.7 114.49 -6.48421053 -478.119617 3100.22825 42.0449861
194 500 11.9 141.61 -5.28421053 -781.119617 4127.6005 27.9228809
195 552 12.9 166.41 -4.28421053 -729.119617 3123.70194 18.3544598
196 412 10.1 102.01 -7.08421053 -869.119617 6157.02634 50.1860388
197 1100 7.3 53.29 -9.88421053 -181.119617 1790.22443 97.6976177
198 959 14.6 213.16 -2.58421053 -322.119617 832.424906 6.67814404
199 333 13.8 190.44 -3.38421053 -948.119617 3208.63639 11.4528809
200 503 8.9 79.21 -8.28421053 -778.119617 6446.10672 68.628144
201 448 14 196 -3.18421053 -833.119617 2652.82825 10.1391967
202 732 12.9 166.41 -4.28421053 -549.119617 2352.54404 18.3544598
203 720 14.5 210.25 -2.68421053 -561.119617 1506.16318 7.20498615
204 808 14.7 216.09 -2.48421053 -473.119617 1175.32873 6.17130194
205 930 9 81 -8.18421053 -351.119617 2873.63687 66.9813019
206 525 15.5 240.25 -1.68421053 -756.119617 1273.46462 2.8365651
207 658 12.1 146.41 -5.08421053 -623.119617 3168.07132 25.8491967
208 555 13.7 187.69 -3.48421053 -726.119617 2529.95361 12.139723
209 626 14.4 207.36 -2.78421053 -655.119617 1823.99093 7.75182825
 Suma 267754 3591.5 76810.61 1.0285E-12 3.3651E-11 279247.995 15093.5179
Promedio 1281.11962 17.1842105 367.51488 Sx^2

Fuente de Suma de Grados de Media de

Variación Cuadrados Libertad Cuadrados n obs= 209
Modelo 5166419.33 1 5166419.33 R-cuadrado= 0.01318862
Desv. Std.
Residuo 386566563 207 1867471.32 σ^2 Regresión= 1366.55454
Total 391732982 208 1883331.64 Sy^2

Interv. al 95%
Variables Coeficientes Desv. Std. t p-value Linf Lsup
β0 Intercepcion 963.191327 213.240257
β1 X 18.5011868 11.1232509

Var(β0)= 45471.4072
Var(β1)= 123.72671
 y^2 y^ e e^2 Recomendaciones:
34640.5119 1224.05806 -129.058062 16655.9834 1 Para seleccionar todos los 209 valores
78467 1164.85426 -163.854264 26848.2199 de cada variable 'X' e 'Y', se situan en
25319.0526 1397.96922 -275.969218 76159.0095 la base de datos 'CEOSAL1', en el
494377.196 1072.34833 -494.34833 244380.271 primer valor, luego con las tres teclas
apretadas: CTR+SHIFT+TECLA
7548.20091 1218.50771 149.492294 22347.946
HACIA ABAJO, se seleccionara
18528.5502 1333.21506 -188.215064 35424.9105 automaticamente todos los datos
41257.5789 1266.61079 -188.610792 35574.0308 existentes hacia abajo. Luego escriben
35013.7512 1264.76067 -170.760673 29159.2075 CTR+C y copian...y CTR+V pegan los
1946.54062 1157.45379 79.5462106 6327.59963 datos en la nueva hoja donde los
200811.191 1449.77254 -616.772542 380408.368 quieran colocar para procesar. Como
509966.828 1442.37207 -875.372067 766276.255 lo hice yo.
121187.268 1459.02313 -526.023135 276700.339 2 Les recomiendo que en la primera
3350.13871 1237.00889 101.991107 10402.1859 columna coloquen la/s variables Y,
118418.311 1375.76779 -438.767794 192517.177 luego la/s X. Esto les servirá para, a
532725.373 2004.80815 6.19185309 38.3390446 futuro exportar mejor la data al
software estadistico. Si bien en el
92343.287 1196.30628 388.693718 151082.807
ejemplo hecho en clases, primero
141465.966 1340.61554 -435.615539 189760.898 estaba las X y luego la Y. Sugiero
49782.3636 998.343582 59.6564175 3558.88815 colocarlas al reves. Ojo con las
128966.899 1331.36495 -409.364946 167579.659 formulas de los calculos, no
3735.60761 1248.1096 -28.1096049 790.149888 equivocarse haciendo los cambios.
67142.976 1679.18726 -657.187258 431895.093 3 Pueden cortar y pegar EN LA MISMA
272608.895 1266.61079 -507.610792 257668.716 UBICACIÓN Y DISTANCIA los
17657.1961 1414.62029 -0.62028652 0.38475537 calculos hechos en el archivo visto en
57657.4306 1251.80984 -210.809842 44440.7896 clases. Si lo hacen bien, las formulas
automaticamente 'jalarán' los calculos
165551.646 1229.60842 458.391582 210122.842
para esta nueva data.El único que
2896396.84 1314.71388 1668.28612 2783178.59 tendrán que cambiar es el de la
14669.9617 1261.06044 -101.060436 10213.2117 formula de obtención del estimador
6568355.86 1187.05569 2656.94431 7059353.08 'beta0' (ya que estará al reves los
648217.598 1262.91055 -786.910554 619228.221 valores de promedio de x e y, por el
44470.5358 1303.61317 188.386835 35489.5994 cambio de columnas). Todo lo demás
66110.4976 1225.90818 -201.908181 40766.9134 debiera estar bien.
97269.3732 1238.85901 354.140989 125415.84
729520.321 1192.60604 -765.606044 586152.615 4 Ello lo corroborarán revisando los
204412.148 1279.56162 -450.561623 203005.776 valores de los estimadores que se
234371.804 1275.86139 -478.861385 229308.226 indican ya calculados en el desarrollo
495784.435 1298.06281 -721.062809 519931.575 de los ejemplos (capturas). Debieran
ser iguales.
3706.42101 1164.85426 177.145736 31380.6117
242931.072 1320.26423 453.735766 205876.146 5
Ojo que para el calculo de 'n obs',
327320.856 1301.76305 -592.763047 351368.03 tambien deberán de variar la formula
177341.732 1303.61317 -443.613165 196792.641 de acuerdo a la cantidad de datos de
3011.85641 1218.50771 117.492294 13804.4392 la columna observaciones, de forma tal
585408.029 1216.65759 -700.657587 490921.055 que les salga todo bien.
122583.746 1198.1564 -267.1564 71372.5423 6 Finalmente, pueden generar el grafico
217267.498 1242.55925 -427.559249 182806.911 de dispersion, su linea de regresion y
159904.321 1268.46091 412.53909 170188.5 la ecuacion de la recta. Los resultados
508539.588 1151.90343 -583.903433 340943.219 debieran darles igual. Ojo noten el
comportamiento del grafico y lleven
256157.067 1325.81459 -550.81459 303396.712
sus opiniones a la clase proxima.
8671.26311 1200.00652 -12.0065191 144.156501
249120.392 1257.3602 -475.360198 225967.318 7 Tambien pueden generar con la
12347.5693 1283.26186 -113.26186 12828.2489 herramienta de 'Analisis de Datos' la
35299.0382 1120.45142 348.548584 121486.116 regresion, tal como se indicó en clases.
Los resultados debieran ser
iguales.Pueden generar la misma
gráfica tambien con dicha herramienta,
tal como se muestra lo hice yo.
 Tambien pueden generar con la
herramienta de 'Analisis de Datos' la
regresion, tal como se indicó en clases.
133312.335 1266.61079 -350.610792 122927.927 Los resultados debieran ser
iguales.Pueden generar la misma
44571.4928 1323.96447 -253.964471 64497.9525
gráfica tambien con dicha herramienta,
149861.598 1318.41411 -424.414115 180127.341 tal como se muestra lo hice yo.
204412.148 1257.3602 -428.360198 183492.46
251120.871 1331.36495 -551.364946 304003.303
1093865.78 1483.07468 843.925322 712209.949
318230.943 1425.721 -708.720999 502285.454
7548.20091 1240.70913 127.29087 16202.9655
557830.306 1196.30628 831.693718 691714.441
7416.58847 1338.76542 -143.76542 20668.4961
1050870.23 1383.16827 -1127.16827 1270508.31
256157.067 1237.00889 -462.008893 213452.217
15845.8708 1207.40699 199.593006 39837.3681
544820.569 1153.75355 -610.753552 373019.901
165746.383 1290.66233 -416.662335 173607.501
34.5789016 1148.2032 138.796804 19264.5528
1096.90905 1251.80984 -3.80984227 14.5148982
164933.143 1088.9994 -213.999398 45795.7424
126821.182 1192.60604 -267.606044 71612.995
233404.565 1205.55688 -407.556875 166102.606
271565.655 1255.51008 -495.51008 245530.239
463923.933 1200.00652 -600.006519 360007.823
84169.3923 1246.25949 -255.259486 65157.4053
83451.8756 972.441921 597.558079 357075.658
136988.531 1268.46091 -357.46091 127778.302
6222.11479 1242.55925 117.440751 13792.33
337700.01 1203.70676 -503.706756 253720.497
291729.201 1168.5545 -427.554501 182802.852
33900.0334 1127.85189 -30.8518904 951.839142
107662.483 1286.9621 -333.962097 111530.682
705800.971 1257.3602 -816.360198 666443.973
470760.129 1225.90818 -630.908181 398045.132
45847.2105 1135.25237 -68.2523651 4658.38535
284.947323 1138.9526 159.047397 25296.0746
267165.33 1249.95972 548.040276 300348.145
8190359.33 1229.60842 2913.39158 8487850.51
3011.85641 1168.5545 167.445499 28037.995
219848.813 1257.3602 492.639802 242693.974
136249.292 1266.61079 -354.610792 125748.814
373174.842 1122.30153 769.698466 592435.728
200811.191 1418.32052 -585.320524 342600.116
19354.2679 1248.1096 -106.109605 11259.2483
14913.2009 1275.86139 -116.861385 13656.5833
3.53583938 1096.39987 186.600127 34819.6075
685385.928 1177.80509 931.194905 867123.951
58621.909 1451.62266 -412.62266 170257.46
83590.1531 1359.11673 -367.116726 134774.69
790.712873 1318.41411 -65.4141149 4279.00643
313733.986 1242.55925 -521.559249 272024.05
4883.2679 1129.70201 221.297991 48972.8008
12073.6985 1137.10248 253.897516 64463.9487
1304.62675 1314.71388 -69.7138776 4860.02472
72296.6602 1027.94548 522.054519 272540.92
 754953.12 1372.06756 777.932443 605178.886
319089.847 1164.85426 681.145736 463959.514
501433.392 1242.55925 -669.559249 448309.588
28717599 1151.90343 5488.09657 30119203.9
103761.048 1283.26186 -324.26186 105145.754
447721.062 1579.28085 -967.280849 935632.242
290392.067 1385.01839 434.981612 189209.003
16868.9138 1168.5545 242.445499 58779.8198
65086.0191 1192.60604 -166.606044 27757.574
34.5789016 1349.86613 -62.8661326 3952.15062
231476.086 1087.14928 -287.149279 82454.7086
27595.7272 1094.54975 20.4502459 418.212558
122416.282 1181.50533 449.494668 202045.456
395490.536 1222.20794 687.792057 473057.913
81293.1961 1150.05331 -154.053315 23732.4237
131855.856 1081.59892 -163.598923 26764.6077
404.798997 1192.60604 68.3939556 4677.73317
52038.5598 1288.81222 -235.812216 55607.4012
3614.36838 1242.55925 -21.5592489 464.801211
208739.684 1399.81934 338.180663 114366.161
3462875.8 1623.6837 1518.3163 2305284.39
383012.928 1392.41886 507.581138 257638.611
729520.321 1192.60604 -765.606044 586152.615
175460.775 1784.64402 -84.6440234 7164.6107
848461.349 1002.04382 -642.04382 412220.267
675880.665 1303.61317 -844.613165 713371.399
3466.89948 1261.06044 78.9395643 6231.45481
304836.072 1242.55925 -513.559249 263743.102
1119617.12 1383.16827 -1160.16827 1345990.41
672203.842 1396.1191 704.8809 496857.084
39648.622 1438.67183 -356.671829 127214.794
249880.397 1462.72337 318.276628 101300.012
240217.239 1331.36495 -540.364946 291994.275
657526.995 1771.69319 320.306807 102596.451
85194.1578 1266.61079 306.389208 93874.3469
55752.4736 1177.80509 -132.805095 17637.1932
170470.21 1422.02076 271.979239 73972.7063
685782.1 1447.92242 -994.922423 989870.627
22837.1387 1786.49414 -656.494142 430984.559
2796.33488 1375.76779 -41.7677941 1744.54863
3953.94254 1375.76779 -31.7677941 1009.19274
92343.287 1612.58299 -27.5829858 760.821104
442065.923 1205.55688 740.443125 548256.021
114163.153 1166.70438 452.295617 204571.325
114839.914 1322.11435 297.885648 88735.8591
98671.1339 1490.47515 -523.475153 274026.235
22464.1291 1775.39343 -344.39343 118606.835
2511.97603 1459.02313 -228.023135 51994.5501
261243.263 1253.65996 -483.659961 233926.958
97894.1339 1240.70913 353.29087 124814.439
82300.354 1484.9248 83.0752035 6901.48943
81864.4354 1248.1096 -253.109605 64064.4721
41664.8181 1333.21506 -256.215064 65646.1592
14428.7224 1743.94141 -582.941412 339820.69
14371.3062 1325.81459 75.1854103 5652.84593
23752.8564 1262.91055 -135.910554 18471.6788
3192941.5 1360.96684 1707.03316 2913962.19
303732.832 1508.97634 -778.976339 606804.137
304836.072 1381.31815 -652.31815 425518.969
99039923.2 1386.86851 9846.13149 96946305.4
110303.44 1203.70676 -254.706756 64875.5318
5592659.22 1107.50058 2538.49942 6443979.28
48788.1435 1853.09841 -351.098415 123270.097
224789.411 1296.21269 -489.212691 239329.057
322759.899 1296.21269 -583.212691 340137.043
43214.2535 1364.66708 124.332918 15458.6745
297155.397 1357.26661 -621.266607 385972.197
3038.1722 1460.87325 -234.873254 55165.4453
544820.569 1527.47753 -984.477526 969196
183355442 1322.11435 13499.8856 182246913
152974.555 1251.80984 -361.809842 130906.362
119633.239 1322.11435 304.885648 92955.2582
1269859.4 1501.57586 906.424135 821604.713
934857.675 1718.03975 529.960249 280857.866
244154.196 1216.65759 -429.657587 184605.642
651442.077 1168.5545 -694.554501 482405.956
709165.45 1163.00415 -724.004145 524182.003
666051.23 1057.54738 -592.54738 351112.398
472133.368 1190.75593 -596.755926 356117.635
351790.88 1100.10011 -412.10011 169826.501
454437.258 1077.89869 -470.898686 221745.572
418763.799 1198.1564 -564.1564 318272.444
561180.201 1159.30391 -627.303908 393510.193
705800.971 1100.10011 -659.10011 434412.955
344709.445 1196.30628 -502.306282 252311.601
579303.072 1200.00652 -680.006519 462408.866
274701.373 1016.84477 -259.844769 67519.3041
375915.665 1212.95735 -544.95735 296978.513
228598.368 1161.15403 -358.154027 128274.307
610147.856 1183.35545 -683.355451 466974.672
531615.416 1201.85664 -649.856638 422313.65
755368.909 1150.05331 -738.053315 544722.695
32804.3157 1098.24999 1.75000855 3.06252992
103761.048 1233.30866 -274.308655 75245.2384
898930.809 1218.50771 -885.507706 784123.897
605470.139 1127.85189 -624.85189 390439.885
694088.297 1222.20794 -774.207943 599397.939
301532.354 1201.85664 -469.856638 220765.26
314855.225 1231.45854 -511.458537 261589.835
223842.172 1235.15877 -427.158774 182464.618
123284.986 1129.70201 -199.702009 39880.8924
571716.876 1249.95972 -724.959724 525566.601
388278.057 1187.05569 -529.055688 279899.921
527249.699 1216.65759 -661.657587 437790.763
429181.713 1229.60842 -603.608418 364343.122
391732982 267754 -2.6603E-11 386566563

CeoSal1
16000

14000

12000

10000

8000

6000

4000

2000
f(x) = 18.5011868461902 x + 963.191327473243
0
0 10 20 30 40 50 60

CeoSal1 (con ejes de 'y' reducidos, para que se vea más

similar al ejemplo desarrollado)
2500

2000
f(x) = 18.5011868461902 x + 963.191327473243

1500

1000

500

0
0 10 20 30 40 50 60
Resumen

Estadísticas de la regresión
Coeficiente de0.11484174
Coeficiente d 0.01318862
R^2 ajustado 0.00842142
Error típico 1366.55454
Observacione 209

ANÁLISIS DE VARIANZA
Grados de libertad
Suma de cuadrados
Promedio de los cuadradosF Valor crítico de F
Regresión 1 5166419.33 5166419.33 2.76653209 0.09776774
Residuos 207 386566563 1867471.32
Total 208 391732982

Coeficientes Error típico Estadístico t Probabilidad Inferior 95% Superior 95%Inferior 95.0%
Intercepción 963.191327 213.240257 4.51693006 1.0534E-05 542.79021 1383.59245 542.79021
roe 18.5011868 11.1232509 1.66328954 0.09776774 -3.42819541 40.4305691 -3.42819541

Análisis de los residuales

Observación
Pronóstico salaryResiduos
1 1224.05806 -129.058062
2 1164.85426 -163.854264
3 1397.96922 -275.969218
4 1072.34833 -494.34833
5 1218.50771 149.492294
6 1333.21506 -188.215064
7 1266.61079 -188.610792
8 1264.76067 -170.760673
9 1157.45379 79.5462106
10 1449.77254 -616.772542
11 1442.37207 -875.372067
12 1459.02313 -526.023135
13 1237.00889 101.991107
14 1375.76779 -438.767794
15 2004.80815 6.19185309
16 1196.30628 388.693718
17 1340.61554 -435.615539
18 998.343582 59.6564175
19 1331.36495 -409.364946
20 1248.1096 -28.1096049
21 1679.18726 -657.187258
22 1266.61079 -507.610792
23 1414.62029 -0.62028652
24 1251.80984 -210.809842
25 1229.60842 458.391582
26 1314.71388 1668.28612
27 1261.06044 -101.060436
28 1187.05569 2656.94431
29 1262.91055 -786.910554
30 1303.61317 188.386835
31 1225.90818 -201.908181
32 1238.85901 354.140989
33 1192.60604 -765.606044
34 1279.56162 -450.561623
35 1275.86139 -478.861385
36 1298.06281 -721.062809
37 1164.85426 177.145736
38 1320.26423 453.735766
39 1301.76305 -592.763047
40 1303.61317 -443.613165
41 1218.50771 117.492294
42 1216.65759 -700.657587
43 1198.1564 -267.1564
44 1242.55925 -427.559249
45 1268.46091 412.53909
46 1151.90343 -583.903433
47 1325.81459 -550.81459
48 1200.00652 -12.0065191
49 1257.3602 -475.360198
50 1283.26186 -113.26186
51 1120.45142 348.548584
52 1266.61079 -350.610792
53 1323.96447 -253.964471
54 1318.41411 -424.414115
55 1257.3602 -428.360198
56 1331.36495 -551.364946
57 1483.07468 843.925322
58 1425.721 -708.720999
59 1240.70913 127.29087
60 1196.30628 831.693718
61 1338.76542 -143.76542
62 1383.16827 -1127.16827
63 1237.00889 -462.008893
64 1207.40699 199.593006
65 1153.75355 -610.753552
66 1290.66233 -416.662335
67 1148.2032 138.796804
68 1251.80984 -3.80984227
69 1088.9994 -213.999398
70 1192.60604 -267.606044
71 1205.55688 -407.556875
72 1255.51008 -495.51008
73 1200.00652 -600.006519
74 1246.25949 -255.259486
75 972.441921 597.558079
76 1268.46091 -357.46091
77 1242.55925 117.440751
78 1203.70676 -503.706756
79 1168.5545 -427.554501
80 1127.85189 -30.8518904
81 1286.9621 -333.962097
82 1257.3602 -816.360198
 83 1225.90818 -630.908181
84 1135.25237 -68.2523651
85 1138.9526 159.047397
86 1249.95972 548.040276
87 1229.60842 2913.39158
88 1168.5545 167.445499
89 1257.3602 492.639802
90 1266.61079 -354.610792
91 1122.30153 769.698466
92 1418.32052 -585.320524
93 1248.1096 -106.109605
94 1275.86139 -116.861385
95 1096.39987 186.600127
96 1177.80509 931.194905
97 1451.62266 -412.62266
98 1359.11673 -367.116726
99 1318.41411 -65.4141149
100 1242.55925 -521.559249
101 1129.70201 221.297991
102 1137.10248 253.897516
103 1314.71388 -69.7138776
104 1027.94548 522.054519
105 1372.06756 777.932443
106 1164.85426 681.145736
107 1242.55925 -669.559249
108 1151.90343 5488.09657
109 1283.26186 -324.26186
110 1579.28085 -967.280849
111 1385.01839 434.981612
112 1168.5545 242.445499
113 1192.60604 -166.606044
114 1349.86613 -62.8661326
115 1087.14928 -287.149279
116 1094.54975 20.4502459
117 1181.50533 449.494668
118 1222.20794 687.792057
119 1150.05331 -154.053315
120 1081.59892 -163.598923
121 1192.60604 68.3939556
122 1288.81222 -235.812216
123 1242.55925 -21.5592489
124 1399.81934 338.180663
125 1623.6837 1518.3163
126 1392.41886 507.581138
127 1192.60604 -765.606044
128 1784.64402 -84.6440234
129 1002.04382 -642.04382
130 1303.61317 -844.613165
131 1261.06044 78.9395643
132 1242.55925 -513.559249
133 1383.16827 -1160.16827
134 1396.1191 704.8809
135 1438.67183 -356.671829
136 1462.72337 318.276628
137 1331.36495 -540.364946
138 1771.69319 320.306807
139 1266.61079 306.389208
140 1177.80509 -132.805095
141 1422.02076 271.979239
142 1447.92242 -994.922423
143 1786.49414 -656.494142
144 1375.76779 -41.7677941
145 1375.76779 -31.7677941
146 1612.58299 -27.5829858
147 1205.55688 740.443125
148 1166.70438 452.295617
149 1322.11435 297.885648
150 1490.47515 -523.475153
151 1775.39343 -344.39343
152 1459.02313 -228.023135
153 1253.65996 -483.659961
154 1240.70913 353.29087
155 1484.9248 83.0752035
156 1248.1096 -253.109605
157 1333.21506 -256.215064
158 1743.94141 -582.941412
159 1325.81459 75.1854103
160 1262.91055 -135.910554
161 1360.96684 1707.03316
162 1508.97634 -778.976339
163 1381.31815 -652.31815
164 1386.86851 9846.13149
165 1203.70676 -254.706756
166 1107.50058 2538.49942
167 1853.09841 -351.098415
168 1296.21269 -489.212691
169 1296.21269 -583.212691
170 1364.66708 124.332918
171 1357.26661 -621.266607
172 1460.87325 -234.873254
173 1527.47753 -984.477526
174 1322.11435 13499.8856
175 1251.80984 -361.809842
176 1322.11435 304.885648
177 1501.57586 906.424135
178 1718.03975 529.960249
179 1216.65759 -429.657587
180 1168.5545 -694.554501
181 1163.00415 -724.004145
182 1057.54738 -592.54738
183 1190.75593 -596.755926
184 1100.10011 -412.10011
185 1077.89869 -470.898686
186 1198.1564 -564.1564
187 1159.30391 -627.303908
188 1100.10011 -659.10011
189 1196.30628 -502.306282
190 1200.00652 -680.006519
191 1016.84477 -259.844769
192 1212.95735 -544.95735
193 1161.15403 -358.154027
194 1183.35545 -683.355451
195 1201.85664 -649.856638
196 1150.05331 -738.053315
197 1098.24999 1.75000855
198 1233.30866 -274.308655
199 1218.50771 -885.507706
200 1127.85189 -624.85189
201 1222.20794 -774.207943
202 1201.85664 -469.856638
203 1231.45854 -511.458537
204 1235.15877 -427.158774
205 1129.70201 -199.702009
206 1249.95972 -724.959724
207 1187.05569 -529.055688
208 1216.65759 -661.657587
209 1229.60842 -603.608418
 roe Curva de regresión ajustada
16000

14000

12000

10000
salary
salary

8000
Pronóstico salar
6000

Superior 95.0% 4000

1383.59245
2000
40.4305691
0
0 10 20 30 40 50 60
roe
ada

salary
Pronóstico salary

60
 salary roe Nota: Este cuadro lo obtienen con la herramienta de 'Anális
Selesccionan los rangos de las columnas de datos (de las v
Media 1281.11962 Media 17.1842105 variable (primera fila) deben seleccionar la opcion que lo es
Error típico 94.9271099 Error típico 0.58923757 estadisticos. Luego 'Ok'.
Mediana 1039 Mediana 15.5
Moda 1368 Moda 15.1
Desviación e 1372.34531 Desviación e 8.51850867
Varianza de l 1883331.64 Varianza de l 72.5649899
Curtosis 58.9712294 Curtosis 3.79736605
Coeficiente d 6.9045768 Coeficiente d 1.57212587
Rango 14599 Rango 55.8
Mínimo 223 Mínimo 0.5
Máximo 14822 Máximo 56.3
Suma 267754 Suma 3591.5
Cuenta 209 Cuenta 209
en con la herramienta de 'Análisis de Datos´: Estadistica descriptiva.
las columnas de datos (de las variables 'X'' e 'Y', y si incluyen el nombre de la
seleccionar la opcion que lo estan haciendo. Marcan resumen de