How in the world do I graph this on Excel?
I’m usually good at making graphs, but for some reason the data I have here is making me confused at how to even order it in a graph.
I had a solution set at different dilution factors (1:2, 1:4, and 1:10) For each dilution, I took four trials of data. We were measuring absorbances.
So for example, for solution one, 1:2 had 2.34, etc, etc. Then 1:4 had .59, etc, etc. Get it?
The goal of making this graph is trying to figure out what missing dilution we need to get 1.5.
My boss wants me to make a graph that has all four data points of each dilution and a linear. . .line thing, to figure out the slope of everything.
So x axis is going to be mg/ml and y axis is going to be the absorbance, so the highest is 2.8 and the lowest would be 0.
But then. . the fact that they’re different dilutions. . .how. . I don’t even know how to explain it.
It’s just coming out weird. I just want a linear slope thing with all the data points I have scattered around it. I hope someone can make sense of how to order it.
This question is in the General Section. Responses must be helpful and on-topic.