Graphing Titration Curve Instructions
Freezing Point Graph
For Pure Solvent and Solution
85 82.5 80 77.5
Temperature (Celcius)
75 72.5 70 67.5 65 62.5 60 57.5 55 0 20 40 60 80 100 120 140 160 180 200 220 240 260 280 300 320 340 360 380 400 420 440
Time (seconds)
Pure BHT BHT + pdB BHT + ???
The actual process may vary based on what version of Microsoft Office or OpenOffice.Org you are using, but it will be similar to the guidelines below. 1. Enter all your data values into a spreadsheet (Just like in the chart on the right) 2. Highlight ALL OF IT, and select “Insert → Chart” 3. Start to configure the chart. We want a XY Scatter Point Graph with Lines. You can choose Line Graph, but formatting it is more of a headache. Go ahead and add axis labels and the chart title now. At this point it should resemble what you see above. Mess with the colors and symbols as you see fit. 4. To scale the Y Axis: double click on the region where the number labels are. You should get a formatting window where you can adjust the scale. (I.E in my graph, the Minimum = 55, the Maximum = 85, and the Interval = 2.5). You should be able to leave the X Axis alone. If not, do the same to rescale it as you see fit. 5. Calculate Δ Tfp as shown in the lab handout using your nifty graph!
Time (Seconds) 20 40 60 80 100 120 140 160 180 200 220 240 260 280 300 320 340 360 380 400 420 440
Pure BHT 74.1 72.8 72.1 71.2 71.1 69.6 70 70.3 70.4 70.4 70.4 70.4 70.5 70.5 70.5 70.5 70.5 70.5
BHT + pdB 77 74.2 72.1 70.2 68.6 67 65.2 64 62.6 61 60.5 60.5 60.4 60 59.7 59.4
BHT + ??? 83 83.2 80.8 78.9 76.1 74.8 72.7 71.2 69.4 68 66.6 64.3 63.5 61.7 60.5 59.1 58.1 58.5 58.1 58.4 57.1 57.7
Troubleshooting/FAQ AKA Problems That You May or May Not Encounter Q: My Graph is just a bunch of dots or its just lines. A: Double click on your graph and find your way to a “Chart Type” (or something to that effect) formatting box. Double check that you have an XY scatter point graph with lines. If not, change it into one. Q: My X Axis
For Pure Solvent and Solution
85 82.5 80 77.5
Temperature (Celcius)
75 72.5 70 67.5 65 62.5 60 57.5 55 0 20 40 60 80 100 120 140 160 180 200 220 240 260 280 300 320 340 360 380 400 420 440
Time (seconds)
Pure BHT BHT + pdB BHT + ???
The actual process may vary based on what version of Microsoft Office or OpenOffice.Org you are using, but it will be similar to the guidelines below. 1. Enter all your data values into a spreadsheet (Just like in the chart on the right) 2. Highlight ALL OF IT, and select “Insert → Chart” 3. Start to configure the chart. We want a XY Scatter Point Graph with Lines. You can choose Line Graph, but formatting it is more of a headache. Go ahead and add axis labels and the chart title now. At this point it should resemble what you see above. Mess with the colors and symbols as you see fit. 4. To scale the Y Axis: double click on the region where the number labels are. You should get a formatting window where you can adjust the scale. (I.E in my graph, the Minimum = 55, the Maximum = 85, and the Interval = 2.5). You should be able to leave the X Axis alone. If not, do the same to rescale it as you see fit. 5. Calculate Δ Tfp as shown in the lab handout using your nifty graph!
Time (Seconds) 20 40 60 80 100 120 140 160 180 200 220 240 260 280 300 320 340 360 380 400 420 440
Pure BHT 74.1 72.8 72.1 71.2 71.1 69.6 70 70.3 70.4 70.4 70.4 70.4 70.5 70.5 70.5 70.5 70.5 70.5
BHT + pdB 77 74.2 72.1 70.2 68.6 67 65.2 64 62.6 61 60.5 60.5 60.4 60 59.7 59.4
BHT + ??? 83 83.2 80.8 78.9 76.1 74.8 72.7 71.2 69.4 68 66.6 64.3 63.5 61.7 60.5 59.1 58.1 58.5 58.1 58.4 57.1 57.7
Troubleshooting/FAQ AKA Problems That You May or May Not Encounter Q: My Graph is just a bunch of dots or its just lines. A: Double click on your graph and find your way to a “Chart Type” (or something to that effect) formatting box. Double check that you have an XY scatter point graph with lines. If not, change it into one. Q: My X Axis