Planning and reporting on your chart: 7. How could the Excel reports for PART TWO be structured to provide meaningful information about your 5 sets of data? What type of graph will you plan? Why? 3, Explain in words what the Excel graph created for PART TWO shows about the ve sets of data. For example: The graph shows that Hawaii exceeds the US average in percentage of mental health consumers who are employed, but New York State has a higher percentage than both Hawaii and the US average. Next, ..... . Type your answer BELOW this line - Part Two Of This Assignment: Using Excel, produce a chart and graph to compare FIVE (5) items reported you must compare New York State, your second state, and the U.S. amounts for the reported measures. PUT YOUR NAME at cell A1 on the sheet where you set up the chart for the graph. Start the chart at A5. -You must submit the EXCEL le, not a PDF or shared Google doc, in addition to this le. BE SURE to answer Question 7 (Planning the chart) and Question 8 (Reporting the results)! 3 Task Points Log on to Samhsa, find and review the URS Reporting Tables for New York State 15 Log on to Samhsa, find and review the URS Reporting Tables for the second state 15 Based on the reports, answer Questions 1 - 6 Question 1 - 15 Question 2 - 16 Question 3 - 16 Question 4 - 16 Question 5 - 16 Question 6 - 16 Total One through Six: 135 Excel chart, correct and submitted on time: 135 Question 7 - 15 Question 8 - /15 Total Seven and Eight: 120 Project Total: /100 Instructor Date Visit the Substance Abuse and Mental Health Services Administration [SAMHSA] National Mental Health Information Center Web site at www.samhsa.gov i. Click on DATA in the black bar ii. Click on Reports and Data Tables iii. On the left: set Survey Collection Dates to the latest available dates (usually a year behind) For example, From: 2017 To: 2017 iv. On the left: Survey Type - choose Uniform Reporting System (URS) v. Look for the latest report for New York - 20xx Uniform Reporting System (URS) Table for New York vi. Download this file and save it so that you can work offline. vii. Do the same process to find and download the report for your assigned 'other state' for the same year. Th Course: HT104 Health St x | foxl Inbox (618) . mwelsh@ * | fo HT104 online work . mu x | | Search| SAMHSA . Sub: x New York 2017 Uniform * $ 2017 Uniform Reporting x | G how to copy and paste . * | + cthisq-reports/NewYork-2017.pdf New York 2017 Uniform Reporting System Mental Health Data Results 6/30 6 0. S) Output Tables Page 5 of 30 Access Domain: Persons Serve o Psychiatric Hospital ge and Gender, FY 2017 New York Report d: 1/1/2016 To: 3/31/2017 Served in State Psychiatric Hospitals Penetration Rates rate per 1,000 population States Demographic 2.225 24.8% 9,131 06 02 Age 18-20 193 2.1%% 5.528 4:2% 0.2 53 Age 21-64 65.5% 109.218 83.0% 0.5 0.6 53 Age 65+ 680 7.6% 7.607 5.8% 02 03 Age Not Available 146 0.1% Age Total 8.965 100.0% 131.633 100.0% 0.5 04 3.010 33.5%% 43,080 32.7% 0.3 Male 5.975 66.5% 88,353 67.1% 0.6 0.6 Gender Not Available 200 0.2% Total 8.985 100.0%% 131.633 100.0% 0.5 04 54 Notes: US totals are based on states reporting. le uses data from URS Table 3 ah HT104.Gantt_ Chu.docx LL254 Form 2 Drat. .doc ^ dil Excel file for Chapt.kix ^ Qi Excel file for Chapt _xisx Of Excel file for Chapt.xisx ^ Q' Excel file for Chapt.xx Show allHow to read this report: Look at the two arrows ALWAYS use the percentage rates, not the population numbers. The United States and its territories have a much larger population than New York State alone, so comparing numbers will be meaningless. When comparing the two states, you can have both documents open on your screen and scroll down. NOTE: The first few pages are summary pages look inside the report! 3 Based on the reports shown, neatly type your answers on this template. Complete the following questions: 1. Can you nd consumer survey results details within the report? If your answer is Pg 1, 2, or 3, you are wrong Yes No If yes, what page? _ 2. What types of data are available within this report? Enter at least 5 different categories, and give the page numbers. If your answers are Pg 1, 2, or 3, you are wrong 3. How does New York State compare to the U.S. national average on various measures surveyed? Where is (are) the largest difference(s) you see? The smallest? Use PERCENTAGES, not population figures or dollar amounts. 4. Select a report for your assigned second state and compare the two state reports. a.