The Pivot Table And Chart Report Exercise

1286 Words null Page
Pivot Table / Chart Report Exercise
There are four observations in the pivot table, and the one part of pivot table report is about the annual adult care facility, total number of census, SMI and SSI. The other part is about New York State Population, total population and total number of race and ethnicity distribution. The results that I received are come from the data Adult Care Facility Annual Survey and New York State Population. I use the pivot table or chart to get the observations.
At the first, I use the pivot table to analyze the total capacity. From the Observation 1 Table 1, we can figure out that each county has ration beds allowed. Total capacity Certified means that total number of Adult Care Facility beds allowed. Total Capacity
…show more content…
From Observation 4 Table 1, we can point out the result that white non-Hispanic is the largest ethnicity group no matter which age group people are. From Observation 4 Chart 1, we can see that people who are 45 years old to 54 years old are the largest group no matter people in which ethnicity. People who are 85 years old or over are the smallest group, people who are 75 years old to 84 years old are the second smallest group, and people who are 65 years old to 74 years old are the third smallest group. The situation means that population in New York State is increased, but people who need the adult care facilities almost the smallest group in population. At Observation 4 Table 2, we can know that the number of female is more than the number of male without ethnicity. We can know the result very clearly from Observation 4 Chart 2. At Observation 4 Table 3, we can receive the same result with the Observation 4 Table 1 that White non-Hispanic is the largest race group in New York State. It is more obviously from Observation 4 Chart 4. At Chart 4, the first largest number of people is New York State, the second largest number of people is Rest of State, and the third largest number of people is New York …show more content…
Trump should not invest in adult care area, and should not build adult care facilities. From Observation 1, I find that the adult care facilities certified are much more than the facilities operational. This condition means that the adult care organizations have enough to provide services for people who need services. And I compare ALP capacity certified and ALP end census. The result is there are many ALP capacity certified for organizations, but there are not too many people need ALP service. The conditions of ALR, EALR, and SNALR are very similar with ALP. From Observation 2, we know that number of people who need ALP, ALR service and so on is change from 2013 to 2014. Sometimes, number of people in 2013 is greater than 2014, or less than 2014. Therefore, the condition means that number of people who need adult care services is not always increase. There is no area to make profit. From Observation 3 and 4, I find that total number of people is increase. However, the old people are not increase from each county. The old people are the largest group need adult care facilities, but there are no many old people. Therefore, my opinion is Mr. Trump should not put money into Adult Care Area in New York State. The currency facilities can fully provide great services for people who need adult care

Related Documents