EXCEL DATA ANALYSIS! PROJECT STATISTICS

TourismData-1.xlsx

Sheet1

Year	Tourism (millions of visitors)	Rental Vacancy (% vacant)	Watercraft injuries (count)	Criminal Activity in Florida (Florida Uniform Crime Reports - Total Crime Index)	FL Alcohol Related Crashes (count)	FL Median Age	FL Consumer Sentiment Index (CSI)
1980	20
1981	21
1982	23
1983	24
1984	27
1985	29						99.30
1986	32	11					98.80
1987	34	11					95.56
1988	37	10.5					96.65
1989	39	9.5		1120515			95.72
1990	41	9		1122935			81.59
1991	40	9.1		1129704			78.40
1992	41	8.7		1112746			78.33
1993	41	8.3		1116567			81.50
1994	40	8		1130875			90.06
1995	41	7.8		1078619			90.61
1996	45	9		1079623			90.83
1997	47	9.5		1073757			98.36
1998	49	8.8		1025100	22,741		102.22
1999	59	10.3		934349	22,252		104.23
2000	73	10.8	293	895708	23,578	38.6	105.47
2001	70	11.5	219	911292	24,411	38.9	91.62
2002	74	10.2	270	900155	21,533	39.4	91.02
2003	75	11.5	187	881615	22,752	39.4	89.42
2004	80	11.7	142	850490	23,013	39.6	94.28
2005	84	10.1	125	838063	23,864	39.7	89.73
2006	84	10.7	146	849926	22,858	39.9	87.80
2007	85	13.7	128	876981	22,823	39.9	81.78
2008	84	16.9	159	883905	22,259	40.1	65.63
2009	81	17.8	153	824559	20,625	40.4	68.67
2010	82	15.1	122	770518	18,107	40.7	70.54
2011	87	14.9	151	769480	17,099	40.9	68.39
2012	92	13.1	124	725944	17,278	41	76.32
2013	94	10.3	125	698607	17,107	41.1	76.74
2014	99	10.1	98	673138	16,873	41.316	81.58
2015	107	8	128	662372	16,400	41.484	91.55
2016	113						91.58