How to Extrapolate Data in Excel: 5 Handy Ways 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 cell F10. Insert the following formula for data extrapolation...
Use Extrapolation Formula to Extrapolate Data We will put the Extrapolation Formula in the formula bar after selecting the desired cell. The extrapolation formula is: Y(x) = b+ (x-a)*(d-b)/(c-a) Here is an example of this method: Apply this equation to the empty cell, we will get...