Pivot Table Report Observations

Decent Essays
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

  • Decent Essays

    The study population from the Finklestein study was the already existing cohort from FREEDOM Study. The overall cohort was formed from 500 participants at 70 clinical sites (Finkelstein et al, 2012). Participants are enrolled in the cohort for 3 years with a minimum of an 18 month follow-up. Cohort members were required to be adult patients with ESRD who were considered suitable candidates for special prescription of daily hemodialysis via the NxStage System One device (Finkelstein et al, 2012). Participants were all also required to have Medicare as their primary insurance payer for administrative reasons.…

    • 1017 Words
    • 4 Pages
    Decent Essays
  • Decent Essays

    One issue with determining the characteristics within this generation as that the younger members have lived a different life than the older ones; while the older ones grew up with technology, it was nowhere near as advanced as it was with the younger members. If you were to ask an older member of the Millennial Generation if the younger members were self-absorbed then they may agree because they did not grow up with social media and the technology in the same way. As stated earlier though, with such a large population in this generation it is not easy to put everyone under the same category. The evidence proves that the majority of the Millennial Generation is determined to better the world and they have the self-confidence to do it. As time goes on the Millennials will be the ones to change history in ways previous generations would have never found to be…

    • 1127 Words
    • 5 Pages
    Decent Essays
  • Decent Essays

    Again, the numbers seem to tell it all. China’s current GDP growth is 6.9 percent, about three times as high as the United States’. Yet, just like the United States did, China is experiencing rapid growth as it industrializes. Americans seem to forget that the standard of living in the United States is far higher than that of China. The United States has 221 times as many secure internet servers per one million people than China does.…

    • 1797 Words
    • 8 Pages
    Decent Essays
  • Decent Essays

    In many situations a family may not qualify for benefits through income, but qualifies after deductions such as medical and healthcare costs, taxes and other work expenses. Too many are dependent on the government funding and decide to stay there. There should be a guaranteed standard of living to encourage successfulness. Welfare in the United States has not provided a guaranteed standard of life “poverty rates in the US remain much higher than any other nation, and barely provide any kind of decent living conditions” (Cochran). The programs in place have not lifted people out of poverty fast enough.…

    • 1676 Words
    • 7 Pages
    Decent Essays
  • Decent Essays

    “With this new perspective, high-skill jobs are not limited to advanced degrees and represent a larger part of the American middle class” (Sauter). He mentioned that these employees receive $53,000 which is 10% higher than the ones that are required and educational background. To include, among the eight more popular STEM jobs that do not require a college degree, there were six jobs that paid more than the national annual average wage of $45,230. There were almost 500,000 employees working on a computer analyst that gets paid $82,320, on average. People with skills have the better opportunity in a job and they can as well be…

    • 722 Words
    • 3 Pages
    Decent Essays
  • Decent Essays

    In an interview, PBS talks to David Cutler, who states that administrative costs are one of the main reasons for the high healthcare cost giving an example of Duke University Hospital having 1,300 billing clerks while a typical Canadian hospital only has a handful of clerks. The issue here is that many of the clerks employed in the U.S. could easily be done without. Other countries with lower costs have more automated file management systems, and since they are single payer systems in most cases getting payment is simple. This is not the case in the United States where most patient files are hard copies and there are so many different health care providers that can provide payment to a hospital. Thus, the United States needs many more clerks to handle the filing and payment options.…

    • 1626 Words
    • 7 Pages
    Decent Essays
  • Decent Essays

    Greater New York takes the lead for the city with the most jobs in this field at an impressive 4,070 (“Top 10 Cities 1). California leads in the state category at an even more impressive…

    • 1189 Words
    • 5 Pages
    Decent Essays
  • Decent Essays

    Unfortunately the difference between post industrialized nations and developing ones surpasses these factors alone. They typically suffer from the absence of a stable government as well. Due to this issue, many countries lack the ability to even begin setting up the networks needed to adopt cell phones. This inaction puts them even further behind in respect to the rest of the world. The government plays an important role as James notes that " One of the best examples in this regard is Jamaica whose growth rate in mobiles has far exceeded the growth rate achieved by most other developing countries" (James…

    • 1264 Words
    • 6 Pages
    Decent Essays
  • Decent Essays

    Herbalife Case Study

    • 1169 Words
    • 5 Pages

    These tiny companies do not have large enough share of the market to be able to influence the industry's direction. In other words, they only have little power to compete with large companies like Herbalife. (Knudsen, K. n.d.) However, the shake industry has reached the peak of its growth because majority of consumers are more interested in cost than quality. This has led to lower profit margins and greater competition as growth continues to decline. Fortunately, Herbalife has many followers that are loyal to the Herbalife brand, which other shake companies lack.…

    • 1169 Words
    • 5 Pages
    Decent Essays
  • Decent Essays

    “Trickle down” policies were implemented around the 1980s and their effects had set in, because later in 2000 the same records were taking again. They showed in 2000 the richest 5% of Americans earned $250,146 an 100% increasing from what they earned 33 years prior. As for the lowest 20% of Americans, they saw their incomes increase only 42% to a total of $10,190, which is below the federal poverty line (People). More recent studies have been done on income inequality and have found it shows no signs of decreasing. Emmanuel Saez and Gabriel Zucman, found that the richest 1% of americans earn 21.2% of all aggregate income in the United States as of 2015 (Inequality).…

    • 967 Words
    • 4 Pages
    Decent Essays