Desktop productivity for business analysts and programmers

Create table with difference sort of data proportion

Reply
N/A
Posts: 0

Create table with difference sort of data proportion

I have this table:

ID AGE SEX Year Retired Wave
1 50 M Not retired 1
2 60 F 2001 1
3 70 M Not Retired 1
5 45 F 2001 1
1 51 M 2002 2
2 55 F Not Retired 3
6 65 F 2004 4
...
...

I would like to build a graph like this :

Proportion of female who retired by 2002= Retire by 2002 / ( Total just Retired + Non Retired in 2002 ) [ only wave 1 person involved ]
|
|
|
|
|____________
Age

Proportion of female who retired by 2002= Retire by 2002 / ( Total just Retired + Non Retired in 2002 ) [Only wave 2 Persons involved]
|
|
|
|______
Age

Secondly, how could I group the proportion by group age instead of just one age. 55-59 instead of 55, 56, 57 ...


Thank you.
Ask a Question
Discussion stats
  • 0 replies
  • 91 views
  • 0 likes
  • 1 in conversation