Find correlations in data - people of a given role in a company and size or sales or number of employees of that company

เสร็จสมบูรณ์ โพสต์แล้ว 7 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
เสร็จสมบูรณ์ ชำระเงินเมื่อจัดส่ง

Hi,

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.

Thanks!

การวิเคราะห์ธุรกิจ การประมวลผลข้อมูล Excel วิเคราะห์สถิติ สถิติ

หมายเลขโปรเจค: #12314088

เกี่ยวกับโปรเจกต์

15 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

มอบให้กับ:

humayunfl

Dear Sir/Madam I read this job's description and understand that I am perfect in this job . I am expert in Internet Research, Web Scraping, PHP, PDF, Academic Writing, BPO, Copy writing, Data Entry Data Entry, Data Pr เพิ่มเติม

$35 USD ใน 3 วัน
(4 รีวิว)
1.6

freelancer 15 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $131

prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do make correlation between your data and show it in bar or pie chart :) please give me a chance for doing your project and im able to start doing your projec เพิ่มเติม

$30 USD ใน 3 วัน
(405 รีวิว)
7.6
emamulbd

Dear Client, Your job posting catches my attention and I submit the proposal as a desired candidate. I'm a full time freelancer experienced in Lead Generation, Virtual Assistant, PDF conversation, Social Media Marke เพิ่มเติม

$155 USD ใน 3 วัน
(72 รีวิว)
6.1
smartresearch1

I am an expert in data analytics and predictive modeling. I have extensive experience in getting business insights from data. I have worked in sales improvement, processes, supply chain and procurement optimization (co เพิ่มเติม

$220 USD ใน 4 วัน
(5 รีวิว)
4.6
taseerali99

Hi, I hope this message sifts through the spam and finds you well. I am a professional statistical consultant with over 100 successful projects completed on this freelance platform. Would love to help you with SP เพิ่มเติม

$388 USD ใน 5 วัน
(15 รีวิว)
4.6
Jammy08

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.

$88 USD ใน 3 วัน
(2 รีวิว)
2.5
TeddyGreif

I am a PhD Student in Germany who have time to do a freelance job from my home. I am organized and dedicated towards the task that will be given to me. I have a reliable and fast internet at home. You are welcome to co เพิ่มเติม

$200 USD ใน 3 วัน
(2 รีวิว)
2.7
writerphd

A proposal has not yet been provided

$77 USD ใน 1 วัน
(1 รีวิว)
1.0
rritika09

working as analyst since last 2 years with an MNC. big data developer. have played a BA role in one of the projects.

$200 USD ใน 8 วัน
(0 รีวิว)
0.0
anggapra

A proposal has not yet been provided

$155 USD ใน 3 วัน
(0 รีวิว)
0.0