Quartile & Regression

Question

MarginVariable 1Variable 21001020752030503040254050

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 Answer

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