topic Re: Population Density correlation between two data sets in Data Management Questions https://community.esri.com/t5/data-management-questions/population-density-correlation-between-two-data/m-p/503771#M28547 <HTML><HEAD></HEAD><BODY><P>Thanks a lot, I will contnue in excel. Also I want to know is there any way to do that in ArcGIS, which tool I need to use for that?&nbsp;</P><P>Thanks in advance.</P></BODY></HTML> Mon, 23 Jan 2017 06:38:58 GMT SlobodanKomatina1 2017-01-23T06:38:58Z Population Density correlation between two data sets https://community.esri.com/t5/data-management-questions/population-density-correlation-between-two-data/m-p/503769#M28545 <HTML><HEAD></HEAD><BODY><P>I have a Excel spreadsheet with US Census Data and I want to know how to c<SPAN style="color: #494949; background-color: #ffffff;">orrelate the Night Light intensity data for Clark County, NV against provided US Census Data (2010) and growth? Which tools I need to use in order to solve this problem?</SPAN></P></BODY></HTML> Sun, 22 Jan 2017 16:22:28 GMT https://community.esri.com/t5/data-management-questions/population-density-correlation-between-two-data/m-p/503769#M28545 SlobodanKomatina1 2017-01-22T16:22:28Z Re: Population Density correlation between two data sets https://community.esri.com/t5/data-management-questions/population-density-correlation-between-two-data/m-p/503770#M28546 <HTML><HEAD></HEAD><BODY><P>excel has correlation and regression built-in. &nbsp;if that is all you want to do with the data, then I suggest you continue with excel</P></BODY></HTML> Sun, 22 Jan 2017 17:11:41 GMT https://community.esri.com/t5/data-management-questions/population-density-correlation-between-two-data/m-p/503770#M28546 DanPatterson_Retired 2017-01-22T17:11:41Z Re: Population Density correlation between two data sets https://community.esri.com/t5/data-management-questions/population-density-correlation-between-two-data/m-p/503771#M28547 <HTML><HEAD></HEAD><BODY><P>Thanks a lot, I will contnue in excel. Also I want to know is there any way to do that in ArcGIS, which tool I need to use for that?&nbsp;</P><P>Thanks in advance.</P></BODY></HTML> Mon, 23 Jan 2017 06:38:58 GMT https://community.esri.com/t5/data-management-questions/population-density-correlation-between-two-data/m-p/503771#M28547 SlobodanKomatina1 2017-01-23T06:38:58Z Re: Population Density correlation between two data sets https://community.esri.com/t5/data-management-questions/population-density-correlation-between-two-data/m-p/503772#M28548 <HTML><HEAD></HEAD><BODY><P>The&nbsp;<A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/tools/spatial-statistics-toolbox/ordinary-least-squares.htm" title="http://desktop.arcgis.com/en/arcmap/latest/tools/spatial-statistics-toolbox/ordinary-least-squares.htm">Ordinary Least Squares (OLS)—Help | ArcGIS Desktop</A>&nbsp;once you get your data in excel formatted properly and brought in using the excel toolset (&nbsp;<A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/understanding-how-to-use-microsoft-excel-files-in-arcgis.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/understanding-how-to-use-microsoft-excel-files-in-arcgis.htm">Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS Desktop</A>&nbsp;) . &nbsp;The online help would be a good bookmark...&nbsp;<A class="link-titled" href="http://desktop.arcgis.com/en/documentation/" title="http://desktop.arcgis.com/en/documentation/">Documentation | ArcGIS Desktop</A>&nbsp;</P></BODY></HTML> Mon, 23 Jan 2017 09:24:35 GMT https://community.esri.com/t5/data-management-questions/population-density-correlation-between-two-data/m-p/503772#M28548 DanPatterson_Retired 2017-01-23T09:24:35Z Re: Population Density correlation between two data sets https://community.esri.com/t5/data-management-questions/population-density-correlation-between-two-data/m-p/503773#M28549 <HTML><HEAD></HEAD><BODY><P>If you want to do this analysis, you will need to summarize the night light intensity data by census polygon. That would require doing some analysis in the GIS, for example that provided by the Zonal Statistics As Table tool.</P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/tools/spatial-analyst-toolbox/h-how-zonal-statistics-works.htm" title="http://desktop.arcgis.com/en/arcmap/latest/tools/spatial-analyst-toolbox/h-how-zonal-statistics-works.htm">How Zonal Statistics works—Help | ArcGIS Desktop</A>&nbsp;</P></BODY></HTML> Sun, 29 Jan 2017 04:04:37 GMT https://community.esri.com/t5/data-management-questions/population-density-correlation-between-two-data/m-p/503773#M28549 curtvprice 2017-01-29T04:04:37Z