Why do my explanatory variables disappear when trying to run OLS?

880
3
04-06-2019 11:45 PM
EbrarMohammad
New Contributor II

Hello,

I am trying to run Ordinary Least Squares Regression. I have compiled data, but for some reason, when I choose my input feature class, the other informational columns do not show up in the explanatory variables section. I have joined a few tables together to create this layer. I tried converting it into a file geodatabase feature class and to a shapefile, but that did not work. Any suggestions?

I have attached two snapshots to give you a better idea.

This image shows some of the variables which I am determining if there is a relation between them and the dependent variable:

This is what shows up when choosing the feature class:

Thank you for your time,

Abby

0 Kudos
3 Replies
DanPatterson_Retired
MVP Emeritus

The requirements for OLS are listed in the help topic 

Ordinary Least Squares (OLS)—ArcGIS Pro | ArcGIS Desktop 

Some suggestions in no particular order...

  • I assume you specified a Dependent variable at some stage, to see what Independent variables showed.
  • A quick glance at your table header shows what appear to be numeric fields aligned to the left, which suggests they are text fields and the 'numbers' are really text representations.  Check the fields to see if they are indeed numeric or have been converted to text.
  • As for the joining issue, the best way to ensure that you get the data you need is to use the Add Join tool which makes a new featureclass containing the data from the input featureclasses.
  • The warnings in the help topic need to be adhered to otherwise it won't work
EbrarMohammad
New Contributor II

Thank you! Yes they were misclassified for some reason. 

Sincerely,

Abby

0 Kudos
DanPatterson_Retired
MVP Emeritus

you can add a new field and convert the text fields to number fields if my observation was correct