How to interpolate in a Spreadsheet
Here's a useful trick that you might not have seen before. Suppose we have some data with includes rows with values missing, then we can use the below formula to apply linear interpolate to fill in the missing datapoints, without having to laboriously type in the interpolation formula long hand (which I used to do all the time)
You can download a Spreadsheet with an example at the following link:
I work as an actuary and underwriter at a global reinsurer in London.
Leave a Reply.