So we can see in the above screenshot that the FORECAST function also works well for this. So let us now see in the below screenshot what happens when we apply this FORECAST function to interpolate the given x value: known_x’s: This is the known range of x values.known_y’s: This is the known range of y values.x: This is the value or data point whose corresponding value we wish to interpolate or predict.Now let’s say we wish to interpolate the same value in Example1 using the FORECAST function.įORECAST function estimates a value based on existing values along with a linear trend. So, the FORECAST function can be used in such cases. There can be times when it becomes difficult to memorize the formula. So we can see in the above screenshot that we have interpolated a value with two known values of x and y’s.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |