Forum Discussion

mvandes's avatar
mvandes
Copper Contributor
Apr 28, 2024

Regression with a variable that has 20 different categories

I need to run a regression with a variable that has 20 different categories. I figured i could make a dummy with 20 different columns with 1 and 0. However when im running my regression i can only use 16 X variables. Does anyone know how i can fix this?

excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Apr 29, 2024
    You could use the LINEST function to get the stats you're after?

Resources