Find Jobs
Hire Freelancers

Ranking System in Excel

$30-250 USD

Dibatalkan
Disiarkan hampir 10 tahun yang lalu

$30-250 USD

Dibayar semasa penghantaran
I need a statistical analysis completed within excel. My goals are 1.) Calculate Standard Deviation 2.) Calculate Weighted Standard Deviation 3.) Develop a Ranking System (the goal of this ranking system is to identify the most and least influential companies based on the weight and hourly weight). For this example 1-21, with 1 having the greatest impact on the groups average hourly rate and 21 having the least. For example, Company ID 360116 has the lowest hourly rate within the group. Should I be concerned with this company? No, because its weight only represents 0.38% of the group. I need to mathematical define (with a rank) what I can internalize. I no this would have a high ranking (least influential) but would it be the least influential amongst the group. Please let me know if you have any other questions. Thanks again
ID Projek: 5957919

Tentang projek

23 cadangan
Projek jarak jauh
Aktif 10 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
23 pekerja bebas membida secara purata $120 USD untuk pekerjaan ini
Avatar Pengguna
Hi Sir, I am ready to work for you.I am expert in statistics and mathematics. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. Please visit my profile once. Thanks with regards, Amit
$250 USD dalam 5 hari
5.0 (95 ulasan)
6.5
6.5
Avatar Pengguna
Dear Sir/Madam. I went trough your attachment and I am 100% grantee that i will develop a perfect ranking model for this. I am an expert in advanced excel features and have a strong financial background which may useful in this project. Please visit my profile to see my qualifications, experience and ratings, and if you are comfortable, I am ready to start this task. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal
$150 USD dalam 3 hari
5.0 (104 ulasan)
6.2
6.2
Avatar Pengguna
Hi Hamilton. Its a relatively simpler job to develop a ranking system. I have done Stats projects and would be glad to design the worksheet for you with all the 3 requirements incorporated. Regards. Usman.
$100 USD dalam 1 hari
5.0 (39 ulasan)
6.0
6.0
Avatar Pengguna
I am the top ranking statistics and mathematics freelancer ( ranking 1) in freelancer.com. I have gone through your project and can surely help you completing this.
$200 USD dalam 3 hari
4.9 (95 ulasan)
5.9
5.9
Avatar Pengguna
A proposal has not yet been provided
$189 USD dalam 3 hari
5.0 (39 ulasan)
5.6
5.6
Avatar Pengguna
Hello ready to start asap to deliver you, I looked at your file and read descriptions, I worked on standard deviation, different statistical functions in excel and also some other ranking methods such as AHP, let me know if you like to work on other methods, I created some sheets for calculating confidence intervals, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go.
$105 USD dalam 3 hari
4.5 (58 ulasan)
5.3
5.3
Avatar Pengguna
A proposal has not yet been provided
$60 USD dalam 3 hari
4.9 (17 ulasan)
5.0
5.0
Avatar Pengguna
Dear, I am able to complete your project. Thanks.
$155 USD dalam 5 hari
5.0 (5 ulasan)
5.0
5.0
Avatar Pengguna
Hi, Please let me know if you are online and we can have further discussions on this. Thanks ============== Hi, I intend to develop this ranking system in Excel using macros. I can work very closely with you on the business logic required to implement such ranking. Would really appreciate if we can discuss further on this. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for building Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features like making of ActiveX Exe, ActiveX dlls, OCX, Win32 API, multi-threading etc.. I fully understand on this highly competetive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$200 USD dalam 5 hari
4.9 (24 ulasan)
4.8
4.8
Avatar Pengguna
You can go through my profile for reviews about my excel work & skills. I can do this, lets discuss further in chat.
$144 USD dalam 3 hari
5.0 (3 ulasan)
4.1
4.1
Avatar Pengguna
I can do this type of analysis. Just need some time and your approval. I think that what you did with the data is in the right way. I can propose some indicator for the rating relative to the both relevant variables: something like "Hourly Rate/Weight". If you are interested in my bid, just send me a message so we can discuss the details. Thanks!
$77 USD dalam 4 hari
4.6 (12 ulasan)
3.5
3.5
Avatar Pengguna
I see that some calculations are already done. I can do a ranking system for your population. I did that before (check my reviews) I had similar projects. If not happy with my work no money will be taken (with the exception of freelancer tax) Regards, Nicholas
$72 USD dalam 3 hari
5.0 (2 ulasan)
1.8
1.8
Avatar Pengguna
I have developed similar projects with Excel using Macros, check my portfolio, my works have quality and warranty, check my reviews.
$130 USD dalam 3 hari
4.0 (1 ulasan)
1.7
1.7
Avatar Pengguna
Hello, I am currently an electrical engineer who has studied statistical analysis and probability. I currently work with Excel and Matlab everyday to process and analyze data. I will complete your project with the upmost quality and certainly within the time frame. Thank you.
$72 USD dalam 3 hari
5.0 (1 ulasan)
1.0
1.0
Avatar Pengguna
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements. We have right skills to work on this assignment. We are a team of professionals including experienced analysts, designers, project managers, developers and QA people having great expertise in web applications development mainly on core PHP, PHP with open sources (Joomla, Wordpress, Codeigniter, Cake PHP), .NET, Asp.NET, Vb.NET, HTML 5 etc. and mobile applications on ios and Android platform. Our award = superb result = happy client. In a good partnership, good results happen. Good cooking makes good eating!BWe consider our client as our partner. can u provide your email or sky-pe etc for further discussion about the project I am ready to discuss with you with best Regards
$155 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hello, Just for clarification: what you are trying to estimate is the marginal impact of one company on the overall group, correct? E.g., if the weighted average hourly rate of the group is 35 and you add company XYZ, the average hourly rate becomes 39. In this case, all you'd need is to choose a threshold, e.g., companies must have a marginal impact of +/- N%. It is possible to rank companies based on their marginal impact on the overall group. Hope this helps. I can do it today if you need it quickly - I am well served in quantitative analysis since I was a quantitative analyst at a hedge fund for over three years. Just hit me up. :) Cheers!
$133 USD dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hello I am an electrical engineer and I am interested in your project. Please contact to start. Thank you
$66 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Sir! i am an engineer and i have good mathematical skill along with good knowledge of Microsoft excel. I am also a critical problem solver. I will be pleased if you let me complete this job for you. I am hopeful to have an excellent working relation with you. Looking forward for your positive reply. Regards.
$111 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
A proposal has not yet been provided
$155 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi There, I have calculated the standard deviation for hourly rate , let me know if that is not correct and you were looking for standard deviation for some other variable. there is no concept of weighted standard deviation in statistics as far as I know, so if you let me know what you are trying to do with tha , I could calculate it in some other way. Also, I have come up with a new ranking system which you can have a look at. Please suggest how to send you the file. Regards, Gangesh
$55 USD dalam 1 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera UNITED STATES
Union, United States
5.0
3
Kaedah pembayaran disahkan
Ahli sejak Okt 1, 2006

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.