Question

i need help on finding the last information im having trouble with creating a graph from the excel spreed sheet if some one could guide me through the steps, please. What should I place in excel to create the graph when I placed the water bath and temp as well as HCI added it gives me seprate lines. Thanks in advance.

C. Data Analysis pse of all buret washin You will the titrant heed to provide your data to your instructor. Your instructor will compile the data from used for each temperature sample and report the class data to you. Six repeated ons are required to establish the data plot for the determination of AH and AS Tor dissolutico lion of borax. The lengthy task of completing the calculations and for minimizing crors in the calculations can be reduced with the use of an Excel spreadsheet. The data from the calculations can then be plotted using the embedded graphing capabilities of Exce The following calculations and analyses are required: I. Calculate the molar solubility of borax at each of the measured temp 2. Calculate the solubility product of borax at each of the measured temperatures. . Plot the natural logarithm of the solubility product versus the reciprocal temperature 1/T (K1) for each sample and draw the best straight line though the data points. of solution of borax. standard entropy of solution for borax 4. Determine the slope of the linear plot equal to -AH /R and calculate the standard enthalpy 5. Determine the y-intercept (at x 0) of the linear plot equal to AS°/R and calculate the Part A Sample number Volume of sample (mL) 5 5.00 5.00 5.00 5.00 5.00 5.00 Temperature of sample (°C) |42.35 |62.2 2.33 7.7 33,3 a2.33 Part B [HCI] (M) Sample number 4 Initial buret reading (mL) Final buret reading (mL) Volume of HCI added (mL) 8.8 ml Average volume of HCI at oC (mL) (Report this temperature and volume to your instructor) Average volume of HCI at 3 C (mL) (Report this temperature and volume to your instructor) Part C Temperature (K) Volume of HCI added (mL) 315.5 335.35 295.45 230. 7b from class data 1/T (K") Moles of HCI used Moles of B4Os(OH)4 [B40s(OH)4] (M) 0.0036 0.036 0.0033 3 0.2 o.190 0.176 0.012 o124 0.174 edition. Wiley, 2014. Molar solubility of borax Solubility product, Ks In Ksp moVL 2.58 3.so 3.44-3 3.47 -3.77 -4 -AH°/R (from data plot) AS /R (from data plot) AHo (kJ/mol) ASo (J/mol*K) G" (kJ), at 298 K

Answer 1

315.5	0.00317	10	0.002	0.2	0.032	-3.44202
335.35	0.002982	9.6	0.00192	0.192	0.028312	-3.56449
295.48	0.003384	8.8	0.00176	0.176	0.021807	-3.82552
280.85	0.003561	6	0.0012	0.12	0.006912	-4.9745
276.15	0.003621	6.2	0.00124	0.124	0.007626	-4.87613
276.45	0.003617	8.7	0.00174	0.174	0.021072	-3.85981
T in K	1/T	Volume oh HCl	[HCl] moles	[B4O5(OH)42-]	Ksp	ln(Ksp)

You have done some mistakes in calculations, the correct values are given above but these values are not giving a straight line. the data plot looks like below.

Plotting the data in excel spreadsheet is

select all the data, go to insert tab click on charts and select there X and Y scatter or line plot.

I hope I have given you the sufficient idea.