Interpolate Data

Overview

Interpolate Data is a tool to insert estimated values into a series based on the surrounding values. In general, Interpolate Data uses the left column as index (e.g., timestamps in time series) and fills empty cells with estimated values. Interpolation methods are listed below.

Videos

Examples

Here is a step-by-step example of using Interpolate Data to interpolate missing avocado average price.

1. Prepare an Excel sheet with data as follows.

   

2. Open Finplicity, and then click Data Basics > Interpolate Data. The form of Interpolate Data will appear, as shown below.

   

3. First select the data range to interpolate. In this example, select A1:B18.

4. Check the checkboxes based on your data. In the example, we need to check “Top row is the header row” and “The left column is the dates’ column.”

5. Then select the interpolation method. In this example, select “linear” for the linear method.

6. Select an output location. In this example, we selected D1.

   

7. Now you have finished all the required fields in this form, and you can click “Run” to interpolate data or click “Save” to save this task. Data interpolation will automatically be shown in its output location.