How do I interpolate values into a range?

H

hello

Hi

I would like to interpolate values into a range.

Column B are the data. I would like to linearly interpolate the values in
column B into the ranges in column A. If it is easier, it is OK to assume
that the value in column B is for the midpoint of the ranges in column A.

Thank you
A B
18-19 17.5
20-24 33.8
25-29 53.1
30-34 68.0
35-39 85.3
40-44 97.5
45-49 100.0
50-54 97.2
55-59 91.1
60-64 53.5
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top