I have data displaying the grind time for a sand sample and the resultant screen size in microns at which 80% of the mass falls through. we do this quite a lot so it will form part of a template.
I would like to know how to get excel to report what grind time I would need for the 80% point to be at a set particle size e.g. 80 microns. This is not a lineir plot. I can do this manually by looking at the graph but would like it to done using a formula to minimise human error.
X Values (80% pass point microns) 619.4, 172.1, 89.4, 74.0, 52.6,
y Values (grind time min) 0, 5, 15, 20, 30,