Homework SourseI am writting a paper and I am really in a jam My paper is o
I am writting a paper and I am really in a jam. My paper is on Wage increases with more education. Here is the data
| Wage | Ed |
| 19388 | 6 |
| 49898 | 12 |
| 28219 | 12 |
| 83601 | 17 |
| 29736 | 8 |
| 50235 | 16 |
| 45976 | 12 |
| 33411 | 12 |
| 21716 | 12 |
| 37664 | 18 |
| 26820 | 18 |
| 29977 | 16 |
| 33959 | 17 |
| 11780 | 11 |
| 10997 | 14 |
| 17626 | 12 |
| 22133 | 16 |
| 21994 | 12 |
| 29390 | 13 |
| 32138 | 14 |
| 30006 | 16 |
| 68573 | 16 |
| 17694 | 8 |
| 26795 | 7 |
| 19981 | 4 |
| 14476 | 12 |
| 19452 | 13 |
| 28168 | 13 |
| 19306 | 9 |
| 13318 | 11 |
| 25166 | 12 |
| 18121 | 12 |
| 13162 | 12 |
| 32094 | 12 |
| 16667 | 12 |
| 50171 | 12 |
| 31691 | 12 |
| 36178 | 12 |
| 15234 | 12 |
| 16817 | 12 |
| 22485 | 12 |
| 30308 | 12 |
| 11702 | 14 |
| 11186 | 12 |
| 12285 | 12 |
| 19284 | 16 |
| 11451 | 12 |
| 57623 | 15 |
| 25670 | 13 |
| 83443 | 17 |
| 49974 | 16 |
| 46646 | 5 |
| 31702 | 12 |
| 13312 | 12 |
| 44543 | 18 |
| 15013 | 16 |
| 33389 | 14 |
| 60626 | 18 |
| 24509 | 14 |
| 20852 | 12 |
| 30133 | 10 |
| 31799 | 12 |
| 16796 | 12 |
| 20793 | 12 |
| 29407 | 10 |
| 29191 | 12 |
| 15957 | 12 |
| 34484 | 13 |
| 35185 | 14 |
| 26614 | 12 |
| 41780 | 12 |
| 55777 | 14 |
| 15160 | 8 |
| 66738 | 9 |
| 33351 | 16 |
| 33498 | 10 |
| 29809 | 8 |
| 15193 | 12 |
| 23027 | 14 |
| 75165 | 15 |
| 18752 | 11 |
| 83569 | 18 |
| 32235 | 12 |
| 20852 | 12 |
| 13787 | 11 |
| 34746 | 14 |
| 17690 | 12 |
| 52762 | 18 |
| 60152 | 16 |
| 33461 | 16 |
| 13481 | 12 |
| 9879 | 12 |
| 16789 | 13 |
| 31304 | 16 |
| 37771 | 15 |
| 50187 | 12 |
| 39888 | 12 |
| 19227 | 12 |
| 32786 | 11 |
| 28440 | 12 |
| Can I do this all on excel and just do a regression from my data table to get my analysis? |
Solution
Since there is a direct realtion betwwe the wage and the education, you can support the paper with excel sheet , but you can also use Various tests e.g T-test to validate it. And ofcourse the simplest tools of mean and standard deviations can be used.
Also you can use statistic softwares like SQL, MiniTab, ANOVA etc.
