Using Linear Regression to Fill in Missing Values

Hi Everyone,

I am trying to use linear regression to fill in values (Excel 2003). If I have two arrays of values (X,Y) with known X values and only the first and last Y values, how can I get Excel to calculate and fill in the unknown Y values for each other X value? I have attached a small excel file to illustrate the problem.

I see this as a linear regression problem and can get my calculator to do it but of course would like to be able to generate unkown values for many X values so the calculator becomes laborious.

It seems like such as simple task but I simply cannot seem to figure it out. Appreciate any help anyone can throw my way.

Matty @ MHS

Thanks shg,

I was hoping there was a function for it but looks like I'm doing it manually.

Thanks again,

Matty @ MHS