Math Experts - Function to compare where salary is compared to others have 800 rows of data

Hi, I'm trying to see where my salary fits as compared to my fellow
Americans. Basically I would like to know what percentile I'm in based on
the US Mean Salary and total employment columns for 800 occupations that I
grabbed for Nov. 2004 from the Bureau of Labor Statistics website. I got
this data from here: http://www.bls.gov/oes/oes_dl.htm#2004_n From the
file that says: "November 2004 National Cross-Industry estimates".

I plotted the data in an excel spreadsheet to see if would come out like a
bell curve, but it did not. So for instance, say I make $40,000. I would
like to know exactly what % make more and less. By looking at the charts I
made it is very difficult to tell. A solution that uses Excel would
probably be the best since the 800 pieces of data are already in the
spreadsheet. Ideally the solution would be flexible where I could plug in
different salaries. Below are the data points I have, but the spreadsheet
from the site also contains lots of data point as well. It looks like
a_mean stands for Annual mean salary, where tot_emp stands for total
employees in this data set.

Thanks

a_mean tot_emp
$15,230.00 651530
$15,430.00 2223820
$15,560.00 393090
$15,670.00 493310
$15,980.00 2228950
$16,020.00 15580
$16,210.00 85240
$16,290.00 483870
$16,310.00 324570
$16,730.00 243640
$16,770.00 105040
$17,110.00 231120
$17,200.00 3451100
$17,360.00 471640
$17,560.00 555780
$17,730.00 123960
$17,820.00 107120
$17,850.00 874060
$17,870.00 209370
$17,980.00 79500
$18,030.00 887120
$18,060.00 532400
$18,080.00 47290
$18,120.00 188950
$18,290.00 215910
$18,530.00 20880
$18,570.00 93420
$18,620.00 60010
$18,730.00 198890
$18,760.00 860050
$19,070.00 44810
$19,200.00 625770
$19,430.00 244300
$19,460.00 10160
$19,620.00 86650
$19,730.00 333920
$19,880.00 44390
$20,130.00 70210
$20,190.00 18490
$20,240.00 395950
$20,270.00 45630
$20,320.00 137240
$20,330.00 **
$20,370.00 770660
$20,540.00 25870
$20,540.00 8000
$20,560.00 19800
$20,600.00 16530
$20,660.00 7480
$20,670.00 28740
$20,750.00 1260820
$20,760.00 27610
$20,800.00 2119800
$20,830.00 29930
$20,960.00 68630
$21,000.00 4550
$21,170.00 134570
$21,170.00 54480
$21,330.00 11870
$21,590.00 504440
$21,640.00 141470
$21,650.00 573740
$21,720.00 54310
$21,730.00 22000
$21,850.00 790
$21,890.00 1395030
$21,890.00 454950
$21,960.00 85930
$21,970.00 1606180
$21,990.00 111380
$22,120.00 64780
$22,180.00 263570
$22,190.00 2388930
$22,260.00 866950
$22,310.00 102180
$22,380.00 992180
$22,400.00 22790
$22,410.00 16640
$22,500.00 238310
$22,570.00 22150
$22,580.00 42570
$22,750.00 202980
$22,780.00 9300
$22,880.00 4260150
$22,890.00 108870
$22,890.00 10290
$22,900.00 1087330
$22,970.00 13350
$23,010.00 142940
$23,020.00 22270
$23,050.00 10230
$23,170.00 19570
$23,180.00 160020
$23,240.00 38880
$23,260.00 50380
$23,270.00 41430
$23,280.00 23420
$23,320.00 17960
$23,430.00 2890
$23,520.00 49710
$23,520.00 407650
$23,560.00 8980
$23,570.00 27660
$23,650.00 148960
$23,700.00 145110
$23,720.00 335000
$23,770.00 56600
$23,780.00 81570
$23,800.00 44880
$23,810.00 405060
$23,890.00 86810
$23,890.00 28320
$23,960.00 475700
$24,030.00 59350
$24,090.00 90900
$24,350.00 74480
$24,440.00 2943750
$24,450.00 89570
$24,560.00 350000
$24,560.00 307400
$24,580.00 412360
$24,680.00 11320
$24,800.00 27490
$24,810.00 15630
$24,870.00 88540
$24,930.00 16890
$24,940.00 90080
$25,020.00 42980
$25,030.00 9030
$25,040.00 63590
$25,150.00 265190
$25,240.00 29400
$25,250.00 37690
$25,270.00 18330
$25,330.00 201230
$25,390.00 24210
$25,440.00 16080
$25,470.00 13530
$25,500.00 40200
$25,530.00 25710
$25,750.00 26030
$25,780.00 1237700
$25,860.00 369430
$25,910.00 25030
$25,960.00 35120
$26,040.00 29470
$26,140.00 22570
$26,270.00 748700
$26,270.00 69320
$26,290.00 24440
$26,300.00 318120
$26,330.00 61110
$26,490.00 6860
$26,490.00 157310
$26,570.00 5390
$26,610.00 182000
$26,640.00 929530
$26,720.00 112850
$26,740.00 1500
$26,760.00 4210
$26,780.00 84460
$26,780.00 207050
$26,800.00 24160
$26,870.00 12870
$26,940.00 24760
$27,030.00 276160
$27,080.00 20190
$27,160.00 40980
$27,190.00 305330
$27,240.00 257500
$27,280.00 47850
$27,290.00 118480
$27,330.00 8880
$27,520.00 1712600
$27,520.00 300210
$27,520.00 59790
$27,570.00 128700
$27,600.00 738610
$27,700.00 21630
$27,770.00 12320
$27,820.00 25500
$27,880.00 99430
$27,900.00 13690
$27,940.00 191070
$27,960.00 53010
$28,140.00 430
$28,160.00 159580
$28,200.00 8490
$28,220.00 3480
$28,250.00 356760
$28,280.00 4570
$28,330.00 34160
$28,360.00 59840
$28,370.00 85120
$28,370.00 90060
$28,390.00 626910
$28,400.00 3370
$28,460.00 119180
$28,460.00 506720
$28,480.00 39630
$28,510.00 239130
$28,550.00 8800
$28,580.00 70820
$28,710.00 62960
$28,720.00 41320
$28,740.00 76810
$28,790.00 24200
$28,810.00 138700
$28,860.00 29030
$28,920.00 892940
$28,950.00 38840
$29,260.00 27650
$29,300.00 250200
$29,300.00 76900
$29,340.00 19770
$29,350.00 2036090
$29,400.00 6060
$29,460.00 444790
$29,500.00 35850
$29,500.00 100640
$29,530.00 93670
$29,570.00 268950
$29,630.00 5790
$29,710.00 16810
$29,760.00 122390
$29,800.00 161730
$29,980.00 36760
$29,980.00 7610
$30,010.00 8480
$30,010.00 88480
$30,060.00 33200
$30,110.00 16840
$30,240.00 159510
$30,280.00 1777320
$30,350.00 16570
$30,380.00 2870
$30,400.00 10250
$30,470.00 66000
$30,640.00 139740
$30,690.00 14120
$30,730.00 42830
$30,770.00 3740
$30,780.00 92090
$30,800.00 26540
$30,810.00 26380
$30,820.00 116560
$30,870.00 28280
$30,900.00 101450
$30,950.00 39150
$31,020.00 67110
$31,050.00 16270
$31,100.00 223870
$31,120.00 244700
$31,150.00 9780
$31,150.00 12810
$31,170.00 890
$31,180.00 91150
$31,260.00 183090
$31,320.00 47260
$31,390.00 18370
$31,430.00 28700
$31,460.00 99030
$31,560.00 505100
$31,630.00 55450
$31,660.00 142610
$31,700.00 61180
$31,750.00 189170
$31,770.00 16960
$31,820.00 206570
$31,820.00 19930
$31,820.00 108530
$31,830.00 130600
$31,890.00 71150
$32,000.00 53790
$32,000.00 4910
$32,010.00 1710
$32,020.00 10130
$32,080.00 43420
$32,100.00 186340
$32,130.00 54120
$32,150.00 29820
$32,210.00 15220
$32,220.00 351710
$32,260.00 136040
$32,290.00 1291030
$32,330.00 53190
$32,400.00 4090
$32,490.00 193860
$32,540.00 41140
$32,580.00 18220
$32,590.00 6960
$32,620.00 18950
$32,630.00 3290
$32,740.00 2520
$32,760.00 44670
$32,820.00 143610
$32,840.00 51770
$32,850.00 2070
$32,910.00 71480
$33,040.00 521220
$33,140.00 133230
$33,220.00 59800
$33,240.00 168010
$33,250.00 163920
$33,320.00 2070
$33,380.00 248900
$33,500.00 62400
$33,530.00 40480
$33,570.00 1530
$33,590.00 19180
$33,600.00 52250
$33,660.00 12020
$33,680.00 13360
$33,730.00 1680
$33,810.00 44310
$33,830.00 71270
$33,850.00 16780
$33,940.00 124470
$33,990.00 73120
$34,040.00 117360
$34,060.00 86620
$34,060.00 11110
$34,070.00 195020
$34,090.00 19880
$34,130.00 12920
$34,210.00 30340
$34,220.00 2470
$34,270.00 3440
$34,300.00 30670
$34,520.00 64240
$34,620.00 85890
$34,760.00 662840
$34,780.00 23350
$34,800.00 17900
$34,860.00 17290
$34,870.00 117850
$34,880.00 92760
$34,880.00 15440
$34,920.00 1594980
$34,960.00 9510
$35,000.00 17770
$35,000.00 364130
$35,000.00 40730
$35,010.00 14990
$35,060.00 36630
$35,130.00 2590
$35,170.00 70400
$35,380.00 7330
$35,480.00 3440
$35,560.00 82070
$35,580.00 706360
$35,640.00 50810
$35,640.00 13480
$35,800.00 9860
$35,850.00 93330
$35,870.00 129840
$35,880.00 14450
$35,930.00 41340
$35,930.00 10070
$35,980.00 141750
$36,060.00 18090
$36,140.00 46340
$36,160.00 416490
$36,240.00 8820
$36,240.00 45930
$36,250.00 49000
$36,330.00 38920
$36,340.00 19060
$36,520.00 61080
$36,540.00 2430
$36,620.00 115810
$36,630.00 89260
$36,690.00 40400
$36,820.00 72740
$36,950.00 39860
$36,970.00 34940
$36,990.00 9300
$37,010.00 69710
$37,020.00 248890
$37,030.00 3110
$37,050.00 12830
$37,090.00 49700
$37,120.00 139970
$37,170.00 34200
$37,230.00 1083890
$37,240.00 15230
$37,270.00 1400
$37,280.00 15450
$37,280.00 8630
$37,350.00 1420170
$37,380.00 7330
$37,430.00 122240
$37,480.00 30670
$37,590.00 50720
$37,650.00 4910
$37,700.00 70580
$37,780.00 160850
$37,840.00 21970
$37,860.00 4150
$37,940.00 26470
$37,970.00 1690
$37,970.00 6710
$38,050.00 57650
$38,080.00 6030
$38,230.00 5420
$38,250.00 913130
$38,280.00 255300
$38,290.00 287450
$38,400.00 21120
$38,410.00 232050
$38,420.00 19440
$38,520.00 105640
$38,550.00 21000
$38,610.00 280160
$38,610.00 4140
$38,640.00 5150
$38,720.00 50760
$38,840.00 45030
$38,870.00 261560
$38,870.00 369280
$38,900.00 11940
$38,920.00 7010
$38,930.00 19740
$39,050.00 52730
$39,060.00 9520
$39,070.00 181720
$39,300.00 187880
$39,350.00 13840
$39,400.00 114920
$39,420.00 57930
$39,470.00 31000
$39,560.00 46450
$39,610.00 6710
$39,840.00 6810
$39,900.00 15350
$39,980.00 275090
$40,040.00 61350
$40,070.00 27290
$40,100.00 43690
$40,120.00 3090
$40,170.00 90890
$40,330.00 8760
$40,330.00 24670
$40,400.00 224600
$40,500.00 37930
$40,520.00 5160
$40,560.00 223700
$40,770.00 43320
$40,770.00 173640
$41,040.00 6570
$41,210.00 35120
$41,400.00 49190
$41,460.00 1840
$41,650.00 99640
$41,710.00 62120
$41,860.00 19920
$41,910.00 168060
$41,950.00 19720
$41,990.00 23570
$42,050.00 430
$42,150.00 22520
$42,190.00 22410
$42,220.00 25570
$42,250.00 108290
$42,560.00 148740
$42,740.00 215280
$42,770.00 114400
$42,800.00 6360
$42,860.00 4540
$43,020.00 91960
$43,120.00 14510
$43,150.00 49300
$43,300.00 37170
$43,320.00 16840
$43,450.00 20060
$43,500.00 66560
$43,500.00 69320
$43,560.00 590
$43,620.00 37430
$43,660.00 491680
$43,930.00 16890
$43,970.00 1460
$44,040.00 49400
$44,180.00 346000
$44,260.00 65530
$44,280.00 108540
$44,510.00 423280
$44,640.00 99420
$44,820.00 71310
$44,890.00 1365190
$44,900.00 8380
$44,940.00 164800
$44,970.00 4310
$45,030.00 12090
$45,160.00 45500
$45,200.00 205400
$45,200.00 621050
$45,310.00 94500
$45,490.00 47820
$45,490.00 56280
$45,510.00 7990
$45,580.00 12610
$45,650.00 69220
$45,650.00 10560
$45,720.00 30330
$45,720.00 75930
$45,750.00 45600
$45,760.00 25870
$45,830.00 60710
$45,870.00 86240
$45,900.00 183960
$45,990.00 22540
$46,020.00 9470
$46,030.00 46950
$46,180.00 12070
$46,210.00 10320
$46,350.00 1431380
$46,350.00 16020
$46,370.00 12550
$46,460.00 8470
$46,600.00 623390
$46,650.00 16260
$46,830.00 77930
$47,020.00 6910
$47,170.00 626110
$47,280.00 51960
$47,300.00 22080
$47,360.00 205830
$47,440.00 173160
$47,480.00 11660
$47,530.00 4550
$47,560.00 10270
$47,610.00 154180
$47,640.00 17640
$47,660.00 2940
$47,830.00 18180
$47,910.00 114240
$47,920.00 173690
$47,970.00 31920
$48,100.00 214350
$48,150.00 4540
$48,200.00 8480
$48,220.00 135560
$48,290.00 685510
$48,340.00 12800
$48,360.00 206140
$48,380.00 16150
$48,450.00 13080
$48,570.00 103160
$48,700.00 145140
$48,750.00 70780
$48,790.00 198450
$48,840.00 100200
$48,980.00 1026050
$49,080.00 245610
$49,310.00 221560
$49,390.00 2480
$49,570.00 168580
$49,660.00 74790
$49,730.00 10880
$49,750.00 101080
$49,790.00 10770
$50,070.00 41050
$50,090.00 149590
$50,210.00 37990
$50,280.00 62320
$50,350.00 152590
$50,360.00 135280
$50,370.00 97380
$50,440.00 141040
$50,460.00 180200
$50,530.00 25440
$50,790.00 26610
$50,840.00 10070
$50,980.00 4060
$51,250.00 17890
$51,260.00 10330
$51,330.00 5060
$51,480.00 95800
$51,640.00 82180
$51,650.00 13180
$51,860.00 263140
$52,150.00 42750
$52,380.00 34050
$52,440.00 26490
$52,480.00 109470
$52,580.00 158890
$52,660.00 9770
$52,670.00 14890
$52,700.00 115760
$52,700.00 23240
$53,090.00 58550
$53,360.00 65620
$53,430.00 455560
$53,440.00 15150
$53,560.00 101730
$53,770.00 21340
$53,920.00 15750
$53,930.00 9900
$54,060.00 383680
$54,270.00 21140
$54,410.00 35950
$54,500.00 1403590
$54,550.00 48670
$54,720.00 549130
$54,820.00 42500
$54,870.00 195270
$54,870.00 96200
$54,900.00 4660
$55,280.00 22780
$55,300.00 3780
$55,680.00 2338530
$55,890.00 120240
$55,900.00 7200
$56,280.00 69990
$56,300.00 36110
$56,310.00 283840
$56,350.00 29770
$56,580.00 3520
$56,600.00 7270
$56,850.00 93200
$56,890.00 87330
$56,900.00 10260
$57,030.00 30950
$57,160.00 1007760
$57,220.00 9830
$57,420.00 45450
$57,440.00 11020
$57,480.00 17940
$57,560.00 64630
$57,610.00 86710
$57,680.00 27960
$57,700.00 34690
$58,090.00 45820
$58,310.00 19130
$58,530.00 880960
$58,540.00 8090
$58,660.00 20810
$58,910.00 20010
$59,200.00 37800
$59,470.00 305330
$59,490.00 14680
$59,560.00 4960
$59,790.00 158130
$59,820.00 5150
$60,020.00 32990
$60,200.00 7030
$60,290.00 54940
$60,780.00 18120
$60,940.00 6910
$61,120.00 4220
$61,320.00 53880
$61,380.00 29860
$61,770.00 14660
$62,250.00 8190
$62,300.00 262930
$62,360.00 7580
$62,400.00 78360
$62,570.00 52210
$62,630.00 760
$62,780.00 14040
$62,820.00 25220
$62,930.00 120770
$63,030.00 3200
$63,180.00 12390
$63,340.00 98430
$63,530.00 3980
$63,690.00 145210
$63,750.00 30170
$63,760.00 53580
$63,950.00 17560
$64,080.00 176840
$64,130.00 7520
$64,130.00 184050
$64,380.00 100420
$64,470.00 22320
$64,880.00 19380
$65,000.00 4450
$65,510.00 13530
$65,600.00 22610
$65,660.00 257650
$65,860.00 4170
$65,910.00 5720
$66,050.00 5100
$66,190.00 93610
$66,480.00 396100
$66,620.00 3580
$66,750.00 25910
$66,760.00 66760
$66,780.00 2980
$67,300.00 96540
$67,730.00 382520
$67,820.00 184900
$68,120.00 248980
$68,240.00 74860
$68,280.00 226100
$68,430.00 13190
$68,500.00 63140
$68,610.00 23560
$69,200.00 50120
$69,230.00 5920
$69,460.00 58180
$69,470.00 497100
$69,480.00 219040
$70,280.00 6240
$70,490.00 13160
$70,650.00 8830
$70,700.00 20940
$70,730.00 7170
$71,210.00 10030
$71,280.00 181340
$72,100.00 302890
$72,160.00 16340
$72,800.00 11550
$73,050.00 86740
$73,270.00 7470
$73,400.00 28310
$73,410.00 6250
$73,460.00 424740
$73,580.00 15510
$74,060.00 12460
$74,150.00 10050
$74,610.00 5480
$74,930.00 53320
$75,330.00 41190
$75,540.00 147120
$75,830.00 227980
$76,050.00 208980
$76,320.00 48290
$76,720.00 153090
$76,920.00 32610
$77,290.00 70300
$77,580.00 102880
$77,890.00 26440
$77,920.00 59000
$78,030.00 28590
$78,570.00 439720
$78,620.00 133410
$78,900.00 34410
$79,260.00 49220
$79,520.00 12250
$79,610.00 72120
$80,070.00 188750
$80,640.00 156270
$81,080.00 2660
$82,010.00 1480
$82,420.00 108800
$82,540.00 11780
$82,820.00 343530
$82,900.00 25110
$83,060.00 102120
$83,460.00 321120
$83,490.00 47640
$83,620.00 79730
$84,020.00 22730
$85,400.00 4490
$85,540.00 79670
$86,910.00 226200
$87,520.00 249170
$88,740.00 58610
$89,230.00 15710
$89,320.00 15870
$89,490.00 14500
$90,860.00 26950
$91,020.00 60410
$92,100.00 25000
$92,840.00 14790
$93,580.00 1704110
$94,180.00 489170
$95,570.00 13090
$96,290.00 23190
$96,780.00 840
$96,950.00 318470
$97,560.00 40250
$100,020.00 172300
$100,110.00 264190
$100,430.00 21680
$104,210.00 188620
$106,040.00 3220
$110,590.00 528270
$111,130.00 6940
$132,660.00 86360
$134,090.00 78430
$137,100.00 174270
$137,980.00 108800
$140,000.00 26870
$140,880.00 334960
$151,380.00 22500
$153,240.00 5670
$156,710.00 550
$156,790.00 50500
$169,600.00 4380
$174,490.00 22100
$174,610.00 26140
$181,850.00 55390

