XLSTAT: Selecting Data in Excel

Watch the video below to view the steps on selecting data with XLSTAT.

If you prefer to read the steps, scroll past the video to view the text.

Selection by Columns

The Column selection requires that your dataset starts on the first row of the Excel sheet.

The Variable labels and Observation labels checkboxes (displayed in most of the XLSTAT dialog boxes) allow you to define the locations of this data if they are NOT in the first row or column.

To select a column, click on the name of the column, as you would do with Excel. Then select the next columns by leaving the mouse button pressed and dragging the mouse cursor over the columns to select.

This mode is useful when columns correspond to variables and rows correspond to observations.

Note:  You can select a range of non-adjacent columns by pressing the ( Ctrl ) key on your keyboard while selecting the data with the mouse.

 

Selection by Rows

The row selection requires that your data set starts on the first column (A) of the Excel sheet.

This mode is useful when rows correspond to variables and columns correspond to observations.

In this case, you need to activate the transposition option (see below).

If the arrow is horizontal as follows, XLSTAT considers that rows correspond to variables and columns to observations.

Click on the name (1, 2, …) of the first row of your data set on the Excel sheet, and then select the next rows by pressing the mouse button and dragging the mouse cursor over the rows to select.

Selection by Range

Use the range selection mode when your data does not start on the first row.

Simply select the data in the corresponding cells using the mouse.

 

Selection from a List of Variables

Click on the following button to change the data selection mode.

When the button shows a list icon, XLSTAT will allow you to display a list of the available variables that you can select.

 

Selection from Flat Files

Click on the button as shown below to change the data selection mode again.

When the button shows a paper sheet, you will be able to import a flat file and display a list of the imported variables.

This mode is useful when your data contains millions of rows. See a more detailed tutorial on how to Run a linear regression on millions of data points in Excel.