Ran Ordinary Least Squares and the output table is in Excel. I am using the data from the 5 variables to predict the value in another data set with the same variables. I was hoping to have a calculated field where I could multiply the coefficient times the whole column for all 5 variables. Coefficient 1 times Variable 1, Coefficient 2 times variable 2, etc. Does anyone have any experience doing this?
