Time and Space Sliding Timer Hot spot analysis

[MayaAlmoussa]

Hello everyone! I have two data sets, one with FIPS map codes (identifies counties in the U.S) and another with average incidence of diseases over years. I want to analyze the hot spots of diseases in these counties over the years. For example: 

Data set 1: FIPS codes. 

Data set 2: Disease dat

FIPS	Disease avg	Year
A	1	2002
B	2	2002
C	3	2002
A	4	2003
B	5	2003
C	6	2003
A	7	2004
B	8	2004
C	9	2004

How can I join (or relate?) both tables, then do a hot spot analysis for each year, then represent those hot spot changes in a sliding timer animation? Youtube videos discussed Space-Tube Cube and Emerging Hot Spot analysis techniques, but I want more of a Sliding Timer representation to create a video. 

[DavidPike]

I would do a table join (one to many) on the FIPS codes layer (I guess you mean this is a spatial dataset) by FIPS code.  transferring the disease data attributes to the spatial table.

I'd then use the Shape Area to Normalize the disease figures by Area and/or Population.

Then symbolize the data as required (may possibly skip the normalization step if you normalize at the symbology stage) The data then should be in the correct format to be viewed with a time slider and any animation recorded.

For Hot Spot analysis, this identifies Statistically Significant 'hot' and 'cold' spots and is not to be confused with density.  I would split your joined data into separate Feature Classes by Year and run the Hot Spot tool.

After you have results for each year, combine them together into a single Feature Class with the rows labelled by Year.  You can then visualize and animate this the same way in a time slider.