ECONOMICS HOMEWORK
ACCOUNTING123
Assign2.5TutorialData2.xlsxEx5
| Average Income | Average Expenditure | ||||
| 552 | 651 | Dependent Variable = Expenditure | |||
| 777 | 851 | Income | Constant | ||
| 1,065 | 1,110 | Coeff. | 0.8875 | 162.6163 | |
| 1,352 | 1,371 | Std. Error | 0.0032 | 6.6034 | |
| 1,641 | 1,624 | R-sqr | 99.99% | 9.1328950971 | |
| 1,937 | 1,869 | 76072.8989499229 | 8 | ||
| 2,252 | 2,160 | 6345223.22181716 | 667.2781828382 | ||
| 2,529 | 2,414 | t-stat. | 275.8132 | 24.6260 | |
| 2,881 | 2,704 | ||||
| 3,468 | 3,251 |
Ex6
| Average Income | Dummy Variable = 0 for white families and 1 for black families | Average Charitable Contributions | |||||
| 555 | 0 | 5 | Dependent Variable = Charitable Contributions | ||||
| 781 | 0 | 6 | Black | Income | Constant | ||
| 1,068 | 0 | 13 | Coeff. | 12.6626 | 0.0318 | -23.3693 | |
| 1,351 | 0 | 17 | Std. Error | 4.2198 | 0.0024 | 5.0983 | |
| 1,642 | 0 | 26 | R-sqr | 93.1% | 7.6985880273 | ERROR:#N/A | |
| 1,935 | 0 | 35 | 87.1625939993 | 13 | ERROR:#N/A | ||
| 2,253 | 0 | 46 | 10331.9501510101 | 770.4873489899 | ERROR:#N/A | ||
| 2,530 | 0 | 52 | t-stat. | 3.0007 | 13.1196 | -4.5837 | |
| 2,880 | 0 | 63 | |||||
| 3,466 | 0 | 91 | |||||
| 549 | 1 | 6 | |||||
| 758 | 1 | 10 | |||||
| 1,031 | 1 | 15 | |||||
| 1,333 | 1 | 31 | |||||
| 1,592 | 1 | 32 | |||||
| 2,315 | 1 | 83 |
