I have a list of 60 big companies, and some data for each. I also have the number of employees who have a given role in each of those companies.
I'm interested in finding if there is a correlation between the two. And I need a graphical representation (dispersions, bar, etc) of it as well, if possible.
My target is to get 3-5 learnings.
One example can be: every 200mln USD in sales, companies tend to have 1 person in that role...so for 1bln USD total sales ( = 200mln * 5) you can expect 5 people in that role.
Another example can be: companies with a market worth lower than 1bln don't really follow any rule, as some have people in that role, while others don't. But for companies with market worth from 1 to 5 billion there is one person in that role per billion, while for market worth from 5 to 10, there are 1.2 people per billion, for companies larger than 10, there are 0.8 people for billion....and so on
A last example can be: not all companies have people in that role, but those who do tend to have 1 every XYZ usd per 100mln of sales (or per 1bln of market worth).
These are just examples I invented. You can find any other type of correlation. If there's less than 3-5 learnings, it would still be ok.
17 freelancers están ofertando el promedio de $132 para este trabajo
Hi I can work on this project. I've been working with data and what you wanted is something like an exploratory analysis, finding relationship through correlations.