Massachusetts ran lead and copper testing at public schools in May 2016. The results, which are available online, and a spreadsheet, Excel. There are over 120,000 samples taken at multiple schools throughout the state. I want to know the five worst schools, and the five best schools. The criteria for best and worst is the single highest lead level, and single highest copper level. Each school was tested at multiple water bubblers, fountains, sinks, etc. therefore, I also want to know the top five schools that had the most excesses, as well as the five schools with the least excesses. I have attached a spreadsheet, for your review. Again, this is all public records; it is on the [login to view URL] website. I am just not good at Min/Max, pivot table type data analysis.
Being a full time freelancer working almost exclusively on Excel based projects, I work on such Excel tasks every single day. I would like to discuss the excesses requirement though.
Relevant Skills and Experience
18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 17 MONTHS , spent at least 250 HOURS on automation in Excel every month.
Proposed Milestones
$30 USD - Draw inferences from raw data as per requirement
$30 USD in 1 day
5.0 (156 reviews)
6.6
6.6
21 freelancers are bidding on average $25 USD for this job
Hello Sir,
I am the expert freelancer for Data Analyis job . i have deliver more than 280 projects with 100% client satisfaction. so please give me chance to work on your job.
Relevant Skills and Experience
I have more than 5 years of experience in Data Processing, Excel
Proposed Milestones
$60 USD - Data Analyis
Greetings sir, I am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement.
Relevant Skills and Experience
I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project.
Proposed Milestones
$15 USD - Payment once project is complete
Hi
I would like to bid for this project. I posses Data Analytics, Research, Financial / Business Analysis & Reporting, Accountancy, Administration, Banking and Content Writing experience with Advance MS Excel Dashboards, MS & Google Office, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
Hey, I'm interested in your project. Please send me a message so that we can discuss more. I can do trial work before hire me sir , will wait for your reply, Thanks, Syed
Relevant Skills and Experience
Data Processing, Excel
Proposed Milestones
$30 USD - advv
Hello,
I went thru the des.
This can be done within today with 100% accurate.
Kindly check my past job work
Today can start. Looking forward to hearing from you
Thanks
Regards
Thushara
Relevant Skills and Experience
Data Processing, Excel
Proposed Milestones
$25 USD - once done
I can help you identify schools according to your given description. i shall also send you screen short of excel sheet so that you can see how we can do such analysis. i shall be thankful to you for considering me for this job.
Within 1 day delivery. With all Formulas, Macros will be written if needed
Relevant Skills and Experience
Excel, Macro's, Programming, Formula Calculators etc.
Proposed Milestones
$25 USD - On delivery
Dear Sir/Madam,
Good Morning,It is quite interesting task to do data analysis.I would love to do it for you on urgent basis.
Is it possible to discuss this in details?
Relevant Skills and Experience
Microsoft Excel 2016 and Google Sheets
Proposed Milestones
$30 USD - Excel file
Please feel free to inbox your concern queries.
thanks
Cheers!
I have been working on Excel spreadsheet for more than 4 years and my work includes preparation of Financial reports, business reports etc. I could sort the data asper your requirements.
To provide summary statistics on the chemical content readings (lead and copper) of drinking water for pre and post flushing activities for the list of schools and rank them as per the instructions.
Relevant Skills and Experience
Excel, Data processing and analysis.
Proposed Milestones
$8 USD - Seek clarifications with employer on the data analysis requirements.
$10 USD - Calculate the summary statistics using pivotable, pivotcharts and data analytics in excel.
$7 USD - Revisit with employer with the data analysis results with further clarifications.
$2 USD - Finalise with the summary statistics and submit.
Additional Services Offered
$1 USD - Provide meaningful summary report and charts.
Need to seek clarifications on the sampling and school criteria.
Let me help you.
Relevant Skills and Experience
I'm new in freelance but I've done several jobs like this. I can help you with these plus I'll tell you how to do stuffs like this so you dont have to spend next time. :)
Proposed Milestones
$10 USD - Your questions will be answered.
Hi, please indicate the method of delivery. I've read the website (source), interesting though. :)