We can use Excel for many more purposes. I will tell it to how to use for finding a relation between two variable. Suppose we are given the columns as there in the data and we have to find a relation such that Y=A+BX, where Y is the first column and x is the second column then we can use regression tool to find a relation such as above. This relation can be extrapolated to find the values for an independent X.
