Plotting X$,$Y Graph in Excel

Copy the example worksheet data into a blank worksheet.

Select the data you want to plot in the scatter chart.

Click the Insert tab, and then click Insert Scatter $($X$,$ Y$)$

Click Scatter.

Click the chart area of the chart to display the Design and Format tabs$.$

Click the Design tab, and then click the chart style you want to use.

Click the chart title and type the text you want.

To change the font size of the chart title, right$-$click the title, click Font, and then enter the size that you want in the Size box. Click OK$.$

Click the chart area of the chart.

On the Design tab, click Add Chart Element $>$ Axis Titles, and then do the following:

To add a horizontal axis title, click Primary Horizontal.

To add a vertical axis title, click Primary Vertical.

Click each title, type the text that you want, and then press Enter.

For more title formatting options, on the Format tab, in the Chart Elements box, select the title from the list, and then click Format Selection. A Format Title pane

will appear. Click Size & Properties, and then you can choose Vertical alignment, Text direction, or Custom angle.

Plotting The Derivative Graph in Excel

Create a new worksheet in excel.

Copy and paste the $xY$ Data in the new worksheet as columns A and $B$

Label Column A $1$ as VNaOH and Column B $1$ as pH

Label Column C$1$ as $V$ and Column D$1$ as $pH$

In C$2$ and D$2$ insert $0$

In C$3$ insert the formula $=A3-A2$

Drag the corner of the cell for C $3$ down until the entire column is filled in with the $$ pHformula.

In D$3$ insert the formula $=$B$3-$B$2$

Drag the corner of the cell for D$3$ down until the entire column is filled in with the $$ Vformula.

Label Column E$1$ as Derivative.

In E$2$ insert $0.$

In E$3$ insert the formula $=D\frac{3}{C}3$

Drag the corner of the cell for E$3$ down until the entire column is filled in with the derivative formula.

Plot the VNaOH $($Column A$)$ vs the Derivative $($column E$).$

You titrate $95$ mL of a monoprotic acid solution with $0\mathrm{.}1267$ M sodium hydroxide solution. The following table shows your data around the end point of the titration. Use Excel

to plot this data in two separate graphs: one as a titration curve $($ pH vs Volume NaOH $),$ and a second as the derivative of this curve $(p\frac{H}{}mL$ vs Average Volume for each

successive pair of data points$).$

What is the volume of titrant used at the end point?

Type your answer...