Thank you for your response. I think that this is heading toward a working solution, but a little clarification is requested. When I used the first formula (and changed the references to the actual sheet name and data rows), what is returned is the value contained in the cell 67% from the cell...
HI!
I'm trying to put straight line across a scatter graph with a percentage of the data points (e.g., 33 out of 100 [33%]) above the line the remaining data points (67) below the line and identify the corresponding y-intercept value.
Scenerio: file download times are recorded once daily over...