Question: Excel Lab: 2 Sample Data Sets For this lab, conduct a statistical study of the homeless levels in two years between 2010 and 2020, discussing
Excel Lab: 2 Sample Data Sets
For this lab, 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:
- Use the data set below:
| 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 |
- Using Excel, perform the following statistical analyses:
- Calculate descriptive statistics for each data set
- Mean, Standard Error, Median, Mode, Standard Deviation, Sample Variance, Kurtosis, Skewness, Range, Minimum, Maximum, Sum, Count
- Create the following graphs, with appropriate labels (See the resources below)
- Generate a double bar chart
- Generate a double box and whisker
- Calculate descriptive statistics for each data set
- 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. Provide an explanation of which visual display you produced best represents your data.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help