Need to perform interpolation or forecasting for the remaining portion of the matrix

dabohra

New member
Joined
Oct 3, 2012
Messages
3
Reaction score
0
Points
0
hi

I am in a unique situation where i have to develop an excel where i have to update the remaining portion of the table based on the details already provided in the excel. Can anyone of you please take a look and let me know if any formula can help in developing the data for the missing cell. I am attaching the spreadsheet for your reference.

Thanks,
Amit
 

Attachments

  • Matrix interpolation.xlsx
    14.4 KB · Views: 22

eisayev

New member
Joined
Oct 1, 2012
Messages
33
Reaction score
0
Points
0
Location
Baku, Azerbaijan
forecast wont work as it can accomodate only 2 variables instead of 3 varaibales that i hav now...

Yesterday I used forecast function. I compared the results to known values and it seems right. There are different values in every row which means its value changing dependent on third variable (the numbers in column). I think it worths to try
 

dabohra

New member
Joined
Oct 3, 2012
Messages
3
Reaction score
0
Points
0
can u pls share the formula so that i can check if it is working fine....
 
Top