Answer Happy

Can I get help with graphing the data collected below, thenanswering the questions based on the graph.
1. Use Exel to prepare a titration graph by plotting theaverage pH (from the two trials) vs. volume (mL) of sodiumhydroxide added. Don’t forget to label the axes and give your grapha title.
Table 1: Trial 1 Equilibrium Constants Data: Syringe Reading 15 mL 14.5 mL 14 mL 13.5 mL 13 mL 12.5 mL 12 mL 11.5 mL 11 mL 10.5 mL 10 mL 9.5 mL 9 mL pH After Each 0.5 mL Increment 3.0 4.0 4.5 4.8 5.9 6.5 6.6 6.7 7.3 7.9 8.9 9.4 10.2 Color Observations Light yellow Light yellow Light yellow Light yellow Greenish-yellow Slightly darker yellow Slightly darker yellow Dark yellow Dark yellow Brownish-yellow Brownish-yellow Dark brown Dark brown
Table 2: Trial 2 Equilibrium Constants Data: Syringe Reading 15 mL 14.5 mL 14 mL 13.5 mL 13 mL 12.5 mL 12 mL 11.5 mL 11 mL 10.5 mL 10 mL 9.5 mL 9 mL pH After Each 0.5 mL Increment 2.9 3.8 4.5 4.6 5.3 6.0 6.8 7.3 7.8 8.7 9.4 10.2 11.0 Color Observations Light Yellow Light Yellow Light Yellow Light Yellow Dark yellow Dark yellow Dark yellow Brownish-yellow Brownish-yellow Dark brown Dark brown Orange-brown Dark orange
2. From your graph, determine the volume of sodium hydroxide needed to reach the equivalence point in the titration. 3. Calculate the volume needed to reach the half-equivalence point in the titration. 4. Find this half-equivalence point on the graph and determine its corresponding pH. 5. Use the half-equivalence point pH value to find the experimental pka. To solve, recall that: pH=pKa + log [base] [acid] 6. Determine the Ka of acetic acid. Recall that: pKa = -log(Ka).