I am not an expert, but consider using a cumulative distribution:


Using your first 10 items as an example, in C1 put:
=B1
in C2 put:
=C1+B2 and copy down. You will see:

$15,230.00 651,530 651,530
$15,430.00 2,223,820 2,875,350
$15,560.00 393,090 3,268,440
$15,670.00 493,310 3,761,750
$15,980.00 2,228,950 5,990,700
$16,020.00 15,580 6,006,280
$16,210.00 85,240 6,091,520
$16,290.00 483,870 6,575,390
$16,310.00 324,570 6,899,960
$16,730.00 243,640 7,143,600

Now in D1 put:
=C1/C$10*100 and copy down to get:
$15,230.00 651,530 651,530 9.12
$15,430.00 2,223,820 2,875,350 40.25
$15,560.00 393,090 3,268,440 45.75
$15,670.00 493,310 3,761,750 52.66
$15,980.00 2,228,950 5,990,700 83.86
$16,020.00 15,580 6,006,280 84.08
$16,210.00 85,240 6,091,520 85.27
$16,290.00 483,870 6,575,390 92.05
$16,310.00 324,570 6,899,960 96.59
$16,730.00 243,640 7,143,600 100.00
the D's are percents below. 100% are below 16,730; 53% are below 15,670.


Enter the full table, locate your position, and get your percentage.
--
Gary''s Student


