Calculate 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!

Advertisements

2 responses to “Calculate Range Spread

  1. I’m really enjoying the design and layout of your website.
    It’s easy on the eyes which makes it far more pleasant for me to come here and visit more regularly.
    Did you hire out a designer to create your
    theme? Superb work!

    Like

  2. Pingback: Measures of central tendency (a.k.a. mean, mode, & median) | CompAble

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