Hi Everyone
Please can you help me with how to approach a relatively basic data analysis in most efficient way.
Data looks like pretty much like that, with a lot more rows of data but no more columns, i.e., only age, avc provider, fund type columns, but with a couple of hunder more rows with other values.
What I want to achieve are outputs like average fund value for each fund, total fund value for each fund and, more imporantly something linke this:
(these output tables are not related to the data sample above)
I am sure there is a smart way to do it without spending too much time on it. Pivot tables? If so, can you give me some guide how? I have just started learning about them so it is very new to me.
I will appreaciate you help.
Many thanks
balusm
Please can you help me with how to approach a relatively basic data analysis in most efficient way.
Data looks like pretty much like that, with a lot more rows of data but no more columns, i.e., only age, avc provider, fund type columns, but with a couple of hunder more rows with other values.
What I want to achieve are outputs like average fund value for each fund, total fund value for each fund and, more imporantly something linke this:
(these output tables are not related to the data sample above)
I am sure there is a smart way to do it without spending too much time on it. Pivot tables? If so, can you give me some guide how? I have just started learning about them so it is very new to me.
I will appreaciate you help.
Many thanks
balusm