The most important part of statistics is accurately and effectively communicating the results of a study. conduct a statistical study of the homeless levels in two years between 2010 and 2020, discussing the results of a hypothesis test, graphing their results, and concluding which visual display best represents your data.

Lab Procedure:

• Using Excel, perform the following statistical analyses:
  • Calculate descriptive statistics for each data set
  • Create the following graphs, with appropriate labels (See the resources below)
    • Generate a double bar chart
    • Generate a double box and whisker
  • In a Word Document,
    • Copy the descriptive statistics you created in Excel and past them into your Word Document. Compare and contrast the mean, the median, and the standard deviation between your two data sets.
    • Run a two-sample t-test for your data using the formula, the TI calculator, OR Excel. Explain the meaning of the test statistics and the p-value.
    • Copy the graphs you created in Excel and paste them into your Word Document. Write an explanation of which visual display you produced best represents your data.

	Homeless Population Per State from 2010 to 2020
State		2011	2020
Alabama		5558	3351
Alaska		2128	1949
Arizona		10504	10979
Arkansas		3424	2366
California	125128	161548
Colorado		15116	9846
Connecticut	4456	2905
DC		6546	6380
Delaware		1035	1165
Florida		56687	27487
Georgia		20975	10234
Hawaii		6188	6458
Idaho		2199	2315
Illinois		14009	10431
Indiana		6196	5625
Iowa		3134	2647
Kansas		2511	2449
Kentucky		6034	4011
Louisiana		9291	3173
Maine		2447	2097
Maryland		10208	6360
Massachusetts	16664	17975
Michigan		13185	8638
Minnesota	7495	7940
Mississippi	2306	1107
Missouri		8989	6527
Montana		1768	1545
Nebraska		3548	2404
Nevada		9150	6900
New Hampshire	1469	1675
New Jersey	14137	9662
New Mexico	3601	3333
New York		63445	91271
North Carolina	12896	9280
North Dakota	603	541
Ohio		13030	10655
Oklahoma	4625	3932
Oregon		17254	14655
Pennsylvania	15096	13375
Rhode Island	1070	1104
South Carolina	5093	4287
South Dakota	826	1058
Tennessee	9113	7256
Texas		36911	27229
Utah		3130	3131
Vermont		1144	1110
Virginia		8816	5957
Washington	20439	22923
West Virginia	2211	1341
Wisconsin	5785	4515
Wyoming		1038	612