I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbInterp

If you have a given set of known (x, y) points and you need to know y-parts of other given x parts then you need to interpolate. It is similar to filling gaps of a table:

sbInterp_01_Screen
sbInterp_02_Screen
sbInterp_01_Code
sbInterp_02_Code
sbInterp_03_Code

If you cannot or if you do not want to use macros, you might want to interpolate with these worksheet functions (poor you):

Poor man's interpolation (PERCENTILE / PERCENTRANK approach)

Poorest man's interpolation (piecewise TREND approach)

If you are lucky and your slopes between adjacent points are monotonously increasing or decreasing you can apply the funnily short MiniMax Interpolation.

If you are interested in downloading a 28 KB Excel 2010 sample file which was used to create the examples on this page go to my Download page, please.

Sulprobil   Get it done   Contact   Disclaimer   Download