Pivot Table Report Observations

Improved 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

  • Improved Essays

    The book Labor’s Love Lost by Cherlin brings to light how the disappearance of the working-class family, along with other cultural shifts, has changed and damaged this American icon. A once thriving and growing social class, with endless possibilities has since hit a brick wall of sorts fracturing their livelihood and the fact that nothing stable has replaced the declining male-breadwinner family has pushed this social class into crisis and has hastened the fall of the working-class family (Cherlin 2014: 5). This book would be a wonderful addition for historians, sociologists, policy-makers, concerned citizens, as well as anyone interested in becoming better advocates for those who have been most effected by the collapse of the working-class…

    • 1009 Words
    • 5 Pages
    Improved Essays
  • Improved Essays

    Summary tables help you see the differences between these categories. For example, two categories that are shown in this data are gender and marital status. Why are these categories? They’re divisions that classify people regarding their shared characteristics. When taking two categories that are shown in this data, you can compare the one another.…

    • 762 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    GEOG 1004: Introduction to Human Geography Mandatory Assignment: Disruptive Demographics Student Name: _Alyn Wakefield__________ Student Number: _____906111600______ Questions: Q1. In the article, Six Disruptive Demographic Trends: What Census 2010 Will Reveal, James Johnson Jr. and John Kasarda outline a number of ‘disruptive demographic trends’ using data from the Census Bureau, the Bureau of Labor Statistics (BLS), the Internal Revenue Service, and other government agencies/sources. Please list the six disruptive trends that are outlined in the article. 1.______The…

    • 1503 Words
    • 7 Pages
    Improved Essays
  • Improved Essays

    The city council has concerns about the housing in the city for elderly citizens. The community is aging and the need of a new assisted living facility will to meet the demands within the community. Enlisting the use of planners will help in deciding how to best meet the community’s overall needs for assisted living as well as providing around the clock care for those citizens needing additional services. After analyzing the need for such services the plans, confirm the success of a new assisted living facility. The cost of the development is estimated at $4 million dollars that include purchasing the land, construction, and cost for financing the loans needed.…

    • 1375 Words
    • 6 Pages
    Improved Essays
  • Superior Essays

    In the article “The Dynamics of Racial Fluidity and Inequality” by Saperstein and Penner (2012), supports on the notion that race is a “flexible” tendency that changes throughout the years and across backgrounds, rather than being a characteristic that is attributed at “birth” and “fixed” (as cited in Grusky & Weisshar, 2014 p.692). In order to better understand how racial classification plays an important role over the life course of an individual this paper will analyze the article of Saperstein and Penner (2012), discuss two major concepts that are affecting social inequality, and point out two strengths/weaknesses that helped or hurt the article. Article The study by Saperstein and Penner (2012) focused on how race is typically treated…

    • 1962 Words
    • 8 Pages
    Superior Essays
  • Improved Essays

    According to the above case study, Plymouth is ethnically diverse community with different groups of population living including African American, Hispanic and Caucasian population. It showed that 40 percent increments in the community population of the Plymouth. Among other population, there seemed declining in the Caucasian population. According to the case study, the Plymouth community is facing declining in the community’s population because of various reasons such as economic issue and lack of employment opportunities. As it was listed that the previous population of the Plymouth community was 15,000 and the recent population is just 8,000.…

    • 1032 Words
    • 5 Pages
    Improved Essays
  • Improved Essays

    Nt1310 Unit 4 Assignment

    • 812 Words
    • 4 Pages

    Mode will be calculated for age, education level, ethnicity and referral source. From the frequency (f) distribution table and data table, bar charts and pie graphs will be generated to help visual the…

    • 812 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Baby boomer want to stay living in their own homes, but will face problems with enough healthcare professionals, cost of social needs, and long term health services. First, with such a large generation growing older, there is not enough healthcare workers of any type to accommodate this generation. With many…

    • 579 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    Over the last decade, Texas has seen changes in general patterns of demographics in reference to ethnicity, age, and income. This population shift has several implications on the future welfare of the Texas economy, government, and other public institutions. However, the Texas government has the ability to implement changes now to help curtail issues that lie ahead. Also, with such drastic changes in demographics, the partisan politics of Texas maybe redefined. Overall, Texas population has been diversifying and growing in strides.…

    • 787 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Between 2010 and 2016 Texas has had the nation’s largest annual population growth, however, this does not mean. 165 Years ago the population of Texas stood at 210,000 people, however, today is at an astounding 28 million. According to our textbook, there are three reasons for the population growth in Texas which are natural increase as a result of the differences between birth’s and death’s, international immigration particularly from Mexico and domestic immigration from other states. Currently, the population is not only growing the racial makeup is also changing. In 2050 it is predicted that the population will reach 41,311,222 and the Texan Latino population will be 54% while in 2010 the population was only 25,145,561 with 38% being Latino.…

    • 308 Words
    • 2 Pages
    Improved Essays
  • Decent Essays

    Who We Are. (2014). Retrieved September 30, 2015, from http://www.plannedparenthood.org/about-us/who-we-are/ Shrestha, L., & Heisler, E. (2011, March 31). The Changing Demographic Profile of the United States.…

    • 697 Words
    • 3 Pages
    Decent Essays
  • Improved Essays

    Unauthorized Immigration

    • 342 Words
    • 2 Pages

    Immigration has shaped the demography of Americans since colonial times. Immigration is an important issue the country faces today, misperceptions persist about fundamental aspects of this crucial topic such as the size and composition of the immigrant population, and how immigration affects the economy and the workforce in the U.S. Contrary to popular perception, less than half of all immigrants in the U.S are Hispanic or Latino. Approximately one-fifth of all immigrants are non-Hispanic white, the overwhelming majority are indeed Latino, primarily from Mexico and Central America. However, also populations of unauthorized immigrants from Asia, South America, Europe, Canada, and the Caribbean.…

    • 342 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    How culture and ethnicity may affect a person's physical and psychological health? Nurses often work with diverse populations with complexity in health and psychosocial problems, assisting them to promote wellness, whether regarding their mental or physical states, their environments, or their social habits, lifestyles, and choices. Nurses need to examine ways their cultural background may influence nursing care when working with patients from different cultural and ethnic groups. The article of Jackson et al., (2010) in their great work titled, "Women Health Centers and Minority Women: Addressing Barriers to Care" discussed the three barriers to identified and recognized access to health care of minority women. The barriers include policy,…

    • 1528 Words
    • 7 Pages
    Improved Essays
  • Improved Essays

    CCJ 6638: Communities & Crime Mariel Snouffer Topic 2: The Origins and Legacies of the Urban Crisis Contrary to the belief that anyone that works hard enough will be rewarded, “real life” is not necessarily the “American Dream” that everyone thinks. Neighborhoods do indeed matter for individual outcomes both independently and beyond individual characteristics. There are many long term impacts on the intergenerational transmission of poverty and wealth; and most certainly crossing racial and ethnic lines. The “American Dream” is the idea that is the primary story of American Immigration; the proposal that steered much of the thrust for civil rights. It is also a suggestion that has been undeviating with the American’s perception of impartial and just treatment, as long as there is a universal option for advancement.…

    • 619 Words
    • 3 Pages
    Improved Essays
  • Decent Essays

    Swot Analysis of Indonesia as a Destination for FDI: Strengths: • Geographically speaking, Indonesia lies in the strategic location through which the world trade transits, i.e. near straits of Malacca that link Indonesian ocean littoral to the South China Sea and the larger Pacific Ocean. If developed, can become a major transit hub in the world. • Country is rich in natural resources like coal, minerals like tin, gold, copper, nickel and bauxite, oil & gas and fertile land to support agricultural products. • Archipelago’s tropical climate and huge land bank makes it ideal for producing palm oil, rubber, coffee, cocoa, and rice. • Majority of the population i.e. 50% lies below 29 years of age, while 67% is below 39 years of age, which will…

    • 832 Words
    • 4 Pages
    Decent Essays