[Futuregen] Examplary graphs for the Data Navigator discussion

[Ricardo Rodrigues]

Dear colleagues,

Ahead of our zoom on Thursday we would like to share with you some 
graphs that would stand as possible examples for the data representation 
in the Data Navigator.


The original idea of the Data Navigator is to represent trends and 
evolution of "outcomes" (e.g. ADLs and IADLs, care giving and receiving) 
as well as their determinants (e.g. how education attainment, living 
arrangements, etc are evolving) across time, place (countries), cohorts 
and gender. Attached are files with different graphic representations 
for care giving and receiving based on SHARE data.

More specifically:

We have thought of depicting this information initially through 
traditional trend lines across time. These are represented in the file 
"FC_trend_country" attached for formal care receiving.

  After seeing Stefan and Johan's cohort graphs, however, we thought 
that these might provide a better portrait of the information we want to 
convey. We therefore put together similar cohort graphs for care 
receiving (formal and informal) and giving (informal only) for several 
cohorts, by gender and by education. These you will find in file 
"FC/IC/ICgave_country_gender" and "FC/IC/ICgave_country_education" 
attached. The data is presented by gender and by education levels for 
all countries that participated in at least 3 waves of SHARE. All lines 
have been smoothed using 5 year groups (i.e. we estimated the prevalence 
rates for 5 year, rather than year-on-year). The figures in the legends 
(e.g. 35-44 female) refer to the years of birth rather than the age of 
the cohorts.

Some "sensitivity graphs":

We also tested the possibility of presenting data for care receiving not 
only for the total population in that cohort/age/gender group - which is 
what is shown in all the graphs above - but also for those with care 
needs only (defined as having at least on ADL, OR one IADL, OR 
difficulties in mobility). We did this for formal care receiving in the 
file "FC_country_gender_need" attached.

As you will notice, the graphs on education do not always result very 
readable. The data depicted in many of them refers to very small numbers 
as those with primary and tertiary education are a relatively small 
group for these cohorts. We therefore depicted the graph for formal care 
received by education with only the upper and lower education groups in 
the file "FC_country_education_2" attached.

To overcome the issue of small numbers for those with primary and 
tertiary education, we also calculated the prevalence rates for formal 
care use for different income and wealth quartiles (1st - poorer - and 
last - richer).  These you will find in the file "FC_country_wealth_1" 
and "FC_country_income_1" attached.

Finally, we also thought it could be interesting to have the data above 
depicted not only per country (i.e. each graph refers to a country), but 
to combine different countries in one graph to compare the evolution 
across countries. An example of this for formal care receiving is 
represented in the file "FC_bycountry_AT_DESW" attached (for Austria, 
Germany and Sweden only as examples).

We know this is a lot of information to digest so we thought of 
detailing what we are sending you as much as possible. If you have any 
questions, please do not hesitate to contact us ahead of the zoom. We 
will also post this in FREEDCAMP and tomorrow we will have the agenda 
for the zoom there as well.

Best wishes,

Ricardo


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.euro.centre.org/pipermail/futuregen/attachments/20191216/5251d816/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FC_country_gender.pdf
Type: application/pdf
Size: 182942 bytes
Desc: not available
URL: <http://lists.euro.centre.org/pipermail/futuregen/attachments/20191216/5251d816/attachment-0011.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: IC_country_gender.pdf
Type: application/pdf
Size: 182711 bytes
Desc: not available
URL: <http://lists.euro.centre.org/pipermail/futuregen/attachments/20191216/5251d816/attachment-0012.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ICgave_country_gender.pdf
Type: application/pdf
Size: 183961 bytes
Desc: not available
URL: <http://lists.euro.centre.org/pipermail/futuregen/attachments/20191216/5251d816/attachment-0013.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ICgave_country_education.pdf
Type: application/pdf
Size: 304740 bytes
Desc: not available
URL: <http://lists.euro.centre.org/pipermail/futuregen/attachments/20191216/5251d816/attachment-0014.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: IC_country_education.pdf
Type: application/pdf
Size: 335636 bytes
Desc: not available
URL: <http://lists.euro.centre.org/pipermail/futuregen/attachments/20191216/5251d816/attachment-0015.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FC_country_education.pdf
Type: application/pdf
Size: 299819 bytes
Desc: not available
URL: <http://lists.euro.centre.org/pipermail/futuregen/attachments/20191216/5251d816/attachment-0016.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FC_trend_country_.pdf
Type: application/pdf
Size: 171570 bytes
Desc: not available
URL: <http://lists.euro.centre.org/pipermail/futuregen/attachments/20191216/5251d816/attachment-0017.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FC_country_gender_need.pdf
Type: application/pdf
Size: 275184 bytes
Desc: not available
URL: <http://lists.euro.centre.org/pipermail/futuregen/attachments/20191216/5251d816/attachment-0018.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FC_country_education_2.pdf
Type: application/pdf
Size: 278270 bytes
Desc: not available
URL: <http://lists.euro.centre.org/pipermail/futuregen/attachments/20191216/5251d816/attachment-0019.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FC_country_wealth_1.pdf
Type: application/pdf
Size: 253481 bytes
Desc: not available
URL: <http://lists.euro.centre.org/pipermail/futuregen/attachments/20191216/5251d816/attachment-0020.pdf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FC_country_income_1.pdf
Type: application/pdf
Size: 257301 bytes
Desc: not available
URL: <http://lists.euro.centre.org/pipermail/futuregen/attachments/20191216/5251d816/attachment-0021.pdf>