VIEWS: 12 PAGES: 2

• pg 1
```									              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