Chemical Batch Distribution Analysis Excel
Budget: £20 – £250 GBP
I have distribution datasets for several batches of chemical compounds coming from two different lab sites and I need clear, reproducible answers on whether those batches behave consistently. Everything must live in one well-structured Excel file that not only holds the numbers but also shows, step-by-step, how each result was reached and what it means.
Here’s what I want to see inside the workbook:
• Statistical analysis – descriptive stats, variance checks, any tests you feel are appropriate to confirm consistency across batches (I’m open to ANOVA, t-tests, control charts, etc.).
• Graphical representation – histograms, box-plots, trend lines, side-by-side site comparisons; keep the visuals clean and labeled so a non-statistician can follow the story.
• Comparative analysis – clear tables or charts that place Site 1 and Site 2 results next to each other, highlighting any divergence.
Include brief written interpretations next to each section and a final summary sheet that states in plain language whether the two sites are producing equivalent material.
Acceptance criteria: the workbook must run without external add-ins (standard Excel functions and built-in Data Analysis ToolPak are fine), every calculation must be traceable, and all charts should update automatically when data change.
If that sounds doable, let’s talk timeline and any upfront questions you have about the raw data format.
Here’s what I want to see inside the workbook:
• Statistical analysis – descriptive stats, variance checks, any tests you feel are appropriate to confirm consistency across batches (I’m open to ANOVA, t-tests, control charts, etc.).
• Graphical representation – histograms, box-plots, trend lines, side-by-side site comparisons; keep the visuals clean and labeled so a non-statistician can follow the story.
• Comparative analysis – clear tables or charts that place Site 1 and Site 2 results next to each other, highlighting any divergence.
Include brief written interpretations next to each section and a final summary sheet that states in plain language whether the two sites are producing equivalent material.
Acceptance criteria: the workbook must run without external add-ins (standard Excel functions and built-in Data Analysis ToolPak are fine), every calculation must be traceable, and all charts should update automatically when data change.
If that sounds doable, let’s talk timeline and any upfront questions you have about the raw data format.