Microsoft Excel Instruction Sheet - wsfcs.k12.nc.us



Microsoft Excel Instruction Sheet

Entering Data into Excel

1. Label first column and type independent variable values underneath.

2. Label second column and type dependent variable values underneath.

Creating a Graph with Excel

1. Click on “Insert” at top of sheet. Click “Chart.”

2. Choose the type of chart to create. We normally use XY Scatter plot. Click “Next.”

3. Select all of your data for the data range by clicking and holding the mouse from the top left corner to the bottom right corner. You will see a blinking box around your data. Do NOT include the column titles in the data range.

4. Your initial test plot should appear.

5. Click on “Series” tab.

6. Enter a name for this graph.

7. Verify that the X values and Y values are correct from the spreadsheet. If the value ranges are incorrect, click on the button at the right and correct them by clicking and dragging. Click “Next” when you are done.

8. Type a name for Value (X) axis and Value (Y) axis. This is the name and unit of each axis in the graph. Click “Next.”

9. Step 4 of the chart wizard asks you how to place the graph. Select the 2nd button for “as object in sheet 1.” Click “Finish.” The graph may be moved by dragging.

Linearizing Data

1. If the initial plot is linear, select “Chart” tab at top of page and click “Add Trendline.”

2. Under the “Type” tab, select “Linear.”

3. Click the “Options” tab and check the boxes “Display equation on chart” and “Display R-squared value on chart.”

4. Click “OK.” The equation can be moved on the graph by clicking and dragging.

5. When you are finished and are ready to print, click anywhere in the data table. Click “File” and “Page Setup.” Select “Landscape.” The print preview should show you the data table and your graph. Print a copy for each member of your group.

1. If the initial plot is NOT linear, determine what method needs to be used in order to linearize the data from the Graphical Methods Summary sheet.

2. Create a new column on the spreadsheet and enter new values.

3. Repeat the steps in the “Creating a Graph With Excel” section of these directions.

4. Create graphs until the data appears to be linear.

5. Find the line of best fit using the first set of steps under the “Linearizing Data” section of these directions.

................
................

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

Google Online Preview   Download