Find Jobs
Hire Freelancers

Data Analysis using Excel

$30-250 USD

Completed
Posted over 9 years ago

$30-250 USD

Paid on delivery
This assignment requires an amount of computer work and written comments. You will examine data for 192 people. 1. Numerical Summary Tables (Descriptive Statistics) : - Contingency Table: Construct one contingency table and a bar chart that shows how many employees of each Position for males and females. - Prepare a summary table that shows average current salary and standard deviation for males and females. - Prepare a summary table that shows average current salary and standard deviation for employees according to their Position. 2. Graphical Summary (Descriptive) and relationships (Inferential) : - Create two new columns of data : The difference between starting salary and current salary; The number of years working for this company. - Use this to create a histogram (or Graphical Summary from basic Stat menu) showing the distribution of the salary increases per year. Comment upon what you see. - Provide side by side boxplots for the differences in salaries, split by position. Again, comment on what you see. - Obtain a scatterplot of these two variables; Make some appropriate comments based upon what is shown on the resulting scatterplot. - Obtain the same plot as above but this time you need to somehow identify the employee positions. In other words obtain a scatterplot of differences between starting and current salary versus years employed at the company grouped according to position within the company. 3. Conclusion : Write a brief concluding paragraph regarding current salaries of employees for this company in the light of gender differences, position and fairness, based upon what you have noticed from the above analyses. I will provide you with the data in Excel sheet, and I will provide you with the details of each question.
Project ID: 6151590

About the project

