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)
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
You can check the below screenshot to find the usage of above formula.
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
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 :