Magnesium reacts with HCl(aq) to form MgCl2 and H2(g)
____ Mg(s) + ____ HCl(aq) -----> ____ MgCl2(aq) + ____ H2(g)
The following data was collected for the above reaction:
Mg (g) 5% (m/v) HCl (ml) H2 gas produced (ml)
0.50 10 167
0.50 20 333
0.50 30 500
0.50 40 500
0.50 50 500
Using Excel, graph the volume of H2(ml) produced versus volume of 5%(m/v) HCl(ml) [5.00 grams HCl per 100 ml of solution]. Draw the two lines that intersect to give the equivalence point. (You may draw these lines by hand if you do not know how to do this in Excel.)
What does the graph look like? Can you show me the labels on the graph x y axis
To graph the volume of H2(ml) produced versus the volume of 5% (m/v) HCl(ml), you can follow these steps using Excel:
1. Open Excel and create a new worksheet.
2. Enter the data provided in the table. Label column A as "Mg(g)", column B as "HCl (ml)", and column C as "H2 gas produced (ml)".
3. Plot a scatter plot graph using this data:
- Highlight the data in columns B and C.
- Click on the "Insert" tab in the Excel menu.
- Select the "Scatter" chart type from the charts section.
- Choose the "Scatter with only Markers" option (it should be the first one).
4. Adjust the chart axes and labels:
- Right-click on the horizontal axis (x-axis) and select "Format Axis".
- In the "Axis Options" section, set the "Minimum" value to 0 and the "Maximum" value according to your data (e.g., 50).
- Label the x-axis as "Volume of 5% HCl (ml)".
- Right-click on the vertical axis (y-axis) and select "Format Axis".
- In the "Axis Options" section, set the "Minimum" value to 0 and the "Maximum" value according to your data (e.g., 600).
- Label the y-axis as "H2 gas produced (ml)".
5. Draw the two lines that intersect at the equivalence point:
- You can draw these lines by hand on a printed copy of the graph, using a ruler or a straight edge.