Salary Tax - Download as Excel by hxx21282

VIEWS: 12 PAGES: 2

									              Salary Tax Table
                             Tax
Year          Salary               20%      22%          24%          26%          28%   30% max-min
       1992     $21,500.00
       1993     $22,037.50
       1994     $23,139.38
       1995     $23,833.56
       1996     $24,071.89
       1997     $24,192.25
       1998     $24,918.02
       1999     $25,914.74
       2000     $26,433.03
       2001     $27,226.03
       2002     $27,498.29
       2003     $29,148.18
       2004     $30,605.59
       2005     $32,135.87
       2006     $33,099.95
       2007     $34,092.95
       2008     $34,433.88
       2009     $37,188.59
       2010     $39,419.90
       2011     $41,390.90
       2012     $43,460.44


Instructions
1. format c4:h24 as currency w/2 decimals
2. enter b4*c3 in c4
3. make b4 column-absolute mixed reference
4. make c3 row-absolute mixed reference
5. fill b4:h24 using b4, h24 should display 13038
6. enter the difference between the max and min formulas in i4 using b4:h4,
7. fill i6:i24 with i4
8. create a line chart using a3:b24, add title and axis labels
9. remove the year data series and added to x-axis
10. add a trendline, display the R-squared value, extend the trendline 5 years forward
11. choose the trendline that best fits the graph

								
To top