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 .

Step 1 : Open Google Sheet and prepare yout data set

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 .

Step 2 : Perform Step value Calculation

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)
How to use Row and Rows Formula in ...
How to use Row and Rows Formula in Excel| Excel Tutorial For Beginners | Lesson - 20

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.

How to Interpolate Missing Values in Google Sheets

Step 3 : Interpolation of Missing values

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 .

Step 4 : Visualization of Interpolated 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

How to Interpolate Missing Values in Google Sheets(Conclusion)

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.

Related articles :

How to Insert Spin Button in Google Sheets ( Easy Guide )

How to Freeze Rows in Google Sheets

How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)

How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )