I have a multiple regression problem, which I tried to solve using simple multiple regression:
model1 <- lm(Y ~ X1 + X2 + X3 + X4 + X5, data=data)
This seems to be explaining the 85% of variance (according to R-squared) which seems pretty good.
However what worries me is the weird looking Residuals vs Fitted plot, see below:
I suspect the reason why we have such parallel lines is because the Y value has only 10 unique values corresponding to about 160 of X values.
Perhaps I should use a different type of regression in this case?
Edit: I've seen in the following paper a similar behavior. Note it's a one-page only paper so when you preview it you can read it all. I think it explains pretty well why I observe this behavior but I'm still not sure if any other regression would work better here?
Edit2: The closest example to our case I can think of is the change in interest rates. FED announces new interest rate every few months (we don't know when and how often). In the meantime we gather our independent variables on the daily basis (such as daily inflation rate, stock market data, etc.). As a result we will have a situation where we can have many measurements for one interest rate.