Forecast is a Worksheet Function available in MS Excel and it uses linear regression to find out the missing value. Now we will learn this function in detail now. This is an example of how to calculate the missing values with the help of a manual formula to understand interpolation. In school, we used to use the below formula to calculate the missing value of Y. Based on our example, it is 30 Cell A4 minus 60 Cell A2the result of which is then multiplied by 1 which equals Finally, the first section of the formula in brown above we add the first value of the speed of the bike. The second section in blue above calculates how far our speed of bike is away from the first speed of bike given, then multiplies it by the value calculated above. In the above example, the last section of the formula which is highlighted in red calculates how much time taken changes whenever the speed of bike changes by 1. We need to insert the below formula in cell B4. Using simple mathematics, we can calculate the missing values in the above example. Interpolation estimates the value based on the existing available data values which are relatable. In the world of mathematics, interpolation is a method of creating new data points with the help of known data points.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |