Scatter Plots on Excel - LCPS



Scatter Plots on Excel - last step before creating the graph is to choose the data you want to graph.Highlight the data in both the concentration and absorbance columns (but not the unknown data) This is shown in Figure 2.Figure 2.Creating the Initial Scatter PlotWith the data you want graphed, start the chart wizardChoose the Chart Wizard icon from the tool bar (Figure 3). If the Chart Wizard is not visible, you can also choose Insert > Chart... Figure 3.The first dialogue of the wizard comes upChoose XY (Scatter) and the unconnected points icon for the Chart sub-type (Figure 4a) Figure 4a.Click Next > The Data Range box should reflect the data you highlighted in the spreadsheet. The Series option should be set to Columns, which is how your data is organized (see Figure 4b).Figure 4b.Click Next > The next dialogue in the wizard is where you label your chart (Figure 4c)Enter Beer's Law for the Chart Title Enter Concentration (M) for the Value X Axis Enter Absorbance for the Value Y Axis Figure 4c.Click on the Legend tab Click off the Show Legend option (Figure 4d) Figure 4d.Click Next > Keep the chart as an object in the current sheet (Figure 4e). Note: Your current sheet is probably named with the default name of "Sheet 1".Figure 4e.Click Finish The initial scatter plot is now finished and should appear on the same spreadsheet page as your original data. Your chart should look like Figure 5. A few items of note:Your data should look as though it falls along a linear path Horizontal reference lines were automatically placed in your chart, along with a gray background Your chart is highlighted with square 'handles' on the corners. When your chart is highlighted, a special Chart floating palette should also appear, as is seen in Figure 5. Note: If the Chart floating palette does not appear, go to Tools>Customize..., click on the Toolbars tab, and then click on the Chart checkbox.If it still doesn't show up as a floating palette, it may be 'docked' on one of your tool bars at the top of the Excel window. Figure 5.Creating a Linear Regression Line (Trendline)When the chart window is highlighted, besides having the chart floating palette appear, a Chart menu also appears. From the Chart menu, you can add a regression line to the chart.Choose Chart > Add trendline... A dialogue box appears (Figure 6a).Select the Linear Trend/Regression type Figure 6a.Choose the Options tab and select Display equation on chart (Figure 6b) Figure 6b.Click OK to close the dialogue The chart now displays the regression line (Figure 7) ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download