topic Re: Why do my explanatory variables disappear when trying to run OLS? in Implementing ArcGIS Questions https://community.esri.com/t5/implementing-arcgis-questions/why-do-my-explanatory-variables-disappear-when/m-p/314910#M319 <HTML><HEAD></HEAD><BODY><P>The requirements for OLS are listed in the help topic&nbsp;</P><P><A class="link-titled" href="https://pro.arcgis.com/en/pro-app/tool-reference/spatial-statistics/ordinary-least-squares.htm" title="https://pro.arcgis.com/en/pro-app/tool-reference/spatial-statistics/ordinary-least-squares.htm">Ordinary Least Squares (OLS)—ArcGIS Pro | ArcGIS Desktop</A>&nbsp;</P><P></P><P>Some suggestions in no particular order...</P><UL><LI>I assume you specified a Dependent variable at some stage, to see what Independent variables showed.</LI><LI>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.&nbsp; Check the fields to see if they are indeed numeric or have been converted to text.</LI><LI>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.</LI><LI>The warnings in the help topic need to be adhered to otherwise it won't work</LI></UL></BODY></HTML> Sun, 07 Apr 2019 14:01:54 GMT DanPatterson_Retired 2019-04-07T14:01:54Z Why do my explanatory variables disappear when trying to run OLS? https://community.esri.com/t5/implementing-arcgis-questions/why-do-my-explanatory-variables-disappear-when/m-p/314909#M318 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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?</P><P></P><P>I have attached two snapshots&nbsp;to give you a better idea.</P><P>This image shows some of the variables which I am determining if there is a relation between them and the dependent variable:</P><P></P><P><IMG class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/441379_pastedImage_2.png" /></P><P></P><P>This is what shows up when choosing the feature class:</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/441378_pastedImage_1.png" /></P><P></P><P></P><P>Thank you for your time,</P><P></P><P>Abby</P></BODY></HTML> Sun, 07 Apr 2019 06:45:43 GMT https://community.esri.com/t5/implementing-arcgis-questions/why-do-my-explanatory-variables-disappear-when/m-p/314909#M318 EbrarMohammad 2019-04-07T06:45:43Z Re: Why do my explanatory variables disappear when trying to run OLS? https://community.esri.com/t5/implementing-arcgis-questions/why-do-my-explanatory-variables-disappear-when/m-p/314910#M319 <HTML><HEAD></HEAD><BODY><P>The requirements for OLS are listed in the help topic&nbsp;</P><P><A class="link-titled" href="https://pro.arcgis.com/en/pro-app/tool-reference/spatial-statistics/ordinary-least-squares.htm" title="https://pro.arcgis.com/en/pro-app/tool-reference/spatial-statistics/ordinary-least-squares.htm">Ordinary Least Squares (OLS)—ArcGIS Pro | ArcGIS Desktop</A>&nbsp;</P><P></P><P>Some suggestions in no particular order...</P><UL><LI>I assume you specified a Dependent variable at some stage, to see what Independent variables showed.</LI><LI>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.&nbsp; Check the fields to see if they are indeed numeric or have been converted to text.</LI><LI>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.</LI><LI>The warnings in the help topic need to be adhered to otherwise it won't work</LI></UL></BODY></HTML> Sun, 07 Apr 2019 14:01:54 GMT https://community.esri.com/t5/implementing-arcgis-questions/why-do-my-explanatory-variables-disappear-when/m-p/314910#M319 DanPatterson_Retired 2019-04-07T14:01:54Z Re: Why do my explanatory variables disappear when trying to run OLS? https://community.esri.com/t5/implementing-arcgis-questions/why-do-my-explanatory-variables-disappear-when/m-p/314911#M320 <HTML><HEAD></HEAD><BODY><P>Thank you! Yes they were misclassified for some reason.&nbsp;</P><P></P><P>Sincerely,</P><P></P><P>Abby</P></BODY></HTML> Mon, 08 Apr 2019 18:15:34 GMT https://community.esri.com/t5/implementing-arcgis-questions/why-do-my-explanatory-variables-disappear-when/m-p/314911#M320 EbrarMohammad 2019-04-08T18:15:34Z Re: Why do my explanatory variables disappear when trying to run OLS? https://community.esri.com/t5/implementing-arcgis-questions/why-do-my-explanatory-variables-disappear-when/m-p/314912#M321 <HTML><HEAD></HEAD><BODY><P>you can add a new field and convert the text fields to number fields if my observation was correct</P></BODY></HTML> Mon, 08 Apr 2019 18:39:42 GMT https://community.esri.com/t5/implementing-arcgis-questions/why-do-my-explanatory-variables-disappear-when/m-p/314912#M321 DanPatterson_Retired 2019-04-08T18:39:42Z