Displaying 2 results from an estimated 2 matches for "f003".
Did you mean:
2003
2016 Apr 10
0
unbalanced number of rows
...with rows specifying companies (codes are assigned to companies) and columns specify months (monthly data). The data is based on male (M) and female (F) information for each month. Following is an example of how data looks like:
01 02 03 04001 na M M M001 M M M F002 M F F na003 M na na M003 F M M F003 F F M M
na= no male/female.
Now, I want to firstly add rows with similar codes to see total number of Male and Female in each month. Secondly, I need to calculate fraction of Female in each month (F/ M+F) for these three companies.
Kindly guide me in this regard.
ThanksSaba
[[alternative HTML vers...
2016 Apr 10
0
unbalanced number of rows
...panies (codes are assigned
> to companies) and columns specify months (monthly data). The data is
> based on male (M) and female (F) information for each month. Following is
> an example of how data looks like:
> 01 02 03 04001 na M M M001 M M M F002 M F F na003 M na na M003 F M M
> F003 F F M M
> na= no male/female.
> Now, I want to firstly add rows with similar codes to see total number of
> Male and Female in each month. Secondly, I need to calculate fraction of
> Female in each month (F/ M+F) for these three companies.
> Kindly guide me in this regard.
> Thank...