Be sure to use the data for the state assigned to complete Assignment #1: Nursin

Be sure to use the data for the state assigned to complete Assignment #1: Nursin

Be sure to use the data for the state assigned to complete Assignment #1: Nursing Home Comparative Data.
Assignment Instructions
Review the following report in detail: “Trends in Low-Risk Cesarean Delivery in the United States, 1990-2013” from the CDC Website – https://www.cdc.gov/nchs/data/nvsr/nvsr63/nvsr63_06.pdfLinks to an external site. https://www.cdc.gov/nchs/data/nvsr/nvsr63/nvsr63_06.pdf
It is critical to read the full report to gain an understanding of how the study was conducted and to learn the details behind the data presented. This will help you specifically in answering Question #3.
Question #1: Create a line graph benchmarking your home state against the national percentage reflecting the trend of low-risk CS rate for the three years 1997, 2009, and 2013.
Your graph should include two separate lines with three data points each. One line should track the national percentage for the years described and the other should track your state’s percentage.
Question #2: Create a bar graph reflecting your home state’s percent of change in comparison to the national average percent of change for the same time period.
The report calculates the percent of change from 1997-2009 and from 2009-2013. In order to create the requested bar graph, you will need to calculate the percent of change from 1997-2013 for the United States as well as for your individual state. These two numbers will then be used to create a bar graph with two bars. One bar will show the percent of change for the United States from 1997-2013 and the other bar will show the percent of change for your state from 1997-2013. ***Use the numbers in the “Percent” columns for your calculations. For example, when calculating the percent of change for the United States, you will calculate the change between 18.4% in 1997 and 26.9% in 2013.
How to calculate the percentage change:
Step 1: Calculate the change (subtract old value from the new value)
Step 2: Divide that change by the old value (you will get a decimal number)
Step 3: Convert that to a percentage (by multiplying by 100 and adding a “%” sign)
Note: when the new value is greater than the old value, it is a percentage increase, otherwise it is a decrease.
Both graphs MUST include labels on both the x and y axis as well as a graph title.
Question #3:
Determine if your state trended within 2% of the national average, based on the percentage change. For instance, if you calculated the national change as 40%, the state change must be between 38%-42% to have trended within the +/- 2% of the national average. (Note: The 40% change indicated here is intended as an example and not the true calculation of the national change.)
If your state did not trend within +/- 2% of the national average rate, why do you think your home state varied? It may be helpful to analyze the individual rates of change from 1997-2009 and from 2009-2013 to see where the differences arose. It may also be helpful to consider factors such as race, age, and other demographic data within your individual state that could impact the percentage.
If your state did trend within +/- 2% of the national average rate, provide a discussion on what could possibly affect this number in the future, specific to the characteristics of your state.
In either situation, your answer should be a minimum of 150 words and include state-specific information. Outside resources to determine influencing factors are permissible and encouraged, but should be cited