$\backslash$table$[[20,17\mathrm{.}8,,,],[30,31\mathrm{.}5,,,],[40,60\mathrm{.}7,,,],[50,88\mathrm{.}7,,,],[60,125\mathrm{.}8,,,],[70,245\mathrm{.}8,,,],[80,462\mathrm{.}7,,,],[90,654\mathrm{.}4,,,],[100,760,,,]]$

Making subscripts and superscripts in Excel:

To type $K^{-1}$ in an Excel worksheet,

type $K-1$

highlight $-1$

select "format"

select "cells"

Check "superscript"

Prepare an XY scatter plot of the vapor pressure versus temperature $($in Kelvin$)$ with a smooth line connecting the data points. Create the chart as a new sheet in your Excel workbook. This can be done in Excel $2007$ by selecting "move chart location" under the design tab. Delete the legend and label the axis accordingly. The title should read: Vapor Pressure vs$.$ Temperature $($K$).$ Label the graph with your name, lab section, day, and lab time under the main title. $($You can do this by left clicking on the main title, and typing your name, lab section, day and time below the Vapor pressure vs$.$ Temperature title$).$

$=>$ Hand in:

A printout of the final chart $($vapor pressure vs$.$ temperature in Kelvin$)$ as well as the spreadsheet of the data.

Now create another chart so that the $ln$ pressure is on the $y-$axis and the reciprocal of temperature $(\frac{1}{T})$ is the $x-$axis. Again, prepare an xy scatter