-------------------------------------------------------------------------------------------------------------------
name: <unnamed>
log: C:\Users\Michael\Documents\newer web pages\soc_meth_proj3\fall_2016_logs\class11.log
log type: text
opened on: 2 Nov 2016, 10:17:29
. *(8 variables, 11 observations pasted into data editor)
*Bring in the Anscombe data by copying from Excel to Stata’s data editor.
. twoway (scatter y2 x2) (lfit y2 x2)
. twoway (scatter y1 x1) (lfit y1 x1)
*graph the data, with OLS line overlay, then describe the line:
. regress y1 x1
Source | SS df MS Number of obs = 11
-------------+------------------------------ F( 1, 9) = 17.99
Model | 27.5100011 1 27.5100011 Prob > F = 0.0022
Residual | 13.7626904 9 1.52918783 R-squared = 0.6665
-------------+------------------------------ Adj R-squared = 0.6295
Total | 41.2726916 10 4.12726916 Root MSE = 1.2366
------------------------------------------------------------------------------
y1 | Coef. Std. Err. t P>|t| [95% Conf. Interval]
-------------+----------------------------------------------------------------
x1 | .5000909 .1179055 4.24 0.002 .2333701 .7668117
_cons | 3.000091 1.124747 2.67 0.026 .4557369 5.544445
------------------------------------------------------------------------------
. clear all
. use "C:\Users\Michael\Documents\newer web pages\soc_meth_proj3\fifty_state_dataset.dta", clear
* In our scatter plot of states by income and pct white, which states are the biggest residuals, and which states are the most influential on the slope of the line?
. twoway (scatter incwage NH_White_proportion, mlabel(statefip)) (lfit incwage NH_White_proportion)
. summarize NH_White_proportion
Variable | Obs Mean Std. Dev. Min Max
-------------+--------------------------------------------------------
NH_White_p~n | 51 .7626632 .1633623 .2354178 .9835737
. regress incwage NH_White_proportion
Source | SS df MS Number of obs = 51
-------------+------------------------------ F( 1, 49) = 2.14
Model | 18878316.5 1 18878316.5 Prob > F = 0.1500
Residual | 432407199 49 8824636.71 R-squared = 0.0418
-------------+------------------------------ Adj R-squared = 0.0223
Total | 451285515 50 9025710.3 Root MSE = 2970.6
-------------------------------------------------------------------------------------
incwage | Coef. Std. Err. t P>|t| [95% Conf. Interval]
--------------------+----------------------------------------------------------------
NH_White_proportion | -3761.36 2571.649 -1.46 0.150 -8929.282 1406.562
_cons | 22161.23 2004.928 11.05 0.000 18132.18 26190.29
-------------------------------------------------------------------------------------
. predict M1_predicted
(option xb assumed; fitted values)
. gen residual=incwage- M1_predicted
. gen abs_residual=abs(residual)
. gsort -abs_residual
. dfbeta( NH_White_proportion)
_dfbeta_1: dfbeta(NH_White_proportion)
*The dfbetas explain how much the slope of the line changes (in units of the SE of the slope) due to each point, or in this case, due to each state.
. gen abs_dfbeta=abs( _dfbeta_1)
. list statefip abs_residual residual abs_dfbeta _dfbeta_1
*CT and NJ have the biggest absolute value residuals.
+--------------------------------------------------------------------+
| statefip abs_re~l residual abs_df~a _dfbeta_1 |
|--------------------------------------------------------------------|
1. | Connecticut 5617.314 5617.314 .0487289 .0487289 |
2. | New Jersey 5432.736 5432.736 .1172426 -.1172426 |
3. | New Mexico 5139.932 -5139.932 .5375599 .5375599 |
4. | Montana 5024.921 -5024.921 .2145686 -.2145686 |
5. | Mississippi 5009.293 -5009.293 .2366829 .2366829 |
|--------------------------------------------------------------------|
6. | Maryland 4840.275 4840.275 .1743481 -.1743481 |
7. | West Virginia 4798.199 -4798.199 .2921322 -.2921322 |
8. | Massachusetts 4666.598 4666.598 .098265 .098265 |
9. | Arkansas 4460.403 -4460.403 .0185422 -.0185422 |
10. | Colorado 4390.833 4390.833 .0056333 .0056333 |
|--------------------------------------------------------------------|
11. | North Dakota 4204.203 -4204.203 .192666 -.192666 |
12. | Minnesota 4187.81 4187.81 .1740437 .1740437 |
13. | Alaska 3780.312 3780.312 .0506594 -.0506594 |
14. | Louisiana 3555.554 -3555.554 .1484154 .1484154 |
15. | Alabama 3416.563 -3416.563 .0482474 .0482474 |
|--------------------------------------------------------------------|
16. | District of Columbia 3381.999 3381.999 .5903278 -.5903278 |
17. | Michigan 3208.876 3208.876 .0356351 .0356351 |
18. | New Hampshire 3021.199 3021.199 .1813799 .1813799 |
19. | South Dakota 2937.162 -2937.162 .1303558 -.1303558 |
20. | Virginia 2706.413 2706.413 .0332524 -.0332524 |
|--------------------------------------------------------------------|
21. | Illinois 2687.422 2687.422 .04929 -.04929 |
22. | Washington 2536.313 2536.313 .0665131 .0665131 |
23. | Oklahoma 2383.868 -2383.868 .0102179 -.0102179 |
24. | Idaho 2289.952 -2289.952 .070259 -.070259 |
25. | Kentucky 2257.391 -2257.391 .075205 -.075205 |
|--------------------------------------------------------------------|
26. | Wisconsin 2079.558 2079.558 .0656909 .0656909 |
27. | South Carolina 1986.75 -1986.75 .022419 .022419 |
28. | Delaware 1970.206 1970.206 .0329438 -.0329438 |
29. | Wyoming 1860.133 -1860.133 .0957266 -.0957266 |
30. | Florida 1833.188 -1833.188 .0603009 .0603009 |
|--------------------------------------------------------------------|
31. | Arizona 1755.73 -1755.73 .062599 .062599 |
32. | Hawaii 1728.106 -1728.106 .3419163 .3419163 |
33. | Rhode Island 1562.148 1562.148 .0499289 .0499289 |
34. | Missouri 1460.693 1460.693 .0429018 .0429018 |
35. | Nebraska 1231.4 -1231.4 .0429309 -.0429309 |
|--------------------------------------------------------------------|
36. | Ohio 1017.316 1017.316 .024228 .024228 |
37. | Kansas 1001.302 -1001.302 .021283 -.021283 |
38. | New York 998.9494 998.9494 .0335865 -.0335865 |
39. | Georgia 939.2884 -939.2884 .0433774 .0433774 |
40. | Texas 873.475 -873.475 .0654734 .0654734 |
|--------------------------------------------------------------------|
41. | Utah 544.7642 -544.7642 .0203697 -.0203697 |
42. | Maine 536.482 -536.482 .0362305 -.0362305 |
43. | Nevada 347.9611 347.9611 .0080656 -.0080656 |
44. | Vermont 328.0741 -328.0741 .0203959 -.0203959 |
45. | California 294.7873 294.7873 .0240138 -.0240138 |
|--------------------------------------------------------------------|
46. | Oregon 241.7805 241.7805 .0072873 .0072873 |
47. | Pennsylvania 230.294 -230.294 .0063625 -.0063625 |
48. | Indiana 165.3883 -165.3883 .0053708 -.0053708 |
49. | Tennessee 89.31062 89.31062 .0009869 .0009869 |
50. | North Carolina 46.82497 -46.82497 .0009033 .0009033 |
|--------------------------------------------------------------------|
51. | Iowa 17.83441 17.83441 .0008664 .0008664 |
+--------------------------------------------------------------------+
. gsort - abs_dfbeta
. list statefip abs_dfbeta _dfbeta_1 abs_residual residual
*DC, NM, and HI are outliers in X, and they turn out to be most influential over the slope of the line.
+--------------------------------------------------------------------+
| statefip abs_df~a _dfbeta_1 abs_re~l residual |
|--------------------------------------------------------------------|
1. | District of Columbia .5903278 -.5903278 3381.999 3381.999 |
2. | New Mexico .5375599 .5375599 5139.932 -5139.932 |
3. | Hawaii .3419163 .3419163 1728.106 -1728.106 |
4. | West Virginia .2921322 -.2921322 4798.199 -4798.199 |
5. | Mississippi .2366829 .2366829 5009.293 -5009.293 |
|--------------------------------------------------------------------|
6. | Montana .2145686 -.2145686 5024.921 -5024.921 |
7. | North Dakota .192666 -.192666 4204.203 -4204.203 |
8. | New Hampshire .1813799 .1813799 3021.199 3021.199 |
9. | Maryland .1743481 -.1743481 4840.275 4840.275 |
10. | Minnesota .1740437 .1740437 4187.81 4187.81 |
|--------------------------------------------------------------------|
11. | Louisiana .1484154 .1484154 3555.554 -3555.554 |
12. | South Dakota .1303558 -.1303558 2937.162 -2937.162 |
13. | New Jersey .1172426 -.1172426 5432.736 5432.736 |
14. | Massachusetts .098265 .098265 4666.598 4666.598 |
15. | Wyoming .0957266 -.0957266 1860.133 -1860.133 |
|--------------------------------------------------------------------|
16. | Kentucky .075205 -.075205 2257.391 -2257.391 |
17. | Idaho .070259 -.070259 2289.952 -2289.952 |
18. | Washington .0665131 .0665131 2536.313 2536.313 |
19. | Wisconsin .0656909 .0656909 2079.558 2079.558 |
20. | Texas .0654734 .0654734 873.475 -873.475 |
|--------------------------------------------------------------------|
21. | Arizona .062599 .062599 1755.73 -1755.73 |
22. | Florida .0603009 .0603009 1833.188 -1833.188 |
23. | Alaska .0506594 -.0506594 3780.312 3780.312 |
24. | Rhode Island .0499289 .0499289 1562.148 1562.148 |
25. | Illinois .04929 -.04929 2687.422 2687.422 |
|--------------------------------------------------------------------|
26. | Connecticut .0487289 .0487289 5617.314 5617.314 |
27. | Alabama .0482474 .0482474 3416.563 -3416.563 |
28. | Georgia .0433774 .0433774 939.2884 -939.2884 |
29. | Nebraska .0429309 -.0429309 1231.4 -1231.4 |
30. | Missouri .0429018 .0429018 1460.693 1460.693 |
|--------------------------------------------------------------------|
31. | Maine .0362305 -.0362305 536.482 -536.482 |
32. | Michigan .0356351 .0356351 3208.876 3208.876 |
33. | New York .0335865 -.0335865 998.9494 998.9494 |
34. | Virginia .0332524 -.0332524 2706.413 2706.413 |
35. | Delaware .0329438 -.0329438 1970.206 1970.206 |
|--------------------------------------------------------------------|
36. | Ohio .024228 .024228 1017.316 1017.316 |
37. | California .0240138 -.0240138 294.7873 294.7873 |
38. | South Carolina .022419 .022419 1986.75 -1986.75 |
39. | Kansas .021283 -.021283 1001.302 -1001.302 |
40. | Vermont .0203959 -.0203959 328.0741 -328.0741 |
|--------------------------------------------------------------------|
41. | Utah .0203697 -.0203697 544.7642 -544.7642 |
42. | Arkansas .0185422 -.0185422 4460.403 -4460.403 |
43. | Oklahoma .0102179 -.0102179 2383.868 -2383.868 |
44. | Nevada .0080656 -.0080656 347.9611 347.9611 |
45. | Oregon .0072873 .0072873 241.7805 241.7805 |
|--------------------------------------------------------------------|
46. | Pennsylvania .0063625 -.0063625 230.294 -230.294 |
47. | Colorado .0056333 .0056333 4390.833 4390.833 |
48. | Indiana .0053708 -.0053708 165.3883 -165.3883 |
49. | Tennessee .0009869 .0009869 89.31062 89.31062 |
50. | North Carolina .0009033 .0009033 46.82497 -46.82497 |
|--------------------------------------------------------------------|
51. | Iowa .0008664 .0008664 17.83441 17.83441 |
+--------------------------------------------------------------------+
. log close
name: <unnamed>
log: C:\Users\Michael\Documents\newer web pages\soc_meth_proj3\fall_2016_logs\class11.log
log type: text
closed on: 2 Nov 2016, 13:23:32
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------