26 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I am a new freelancer waiting for an opportunity to prove my skills. I am an expert in handling excel data. Being an sincere and dedicated worker I can produce 100% quality output without mistakes. I am a 7.5 scorer in IELTS so can give you a better output based on your instructions. I am flexible with timings and compensation. You can pay me based on the quality of my output. You can contact me if you need more details about my working methodologies. As I am new freelancer I don't have any work samples or reviews to showcase. If needed and provided I can do sample work for you for free. You can select me only if you like my work. Thank You for reading my proposal.
$45 USD in 3 days
5.0 (2 reviews)
1.6
1.6
26 freelancers are bidding on average $145 USD for this job
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 USD in 3 days
4.9 (128 reviews)
6.3
6.3
User Avatar
I already mentioned that I would work on Minitab for the analysis. --------------- Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. Some of the projects which I have done include: 1) Pattern identification: Prepared software to identify repeating patterns due to addition of new data-point. (Project - "Write some Software which can detect Patterns" - 5882496) 2) Time series analysis to determine relationship and prediction of retail petrol vs from wholsale petrol prices (Project - 5332392) 3) Multi-regression for product harvesting strategy using dummy variables wherever applicable. Used Minitab and JMP for above projects. I have worked extensively on excel and VBA in my job and here on freelancer as well. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
$178 USD in 1 day
4.9 (40 reviews)
5.6
5.6
User Avatar
Hello ready to start asap to deliver you, If you can give me your notes and conditions, 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. I have good command of English that I think can be useful for this project. I have a base of statistics, mathematics, accounting, cost calculating, project scheduling and project management and finance that helps in this project.
$119 USD in 3 days
4.6 (95 reviews)
5.7
5.7
User Avatar
Hi, We are a group of analysts and have more than 10 years of experience of working in business intelligence and analytics. We can use SPSS or SAS, but to keep the cost low Excel can be used to create all the graphs and summarized table details you want. If you want post the excel work we can provide you with a neat presentation as well to cover all the questions you are trying to address. If you can provide us a sample of the data we can work on some of the tables and charts so that you get a chance to measure or quality before choosing, in case if you want. We provide a strong after sales service as well and our adherence to timeline is of utmost importance. Also maintain secrecy about client data is one of our values. You can expect 100% commitment. Kindly let us know, if you would like to give us an opportunity to work with you. Regards. Pal
$250 USD in 3 days
4.7 (39 reviews)
5.4
5.4
User Avatar
I teach Minitab 16 and 17 and use it a lot. I'm also in grad school for applied statistics. However I'm traveling at the moment and even though I have Minitab with me, because of my schedule, I doubt I could get this done 3 days from today. If you mean 3 days from the end of your 6 day project bidding time, I can do that. Let me know if you have any questions. Bill
$222 USD in 7 days
4.9 (3 reviews)
3.8
3.8
User Avatar
Expert Statistical Analyst with Advance Excel knowledge here. I have an extensive (around 8 years of) experience in conducting statistical and econometric analysis. I am particularly interested in projects that involve Financial Modelling. I am confident that I will be able to take care of your requirements and complete the work successfully within the permitted time. I am well versed with all referencing styles and assured plagiarism free writing. My star rating of 5/5 will speaks about my quality of writing. My core competencies include (but are not limited to): 1. Time Series Analysis (ARMA, ARIMA, ARCH, GARCH, VAR and Stochastic Volatility Models) 2. Panel Data Models (Dynamic and Static) 3. Program Evaluation Models I am extremely proficient in using Stata, SPSS, Eviews and other similar programs, and I can program in Gauss and Matlab as well as write articles in Latex if needed. I will only accept an assignment which I am professionally competent and necessarily able to deliver it on its required time. And if in some cases I am not confident on something, I will honestly refuse and will never accept anything that is out of my professional capability. Look forward to hear from you. Thank you Shiji
$100 USD in 3 days
5.0 (5 reviews)
3.5
3.5
User Avatar
Hi, I am Nikhil Gupta. I am having total 9 years of extensive experience into Analytics. I rarely bid on this website. However, I am planning to be active on this website. I worked on tools like Excel, SAS, R & SPSS. Good exposure to statistical Analysis. I can do this task at nominal price and in very less amount. Experience the quality work by awarding this project. Thanks, Nikhil Gupta
$155 USD in 3 days
5.0 (4 reviews)
3.1
3.1
User Avatar
HI Brother, I am Data Scientist working in Multinational Company. My work is to see the hidden pattern in the large and complex data sets and predictive analytics, Data mining,Machine Learning and also uses the statistical techniques on those datasets to see what data behaves in past. By seeing the past what will be the behavior the that data set in future. I am also working on "kaggle" competitions currently .I am also writing the column on All Analytics and my rank on All analytics in Statistician. I am also working on the Time Series analysis using ARIMA, SARIMA models and also working on econometric analsysi using Linear, Nonlinear, Logistic, Probit models, hypothesis testing and Cox regression for the survival analysis and also survey analysis etc. I am also the writer of the various research papers and one of them is relating medical data you can sight my paper at IEEEXPLORE. I am also using R, SPSS Statistics, Spss Modler, Stata, SAS, MATLAB, WEKA, Statistica and Pyhthon for Data Analysis for Machine Learning, Data Mining and Data Science. Thanks Regards, Muhammad Shoaib. Data Scientist
$66 USD in 3 days
4.9 (7 reviews)
3.1
3.1
User Avatar
Hi, I could easily complete your assignment. When is your deadline? .
$138 USD in 5 days
5.0 (4 reviews)
2.8
2.8
User Avatar
Hi, I am writing to express my interest in completing your assignment. I work as a Data Scientist and I have expertise in Data Analysis using Excel and R.
$155 USD in 2 days
5.0 (5 reviews)
2.9
2.9
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
As a software engineer, my day to day activities deals similar to this kind of job. If you give me an opportunity , i will give my best to achieve good results.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a good experience in using all of these excel functions and using it quite often in my other job.
$250 USD in 3 days
5.0 (1 review)
0.0
0.0
User Avatar
I wanna Complete The Work With My Best Abilities And Efficiency, Have Any Work For Me..!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Ainda não foi fornecida uma proposta
$155 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good afternoon, I can complete the assignment in 1 day in Minitab if you decide to pick me. I'm from Romania and I'm currently working as Data Analyst at Vodafone Global Enterprise in Budapest Hungary. I am looking forward to hearing from you. Thank you for your time, Sergiu
$40 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
This assignment can be done within 24 hours after confirmation. The analysis can be carried out using MINITAB. I have more than 10 years of experience in data analysis and online tutoring. Kindly confirm and send all the required files to proceed with this assignment.
$40 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am good to give you Quality of work in timelines and well experienced in data entry and excel too. We are having team to manage the work and they are statistical background.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of KUWAIT
KWI, Kuwait
4.8
28
Payment method verified
Member since Apr 18, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.