How to Interpolate Missing Values in Google Sheets(Quick & Easy Guide)

In this tutorial you will learn How to Interpolate Missing Values in Google Sheets

How to Interpolate Missing Values in Google Sheets : Step by Step Guide

Here are the steps to Interpolate Missing values in Google Sheets .

As a first step we will need a data set to Interpolate Missing values in Google Sheets

In this example we have following dataset with missing values .

Now we need to calculate the Step value for the above mentioned data range.

We will use the below formula to perform the Calculation of Step value which can be used to fill the missing data.

Step Value = (End value – Start Value) / (#Missing observations +1)

Using the above formula we can perform the calculation as :

Step = (10 – 9) / (2 + 1) = 0.75

We will use the below formula in cell C2 and press enter

=(A13-A8)/(COUNTBLANK(A9:A12)+1)

You can check the below screenshot to find the usage of above formula.

Now we will fill the missing values with our calculated step value

Click on the first missing cell and type the formula required formula

cell number+step value

Now drag the formula downwards across the remaining cellls to fill the missing values .

Now we can visualize the interpolated values using a Line Chart to check whether the interpolated values fit in the data range.

To visualize the values Select any cell within the data set and press CTRL+A to select the entire dataset .
Now Click on the Insert menu and Select Chart from the drop-down

Insert->Chart

Google Sheet wil generate a default Chart ,On the Chart Editor under Chart type Select a Line Chart from the drop-down options.

It will generate a Chart as shown below

In the above tutorial we have shown you a step by step guide using which you can Interpolate Missing Values in Google Sheets.

We hope this tutorial on How to Interpolate Missing Values in Google Sheets was useful.