Calculating cmc and Q/N
1. Transcribe your concentration and conductivity results into columns A and B of an Excel spreadsheet. Prepare a graph of conductivity (y-axis) versus surfactant concentration (xaxis). From looking at your graph, estimate the concentration at which two straight lines
would intersect: this should correspond to the critical micelle concentration, or cmc.
2. Your data should look like two straight line segments. To find the intersection between these two lines, you need to fit the data by linear regression. Trendline is the quickest way to do this, but is not the best way if you need to know uncertainty. First, fit each of the two segments using Trendline, and decide which points belong to which line. Show both equations and R2 values for now, and note them down, but don’t include them on any Figures in your final presentation.
DETAILED ASSIGNMENT
