Quartile & Regression

[dataguy]

Margin	Variable 1	Variable 2
100	10	20
75	20	30
50	30	40
25	40	50

After setting up the  linear regression and also a step-wise regression on the above sample data (I have many more columns), I am noticing that the R^2 value of the targeted variable (margin) is around 20%. So, I am thinking of breaking the data into quartile (using Tile) and want to create a model to predict that my margin is in the first quartile. How would I do that?

[NicoleJohnson · Accepted solution]

You might be able to get some tips from this post + @jdunkerley79 solution about Calculating Quartiles. There are options in the Summarize tool that allow you to set % to create your quartile values... does that help? There is also an alternative solution from @MarqueeCrew in that posting that uses the Tile method you mentioned. :)

NJ