"Bob" wrote:

> Hi, I'm trying to see where my salary fits as compared to my fellow
> Americans. Basically I would like to know what percentile I'm in based on
> the US Mean Salary and total employment columns for 800 occupations that I
> grabbed for Nov. 2004 from the Bureau of Labor Statistics website. I got
> this data from here: http://www.bls.gov/oes/oes_dl.htm#2004_n From the
> file that says: "November 2004 National Cross-Industry estimates".
>
> I plotted the data in an excel spreadsheet to see if would come out like a
> bell curve, but it did not. So for instance, say I make $40,000. I would
> like to know exactly what % make more and less. By looking at the charts I
> made it is very difficult to tell. A solution that uses Excel would
> probably be the best since the 800 pieces of data are already in the
> spreadsheet. Ideally the solution would be flexible where I could plug in
> different salaries. Below are the data points I have, but the spreadsheet
> from the site also contains lots of data point as well. It looks like
> a_mean stands for Annual mean salary, where tot_emp stands for total
> employees in this data set.
>
> Thanks
>
> a_mean tot_emp
> $15,230.00 651530
> $15,430.00 2223820
> $15,560.00 393090
> $15,670.00 493310
> $15,980.00 2228950
> $16,020.00 15580
> $16,210.00 85240
> $16,290.00 483870
> $16,310.00 324570
> $16,730.00 243640
> $16,770.00 105040
> $17,110.00 231120
> $17,200.00 3451100
> $17,360.00 471640
> $17,560.00 555780
> $17,730.00 123960
> $17,820.00 107120
> $17,850.00 874060
> $17,870.00 209370
> $17,980.00 79500
> $18,030.00 887120
> $18,060.00 532400
> $18,080.00 47290
> $18,120.00 188950
> $18,290.00 215910
> $18,530.00 20880
> $18,570.00 93420
> $18,620.00 60010
> $18,730.00 198890
> $18,760.00 860050
> $19,070.00 44810
> $19,200.00 625770
> $19,430.00 244300
> $19,460.00 10160
> $19,620.00 86650
> $19,730.00 333920
> $19,880.00 44390
> $20,130.00 70210
> $20,190.00 18490
> $20,240.00 395950
> $20,270.00 45630
> $20,320.00 137240
> $20,330.00 **
> $20,370.00 770660
> $20,540.00 25870
> $20,540.00 8000
> $20,560.00 19800
> $20,600.00 16530
> $20,660.00 7480
> $20,670.00 28740
> $20,750.00 1260820
> $20,760.00 27610
> $20,800.00 2119800
> $20,830.00 29930
> $20,960.00 68630
> $21,000.00 4550
> $21,170.00 134570
> $21,170.00 54480
> $21,330.00 11870
> $21,590.00 504440
> $21,640.00 141470
> $21,650.00 573740
> $21,720.00 54310
> $21,730.00 22000
> $21,850.00 790
> $21,890.00 1395030
> $21,890.00 454950
> $21,960.00 85930
> $21,970.00 1606180
> $21,990.00 111380
> $22,120.00 64780
> $22,180.00 263570
> $22,190.00 2388930
> $22,260.00 866950
> $22,310.00 102180
> $22,380.00 992180
> $22,400.00 22790
> $22,410.00 16640
> $22,500.00 238310
> $22,570.00 22150
> $22,580.00 42570
> $22,750.00 202980
> $22,780.00 9300
> $22,880.00 4260150
> $22,890.00 108870
> $22,890.00 10290
> $22,900.00 1087330
> $22,970.00 13350
> $23,010.00 142940
> $23,020.00 22270
> $23,050.00 10230
> $23,170.00 19570
> $23,180.00 160020
> $23,240.00 38880
> $23,260.00 50380
> $23,270.00 41430
> $23,280.00 23420
> $23,320.00 17960
> $23,430.00 2890
> $23,520.00 49710
> $23,520.00 407650
> $23,560.00 8980
> $23,570.00 27660
> $23,650.00 148960
> $23,700.00 145110
> $23,720.00 335000
> $23,770.00 56600
> $23,780.00 81570
> $23,800.00 44880
> $23,810.00 405060
> $23,890.00 86810
> $23,890.00 28320
> $23,960.00 475700
> $24,030.00 59350
> $24,090.00 90900
> $24,350.00 74480
> $24,440.00 2943750
> $24,450.00 89570
> $24,560.00 350000
> $24,560.00 307400
> $24,580.00 412360
> $24,680.00 11320
> $24,800.00 27490
> $24,810.00 15630
> $24,870.00 88540
> $24,930.00 16890
> $24,940.00 90080
> $25,020.00 42980
> $25,030.00 9030
> $25,040.00 63590
> $25,150.00 265190
> $25,240.00 29400
> $25,250.00 37690
> $25,270.00 18330
> $25,330.00 201230
> $25,390.00 24210
> $25,440.00 16080
> $25,470.00 13530
> $25,500.00 40200
> $25,530.00 25710
> $25,750.00 26030
> $25,780.00 1237700
> $25,860.00 369430
> $25,910.00 25030
> $25,960.00 35120
> $26,040.00 29470
> $26,140.00 22570
> $26,270.00 748700
> $26,270.00 69320
> $26,290.00 24440
> $26,300.00 318120
> $26,330.00 61110
> $26,490.00 6860
> $26,490.00 157310
> $26,570.00 5390
> $26,610.00 182000
> $26,640.00 929530
> $26,720.00 112850
> $26,740.00 1500
> $26,760.00 4210
> $26,780.00 84460
> $26,780.00 207050
> $26,800.00 24160
> $26,870.00 12870
> $26,940.00 24760
> $27,030.00 276160
> $27,080.00 20190
> $27,160.00 40980
> $27,190.00 305330
> $27,240.00 257500
> $27,280.00 47850
> $27,290.00 118480
> $27,330.00 8880
> $27,520.00 1712600
> $27,520.00 300210
> $27,520.00 59790
> $27,570.00 128700
> $27,600.00 738610
> $27,700.00 21630
> $27,770.00 12320
> $27,820.00 25500
> $27,880.00 99430
> $27,900.00 13690
> $27,940.00 191070
> $27,960.00 53010
> $28,140.00 430
> $28,160.00 159580
> $28,200.00 8490
> $28,220.00 3480
> $28,250.00 356760
> $28,280.00 4570
> $28,330.00 34160
> $28,360.00 59840
> $28,370.00 85120
> $28,370.00 90060
> $28,390.00 626910
> $28,400.00 3370
> $28,460.00 119180
> $28,460.00 506720
> $28,480.00 39630
> $28,510.00 239130
> $28,550.00 8800
> $28,580.00 70820
> $28,710.00 62960
> $28,720.00 41320
> $28,740.00 76810
> $28,790.00 24200
> $28,810.00 138700
> $28,860.00 29030
> $28,920.00 892940
> $28,950.00 38840
> $29,260.00 27650
> $29,300.00 250200
> $29,300.00 76900
> $29,340.00 19770
> $29,350.00 2036090
> $29,400.00 6060
> $29,460.00 444790
> $29,500.00 35850
> $29,500.00 100640
> $29,530.00 93670
> $29,570.00 268950
> $29,630.00 5790
> $29,710.00 16810
> $29,760.00 122390
> $29,800.00 161730
> $29,980.00 36760
> $29,980.00 7610
> $30,010.00 8480
> $30,010.00 88480
> $30,060.00 33200
> $30,110.00 16840
> $30,240.00 159510
> $30,280.00 1777320
> $30,350.00 16570
> $30,380.00 2870
> $30,400.00 10250
> $30,470.00 66000
> $30,640.00 139740
> $30,690.00 14120
> $30,730.00 42830
> $30,770.00 3740
> $30,780.00 92090
> $30,800.00 26540
> $30,810.00 26380
> $30,820.00 116560
> $30,870.00 28280
> $30,900.00 101450
> $30,950.00 39150
> $31,020.00 67110
> $31,050.00 16270
> $31,100.00 223870
> $31,120.00 244700
> $31,150.00 9780
> $31,150.00 12810
> $31,170.00 890
> $31,180.00 91150
> $31,260.00 183090
> $31,320.00 47260
> $31,390.00 18370
> $31,430.00 28700
> $31,460.00 99030
> $31,560.00 505100
> $31,630.00 55450
> $31,660.00 142610
> $31,700.00 61180
> $31,750.00 189170
> $31,770.00 16960
> $31,820.00 206570
> $31,820.00 19930
> $31,820.00 108530
> $31,830.00 130600
> $31,890.00 71150
> $32,000.00 53790
> $32,000.00 4910
> $32,010.00 1710
> $32,020.00 10130
> $32,080.00 43420
> $32,100.00 186340

If the table is in $A$2:$B$81 and the salary of interest is in D2, then the
percentile should be =sumif(A2:A81,"<"&d2,B2:B81)/sum(B2:B81).
(This makes a simplify approximation that the number of employes shown for
any a_mean in your table all earn exactly that amount).

"Bob" wrote:

> Hi, I'm trying to see where my salary fits as compared to my fellow
> Americans. Basically I would like to know what percentile I'm in based on
> the US Mean Salary and total employment columns for 800 occupations that I
> grabbed for Nov. 2004 from the Bureau of Labor Statistics website. I got
> this data from here: http://www.bls.gov/oes/oes_dl.htm#2004_n From the
> file that says: "November 2004 National Cross-Industry estimates".
>
> I plotted the data in an excel spreadsheet to see if would come out like a
> bell curve, but it did not. So for instance, say I make $40,000. I would
> like to know exactly what % make more and less. By looking at the charts I
> made it is very difficult to tell. A solution that uses Excel would
> probably be the best since the 800 pieces of data are already in the
> spreadsheet. Ideally the solution would be flexible where I could plug in
> different salaries. Below are the data points I have, but the spreadsheet
> from the site also contains lots of data point as well. It looks like
> a_mean stands for Annual mean salary, where tot_emp stands for total
> employees in this data set.
>
> Thanks
>
> a_mean tot_emp
> $15,230.00 651530
> $15,430.00 2223820
> $15,560.00 393090
> $15,670.00 493310
> $15,980.00 2228950
> $16,020.00 15580
> $16,210.00 85240
> $16,290.00 483870
> $16,310.00 324570
> $16,730.00 243640
> $16,770.00 105040
> $17,110.00 231120
> $17,200.00 3451100
> $17,360.00 471640
> $17,560.00 555780
> $17,730.00 123960
> $17,820.00 107120
> $17,850.00 874060
> $17,870.00 209370
> $17,980.00 79500
> $18,030.00 887120
> $18,060.00 532400
> $18,080.00 47290
> $18,120.00 188950
> $18,290.00 215910
> $18,530.00 20880
> $18,570.00 93420
> $18,620.00 60010
> $18,730.00 198890
> $18,760.00 860050
> $19,070.00 44810
> $19,200.00 625770
> $19,430.00 244300
> $19,460.00 10160
> $19,620.00 86650
> $19,730.00 333920
> $19,880.00 44390
> $20,130.00 70210
> $20,190.00 18490
> $20,240.00 395950
> $20,270.00 45630
> $20,320.00 137240
> $20,330.00 **
> $20,370.00 770660
> $20,540.00 25870
> $20,540.00 8000
> $20,560.00 19800
> $20,600.00 16530
> $20,660.00 7480
> $20,670.00 28740
> $20,750.00 1260820
> $20,760.00 27610
> $20,800.00 2119800
> $20,830.00 29930
> $20,960.00 68630
> $21,000.00 4550
> $21,170.00 134570
> $21,170.00 54480
> $21,330.00 11870
> $21,590.00 504440
> $21,640.00 141470
> $21,650.00 573740
> $21,720.00 54310
> $21,730.00 22000
> $21,850.00 790
> $21,890.00 1395030
> $21,890.00 454950
> $21,960.00 85930
> $21,970.00 1606180
> $21,990.00 111380
> $22,120.00 64780
> $22,180.00 263570
> $22,190.00 2388930
> $22,260.00 866950
> $22,310.00 102180
> $22,380.00 992180
> $22,400.00 22790
> $22,410.00 16640
> $22,500.00 238310
> $22,570.00 22150
> $22,580.00 42570
> $22,750.00 202980
> $22,780.00 9300
> $22,880.00 4260150
> $22,890.00 108870
> $22,890.00 10290
> $22,900.00 1087330
> $22,970.00 13350
> $23,010.00 142940
> $23,020.00 22270
> $23,050.00 10230
> $23,170.00 19570
> $23,180.00 160020
> $23,240.00 38880
> $23,260.00 50380
> $23,270.00 41430
> $23,280.00 23420
> $23,320.00 17960
> $23,430.00 2890
> $23,520.00 49710
> $23,520.00 407650
> $23,560.00 8980
> $23,570.00 27660
> $23,650.00 148960
> $23,700.00 145110
> $23,720.00 335000
> $23,770.00 56600
> $23,780.00 81570
> $23,800.00 44880
> $23,810.00 405060
> $23,890.00 86810
> $23,890.00 28320
> $23,960.00 475700
> $24,030.00 59350
> $24,090.00 90900
> $24,350.00 74480
> $24,440.00 2943750
> $24,450.00 89570
> $24,560.00 350000
> $24,560.00 307400
> $24,580.00 412360
> $24,680.00 11320
> $24,800.00 27490
> $24,810.00 15630
> $24,870.00 88540
> $24,930.00 16890
> $24,940.00 90080
> $25,020.00 42980
> $25,030.00 9030
> $25,040.00 63590
> $25,150.00 265190
> $25,240.00 29400
> $25,250.00 37690
> $25,270.00 18330
> $25,330.00 201230
> $25,390.00 24210
> $25,440.00 16080
> $25,470.00 13530
> $25,500.00 40200
> $25,530.00 25710
> $25,750.00 26030
> $25,780.00 1237700
> $25,860.00 369430
> $25,910.00 25030
> $25,960.00 35120
> $26,040.00 29470
> $26,140.00 22570
> $26,270.00 748700
> $26,270.00 69320
> $26,290.00 24440
> $26,300.00 318120
> $26,330.00 61110
> $26,490.00 6860
> $26,490.00 157310
> $26,570.00 5390
> $26,610.00 182000
> $26,640.00 929530
> $26,720.00 112850
> $26,740.00 1500
> $26,760.00 4210
> $26,780.00 84460
> $26,780.00 207050
> $26,800.00 24160
> $26,870.00 12870
> $26,940.00 24760
> $27,030.00 276160
> $27,080.00 20190
> $27,160.00 40980
> $27,190.00 305330
> $27,240.00 257500
> $27,280.00 47850
> $27,290.00 118480
> $27,330.00 8880
> $27,520.00 1712600
> $27,520.00 300210
> $27,520.00 59790
> $27,570.00 128700
> $27,600.00 738610
> $27,700.00 21630
> $27,770.00 12320
> $27,820.00 25500
> $27,880.00 99430
> $27,900.00 13690
> $27,940.00 191070
> $27,960.00 53010
> $28,140.00 430
> $28,160.00 159580
> $28,200.00 8490
> $28,220.00 3480
> $28,250.00 356760
> $28,280.00 4570
> $28,330.00 34160
> $28,360.00 59840
> $28,370.00 85120
> $28,370.00 90060
> $28,390.00 626910
> $28,400.00 3370
> $28,460.00 119180
> $28,460.00 506720
> $28,480.00 39630
> $28,510.00 239130
> $28,550.00 8800
> $28,580.00 70820
> $28,710.00 62960
> $28,720.00 41320
> $28,740.00 76810
> $28,790.00 24200
> $28,810.00 138700
> $28,860.00 29030
> $28,920.00 892940
> $28,950.00 38840
> $29,260.00 27650
> $29,300.00 250200
> $29,300.00 76900
> $29,340.00 19770
> $29,350.00 2036090
> $29,400.00 6060
> $29,460.00 444790
> $29,500.00 35850
> $29,500.00 100640
> $29,530.00 93670
> $29,570.00 268950
> $29,630.00 5790
> $29,710.00 16810
> $29,760.00 122390
> $29,800.00 161730
> $29,980.00 36760
> $29,980.00 7610
> $30,010.00 8480
> $30,010.00 88480
> $30,060.00 33200
> $30,110.00 16840
> $30,240.00 159510
> $30,280.00 1777320
> $30,350.00 16570
> $30,380.00 2870
> $30,400.00 10250
> $30,470.00 66000
> $30,640.00 139740
> $30,690.00 14120
> $30,730.00 42830
> $30,770.00 3740
> $30,780.00 92090
> $30,800.00 26540
> $30,810.00 26380
> $30,820.00 116560
> $30,870.00 28280
> $30,900.00 101450
> $30,950.00 39150
> $31,020.00 67110
> $31,050.00 16270
> $31,100.00 223870
> $31,120.00 244700
> $31,150.00 9780
> $31,150.00 12810
> $31,170.00 890
> $31,180.00 91150
> $31,260.00 183090
> $31,320.00 47260
> $31,390.00 18370
> $31,430.00 28700
> $31,460.00 99030
> $31,560.00 505100
> $31,630.00 55450
> $31,660.00 142610
> $31,700.00 61180
> $31,750.00 189170
> $31,770.00 16960
> $31,820.00 206570
> $31,820.00 19930
> $31,820.00 108530
> $31,830.00 130600
> $31,890.00 71150
> $32,000.00 53790
> $32,000.00 4910
> $32,010.00 1710
> $32,020.00 10130
> $32,080.00 43420
> $32,100.00 186340