Need a hand? All the help you want just a few clicks away
I am running a multiple linear regression (MLR) and of the explanatory variables is log-transformed and the other is not. How do I use the MLR equation to predict the dependent variable? Specifically, do I use exponent in excel on the result? or exponent on just that variable that was log-transformed and the coefficient? For example, here 2.33 is a log-transformed value =EXP(2.47+((0.44*2.5)+(0.29*2.33))). Or does there need to be a EXP in front of the (0.29 *2.33) portion of the equation?
For predictions, no need to enter any EXP. If the model equation was built over log-transformed variables, just enter the log transformed predictor values:
Y = 2.47 + 0.44*2.5 + 0.29*2.33
XLSTAT first steps and statistical learning resources
The place where you will master all of XLSTAT features
Any feature or option you’d like us to develop?
For those of you who prefer video help