Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Subjective Independent Variables Share

Subjective Independent Variables

Excel Help for Subjective Independent Variables in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

Subjective Independent Variables

Rate this:
(4/5 from 2 votes)
Shocked Hello, I am a real estate appraiser and use the Multiple Variable Regression Analysis and Firecasting template. I have a question regarding subjective independent variables. For instance, # of bathrooms and # of bedrooms is cut and dry for the analysis. However, quality and condition is not. How would you recommend I employ a numeric value to the quality and condition of each independent variable used in the analysis? I've noticed when just 1 or 2 is used as an independent variable indicator, the results are often quite high. But ranges of 100-200 seem to adjust more proportionately. I hope I'm explaining and asking this in an understandable manner..?? Thank you to all who can help me!
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Applaud
Rate this:
(4/5 from 2 votes)
By adding more granularity to the factor level for qualitative variables we can get more accurate results.  This depends, of course, on the number of levels available in the data but more is preferable. 

If we have logistic data e.g. en-suite bathroom yes or no, then we can only have 2 levels: 1 and 0 but if we can gauge and create multiple levels of quality then we have a better way to predict the dependent variable when these values are specified for prediction.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Subjective Independent Variables in the