I have this data set:
Excel 2007
I need to find two things: 1) the city and 2) where the incumbent's salary falls in between
in order to find the difference between the national average.
Can this be done???
Excel Workbook | |||||
---|---|---|---|---|---|
B | C | D | |||
6 | City | Salary | % Difference from National | ||
7 | Akron, OH | 20,000 | *** | ||
8 | Akron, OH | 30,000 | -1.50% | ||
9 | Akron, OH | 40,000 | -1.40% | ||
10 | Akron, OH | 50,000 | -1.40% | ||
11 | Akron, OH | 60,000 | -1.30% | ||
12 | Akron, OH | 70,000 | -1.40% | ||
13 | Akron, OH | 80,000 | -1.30% | ||
14 | Akron, OH | 90,000 | -1.20% | ||
15 | Akron, OH | 100,000 | -1.20% | ||
16 | Akron, OH | 110,000 | *** | ||
17 | Akron, OH | 120,000 | *** | ||
18 | Albany, NY | 20,000 | 1.40% | ||
19 | Albany, NY | 30,000 | -2.00% | ||
20 | Albany, NY | 40,000 | -3.70% | ||
21 | Albany, NY | 50,000 | -4.10% | ||
22 | Albany, NY | 60,000 | -4.30% | ||
23 | Albany, NY | 70,000 | -4.60% | ||
24 | Albany, NY | 80,000 | -4.50% | ||
25 | Albany, NY | 90,000 | -4.40% | ||
26 | Albany, NY | 100,000 | -4.30% | ||
27 | Albany, NY | 110,000 | *** | ||
28 | Albany, NY | 120,000 | *** | ||
120K |
I need to find two things: 1) the city and 2) where the incumbent's salary falls in between
in order to find the difference between the national average.
Can this be done???