Hello, I need some assistance with using the OLS regression tool in ArcMap 9.3. 1) I created a shape file from an excel file with XY coordinates using Arc Catalog. 2) I opened the table in arc map and added a unique field ID (=FID+1), using the field calculator. When I select the shape file in the OLS tool window I get a red X in the upper left corner of the first field. I am assuming the red X means there is a problem with the shape file. If I move through the rest of the fields in the tool and click the ok or run button I get an error message with no text. Is the shape file created correctly? Is the unique field ID created correctly? I have attached a sample of my excel data set for anyone to test. Any help is much appreciated. Ken P.S. the original data set has 10,000 observations and 80 variables.
... View more