How to analyze unbalanced data which three of independent factors are unbalanced levels?

[#1]

Hello,

I have a data set which has four predictors: three of the predictors including time, distance, and power are unbalanced and one balance predictor. Do you have any idea what is the best way to analyze such data? And how I can analyze them? I do appreciate any help.

[#2]

Hi @Shad ,

How about trying Stepwise regression with forward selection?  That way you will only include interactions that have data. Unbalanced is OK, but if there is missing data for a factor in an interaction, then you cannot use it. there is nothing one can estimate because the data is not there. If you have too many model effects and not enough data, then you cannot estimate all of the effects. 

Stepwise with forward selection can help in these cases. Same with Decision trees.

Hope that helps.

Chris

Chris

[#3]

I did the stepwise with forwardn selection and minimum BIC rule. Now it ended up with some significant factors. If I want to compare each factor level or their interaction means, how I can do that? I want to see if there is any significant differences in response among predictors levels or their interaction combinations. 

[#4]

Hi @Shad ,

Once the terms are selected, there is a button that says make model. For categorical models, you can add the whole effects and then the interaction terms and remove the parameterized effects.

Here is a link regarding Stepwise Regression that should help.

https://www.jmp.com/support/help/14/stepwise-regression-models.shtml#

Best,

Chris