The decomposition of H2O2 was studied and the concentration (in moles per liter) as a function of time was determined. a. Create a spreadsheet in Excel with the following columns and values. Calculate values for the natural logarithm of [H2O2] using an appropriate formula. Time H2O2(M) LN [H2O2] 0 0.862 120 0.556 240 0.394 360 0.246 480 0.149 b. Create a graph of [H2O2] versus time. Use the Scatter chart type and use the subtype that connect the points with a line. c. Create a graph of LN(H2O2) versus time. Use the scatter chart type and use the subtype that does not connect the points with a line. Instead, insert a trendline (linear fit) and display the equation of the line on the graph. d. Using the trendline equation, calculate the natural log of concentration (LN[H2O2] corresponding to a time elapsed of 200 seconds. From that value, calculate the molar concentration of H2O2 at 200 seconds
The decomposition of H2O2 was studied and the concentration (in moles per liter) as a function of time was determined.
a. Create a spreadsheet in Excel with the following columns and values. Calculate values for the natural logarithm of [H2O2] using an appropriate formula.
| Time | H2O2(M) | LN [H2O2] |
| 0 | 0.862 | |
| 120 | 0.556 | |
| 240 | 0.394 | |
| 360 | 0.246 | |
| 480 | 0.149 |
b. Create a graph of [H2O2] versus time. Use the Scatter chart type and use the subtype that connect the points with a line.
c. Create a graph of LN(H2O2) versus time. Use the scatter chart type and use the subtype that does not connect the points with a line. Instead, insert a trendline (linear fit) and display the equation of the line on the graph.
d. Using the trendline equation, calculate the natural log of concentration (LN[H2O2] corresponding to a time elapsed of 200 seconds. From that value, calculate the molar concentration of H2O2 at 200 seconds
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
