We have a list of 7 people with different heights and weights. We will extrapolate for the unknown weights. Method 1 – Using a Formula for Data Extrapolation in Excel Steps: Select cellF10. Insert the following
Excel also has a function calledtheTRENDfunctionthat can be used to extrapolate data without making graphs. Using linear regression, this statistical function will figure out what the next trend will be based on what we already know. Here is the previous example of theFORECASTfunction with theTRE...