Calculating Range Spread


Determining the minimum and maximum when only the midpoint is known . . .

When using survey data to determine the salary range for a position, you could use the 10th 50th and 90th percentiles as your minimum, midpoint, and maximum for the range. One of the problems with doing that, though, is that those points tend to fluctuate with the survey data so that you never really know what your range spread is from position to position.

There is a simple method for determining the min, mid, and max of your salary range when only the midpoint of the survey data is known. First, you have to decide whether you want to use the 50th percentile as your midpoint or use the mean of the salary data for the demographic elements you’ve selected. For this example, let’s use the mean shown below.

Image from Compensation.BLR.com Salary Finder

Image from Compensation.BLR.com Salary Finder.

The next decision you need to make is the range spread. Do you want it to be 25%, 50%, 75%, or even more? For this example, let’s use 50% as our range spread. In this case, the midpoint of our rage is $135,500 (rounding is okay).

To find the minimum, divide the market rate by 1.00 + ½ of the range spread:

Compable10

To find the maximum, multiply the minimum times 1 plus the range spread:

Compable11

See, it’s really easy!

NOTE: If you’d like to see this formula in action, go to http://compensation.blr.com/timesavers/Calculators/Compensation/Compensation-Administration/Job-Grade-Rate-Range-Calculator/

 

Advertisements

35 responses to “Calculating Range Spread

  1. My brother suggested I might like this blog. He was entirely right.
    This post actually made my day. You can not imagine simply how much time I
    had spent for this info! Thanks!

    Like

  2. I’m really enjoying the design and layout of your site.

    It’s a very easy on the eyes which makes it much more pleasant for me to come here and
    visit more often. Did you hire out a developer to create your theme?
    Excellent work!

    Like

  3. This is an excellent web page, could you be interested in doing
    an interview concerning just how you designed it?
    If so e-mail me!

    Like

  4. Very nice post. I just stumbled upon your weblog
    and wished to say that I have really enjoyed surfing around your
    blog posts. In any case I will be subscribing to your rss feed and I
    hope you write again soon!

    Like

  5. I’m more than happy to find this web site. I need to to thank you for your time for this particularly fantastic read!!
    I definitely savored every little bit of it and I have you saved as a favorite to see new information on your
    web site.

    Like

  6. Setting up and managing a blog is really easy with WordPress. just go to http://www.wordpress.com and you’ll find easy to understand instructions. Also, they have a great “help” team to get you over any small hurdles you might encounter.

    Once you get your blog set up, be sure to send me a link. Happy blogging!

    Like

  7. Very worthwhile information!Ideal! just what I was looking for!

    Like

  8. Pretty great post. I just stumbled upon your weblog and wished
    to say that I have really enjoyed browsing your blog posts.
    After all I will be subscribing to your rss feed and I’m hoping you write once more very soon!

    Like

Please share your thoughts.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s