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 [url removed, login to view] website. I am just not good at Min/Max, pivot table type data analysis.
23 freelanceria on tarjonnut keskimäärin 25 $ tähän työhön
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.
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