Interpolation in Excel based on Splines and Natural Neighbor Algorithm

2D (Curve) Interpolation
Use INTERPXY to:
  1. Interpolate from a set of (x,y) data points.
  2. Map a set of scattered (x,y) data points onto a uniform grid for curve plotting.
3D (Surface) Interpolation
Use INTERPXYZ to interpolate from a set of (x,y,z) data points.
3D Scattered data Gridding
Use GRIDXYZ to map a set of scattered (x,y,z) data points onto a uniform rectilinear grid for surface plotting.

Video Illustrations

How to interpolate (x,y) data points with INTERPXY()

Description

This video demonstrates how to use the function INTERPXY to interpolate on a graph generated from discrete (x,y) data set points in both Excel and Google Sheets by the ais of splines.

How to interpolate from a set of (x,y,z) points with INTERPXYZ()

Description

This video demonstrates how to use the function INTERPXYZ to interpolate from a set of discrete (x,y,z) data points in both Excel and Google Sheets. INTERPXYZ is based on natural neighbor algorithm.

How to plot interpolate and plot surface from scattered (x,y,z) data points with GRIDXYZ()

Description

This video demonstrates how to use the function GRIDXYZ to interpolate a set of scattered (x,y,z) data points onto a uniform rectilinear grid in both Excel and Google Sheets. And, how to generate a surface plot in Excel using the interpolated grid data. GRIDXYZ is based on natural neighbor algorithm.
Question or Comment? Email us:
support @ excel-works.com

ExceLab: Transforming Excel into a Calculus Power House

ExceLab functions and methods are protected by USA Patents 10628634, 10114812, 9892108 and 9286286.

Share
© 2015-2024, ExcelWorks LLC
Boston, USA