$0$

$2$

$4$

$6$

Mass $($grams$)$

$9\mathrm{.}3$

$8\mathrm{.}5$

$8\mathrm{.}1$

$7\mathrm{.}2$

$6\mathrm{.}4$

$12$

$5\mathrm{.}6$

$5\mathrm{.}1$

$4\mathrm{.}6$

$4\mathrm{.}0$

$20$

$3\mathrm{.}1$

$22$

$2\mathrm{.}5$

$24$

$1\mathrm{.}8$

$26$

$28$

$30$

$0\mathrm{.}7$

$0\mathrm{.}0$

Input these numbers into your Excel spreadsheet, but first review the explanation below, as it relates to MS XL $2007.$

For MS XL $2007$

Excel is divided into cells. Each cell is designated by a column $($designated A$,$ B$,$ C$....)$ and a row $($designated $1,2,3,..).$ Start entering data in a cell near the top of the sheet, but NOT at the very top and left$-$hand corner.

Leave some room for headers or movement of the data if needed later on$.$ Pointing to cell C$6,$ type "Time $($minutes$)"$ as a header for that column, and type "Mass $($grams$)"$ as a header in the next column in the D$6$ cell to the right. As in the table on the prior page, enter values for "Time" for the even numbered minutes from O to $30$ in a single column. Enter the corresponding "Mass" values in the adjacent column to the right. In other words, if the time $"0\mathrm{.}0"$ is in cell C$7,$ then the mass $"10\mathrm{.}0"$ is in cell D$7,$ and the time $"2\mathrm{.}0*$ goes in C$8$ and mass $"9\mathrm{.}0"$ goes in D$8,$ etc.

In order to determine the rate at which the ice is melting, we need to plot the data:

Plot of absorbance vs concentration

Y $=0\mathrm{.}2263$x $+0\mathrm{.}0132$

$=0\mathrm{.}9926$

Was this solution helpful?

Graphing Techniques

Page $5$ of $8$

$1)$ Highlight the data in the two columns you just created. Include text only $...$ DO NOT include the column headings. Click on the "Insert" tab on the toolbar at the top of the page, and icons will appear that represent several options for the types of charts.

$2)$ Click on $"$XY $($Scatter$)"$ from the several types of graphs. Then select one of the $5$ options for the appearance of the graph $($try the one with data points and curvy lines$).$

$3)$ You should now see the graph you selected appear on the spreadsheet. The graph will need to be dressed up by adding a heading and axis labels.

$4)$ First you need to get rid of useless and