Effective Marginal Tax Rate Calculations (Following Mankiw).xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Copy and Paste of Table 4 from Early's ReportReconstructing the Columns from Table 4 of Early's Report (as Text Strings)1234567891011
2
Lowest 23.2 2.2 34.3 39.4 0.8 8.3 42.6 1.9 1.5 12.9 493.2Lowest 23.2 2.2 34.3 39.4 0.8 8.3 42.6 1.9 1.5 12.9493.2712162126303439434752
3
Second 19.1 7.0 24.3 32.0 4.2 11.1 31.1 6.2 6.5 13.9 97.7Second 19.1 7.0 24.3 32.0 4.2 11.1 31.1 6.2 6.5 13.997.7712162126303540444853
4
Middle 19.1 12.6 16.9 20.7 8.6 14.5 18.9 11.1 12.6 15.4 21.5Middle 19.1 12.6 16.9 20.7 8.6 14.5 18.9 11.1 12.6 15.421.5712172227313641465156
5
Fourth 19.1 20.5 14.1 7.8 17.2 19.8 7.3 18.0 20.2 18.6 –9.2Fourth 19.1 20.5 14.1 7.8 17.2 19.8 7.3 18.0 20.2 18.6–9.2712172226313640455055
6
Highest 19.6 57.7 10.4 0.0 69.2 46.2 0.0 62.8 59.3 39.3 –31.9Highest 19.6 57.7 10.4 0.0 69.2 46.2 0.0 62.8 59.3 39.3–31.9813182327323741465156
7
8
9
10
11
Text String Converted to Values
12
Lowest23.22.234.339.40.88.342.61.91.512.9493.2
13
Second19.1724.3324.211.131.16.26.513.997.7
14
Middle19.112.616.920.78.614.518.911.112.615.421.5
15
Fourth19.120.514.17.817.219.87.31820.218.6#VALUE!
16
Highest19.657.710.4069.246.2062.859.339.3#VALUE!
17
18
19
20
Quintile AQuintile BFINAATT for AFINAATT for BMoney Income for AMoney Income for BEffective Marginal Tax RateChange In Share of Quintile AChange In Share of Quintile BNew FINAATT for ANew FINAATT for BMoney Income for AMoney Income for BEffective Marginal Tax RateSquared DeviationsPercentage Change in FINAATT Share
21
11 12.9 12.9 2.2 2.2 0.0 0.0 12.9 12.9 2.2 2.2+ 0%
22
12 13.9 12.9 7.0 2.279% 0.9 0.0 14.8 12.9 7.0 2.260%+ 7%
23
13 15.4 12.9 12.6 2.276% 1.7 0.0 17.1 12.9 12.6 2.260%+ 11%
24
14 18.6 12.9 20.5 2.269% 1.6 0.0 20.2 12.9 20.5 2.260%+ 9%
25
15 39.3 12.9 57.7 2.252%-4.2 0.0 35.1 12.9 57.7 2.260%- 11%
26
21 12.9 13.9 2.2 7.0 0.0 0.9 12.9 14.8 2.2 7.0+ 0%
27
22 13.9 13.9 7.0 7.0 0.9 0.9 14.8 14.8 7.0 7.0+ 7%
28
23 15.4 13.9 12.6 7.073% 1.7 0.9 17.1 14.8 12.6 7.060%0+ 11%
29
24 18.6 13.9 20.5 7.065% 1.6 0.9 20.2 14.8 20.5 7.060%+ 9%
30
25 39.3 13.9 57.7 7.050%-4.2 0.9 35.1 14.8 57.7 7.060%- 11%
31
31 12.9 15.4 2.2 12.6 0.0 1.7 12.9 17.1 2.2 12.6+ 0%
32
32 13.9 15.4 7.0 12.6 0.9 1.7 14.8 17.1 7.0 12.6+ 7%
33
33 15.4 15.4 12.6 12.6 1.7 1.7 17.1 17.1 12.6 12.6+ 11%
34
34 18.6 15.4 20.5 12.659% 1.6 1.7 20.2 17.1 20.5 12.660%0+ 9%
35
35 39.3 15.4 57.7 12.647%-4.2 1.7 35.1 17.1 57.7 12.660%- 11%
36
41 12.9 18.6 2.2 20.5 0.0 1.6 12.9 20.2 2.2 20.5+ 0%
37
42 13.9 18.6 7.0 20.5 0.9 1.6 14.8 20.2 7.0 20.5+ 7%
38
43 15.4 18.6 12.6 20.5 1.7 1.6 17.1 20.2 12.6 20.5+ 11%
39
44 18.6 18.6 20.5 20.5 1.6 1.6 20.2 20.2 20.5 20.5+ 9%
40
45 39.3 18.6 57.7 20.544%-4.2 1.6 35.1 20.2 57.7 20.560%0- 11%
41
51 12.9 39.3 2.2 57.7 0.0-4.2 12.9 35.1 2.2 57.7+ 0%
42
52 13.9 39.3 7.0 57.7 0.9-4.2 14.8 35.1 7.0 57.7+ 7%
43
53 15.4 39.3 12.6 57.7 1.7-4.2 17.1 35.1 12.6 57.7+ 11%
44
54 18.6 39.3 20.5 57.7 1.6-4.2 20.2 35.1 20.5 57.7+ 9%
45
55 39.3 39.3 57.7 57.7-4.2-4.2 35.1 35.1 57.7 57.7- 11%
46
Sum of Squares
47
0
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
 
 
Main menu