Suppose you have three test scores collected from a class of ten students (5 females, and 5 males) during a semester. The information you have for each student is: identification number, gender, score for test one, test two and test three (the full data set is displayed toward the end of this section for you to enter into the Worksheet window).

SigmaPlot needs data in the worksheet (looks like a spreadsheet) to generate graphs. There are two ways to enter data: entering data directly or importing external data (e.g. Excel data) into a worksheet.

Entering Data

Let us open a Worksheet and enter the variable names and the data above.

1.Select New from the File menu. A new dialog box appears. Click Ok in the box.

2.Double-click on the top of the 1st column.

3.Type Name for the variable name. The name of the column shows 1-Name.

Define the remaining five variables as the same way.

Now, the top row should have six variable names. Let us key in the data.

4.Move the pointer to the cell below the variable Name, by clicking it.

5.Type in the data given above, pressing ENTER after each value. To move down columns, press the down arrow. To move right columns, press TAB.

Once you finish entering the data your Worksheet will appear as shown below.

Importing External Data

Suppose we have an Excel file (e.g. Clas.xls). We are going to import the data into SigmaPlot. (Note: Example data �gClas.xls�h is stored on the Stat/Math Center website, http://www.indiana.edu/~statmath/other/sigmaplot/Clas.xls). We will use this file for all remaining examples.

1. Open the worksheet and Select Import from the File menu.

2.An Import File dialog box appears. Click Import in the box.

3.An Import Spreadsheet dialog box appears. This box asks you the name of sheet from the Excel file and the range of the data. We are going to import the entire data from Sheet1.

4.Click Import.

5.The imported data looks as below:

---

Next: Generating Graphs
Up: Table of Contents
Prev: Orientation