Homework Answered Another way we use Excel to complete analysis is with large amounts of data such as those developed wi
Posted: Mon May 23, 2022 2:17 am
Homework Answered Another way we use Excel to complete analysis is with large amounts of data such as those developed with titrations. This is where we measure the pH of a solution after adding known volumes of acid or base. The data for such a titration curve is given below. Input this data into your spreadsheet and graph V (volume in ml) as your x values and pH as your y values. Using the graph, determine the pH at the second equivalence point (midpoint of second vertical region), Answer to 2 sf. NOTE: To see full list of values click on the image. V, mL pH 2.002743 3 4.295572 3.333333 7.855185 3.666667 12.46441 4. 17.05997 4.333333 20.57004 4.666667 22.74727 5 23.94245 5.333333 DO Fullscree
24.58715 5.666667 24.99951 6 25.41156 6.333333 26.0552 6.666667 27.24796 7 29.42023 7.333333 32.92076 7.666667 37.49875 8 42.07547 8.333333 45.57173 8.666667 47.7345 9 48.90699 9.333333 49.50733 9.666667 49.8273 10
50.73235 11 51.63955 11.33333 53.64499 11.66667 58.33056 12 70.59393 12.33333 114.9659 12.66667
24.58715 5.666667 24.99951 6 25.41156 6.333333 26.0552 6.666667 27.24796 7 29.42023 7.333333 32.92076 7.666667 37.49875 8 42.07547 8.333333 45.57173 8.666667 47.7345 9 48.90699 9.333333 49.50733 9.666667 49.8273 10
50.73235 11 51.63955 11.33333 53.64499 11.66667 58.33056 12 70.59393 12.33333 114.9659 12.66667