Is it Best for the Elderly to Move to a Residential Care Home?

I have just read the results of the first Care Index from Partnership which states nearly 60% of the elderly do not want to go into a care home. Having elderly relatives in our family I can fully understand this but is it best to be looked after at home or not?