The following data describes the sequence of chemical reaction concentration A a

Question

The following data describes the sequence of chemical reaction concentration A and B (mole per liter). Enter data in Excel worksheet and determine an equation that curve-fits each concentration data (Conc A: exponential curve; Conc B: 5-order polynomial curve). Using the equation obtained in part (a) for both Conc A and B versus time, determine when the concentration is maximized (both Conc) Using the equation obtained in part (a) for Conc A versus time, estimate the concentration after 23 seconds

Explanation / Answer

Start by entering preliminary data in columns. Label each column.If you need to do repetitive calculations on your data andyou can have Excel do the repetitive work

Open/Start Excel.

2.Under the File menu, choose “New”. A blank workbook opens.

3.Enter the data for the graph in two adjacent column

s. You can start the columns anywhere on the workbook. Include headings at the top of the table. Make sure you list the data for the x-axis on the left and the data for the y-axis on the right.

4.Once all of the data has been listed, highlight the data (only data, not headings) and press the “chart wizard” button on the Excel standard toolbar. The picture on this button looks like a small bar graph.

5“Chart Wizard

–

Step 1 of 4”: Choose the type of graph. (We will be doing XYscatter plots.) For the chart sub-type, you should usually choose the one with just the points and no line drawn on the points. Press “Next”.

6.“Chart Wizard

–Step 2 of 4”: If you had not already selected the data, you could

do so now. If you already have, press “Next”.

7.“Chart Wizard

–Step 3 of 4”: You have many options here.

•Under the “Titles” tab, enter the title of the graph and the labels for the “Value (X) axis” and the “Value (Y) axis”.

•Under the “Gridlines” tab, make a checkmark in each of the boxes to show both major and minor gridlines for both the x and the y axes if you want to be able to estimate values from the graph easily.

•Under the “Legend” tab, I usually un-check the box “Show legend”, so that “series 1” does not appear in the final graph. There’s no need for a legend if there is only one set of data plotted.

•Click “next”.

8.“Chart Wizard–Step 4 of 4”: You can now choose whether to place your graph as a small graph in a document, or as a full-page graph. Choose “as new sheet” for a full-page graph. Press “Finish”.

9.If you’d like to change the starting/ending points of either of the axes or changethe size of the increments on the graph:

•Put the cursor over the axis you want to change until the name of the axis

pops up. Click.On the Format menu, click Selecte d Axis.

•Click the Scale tab, and then select the options you want. For the best graphs, choose the minimum and maximum so that your data points are spread out on the page. Also, check the values of the “major unit” and “minor unit” to make sure that the values follow the 1, 2, 5 rule. If they don’t, change them so that they do. For example, if the minor unit is 0.04, change it to 0.05 so that it will be easier to estimate between the lines of the finished graph.

10.If you’d like to remove or change the shading of the background of the graph:

•Point the cursor on a part of the plot with no points or lines, until “Plot Area”pops up. Click.

•One the Format menu, clickSelected Plot Area.

•Under Area, select None for a blank background.

*** Under the “Chart” menu, choose “Add trendline”. Then, under “Type”, choose “exponential”. Even if there is error in the data,the program will draw the best exponential curve to fit the data happens to be exponential.

Now let’s convert this data into its exponetial curve form and make a graph of the exponetial curve

so when you choose “add trendline”, select “order polynomial curve” as the function.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.