topic Re: running a regression in model builder? in ArcGIS Solutions Questions https://community.esri.com/t5/arcgis-solutions-questions/running-a-regression-in-model-builder/m-p/326457#M378 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hello all. I was asked to look into something at work, and I'm not really sure where to even start...<BR /><BR />We have a tool that runs a regression based on demographic data for rings and trade areas of a specific point. The work flow works like this...<BR /><BR />Trade area created based on Census tracts. Brought into ArcMap.<BR />Rings created for that specific point at 1, 3, 5 miles.<BR />Pull demographic data for rings and trade area.<BR />Input demographic data, as well as other data, into 3 Excel spreadsheets that reside in the same workbook. This is the regression.<BR />Regression gives a report detailing how each type of demographic data input into the model effects the overall model result.<BR />Report is given to the person who requested the model to be run on that specific site.<BR /><BR />Is this something that can be created in Modelbuilder?<BR /><BR />Thanks!!</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Hi Rafiq,</SPAN><BR /><BR /><SPAN>At the point where the data is being dumped to Excel are there calculations being performed that are comparing the data from separate tabs?&nbsp; Up to that point it appears pretty straight forward as far as a model being created for that part of the work flow.</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Jason R.</SPAN></BODY></HTML> Fri, 10 Jan 2014 22:52:24 GMT Jason_RobinsonRobinson 2014-01-10T22:52:24Z running a regression in model builder? https://community.esri.com/t5/arcgis-solutions-questions/running-a-regression-in-model-builder/m-p/326456#M377 <HTML><HEAD></HEAD><BODY><SPAN>Hello all. I was asked to look into something at work, and I'm not really sure where to even start...</SPAN><BR /><BR /><SPAN>We have a tool that runs a regression based on demographic data for rings and trade areas of a specific point. The work flow works like this...</SPAN><BR /><BR /><SPAN>Trade area created based on Census tracts. Brought into ArcMap.</SPAN><BR /><SPAN>Rings created for that specific point at 1, 3, 5 miles.</SPAN><BR /><SPAN>Pull demographic data for rings and trade area.</SPAN><BR /><SPAN>Input demographic data, as well as other data, into 3 Excel spreadsheets that reside in the same workbook. This is the regression.</SPAN><BR /><SPAN>Regression gives a report detailing how each type of demographic data input into the model effects the overall model result.</SPAN><BR /><SPAN>Report is given to the person who requested the model to be run on that specific site.</SPAN><BR /><BR /><SPAN>Is this something that can be created in Modelbuilder?</SPAN><BR /><BR /><SPAN>Thanks!!</SPAN></BODY></HTML> Thu, 09 Jan 2014 14:08:22 GMT https://community.esri.com/t5/arcgis-solutions-questions/running-a-regression-in-model-builder/m-p/326456#M377 RafiqBasaria 2014-01-09T14:08:22Z Re: running a regression in model builder? https://community.esri.com/t5/arcgis-solutions-questions/running-a-regression-in-model-builder/m-p/326457#M378 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hello all. I was asked to look into something at work, and I'm not really sure where to even start...<BR /><BR />We have a tool that runs a regression based on demographic data for rings and trade areas of a specific point. The work flow works like this...<BR /><BR />Trade area created based on Census tracts. Brought into ArcMap.<BR />Rings created for that specific point at 1, 3, 5 miles.<BR />Pull demographic data for rings and trade area.<BR />Input demographic data, as well as other data, into 3 Excel spreadsheets that reside in the same workbook. This is the regression.<BR />Regression gives a report detailing how each type of demographic data input into the model effects the overall model result.<BR />Report is given to the person who requested the model to be run on that specific site.<BR /><BR />Is this something that can be created in Modelbuilder?<BR /><BR />Thanks!!</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Hi Rafiq,</SPAN><BR /><BR /><SPAN>At the point where the data is being dumped to Excel are there calculations being performed that are comparing the data from separate tabs?&nbsp; Up to that point it appears pretty straight forward as far as a model being created for that part of the work flow.</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Jason R.</SPAN></BODY></HTML> Fri, 10 Jan 2014 22:52:24 GMT https://community.esri.com/t5/arcgis-solutions-questions/running-a-regression-in-model-builder/m-p/326457#M378 Jason_RobinsonRobinson 2014-01-10T22:52:24Z