Using MS Excel, prepare graphs of fractional compositions versus pH for a monoprotic and a diprotic...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using MS Excel, prepare graphs of fractional compositions versus pH for a monoprotic and a diprotic species of your choice. Please use a separate worksheet for the two species. To start, you will need to research and list the Ka value(s) of your compound (include a reference!). Next, set up one column of pH values from 0-14 in increments of 0.5 pH units. In the next column, use an equation to calculate the [H+] for each pH unit. In the next columns, use an equation to calculate αHx and ax for each listed pH (for the diprotic acid, you will have three such columns: αH2x, αHx, and ax). Create a scatter plot with multiple series, using the pH values for the x- values and the a values for the y-values. Note that the graph for your monoprotic species will have two series (one for the protonated and deprotonated form), and the graph for your diprotic species will have three series (full protonated, intermediate form, and fully deprotonated form). Your x-axis should show the pH range from 0-14 and your y-axis should shows the a range from 0-1. Include labels for each axis and all series, and be sure that your graph is neat and easy to read and interpret! Using MS Excel, prepare graphs of fractional compositions versus pH for a monoprotic and a diprotic species of your choice. Please use a separate worksheet for the two species. To start, you will need to research and list the Ka value(s) of your compound (include a reference!). Next, set up one column of pH values from 0-14 in increments of 0.5 pH units. In the next column, use an equation to calculate the [H+] for each pH unit. In the next columns, use an equation to calculate αHx and ax for each listed pH (for the diprotic acid, you will have three such columns: αH2x, αHx, and ax). Create a scatter plot with multiple series, using the pH values for the x- values and the a values for the y-values. Note that the graph for your monoprotic species will have two series (one for the protonated and deprotonated form), and the graph for your diprotic species will have three series (full protonated, intermediate form, and fully deprotonated form). Your x-axis should show the pH range from 0-14 and your y-axis should shows the a range from 0-1. Include labels for each axis and all series, and be sure that your graph is neat and easy to read and interpret!
Expert Answer:
Answer rating: 100% (QA)
Answer 1 Ka Values The Ka values of a compound refers to the acid dissociation constant or the equilibrium constant that describes the strength of an ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
You will need to research various brainstorming techniques. Although brainstorming is typically performed in group sessions, you will be applying the same techniques to analyze your problem. Select a...
-
Use Excel to create a scatter plot with smooth lines of the Normal Curve. Graph the equation according to these requirements: = 3 = .7 -2 x 8 in increments of .2 Paste the scatter plot into Excel.
-
Graphs of populations of two species are shown. Use them to sketch the corresponding phase trajectory. 5. species 1 200- species 2 100- 6. y. species I 1200 1000 800 600 400 species 2 200 10 15
-
The distance between the K+ and Cl ions in KCl is 2.80 1010 m. Calculate the energy required to separate the two ions to an infinite distance apart, assuming them to be point charges initially at...
-
Refer to the cost curve in the following exhibit: a. What is the lowest level of output at which the efficient scale of production is reached in the long run? b. In the short run described by SRATC,...
-
Calculate the standard enthalpy of formation of FeS 2 (s) at 600. °C from the following data at 298.15 K. Assume that the heat capacities are independent of temperature. You are also given that...
-
Use the data in Exercise 19 in Section 13.1 for the following: a. Compute a point estimate for the mean number of calories in fast-food products that contain 15 grams of protein. b. Construct a 95%...
-
The weighted average cost of capital for a firm (assuming all three Modigliani and Miller assumptions apply) is 15 percent. What is the current cost of equity capital for the firm if its cost of debt...
-
All assets are either operating or non-operating. Operating assets are used to generate sales while non-operating assets are typically excess monies that have not yet been invested in operating...
-
Jonathan Herring suggests the following virtues might be included within virtue ethics - politeness, fidelity, prudence, temperance, courage, justice, generosity, compassion, mercy , gratitude,...
-
Calculate the exact count of operations, with all steps and details int x = 10, y = 12, z = 14, count = 50, i, j; for (i = 1; i = 1; j = j * 2) { count - -; } }
-
A batch of 200 laptops contains three defective laptops. You choose three laptops at random. What is the probability that you have (a) no defective laptops? (b) all three defective laptops? (c) two...
-
A code consists of two distinct letters followed by three digits. The last digit cannot be 0 or 1. What is the probability of guessing the security code on the first try? Use counting principles to...
-
A basketball coach has to choose 5 players from a list of 12 players. In how many ways can the coach choose the 5 players? Use combinations and permutations.
-
Six different letters are to be put in six envelopes of different colors in a manner that each envelope gets only one letter. In how many ways can this be done? Use combinations and permutations.
-
In a community 60% of the population speaks English, 30% speaks Spanish and 15% speaks both English and Spanish. Find the probability that a randomly chosen person from this community speaks English...
-
A careful analysis of demand for Bubbles in Strasburg, ND reveals a strange segmentation in the market. (RecallBubbles is the beverage which produces an unexplained craving for Lawrance Welk's music....
-
A Bloomberg Businessweek subscriber study asked, In the past 12 months, when traveling for business, what type of airline ticket did you purchase most often? A second question asked if the type of...
-
Russell (age 50) and Linda (age 45) Long have brought you the following information regarding their income and expenses for the current year. Russell owns and operates a landscaping business called...
-
Quince Corporation has taxable income of $450,000 for its 2012 calendar tax year. Calculate the corporation's income tax liability for 2012 before tax credits. $_________
-
Greg died on July 1, 2012, and left Lea, his wife, a $50,000 life insurance policy which she elects to receive at $5,000 per year plus interest for 10 years. In the current year, Lea receives $6,200....
-
Third quartile = _______
-
Interquartile range (IQR) = _____ _____ = _____
-
Find the mean for the following frequency tables. Frequency a. Grade 49.5-59.5 2 59.5-69.5 3 69.5-79.5 8 79.5-89.5 12 89.5-99.5 5 Table 2.51 b. Daily Low Temperature Frequency 49.5-59.5 53 59.5-69.5...
Study smarter with the SolutionInn App