The most important part of statistics is accurately and effectively communicating the results of a study. conduct
Fantastic news! We've Found the answer you've been seeking!
Question:
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 | |||
Expert Answer:
Posted Date:
